ORDER_COMPLIANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Compliance
Definition: Stores the information for patient compliance of orders that are within the system.
Table Type: ACTIVITY





Column Detail - ORDER_COMPLIANCE


Column Name Type Null? Definition
ENCNTR_COMPLIANCE_STATUS_FLAG DOUBLE N The compliance status for the encounter. 0 - Complete, 1 - Incomplete, 2 - In Error
ENCNTR_ID DOUBLE N Encounter that the compliance was captured for.
NO_KNOWN_HOME_MEDS_IND DOUBLE N Indicates that no know home medications were present for a patient at the time the compliance was captured.
ORDER_COMPLIANCE_ID DOUBLE N The primary key of this table
PERFORMED_DT_TM DATETIME N The date and time the compliance was captured.
PERFORMED_PRSNL_ID DOUBLE N The personnel that captured the patient compliance.
PERFORMED_TZ DOUBLE N The time zone the personnel was in when the compliance information was captured.
UNABLE_TO_OBTAIN_IND DOUBLE N Indicates that no information was able to be obtained for any order during the time that the compliance was captured.
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 - ORDER_COMPLIANCE


Child Column in ORDER_COMPLIANCE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERFORMED_PRSNL_ID PRSNL PERSON_ID




Parent Column in ORDER_COMPLIANCE (PK) Child Table Name Child Column Name
Children: ORDER_COMPLIANCE_ID ORDER_COMPLIANCE_DETAIL ORDER_COMPLIANCE_ID


ORDER_COMPLIANCE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Compliance Detail
Definition: Stores detail information about patient compliance for orders that are within the system.
Table Type: ACTIVITY





Column Detail - ORDER_COMPLIANCE_DETAIL


Column Name Type Null? Definition
COMPLIANCE_CAPTURE_DT_TM DATETIME N The date/time that compliance information for the order was captured during the compliance conversation.
COMPLIANCE_STATUS_CD DOUBLE N The status of the compliance that was captured according to the information source. For example, not taking, still taking as prescribed, etc.
INFORMATION_SOURCE_CD DOUBLE N The source that provided the information for the order during the compliance conversation.
LAST_OCCURRED_DT_ONLY_IND DOUBLE N Indicates whether the last occurred date/time field has only a valid date (1) or both a valid date and a valid time (0).
LAST_OCCURRED_DT_TM DATETIME Y The last date and time that the patient took a medication, performed a procedure or carried out an order.
LAST_OCCURRED_TZ DOUBLE Y The time zone for the last occurred date time. This time zone is based on the encounter location.
LONG_TEXT_ID DOUBLE N The long text id from the long text table where the comments that were captured for an order during the compliance conversation are stored.
ORDER_COMPLIANCE_DETAIL_ID DOUBLE N The primary key of this table.
ORDER_COMPLIANCE_ID DOUBLE N The ID of the order compliance that the order compliance detail is related to.
ORDER_NBR DOUBLE N The order ID from the orders table for the order that was reviewed during the compliance conversation.
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_COMPLIANCE_DETAIL


Child Column in ORDER_COMPLIANCE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ORDER_COMPLIANCE_ID ORDER_COMPLIANCE ORDER_COMPLIANCE_ID


ORDER_POTENTIAL_DIAGNOSIS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Potential Diagnosis
Definition: Stores potential diagnosis information that is associated to an order.
Table Type: ACTIVITY





Column Detail - ORDER_POTENTIAL_DIAGNOSIS


Column Name Type Null? Definition
DIAGNOSIS_DISPLAY VARCHAR(255) Y The annotated display of the pending diagnosis displayed face up to the user
NOMENCLATURE_ID DOUBLE N Foreign key to the nomenclature associated to this pending diagnosis after crossmapping occurred
ORDER_POTENTIAL_DIAGNOSIS_ID DOUBLE N Unique generated number that identifies a single row on the order_potential_diagnosis table.
ORIGINATING_NOMENCLATURE_ID DOUBLE N Foreign key to the nomenclature associated to this pending diagnosis before crossmapping occurred
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 - ORDER_POTENTIAL_DIAGNOSIS


Child Column in ORDER_POTENTIAL_DIAGNOSIS(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ORIGINATING_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


ORDER_RECON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Reconciliation
Definition: Stores information related to a specific order reconciliation conversation.
Table Type: ACTIVITY





Column Detail - ORDER_RECON


Column Name Type Null? Definition
CROSS_ENCNTR_IND DOUBLE N The table row was created by a reconciliation intended to bridge care from one encounter to another.
ENCNTR_ID DOUBLE N The ID of the encounter this order reconciliation is related to.
NEXT_LOC_CD DOUBLE N The next level of care code of where the patient will be admitted, transferred or discharged to after this reconciliation.
NO_KNOWN_MEDS_IND DOUBLE N Indicates if medications existed during the reconciliation conversation. 0 - Meds were reconciled. 1 - No meds were reconciled.
ORDER_RECON_ID DOUBLE N The primary identifier of this table.
PERFORMED_DT_TM DATETIME N The date and time that the reconciliation took place.
PERFORMED_PRSNL_ID DOUBLE N Personnel identifier of the user that performed the reconciliation.
PERFORMED_TZ DOUBLE N Performed personnel time zone at the time of reconciliation.
PERSON_ID DOUBLE N The person ID from the person table on which this reconciliation was performed.
RECON_STATUS_CD DOUBLE N The reconciliation status code. Field can be 0.0 or a value from code set 4002695.
RECON_TYPE_FLAG DOUBLE N The type of reconciliation that was performed. 1 - Admission, 2 - Transfer, 3 - Discharge, 4 - Short Term Leave, 5 - Return From Short Term Leave
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 - ORDER_RECON


Child Column in ORDER_RECON(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERFORMED_PRSNL_ID PRSNL PERSON_ID




Parent Column in ORDER_RECON (PK) Child Table Name Child Column Name
Children: ORDER_RECON_ID ORDER_RECON_DETAIL ORDER_RECON_ID


ORDER_RECON_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Reconciliation Detail
Definition: Stores detailed information about each order that was reconciled by a user during the patient care venue changes.
Table Type: ACTIVITY





Column Detail - ORDER_RECON_DETAIL


Column Name Type Null? Definition
CLINICAL_DISPLAY_LINE VARCHAR(2000) N Clinical display line for the order at the time of reconciliation.
CONTINUE_ORDER_IND DOUBLE N Indicates whether the personnel that performed the reconciliation chose to continue the order. 1 - Continue the order, 2 - Do not continue the order, 3 - Continue the order with changes, 4 - acknowledge order.
ORDER_MNEMONIC VARCHAR(1000) Y The mnemonic for this order.
ORDER_NBR DOUBLE N The order ID for the reconciled order.
ORDER_PROPOSAL_ID DOUBLE N The proposal id for the reconciled proposal.
ORDER_RECON_DETAIL_ID DOUBLE N The primary key of this table.
ORDER_RECON_ID DOUBLE N The ID of the order reconciliation that this detail is related to.
RECON_NOTE_TXT VARCHAR(500) Y This field will be used to store any reconciliation related note for an order.
RECON_ORDER_ACTION_MEAN VARCHAR(20) N The action that was taken on an order during the reconciliation process.
SIMPLIFIED_DISPLAY_LINE VARCHAR(1000) Y Simplified display line for the order at the time of reconciliation
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_RECON_DETAIL


Child Column in ORDER_RECON_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ORDER_PROPOSAL_ID ORDER_PROPOSAL ORDER_PROPOSAL_ID
ORDER_RECON_ID ORDER_RECON ORDER_RECON_ID