Table Detail Report
ORDER_COMMENT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | ORDER COMMENT |
| Definition: | Stores comments associated with an order |
| Table Type: | ACTIVITY |
Column Detail - ORDER_COMMENT
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTION_SEQUENCE | DOUBLE | N | which action sequence the comment goes with |
| COMMENT_DT_TM | DATETIME | Y | when the comment was written |
| COMMENT_PRSNL_ID | DOUBLE | N | **Obsolete Column - Column was never used** who wrote the comment |
| COMMENT_TYPE_CD | DOUBLE | N | type of comment |
| DISPLAY_MASK | DOUBLE | Y | Display bit mask to tell who needs to show the comment |
| LONG_TEXT_ID | DOUBLE | N | the long text id for the long text table |
| ORDER_ID | DOUBLE | N | Order Id from the orders table |
| 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_COMMENT
| Child Column in ORDER_COMMENT(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
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 |