Table Detail Report
ORDER_THERAP_SBSTTN
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Order Therapeutic Substitution |
| Definition: | This table stores the therapeutic substitution information for an order at the ingredient level. When a therapeutic substitution rule is accepted, overridden or an alternate regimen applied to an order, a row will be added to this table. |
| Table Type: | ACTIVITY |
Column Detail - ORDER_THERAP_SBSTTN
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTION_SEQUENCE | DOUBLE | N | A sequence number used to identify the order of the actions. |
| COMP_SEQUENCE | DOUBLE | N | A system assigned number, identifying the order of the ingredient on which the substitution is applied. |
| ITEM_ID | DOUBLE | N | The ID that uniquely identifies the pharmacy product for which the therapeutic substitution rule is applied. This field will reference the item_id field on the medication_definition table. This field must be valued if a therapeutic substitution rule at the product level was accepted. |
| ORDER_ID | DOUBLE | N | The ID of the order associated to this substitution. |
| ORDER_THERAP_SBSTTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the order_therap_sbsttn table. It is a number internally assigned by the system. |
| OVERRIDE_REASON_CD | DOUBLE | N | Codified value indicating the reason the therapeutic substitution was overridden. When a therapeutic substitution is accepted or an alternate regimen is applied, this field will be 0. If the therapeutic substitution is overridden, this field must contain the reason code value. |
| SUBSTITUTION_ACCEPT_FLAG | DOUBLE | N | The flag to indicate whether the therapeutic substitution was accepted or overridden. The possible values are 1 = Accept, 2 = Override and 3 = Alternate Regimen. |
| THERAP_SBSTTN_ID | DOUBLE | N | The ID of the therapeutic substitution rule applied to the order. This field will be 0 if the substitution rule is overridden. If the substitution rule is accepted or an alternate regimen is applied, this field should contain a unique identifier from the rx_therap_sbsttn table. |
| 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_THERAP_SBSTTN
| Child Column in ORDER_THERAP_SBSTTN(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ITEM_ID | MEDICATION_DEFINITION | ITEM_ID |
| ORDER_ID | ORDERS | ORDER_ID |
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 |