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 |