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