Table Detail Report

RX_PERSON_OWE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RX Person Owe
Definition: This table will store information about the person owe values related to dispensing.
Table Type: ACTIVITY





Column Detail - RX_PERSON_OWE


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE N The personnel identifier of the user that created and/or modified the owe. If the value is 0, it means it was created by the system. Otherwise, the it contains the personnel identifier from the person table.
ACTION_TYPE_CD DOUBLE N Action that was performed to create this row. For example - create, cancel, resolve, etc.
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.
DISPENSE_FROM_CD DOUBLE N Identifies the pharmacy location that is needed for the owed stock.
DISPENSE_HX_ID DOUBLE N This field links the person_owe_id record to the dispensing event record. This will enable users to track the owe to the original dispense.
INGRED_SEQ DOUBLE N Identifies the sequence of the ingredients on the order.
INVENTORY_LOCATION_CD DOUBLE N Inventory location that owes the person.
INV_ITEM_ID DOUBLE N Identifies the inventory item which qoh(quantity on hand) is tracked, in place of the formulation, including active ingredient, strength and dosage form.
ITEM_ID DOUBLE N This column represents the item to which this owe is associated.
ORDER_ID DOUBLE N This field represents the order to which the owe is associated.
OWE_ACTION_SEQ DOUBLE N Indicates the number of times this owe (per dispense hx id) has been modified. When the owe is created, it will be 1.
PACKAGE_TYPE_ID DOUBLE N Identifies the package associated to the item for which this owe was created.
PERSON_OWE_DOSES_CNT DOUBLE Y This value will indicate how many doses the person is owed. It is manually assigned.
PERSON_OWE_QTY DOUBLE Y This column contains the value of the person_owe_doses * QPD(Quantity Per Dose).
RESOLVED_DHX_ID DOUBLE N Represents the dispensed History resolved person owe or reconciled what was person owe.
RX_PERSON_OWE_ID DOUBLE N Uniquely identifies a person owe related to dispensing.
SYS_PERSON_OWE_QTY DOUBLE Y Amount of owe quantity that the system calculates without user interaction.
SYS_PRSN_OWE_DOSES_CNT DOUBLE Y Contains the amount of owe doses that the system calculated without user interaction.
TNF_ID DOUBLE N Identifier of the template non-formulary item.
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_PERSON_OWE


Child Column in RX_PERSON_OWE(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
RESOLVED_DHX_ID DISPENSE_HX DISPENSE_HX_ID
INV_ITEM_ID ITEM_DEFINITION ITEM_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
DISPENSE_FROM_CD LOCATION LOCATION_CD
INVENTORY_LOCATION_CD LOCATION LOCATION_CD
ORDER_ID ORDERS ORDER_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


RX_PREP_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Preparation Information
Definition: Stores links to documentation that contain information on how to prepare an item.
Table Type: REFERENCE





Column Detail - RX_PREP_INFO


Column Name Type Null? Definition
LONG_TEXT_ID DOUBLE N Foreign key to the long_text_reference table.
PREP_INFO_CD DOUBLE N The code value for the preparation information from code set 4760.
PREP_INFO_TYPE_FLAG DOUBLE N The type of preparation information which is stored on the long_text_reference table.
RX_PREP_INFO_ID DOUBLE N Generated, unique identifier for the 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 - RX_PREP_INFO


Child Column in RX_PREP_INFO(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


RX_PRINTER_LOCATION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RX PRINTER LOCATION R
Definition: Relationship table between dispense categories and printers
Table Type: REFERENCE





Column Detail - RX_PRINTER_LOCATION_R


Column Name Type Null? Definition
DENIAL_REPORT_DEVICE_CD DOUBLE N The printer to print the denial reports on.
DEVICE_CD DOUBLE N Printer used for this location/dispense category combination. This value comes from the DEVICE table and is not a true CODE_VALUE.
DISPENSE_CATEGORY_CD DOUBLE N Dispense category key to table.
LEAFLET_DEVICE_CD DOUBLE N Leaflet Printer
LOCATION_CD DOUBLE N Location key for printer assignment.
REFILL_NOTIFY_DEVICE_CD DOUBLE N Contains the device code for the refill notification printer.
TRANS_NOTIFY_DEVICE_CD DOUBLE N Transfer Notification Printer
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.
VALIDATION_DEVICE_CD DOUBLE N Validation printer



Relationship Detail - RX_PRINTER_LOCATION_R


Child Column in RX_PRINTER_LOCATION_R(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD CODE_VALUE CODE_VALUE
DENIAL_REPORT_DEVICE_CD DEVICE DEVICE_CD
DEVICE_CD DEVICE DEVICE_CD


RX_PRODUCT_ASSIGN_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy product assign audit table.
Definition: The table is used to log detailed audit information when system attempts to assign pharmacy products automatically. It records significant steps during auto product assign process.
Table Type: ACTIVITY





Column Detail - RX_PRODUCT_ASSIGN_AUDIT


Column Name Type Null? Definition
CATALOG_GROUP_ID DOUBLE N Unique identifier for the catalog group that is being tried for product assign.
CATALOG_ITEM_ID DOUBLE N Unique identifier for the catalog item that was selected during auto product assignment.
ITEM_ID DOUBLE N Unique identifier for the product on which matching is performed. For records with item_id valued, catalog_item_id should be populated. Item_id comes from item_id in medication_definition table.
REPORT_LEVEL_FLAG DOUBLE N Report level. 0: audit - find a match successfully. Matching item is recorded in set_item_id or item_id field. 1: info - fail to match because of reasons recorded in status_number and status_string fields 2: debug - additional information about a specific event with details recorded in status_number and status_string fields.
SET_ITEM_ID DOUBLE N Unique identifier for the IV set on which product matching is performed. Set_item_id comes from item_id in medication_definition table.
STATUS_MESSAGE VARCHAR(2000) N Text description of a specific event that occurred during the auto product assignment process.
STATUS_NUMBER DOUBLE N Enumerated number used to identify a specific event that occurred during the auto product assignment process.
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_PRODUCT_ASSIGN_AUDIT


Child Column in RX_PRODUCT_ASSIGN_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
SET_ITEM_ID MEDICATION_DEFINITION ITEM_ID
CATALOG_GROUP_ID RX_PRODUCT_ASSIGN_GROUP_AUDIT CATALOG_GROUP_ID
CATALOG_ITEM_ID RX_PRODUCT_ASSIGN_ITEM_AUDIT CATALOG_ITEM_ID


RX_PRODUCT_ASSIGN_GROUP_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy product assign audit table at catalog group level.
Definition: The table is used to log order catalog group level information when system attempts to assign pharmacy products automatically. It records input information common to all items to be product assigned within a group. For example, an order with one or more ingredients is considered a group.
Table Type: ACTIVITY





Column Detail - RX_PRODUCT_ASSIGN_GROUP_AUDIT


Column Name Type Null? Definition
CATALOG_GROUP_ID DOUBLE N Unique identifier.
CONTINUOUS_FILTER_IND DOUBLE N Match products built to be dispensed as continuous infusion. It is used to filter down the list of products qualify for auto product assign. 0: product can be dispensed as continuous infusion or not is irrelevant for the purpose of product filtering. Products do not have to be built as continuous infusion to qualify for product assign. 1: only products built as continuous infusion qualify for product assign
ENCNTR_TYPE_CD DOUBLE N Encounter type code (encntr_type_cd) from patient encounter. It's used to flex product defaults on the selected product.
FACILITY_CD DOUBLE N Facility code (loc_facility_cd) from patient encounter. It is used to filter down the list of products qualify for auto product assign. It is also used to flex product defaults on the selected product.
FORM_CD DOUBLE N Code value for drug form. It is used to filter down the list of products qualify for auto product assign.
INTERMITTENT_FILTER_IND DOUBLE N Match products built to be dispensed as intermittent. It is used to filter down the list of products qualify for auto product assign. 0: product can be dispensed as intermittent or not is irrelevant for the purpose of product filtering. Products do not have to be built as intermittent to qualify for product assign. 1: only products built as intermittent qualify for product assign
MED_FILTER_IND DOUBLE N Match products built to be dispensed as medications. It is used to filter down the list of products qualify for auto product assign. 0: product can be dispensed as medication or not is irrelevant for the purpose of product filtering. Products do not have to be built as medication to qualify for product assign. 1: only products built as medication qualify for product assign At least one of med_filter_ind, continuous_filter_ind and intermittent_filter_ind needs to be 1.
PAT_LOCN_CD DOUBLE N Patient location code (loc_nurse_unit_cd) from patient encounter. It is used to flex product defaults on the selected product.
ROUTE_CD DOUBLE N Code value for route of the medication. It is used to filter down the list of products qualify for auto product assign.
SKIP_IV_SET_IND DOUBLE N Whether or not attempt to match on IV sets. 0: do not match IV sets 1: match IV sets
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_PRODUCT_ASSIGN_GROUP_AUDIT




Parent Column in RX_PRODUCT_ASSIGN_GROUP_AUDIT (PK) Child Table Name Child Column Name
Children: CATALOG_GROUP_ID RX_AUTO_VERIFY_AUDIT CATALOG_GROUP_ID
RX_PRODUCT_ASSIGN_AUDIT CATALOG_GROUP_ID
RX_PRODUCT_ASSIGN_ITEM_AUDIT CATALOG_GROUP_ID