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 |