Table Detail Report
ORDER_DAILY_REVIEW_DEFER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | order daily review deferral |
Definition: | This table stores information about the daily review responsibility deferrals. |
Table Type: | ACTIVITY |
Column Detail - ORDER_DAILY_REVIEW_DEFER
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFER_BY_PRSNL_ID | DOUBLE | N | The personnel who deferred the daily review responsibility. |
DEFER_COMMENT_TXT | VARCHAR(255) | Y | The comment associated to the deferred daily review responsibility. |
DEFER_DT_TM | DATETIME | N | The date and time the deferral occurred. |
DEFER_FROM_PRSNL_GROUP_ID | DOUBLE | N | The personnel group who deferred the daily review responsibility. |
DEFER_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
FROM_DAILY_REVIEW_RSPNL_ID | DOUBLE | N | The daily review responsibility that is being deferred from. |
ORDER_DAILY_REVIEW_DEFER_ID | DOUBLE | N | Unique generated number that identifies a single row on the order_daily_review_defer table. |
ORDER_ID | DOUBLE | N | The order associated to the deferred daily review responsibility. |
TO_DAILY_REVIEW_RSPNL_ID | DOUBLE | N | The daily review responsibility that is being deferred to. |
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_DAILY_REVIEW_DEFER
Child Column in ORDER_DAILY_REVIEW_DEFER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
FROM_DAILY_REVIEW_RSPNL_ID | ORDER_DAILY_REVIEW_RSPNL | ORDER_DAILY_REVIEW_RSPNL_ID | |
TO_DAILY_REVIEW_RSPNL_ID | ORDER_DAILY_REVIEW_RSPNL | ORDER_DAILY_REVIEW_RSPNL_ID | |
DEFER_BY_PRSNL_ID | PRSNL | PERSON_ID | |
DEFER_FROM_PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
ORDER_DAILY_REVIEW_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order daily review history |
Definition: | Retains all daily review resolution actions. |
Table Type: | ACTIVITY |
Column Detail - ORDER_DAILY_REVIEW_HISTORY
Column Name | Type | Null? | Definition |
---|---|---|---|
DAILY_REVIEW_DT_NBR | DOUBLE | N | The date number of the date that this daily review is for. |
DAILY_REVIEW_RESOLUTION_FLAG | DOUBLE | N | The flag used to indicate the resolution type of the daily review. 0 = Completed by Provider, 1 = Resolved by Order Action, 2 - No Longer Needed, 3 - Not Done. |
ORDER_ACTION_SEQUENCE | DOUBLE | Y | The sequence of the action on the order which caused the order daily review resolution. |
ORDER_DAILY_REVIEW_HISTORY_ID | DOUBLE | N | Unique generated number that identifies a single row on the order_daily_review_history table. |
ORDER_ID | DOUBLE | N | The order associated to this daily review responsibility. |
OVERDUE_IND | DOUBLE | N | The daily review was resolved when overdue or not overdue. |
REVIEWED_DT_TM | DATETIME | N | The date time the daily review was reviewed. |
REVIEWED_PRSNL_ID | DOUBLE | N | Personnel that reviewed the daily review. |
REVIEWED_TZ | DOUBLE | N | Time zone associated with the corresponding DT_TM column. |
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_DAILY_REVIEW_HISTORY
Child Column in ORDER_DAILY_REVIEW_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
REVIEWED_PRSNL_ID | PRSNL | PERSON_ID |
ORDER_DAILY_REVIEW_RSPNL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | order daily review responsibility |
Definition: | This table stores information about the daily review responsibilities associated to orders. |
Table Type: | ACTIVITY |
Column Detail - ORDER_DAILY_REVIEW_RSPNL
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSIGNED_PRSNL_ID | DOUBLE | N | The personnel who is filtered to view this daily review responsibility. |
DAILY_REVIEW_RSPNL_BIT | DOUBLE | N | A bitmask which indicates additional attributes about the daily review responsibility. The 1st bit (2^0) indicates if all daily reviews are resolved. The 2nd bit (2^1) indicates if any resolved when overdue daily reviews exist. The 3rd bit (2^2) indicates that this responsibility was deferred to another responsibility. The 4th bit (2^3) indicates that this responsibility was deferred from another responsibility. |
DAILY_REVIEW_STATUS_FLAG | DOUBLE | N | The flag used to indicate the status of the daily review responsibility. 0 = inactive, 1 = active. |
DUE_TM_TXT | VARCHAR(4) | Y | The due time of the daily review for this responsibility. |
EFFECTIVE_START_DT_TM | DATETIME | N | The start date time of this daily review responsibility. |
EFFECTIVE_START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
EFFECTIVE_STOP_DT_TM | DATETIME | Y | The stop date time of this daily review responsibility. |
EFFECTIVE_STOP_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
ENCNTR_ID | DOUBLE | N | The persons encounter id. |
ORDER_DAILY_REVIEW_RSPNL_ID | DOUBLE | N | Unique generated number that identifies a single row on the order_daily_review_rspnl table. |
ORDER_ID | DOUBLE | N | The order associated to this daily review responsibility. |
PATIENT_LOCATION_FACILITY_CD | DOUBLE | N | The patient facility location that is responsible for this daily review responsibility. |
PATIENT_LOCATION_NURSE_UNIT_CD | DOUBLE | N | The patient nurse unit location that is responsible for this daily review responsibility. |
PATIENT_LOC_TZ | DOUBLE | Y | The time zone of the patient's location. |
PERSON_ID | DOUBLE | N | Person whom this daily review is for. |
REVIEW_TRACKING_VALUE_TXT | VARCHAR(512) | Y | The review tracking string used to determine if a daily review has been resolved |
RSPNL_BEGIN_DT_NBR | DOUBLE | N | The date number when daily reviews for the responsibility are active. |
RSPNL_END_DT_NBR | DOUBLE | Y | The date number when daily reviews for the responsibility end. |
RSPNL_PRSNL_GROUP_ID | DOUBLE | N | The personnel group responsible for this daily review responsibility. |
RSPNL_PRSNL_ID | DOUBLE | N | Personnel who is responsible for this daily review responsibility. |
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_DAILY_REVIEW_RSPNL
Child Column in ORDER_DAILY_REVIEW_RSPNL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PATIENT_LOCATION_FACILITY_CD | LOCATION | LOCATION_CD | |
PATIENT_LOCATION_NURSE_UNIT_CD | LOCATION | LOCATION_CD | |
ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID | |
ASSIGNED_PRSNL_ID | PRSNL | PERSON_ID | |
RSPNL_PRSNL_ID | PRSNL | PERSON_ID | |
RSPNL_PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
Parent Column in ORDER_DAILY_REVIEW_RSPNL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORDER_DAILY_REVIEW_RSPNL_ID | ORDER_DAILY_REVIEW_DEFER | FROM_DAILY_REVIEW_RSPNL_ID |
ORDER_DAILY_REVIEW_DEFER | TO_DAILY_REVIEW_RSPNL_ID |
ORDER_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER DETAIL |
Definition: | Table used to store all the order details captured about an order. |
Table Type: | ACTIVITY |
Column Detail - ORDER_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | N | The sequence of the action placed on the order. |
DETAIL_SEQUENCE | DOUBLE | N | The sequence of the order details. |
OE_FIELD_DISPLAY_VALUE | VARCHAR(255) | Y | The display value of the order detail. |
OE_FIELD_DISPLAY_VALUE_EXTEND | VARCHAR(4000) | Y | The extended display value of the order detail. |
OE_FIELD_DT_TM_VALUE | DATETIME | Y | The date and time value of the field if of type date/time. |
OE_FIELD_ID | DOUBLE | N | The id of the field. |
OE_FIELD_MEANING | VARCHAR(25) | Y | The meaning of the field. |
OE_FIELD_MEANING_ID | DOUBLE | N | The Cerner controlled value that id's the meaning of the field. |
OE_FIELD_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
OE_FIELD_VALUE | DOUBLE | Y | The value of the field if a numeric or coded value. |
ORDER_ID | DOUBLE | N | The id of the order. |
PARENT_ACTION_SEQUENCE | DOUBLE | Y | The action sequence of the parent order. |
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_DETAIL
Child Column in ORDER_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
Parent Column in ORDER_DETAIL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACTION_SEQUENCE | ORDER_DETAIL_HISTORY | ACTION_SEQUENCE |
DETAIL_SEQUENCE | ORDER_DETAIL_HISTORY | DETAIL_SEQUENCE | |
ORDER_ID | ORDER_DETAIL_HISTORY | ORDER_ID |
ORDER_DETAIL_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Detail History |
Definition: | This table stores order details that are altered by the system from what the user entered. |
Table Type: | ACTIVITY |
Column Detail - ORDER_DETAIL_HISTORY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | N | Action sequence of the order (from the order_action table) on which the details were added or altered. Part of a foreign key to the order_detail table. |
DETAIL_ALTER_FLAG | DOUBLE | N | Indicates what type of change occurred on the current order detail row. For new orders, this field would be set to 2. 1 - Modified, 2 - Add, 3- Delete. |
DETAIL_ALTER_TRIGGER_CD | DOUBLE | N | A code value that indicates what triggered the alter to the order detail. For example, Auto Product Assign. |
DETAIL_SEQUENCE | DOUBLE | N | The sequence of the order details. Part of a foreign key to the order_detail table. |
HISTORY_SEQUENCE | DOUBLE | N | The sequence of the history records for an order detail. It is the sequence in which the details were altered. |
OE_FIELD_DISPLAY_VALUE | VARCHAR(255) | Y | The display value of the order detail. |
OE_FIELD_DT_TM_VALUE | DATETIME | Y | The date and time value captured by this order detail. This is only filled out for date/time details. |
OE_FIELD_ID | DOUBLE | N | This number uniquely identifies the order entry field. It is defined in the order_entry_fields table and is a foreign key to that table. |
OE_FIELD_MEANING_ID | DOUBLE | N | This is the Cerner defined meaning id associated to the oe_field_id. It identifies the type of information that the detail captures. |
OE_FIELD_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column (OE_FIELD_DT_TM_VALUE). This is only filled out for date/time details. |
OE_FIELD_VALUE | DOUBLE | Y | Numeric value captured by this detail. This could be a codified value or simple numeric value. |
ORDER_DETAIL_HISTORY_ID | DOUBLE | N | The unique primary key of this table. |
ORDER_ID | DOUBLE | N | The order ID for the order whose details were altered or added. This is part of a foreign key to the Order_Detail table and is a separate foreign key to the orders table for archive purposes. |
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_DETAIL_HISTORY
Child Column in ORDER_DETAIL_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OE_FIELD_MEANING_ID | OE_FIELD_MEANING | OE_FIELD_MEANING_ID |
ORDER_ID | ORDERS | ORDER_ID | |
ACTION_SEQUENCE | ORDER_DETAIL | ACTION_SEQUENCE | |
DETAIL_SEQUENCE | ORDER_DETAIL | DETAIL_SEQUENCE | |
ORDER_ID | ORDER_DETAIL | ORDER_ID | |
OE_FIELD_ID | ORDER_ENTRY_FIELDS | OE_FIELD_ID |