Table Detail Report
ORM_ORD_HIST_SNAPSHOT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | orm_order_history_snapshot |
Definition: | This table will be a list of medication history snapshots. These snapshots will allow the user to see how the medication history has changed. |
Table Type: | ACTIVITY |
Column Detail - ORM_ORD_HIST_SNAPSHOT
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_ID | DOUBLE | N | The encounter for which the medication history snapshot was taken |
MED_HISTORY_STATUS_IND | DOUBLE | N | The medication history status at the time that the snapshot was taken |
ORM_ORD_HIST_SNAPSHOT_ID | DOUBLE | N | Unique generated number that identifies a single row on the orm_ord_hist_snapshot table. |
PATIENT_ID | DOUBLE | N | The person for whom the medication history snapshot was taken. |
PERFORMED_DT_TM | DATETIME | N | The date/time the snapshot was taken. |
PERFORMED_PERSON_ID | DOUBLE | N | The person who triggered the snapshot. |
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 - ORM_ORD_HIST_SNAPSHOT
Child Column in ORM_ORD_HIST_SNAPSHOT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PATIENT_ID | PERSON | PERSON_ID | |
PERFORMED_PERSON_ID | PRSNL | PERSON_ID |
Parent Column in ORM_ORD_HIST_SNAPSHOT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORM_ORD_HIST_SNAPSHOT_ID | ORM_ORD_HIST_SNAPSHOT_COMP | SNAPSHOT_ID |
ORM_ORD_HIST_SNAPSHOT_COMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | orm_order_history_snapshot_component |
Definition: | Contains history snapshot components. These components are the individual orders which are in the snapshots |
Table Type: | ACTIVITY |
Column Detail - ORM_ORD_HIST_SNAPSHOT_COMP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | N | The order action sequence of the order when the snapshot was taken. |
ACTIVITY_TYPE_CD | DOUBLE | N | The order's activity type. |
CATALOG_CD | DOUBLE | N | The catalog code of the order. |
CATALOG_TYPE_CD | DOUBLE | N | The catalog type of the order. |
CLINICAL_DISPLAY_LINE | VARCHAR(255) | Y | The order's clinical display line when the snapshot was taken. |
COMPLIANCE_LONG_TEXT_ID | DOUBLE | N | The compliance long text id. |
COMPLIANCE_STATUS_CD | DOUBLE | N | The order's compliance status when the snapshot was taken. |
ENCNTR_ID | DOUBLE | N | The encounter for which the medication history snapshot was taken |
HNA_ORDER_MNEMONIC | VARCHAR(100) | Y | Order HNA mnemonic. |
ORDERED_AS_MNEMONIC | VARCHAR(100) | Y | Ordered as mnemonic. |
ORDER_ID | DOUBLE | N | The order's id. |
ORDER_LAST_UPD_DT_TM | DATETIME | Y | The date the order was last updated at the time that the snapshot was taken. |
ORDER_LAST_UPD_TZ | DOUBLE | Y | The time zone for the last updated date/time. |
ORDER_MNEMONIC | VARCHAR(100) | Y | Order mnemonic. |
ORDER_STATUS_CD | DOUBLE | N | The order's status. |
ORM_ORD_HIST_SNAPSHOT_COMP_ID | DOUBLE | N | Unique generated number that identifies a single row on the orm_ord_hist_snapshot_comp table. |
SIMPLIFIED_DISPLAY_LINE | VARCHAR(1000) | Y | The order's simplified display line when the snapshot was taken. |
SNAPSHOT_ID | DOUBLE | N | The snapshot component is linked to this snapshot. |
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. |
VENUE_TYPE_CD | DOUBLE | N | The venue type of the order at the time the snapshot was created. |
Relationship Detail - ORM_ORD_HIST_SNAPSHOT_COMP
Child Column in ORM_ORD_HIST_SNAPSHOT_COMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
COMPLIANCE_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
ACTION_SEQUENCE | ORDER_ACTION | ACTION_SEQUENCE | |
ORDER_ID | ORDER_ACTION | ORDER_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SNAPSHOT_ID | ORM_ORD_HIST_SNAPSHOT | ORM_ORD_HIST_SNAPSHOT_ID |
PROTOCOL_ORDER_STAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Protocol Order Statistic |
Definition: | Manages protocol group information common to protocol and day of treatments across a given protocol order. |
Table Type: | ACTIVITY |
Column Detail - PROTOCOL_ORDER_STAT
Column Name | Type | Null? | Definition |
---|---|---|---|
CANCELED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Canceled status. |
COMPLETED_CLIN_REV_DOT_CNT | DOUBLE | N | The count of pharmacy day of treatment orders who have a completed clinical review status. |
COMPLETED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Completed status. |
DISCONTINUED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Discontinued status. |
FIRST_DOT_ORDER_ID | DOUBLE | N | The order ID of the first related day of treatment order. This is considered to be the day of treatment order which represents the start of the protocol order. This field will always be populated to show a relationship to a day of treatment order. |
FUTURE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Future status. |
INCOMPLETE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an Incomplete status. |
INPROCESS_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an In-process status. |
LAST_DOT_ORDER_ID | DOUBLE | N | The order ID of the last related day of treatment order. This is considered to be the day of treatment order which represents the stop of the protocol order. This field will always be populated to show a relationship to a day of treatment order. |
NEEDING_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a needing clinical review status. |
NEEDING_RX_VERIFY_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a needing Rx verification status. |
NOT_APPLY_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a does not apply clinical review status. |
ONE_CLIN_REVIEW_REQD_DOT_CNT | DOUBLE | Y | The count of related day of treatment orders which require one Rx verify review. |
ORDERED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in an Ordered status. |
PENDING_COMPLETE_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Pending Complete status. |
PROTOCOL_ORDER_ID | DOUBLE | N | The ID of the related protocol order. |
PROTOCOL_ORDER_STAT_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
PROTOCOL_TYPE_FLAG | DOUBLE | N | Protocol type flag determining how the protocol is to be managed. 1 - PowerPlans Managed Oncology, 2 - Future Recurring. |
REJECTED_CLIN_REV_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a rejected clinical review status. |
REJECTED_RX_VERIFY_DOT_CNT | DOUBLE | N | The count of related pharmacy day of treatment orders who have a rejected Rx verification status. |
TOTAL_DOT_CNT | DOUBLE | N | Total number of day of treatment orders which are related to the protocol order. |
TWO_CLIN_REVIEW_REQD_DOT_CNT | DOUBLE | Y | The count of related day of treatment orders which require two Rx verify reviews. |
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. |
VOIDED_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Voided (Deleted) status. |
VOIDED_WITH_RESULTS_DOT_CNT | DOUBLE | N | The count of related day of treatment orders which are in a Voided with Results status. |
Relationship Detail - PROTOCOL_ORDER_STAT
Child Column in PROTOCOL_ORDER_STAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FIRST_DOT_ORDER_ID | ORDERS | ORDER_ID |
LAST_DOT_ORDER_ID | ORDERS | ORDER_ID | |
PROTOCOL_ORDER_ID | ORDERS | ORDER_ID |
REPRINT_HX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | REPRINT_HX |
Definition: | Prescription reprint history |
Table Type: | ACTIVITY |
Column Detail - REPRINT_HX
Column Name | Type | Null? | Definition |
---|---|---|---|
ORDER_ID | DOUBLE | N | Order Id from the orders table |
PRSNL_ID | DOUBLE | N | personnel identifier |
REPRINT_HX_ID | DOUBLE | N | reprint prescription history identifier |
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 - REPRINT_HX
Child Column in REPRINT_HX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
PRSNL_ID | PRSNL | PERSON_ID |
TRACING_TICKET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | tracing_ticket |
Definition: | This table stores tracing/logging information among the services we own. The number of rows on this table is managed internally by Cerner and the default maximum size is 10. million. |
Table Type: | ACTIVITY |
Column Detail - TRACING_TICKET
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATION_DT_TM | DATETIME | N | The date/time at which the ticket was created. |
GROUP_VALUE | DOUBLE | N | This field is used to organize tickets into logical groups. |
PARENT_TICKET_ID | DOUBLE | N | This field allows recursive association between parent and child rows. A value of zero indicates a parent ticket row, while a positive value indicates a child ticket row. |
TICKET_SEQ | DOUBLE | N | This field indicates the depth of a ticket in a chain of services. A value of zero indicates a parent ticket row. |
TRACING_MSG_TXT | VARCHAR(4000) | N | This field stores tracing message for child ticket rows. |
TRACING_TICKET_ID | DOUBLE | N | Unique generated number that identifies a single row on the tracing_ticket 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 - TRACING_TICKET
Child Column in TRACING_TICKET(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_TICKET_ID | TRACING_TICKET | TRACING_TICKET_ID |
Parent Column in TRACING_TICKET (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TRACING_TICKET_ID | TRACING_TICKET | PARENT_TICKET_ID |