Table Detail Report

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


ORDER_FUTURE_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Future Info
Definition: This table stores information related to orders in a future status.
Table Type: ACTIVITY





Column Detail - ORDER_FUTURE_INFO


Column Name Type Null? Definition
BEGIN_DUE_DT_TM DATETIME N The date at which the future order should be considered for activation. Will never be null. If no start range is defined, begin_due_dt_tm will equal end_due_dt_tm.
END_DUE_DT_TM DATETIME N The date after which the future order is considered to be overdue for activation. Will never be null. If no start range is defined, end_due_dt_tm will equal begin_due_dt_tm.
EXPIRATION_DT_TM DATETIME Y The date after which the future order qualifies for cancellation. Will never be null.
ORDER_FUTURE_INFO_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_FUTURE_INFO table.
ORDER_ID DOUBLE N Unique foreign key from ORDERS table
START_RANGE_NBR DOUBLE Y The amount of time applied to the start of the order to determine the due range. Will be NULL or greater than 0. If populated, start_range_unit_flag will be populated. Will never be fractional, if needed use the next granular unit.
START_RANGE_UNIT_FLAG DOUBLE Y The unit of time applied to the start of the order to determine the due range. If valued, start_range_value will also be valued. NULL: Order does not have start range, 1: days, 2: weeks, 3: months
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_FUTURE_INFO


Child Column in ORDER_FUTURE_INFO(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID