Table Detail Report

RX_EXT_DRUG_ITEM_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet External Drug Item Audit
Definition: This will show the mapping between the itemid and drug identifiers.
Table Type: ACTIVITY





Column Detail - RX_EXT_DRUG_ITEM_AUDIT


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date that the record was created in the table.
DRUG_IDENT VARCHAR(14) N NDC (National Drug Code) comes from MED_IDENTIFIER.VALUE
ITEM_ID DOUBLE N The item that is mapped to the drug identifier.
RX_EXT_DRUG_ITEM_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the RX_EXT_DRUG_ITEM_AUDIT table.
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 - RX_EXT_DRUG_ITEM_AUDIT


Child Column in RX_EXT_DRUG_ITEM_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID


RX_EXT_ITEM_UPDATE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Esternal Item Update Audit
Definition: To store the activities that were taken on different items.
Table Type: ACTIVITY





Column Detail - RX_EXT_ITEM_UPDATE_AUDIT


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date that the record was created in the table.
ITEM_ID DOUBLE N The formulary product that the activity was taken on.
NEW_ALWAYS_DISPENSE_FROM_FLAG DOUBLE N Originally from MED_DISPENSE. Indicates whether the product is available in the formulary.
RX_EXT_ITEM_UPDATE_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the RX_EXT_ITEM_UPDATE_AUDIT table.
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 - RX_EXT_ITEM_UPDATE_AUDIT


Child Column in RX_EXT_ITEM_UPDATE_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID


RX_EXT_ORD_PRD_SYNC_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy External Order Product Sync Audit
Definition: Holds audit records for when order products are updated based on an external pharmacy supply.
Table Type: ACTIVITY





Column Detail - RX_EXT_ORD_PRD_SYNC_AUDIT


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date that the record was created in the table.
ITEM_ID DOUBLE N The ITEM_ID of the original order product.
NEW_ITEM_ID DOUBLE N The new ITEM_ID of the order product if it was successfully synced
ORDER_ID DOUBLE N The ORDER_ID of the order that qualified for syncing
RX_EXT_ORD_PRD_SYNC_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the RX_EXT_ORD_PRD_SYNC_AUDIT table.
STATUS_FLAG DOUBLE N Denotes whether or not the order product was synced to an external order product successfully.
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 - RX_EXT_ORD_PRD_SYNC_AUDIT


Child Column in RX_EXT_ORD_PRD_SYNC_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
NEW_ITEM_ID MEDICATION_DEFINITION ITEM_ID
ORDER_ID ORDERS ORDER_ID


RX_EXT_ORD_PRD_SYNC_RUN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy External Order Product Sync Run
Definition: Holds records of the last successful operations job for updating order products based on an external pharmacy supply.
Table Type: ACTIVITY





Column Detail - RX_EXT_ORD_PRD_SYNC_RUN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
CREATE_DT_TM DATETIME Y The date time each record is added to the table.
FACILITY_CD DOUBLE Y The facility code for which the operations job successfully ran.
LAST_RUN_DT_TM DATETIME Y The date time of the last successful run of the operations job.
RX_EXT_ORD_PRD_SYNC_RUN_ID DOUBLE N Unique generated number that identifies a single row on the RX_EXT_ORD_PRD_SYNC_RUN table.
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 Y 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 - RX_EXT_ORD_PRD_SYNC_RUN


Child Column in RX_EXT_ORD_PRD_SYNC_RUN(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD


RX_FORMULA



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Formula
Definition: Contains representations of demographic formulas for a method.
Table Type: REFERENCE





Column Detail - RX_FORMULA


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FORMULA_TXT VARCHAR(1000) N The text of the actual mathematical formula.
RX_FORMULA_ID DOUBLE N Unique generated number that identifies a single row on the rx_formula table.
RX_FORMULA_P_ID DOUBLE N Used for grouping version of a formula.
RX_METHOD_ID DOUBLE N The method this formula is part of.
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 - RX_FORMULA


Child Column in RX_FORMULA(FK) Parent Table Name Parent Column Name
Parents: RX_FORMULA_P_ID RX_FORMULA RX_FORMULA_ID
RX_METHOD_ID RX_METHOD RX_METHOD_ID




Parent Column in RX_FORMULA (PK) Child Table Name Child Column Name
Children: RX_FORMULA_ID RX_FORMULA RX_FORMULA_P_ID
RX_FORMULA_RANGE RX_FORMULA_ID