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