Table Detail Report

ORDER_TRACKING_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Tracking History
Definition: History of tracked orders for physicians
Table Type: ACTIVITY





Column Detail - ORDER_TRACKING_HIST


Column Name Type Null? Definition
ORDER_ID DOUBLE N The unique order identifier.
ORDER_TRACKING_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_TRACKING_HISTORICAL table.
REMOVAL_SYSTEM_FLAG DOUBLE N The value to identifiy the sytem that populated the row. 0 - Undefined. 1 - Orders Tracking Worklist Async Script. 2 - Cleanup Ops Job, 3 - Manual Completion Service.
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.



Relationship Detail - ORDER_TRACKING_HIST


Child Column in ORDER_TRACKING_HIST(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


ORDER_TRACKING_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Tracking Worklist
Definition: Tracked orders for physicians.
Table Type: ACTIVITY





Column Detail - ORDER_TRACKING_WORKLIST


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N Sub activity type order.
ACTIVITY_TYPE_CD DOUBLE N Activity type of the order.
CATALOG_CD DOUBLE Y The catalog code associated to the order.
CATALOG_TYPE_CD DOUBLE N The catalog type of the order.
DEPT_STATUS_CD DOUBLE N The departmental status of the order
EFFECTIVE_ENCNTR_ID DOUBLE N The effective encounter of the order.
END_DUE_DT_TM DATETIME Y End due date and time of the order.
ORDER_ID DOUBLE N The unique order ID
ORDER_PROVIDER_ID DOUBLE N The ID of the ordering provider.
ORDER_STATUS_CD DOUBLE N The status of the order.
ORDER_TRACKING_WORKLIST_ID DOUBLE N Unique generated number that identifies a single row on the ORDERS_TRACKING_WORKLIST table.
ORIGINATING_NURSE_UNIT_CD DOUBLE N Originating nurse unit from where the order was placed.
ORIG_ORD_DT_TM DATETIME Y Originally ordered date and time of the order.
PATIENT_ID DOUBLE N The patient ID for who the order was created.
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.



Relationship Detail - ORDER_TRACKING_WORKLIST


Child Column in ORDER_TRACKING_WORKLIST(FK) Parent Table Name Parent Column Name
Parents: EFFECTIVE_ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
PATIENT_ID PERSON PERSON_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID


ORDER_WARNING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Warning
Definition: This table stores warnings related to orders.
Table Type: ACTIVITY





Column Detail - ORDER_WARNING


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.
ORDER_ID DOUBLE N The identifier of the order which is associated to the warning.
ORDER_WARNING_ID DOUBLE N The primary key of this table. It is internally assigned by the system.
RESOLVED_ACTION_SEQUENCE DOUBLE N If populated, indicates the order action sequence which resolved this warning.
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.
WARNING_LEVEL_FLAG DOUBLE N Illustrates the warning level. Valid flag values are: 1 -Severe, 2 - Audit, 3 - Informational
WARNING_TYPE_FLAG DOUBLE N Illustrates the type of warning. Valid flag values are: 1 - Protocol person mismatch, 2 - Protocol/DoT removed for GDPR.



Relationship Detail - ORDER_WARNING


Child Column in ORDER_WARNING(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


ORM_ERROR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Management Error Log
Definition: Stores clinical and system admin information for failed asynch orm transactions.
Table Type: ACTIVITY





Column Detail - ORM_ERROR_LOG


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N The dt/tm the action was received by the system.
ACTION_STATUS_FLAG DOUBLE Y Describes the action. 0 - None 1 - Success 2 - Action Error 3 - Group Error
ACTION_TYPE_CD DOUBLE N The code representing the action that was attempted.
APPLICATION_NUMBER DOUBLE Y The number of the application used to initiate the transaction.
CLIENT_NODE_NAME VARCHAR(255) N The name of the node the program was when it initiated the transaction.
COMMUNICATION_TYPE_CD DOUBLE N The code representing the way the requesting personnel communicated that the action be taken to the personnel that submitted the action.
ENCNTR_ID DOUBLE N The encounter that the order was associated with when the action occurred.
ERROR_NBR DOUBLE Y The numeric representation of the generic error that occurred.
ERROR_SPECIFIC_NBR DOUBLE Y The numeric representation of the specific error that occurred.
ERROR_SPECIFIC_STRING VARCHAR(1000) Y The system administrator interpretation of the error that occurred.
ERROR_STRING VARCHAR(1000) Y The functional interpretation of the error that occurred.
INGREDIENT_MNEMONICS VARCHAR(2000) Y The mnemonics of the ingredients sent on the order.
LONG_BLOB LONGBLOB Y Stores the request sent to the Order Write Server when the error item is processed.
ORDERED_AS_MNEMONIC VARCHAR(255) Y The mnemonic used to place the order the action was applied to.
ORDER_CONVERSATION_ID DOUBLE N The identifier of the transaction that contained the action. While this column is populated from sequence ORDER_SEQ, it is not related to a primary key column.
ORDER_ID DOUBLE N The identifier of the order the action was applied to.
ORDER_PROVIDER_ID DOUBLE N The identifier of the personnel that requested the action be submitted.
ORM_ERROR_LOG_ID DOUBLE N Unique identifier to this table.
PERSON_ID DOUBLE N The identifier of the person that is the subject of the order.
PRSNL_ID DOUBLE N The identifier of the personnel that submitted the action.
REQUESTED_START_DT_TM DATETIME Y The dt/tm the order was requested to start.
REQUESTED_START_TZ DOUBLE Y Time zone associated with the requested_start_dt_tm column.
REQUEST_LONG_BLOB_ID DOUBLE N The identifier of the row on the long_blob table that is storing the transaction.
REQUEST_NUMBER DOUBLE N The name of the request used to initiate the transaction.
REQ_INDEX DOUBLE Y The item in the request that points to the failed action.
SYNONYM_ID DOUBLE N The identifier of the synonym representing the orderable the action was applied to.
TASK_NUMBER DOUBLE N The name of the task used to initiate the transaction.
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.
USERNAME VARCHAR(50) N The username of the person logged into the program that initiated the transaction.
USER_TYPE_FLAG DOUBLE Y Describes the user that placed the transaction with the failed action. 0 - Normal 1 - System



Relationship Detail - ORM_ERROR_LOG


Child Column in ORM_ERROR_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
REQUEST_LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
ORDER_ID ORDERS ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PERSON_ID PERSON PERSON_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID


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