Table Detail Report
ORM_ERX_ACTIVITY_LOG
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Order Management ePrescribing Activity Log |
| Definition: | This table stores the formulary status viewing history for RxHub reporting purpose. |
| Table Type: | ACTIVITY |
Column Detail - ORM_ERX_ACTIVITY_LOG
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
| FB_AGE_LIMIT_IND | DOUBLE | Y | Indicates if the age limit detail was displayed. |
| FB_BENEFIT_SET_ID | DOUBLE | N | **OBSOLETE COLUMN**Formulary set id associated to the patient. It is the primary key of table FB_BENEFIT_SET. |
| FB_BENEFIT_SET_UID_TXT | VARCHAR(255) | N | The formulary benefit set unique id associated to the patient. |
| FB_COPAY_FIXED_AMT | DOUBLE | Y | Patient cost as a flat dollar amount (No $ sign, USD). |
| FB_COPAY_MTHD_TXT | VARCHAR(20) | Y | Copay type to consider first (Flat, Percent) if both provided. |
| FB_COPAY_PCT_NBR | DOUBLE | Y | Percent of the total drug price patient is responsible to pay (0.0 - 1.0). |
| FB_COPAY_TIER_NBR | DOUBLE | Y | The drug's tier as an indication of cost to the patient. Higher tiers denote lower cost. |
| FB_DETAIL_VIEWED_IND | DOUBLE | N | Indicates whether formulary detail dialog was shown to the user. |
| FB_FORMULARY_STATUS | DOUBLE | Y | Formulary status, the relative value and effectiveness of the drug. |
| FB_GENDER_LIMIT_IND | DOUBLE | Y | Indicates if the age limit detail was displayed. |
| FB_MED_NECESSITY_IND | DOUBLE | Y | Indicates if the medical necessity detail was displayed. |
| FB_PRIOR_AUTH_IND | DOUBLE | Y | Indicates if the prior authorization detail was displayed. |
| FB_PROD_EXC_IND | DOUBLE | Y | Indicates if the drug exclusion detail was displayed. |
| FB_QTY_LIMIT_IND | DOUBLE | Y | Indicates if the quantity limit detail was displayed. |
| FB_RSRC_DRUG_IND | DOUBLE | Y | Indicates if the specific resource link detail was displayed. |
| FB_RSRC_SMRY_IND | DOUBLE | Y | Indicates if the summary level resource link detail was displayed. |
| FB_STEP_MEDS_IND | DOUBLE | Y | Indicates if the step medication detail was displayed. |
| FB_STEP_THERAPY_IND | DOUBLE | Y | Indicates if the step therapy detail was displayed. |
| FB_TXT_MSG_IND | DOUBLE | Y | Indicates if the text message detail was displayed. |
| ORDER_ID | DOUBLE | N | The order id of the prescription. |
| ORM_ERX_ACTIVITY_LOG_ID | DOUBLE | N | The unique primary key of this table. It is internally generated. |
| REQ_ROUTING_TYPE_FLAG | DOUBLE | N | Routing method used for the prescription. 0 - Unknown routing type, 1 - Do not route, 2 - Route to printer, 3 - Route to pharmacy, 4 - Route to fax. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ORM_ERX_ACTIVITY_LOG
| Child Column in ORM_ERX_ACTIVITY_LOG(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
ORM_ORD_HIST_SNAPSHOT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | orm_order_history_snapshot |
| Definition: | This table will be a list of medication history snapshots. These snapshots will allow the user to see how the medication history has changed. |
| Table Type: | ACTIVITY |
Column Detail - ORM_ORD_HIST_SNAPSHOT
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ENCNTR_ID | DOUBLE | N | The encounter for which the medication history snapshot was taken |
| MED_HISTORY_STATUS_IND | DOUBLE | N | The medication history status at the time that the snapshot was taken |
| ORM_ORD_HIST_SNAPSHOT_ID | DOUBLE | N | Unique generated number that identifies a single row on the orm_ord_hist_snapshot table. |
| PATIENT_ID | DOUBLE | N | The person for whom the medication history snapshot was taken. |
| PERFORMED_DT_TM | DATETIME | N | The date/time the snapshot was taken. |
| PERFORMED_PERSON_ID | DOUBLE | N | The person who triggered the snapshot. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ORM_ORD_HIST_SNAPSHOT
| Child Column in ORM_ORD_HIST_SNAPSHOT(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
| PATIENT_ID | PERSON | PERSON_ID | |
| PERFORMED_PERSON_ID | PRSNL | PERSON_ID |
| Parent Column in ORM_ORD_HIST_SNAPSHOT (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | ORM_ORD_HIST_SNAPSHOT_ID | ORM_ORD_HIST_SNAPSHOT_COMP | SNAPSHOT_ID |
ORM_ORD_HIST_SNAPSHOT_COMP
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | orm_order_history_snapshot_component |
| Definition: | Contains history snapshot components. These components are the individual orders which are in the snapshots |
| Table Type: | ACTIVITY |
Column Detail - ORM_ORD_HIST_SNAPSHOT_COMP
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTION_SEQUENCE | DOUBLE | N | The order action sequence of the order when the snapshot was taken. |
| ACTIVITY_TYPE_CD | DOUBLE | N | The order's activity type. |
| CATALOG_CD | DOUBLE | N | The catalog code of the order. |
| CATALOG_TYPE_CD | DOUBLE | N | The catalog type of the order. |
| CLINICAL_DISPLAY_LINE | VARCHAR(255) | Y | The order's clinical display line when the snapshot was taken. |
| COMPLIANCE_LONG_TEXT_ID | DOUBLE | N | The compliance long text id. |
| COMPLIANCE_STATUS_CD | DOUBLE | N | The order's compliance status when the snapshot was taken. |
| ENCNTR_ID | DOUBLE | N | The encounter for which the medication history snapshot was taken |
| HNA_ORDER_MNEMONIC | VARCHAR(100) | Y | Order HNA mnemonic. |
| ORDERED_AS_MNEMONIC | VARCHAR(100) | Y | Ordered as mnemonic. |
| ORDER_ID | DOUBLE | N | The order's id. |
| ORDER_LAST_UPD_DT_TM | DATETIME | Y | The date the order was last updated at the time that the snapshot was taken. |
| ORDER_LAST_UPD_TZ | DOUBLE | Y | The time zone for the last updated date/time. |
| ORDER_MNEMONIC | VARCHAR(100) | Y | Order mnemonic. |
| ORDER_STATUS_CD | DOUBLE | N | The order's status. |
| ORM_ORD_HIST_SNAPSHOT_COMP_ID | DOUBLE | N | Unique generated number that identifies a single row on the orm_ord_hist_snapshot_comp table. |
| SIMPLIFIED_DISPLAY_LINE | VARCHAR(1000) | Y | The order's simplified display line when the snapshot was taken. |
| SNAPSHOT_ID | DOUBLE | N | The snapshot component is linked to this snapshot. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| VENUE_TYPE_CD | DOUBLE | N | The venue type of the order at the time the snapshot was created. |
Relationship Detail - ORM_ORD_HIST_SNAPSHOT_COMP
| Child Column in ORM_ORD_HIST_SNAPSHOT_COMP(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
| COMPLIANCE_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
| ACTION_SEQUENCE | ORDER_ACTION | ACTION_SEQUENCE | |
| ORDER_ID | ORDER_ACTION | ORDER_ID | |
| CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
| SNAPSHOT_ID | ORM_ORD_HIST_SNAPSHOT | ORM_ORD_HIST_SNAPSHOT_ID |
PROTOCOL_ORDER_STAT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Protocol Order Statistic |
| Definition: | Manages protocol group information common to protocol and day of treatments across a given protocol order. |
| Table Type: | ACTIVITY |
Column Detail - PROTOCOL_ORDER_STAT
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| CANCELED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Canceled status. |
| COMPLETED_CLIN_REV_DOT_CNT | DOUBLE | N | The count of pharmacy day of treatment orders who have a completed clinical review status. |
| COMPLETED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Completed status. |
| DISCONTINUED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Discontinued status. |
| FIRST_DOT_ORDER_ID | DOUBLE | N | The order ID of the first related day of treatment order. This is considered to be the day of treatment order which represents the start of the protocol order. This field will always be populated to show a relationship to a day of treatment order. |
| FUTURE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Future status. |
| INCOMPLETE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an Incomplete status. |
| INPROCESS_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an In-process status. |
| LAST_DOT_ORDER_ID | DOUBLE | N | The order ID of the last related day of treatment order. This is considered to be the day of treatment order which represents the stop of the protocol order. This field will always be populated to show a relationship to a day of treatment order. |
| NEEDING_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a needing clinical review status. |
| NEEDING_RX_VERIFY_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a needing Rx verification status. |
| NOT_APPLY_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a does not apply clinical review status. |
| ONE_CLIN_REVIEW_REQD_DOT_CNT | DOUBLE | Y | The count of related day of treatment orders which require one Rx verify review. |
| ORDERED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an Ordered status. |
| PENDING_COMPLETE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Pending Complete status. |
| PROTOCOL_ORDER_ID | DOUBLE | N | The ID of the related protocol order. |
| PROTOCOL_ORDER_STAT_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
| PROTOCOL_TYPE_FLAG | DOUBLE | N | Protocol type flag determining how the protocol is to be managed. 1 - PowerPlans Managed Oncology, 2 - Future Recurring. |
| REJECTED_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a rejected clinical review status. |
| REJECTED_RX_VERIFY_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a rejected Rx verification status. |
| TOTAL_DOT_CNT | DOUBLE | N | Total number of day of treatment orders which are related to the protocol order. |
| TWO_CLIN_REVIEW_REQD_DOT_CNT | DOUBLE | Y | The count of related day of treatment orders which require two Rx verify reviews. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| VOIDED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Voided (Deleted) status. |
| VOIDED_WITH_RESULTS_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Voided with Results status. |
Relationship Detail - PROTOCOL_ORDER_STAT
| Child Column in PROTOCOL_ORDER_STAT(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | FIRST_DOT_ORDER_ID | ORDERS | ORDER_ID |
| LAST_DOT_ORDER_ID | ORDERS | ORDER_ID | |
| PROTOCOL_ORDER_ID | ORDERS | ORDER_ID |
REPRINT_HX
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | REPRINT_HX |
| Definition: | Prescription reprint history |
| Table Type: | ACTIVITY |
Column Detail - REPRINT_HX
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ORDER_ID | DOUBLE | N | Order Id from the orders table |
| PRSNL_ID | DOUBLE | N | personnel identifier |
| REPRINT_HX_ID | DOUBLE | N | reprint prescription history identifier |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - REPRINT_HX
| Child Column in REPRINT_HX(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
| PRSNL_ID | PRSNL | PERSON_ID |