Table Detail Report
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 |
ORDER_ERX_INFO
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Order ERX Information |
| Definition: | Information for electronically prescribed orders. |
| Table Type: | ACTIVITY |
Column Detail - ORDER_ERX_INFO
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| EXTERNAL_CHAIN | VARCHAR(500) | Y | An ExternalChain is an external id used to identify all; orders in one order chain. An order chain is a set; of orders that are linked together in chronological order. An; order chain is used when an order is renewed or replaced.; The purpose is to be able provide a grouping of related orders. |
| ORDER_ERX_INFO_ID | DOUBLE | N | Unique generated number that identifies a single row on the ORDER_ERX_INFO table. |
| ORDER_ID | DOUBLE | Y | ORDER_ID from orders table associated to this prescription. |
| UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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_ERX_INFO
| Child Column in ORDER_ERX_INFO(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
ORDER_ERX_STATUS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Electronic Prescription Order Status |
| Definition: | Stores status and related information for each electronically routed prescription order |
| Table Type: | ACTIVITY |
Column Detail - ORDER_ERX_STATUS
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| MESSAGE_IDENT | VARCHAR(100) | Y | The identifier uniquely identifying the current NCPDP transaction. |
| ORDER_ERX_STATUS_ID | DOUBLE | N | Unique generated number that identifies a single row on the ORDER_ERX_STATUS table. |
| ORDER_ID | DOUBLE | N | The identifier of the order that references the original prescription. |
| ORDER_RELATION_CD | DOUBLE | N | The relationship between the two orders. |
| PHARMACY_IDENT | VARCHAR(100) | Y | The identifier of the pharmacy to whom the electronic prescription is being sent. |
| PHARMACY_NOTE | VARCHAR(1000) | Y | The note or comment from the pharmacy related to the current order. |
| REASON_CODES_TXT | VARCHAR(2000) | Y | List of reason codes comma delimited. |
| REASON_CODE_BITMASK | DOUBLE | Y | The reason code if the order was denied/cancelled |
| RELATED_ORDER_ID | DOUBLE | N | The identifier of the order which is related to the order that references the original prescription. |
| RELATES_TO_MESSAGE_IDENT | VARCHAR(100) | Y | The identifier of the previous NCPDP transaction that the current message relates to. |
| STATUS_CD | DOUBLE | N | The status of the electronic prescription. |
| TRANSACTION_TYPE_FLAG | DOUBLE | N | The type of transaction that the current electronic prescription order is undergoing. |
| 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_ERX_STATUS
| Child Column in ORDER_ERX_STATUS(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
| RELATED_ORDER_ID | ORDERS | ORDER_ID |
ORDER_EXTERNAL_IDENTIFIER
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Order External Identifier |
| Definition: | External identifiers of orders. |
| Table Type: | ACTIVITY |
Column Detail - ORDER_EXTERNAL_IDENTIFIER
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| EXTERNAL_IDENT | VARCHAR(255) | Y | Identifier of the External resource. |
| EXTERNAL_RESOURCE_VERSION_TXT | VARCHAR(4000) | Y | The latest known version of the external resource. |
| EXTERNAL_URL | VARCHAR(4000) | Y | The URL for the external resource that populated the row. |
| ORDER_EXTERNAL_IDENTIFIER_ID | DOUBLE | N | Unique generated number that identifies a single row on the ORDER_EXTERNAL_IDENTIFIER table. |
| ORDER_ID | DOUBLE | Y | The order_id from Orders table. |
| SYSTEM_URI | VARCHAR(4000) | Y | The number or identifier of the external resource that populated the row. |
| UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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_EXTERNAL_IDENTIFIER
| Child Column in ORDER_EXTERNAL_IDENTIFIER(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORDER_ID | ORDERS | ORDER_ID |
ORDER_EXT_CALL_TRACKING
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | order external call tracking |
| Definition: | This table stores tracking information for calls made during order processing to external services. |
| Table Type: | ACTIVITY |
Column Detail - ORDER_EXT_CALL_TRACKING
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTION_SEQUENCE | DOUBLE | N | The sequence of the ORDER_ACTION that executed the external service call being tracked. |
| ORDER_EXT_CALL_TRACKING_ID | DOUBLE | N | Unique generated number that identifies a single row on the order_ext_call_tracking table. |
| ORDER_ID | DOUBLE | N | Identifies the order associated to the external service call being tracked. |
| SERVICE_NAME_TXT | VARCHAR(255) | N | Human-readable name of the external service being tracked. |
| TRANSACTION_CALL_DT_TM | DATETIME | Y | The date/time at which the external service was called. |
| 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_EXT_CALL_TRACKING
| Child Column in ORDER_EXT_CALL_TRACKING(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTION_SEQUENCE | ORDER_ACTION | ACTION_SEQUENCE |
| ORDER_ID | ORDER_ACTION | ORDER_ID |