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 |