Table Detail Report

RX_PRODUCT_ASSIGN_ITEM_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy product assign audit table at catalog item level.
Definition: The table is used to log order catalog item level information when system attempts to assign pharmacy products automatically. It records input information on items to be product assigned. For example, an ingredient within an order is considered an item.
Table Type: ACTIVITY





Column Detail - RX_PRODUCT_ASSIGN_ITEM_AUDIT


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Code value for order catalog. It is used to filter products built for a given order catalog.
CATALOG_GROUP_ID DOUBLE N Unique identifier for the catalog group the item belongs to.
CATALOG_ITEM_ID DOUBLE N Unique identifier.
FREETEXT_DOSE VARCHAR(255) Y This is the free text dose of the item. A free text dose can affect product assignment
ORDERABLE_TYPE_FLAG DOUBLE Y It is used to disqualify item from product assign if it's free-text.
STRENGTH DOUBLE Y Strength of the medication. It is used in conjunction with strength_unit_cd to match products.
STRENGTH_UNIT_CD DOUBLE N Code value for strength unit of the medication. It is used in conjunction with strength to match products.
SYNONYM_ID DOUBLE N Unique identifier for order catalog synonym. It is used to filter products built for a given order catalog synonym.
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.
VOLUME DOUBLE Y Volume of the medication. It is used in conjunction with volume_unit_cd to match products.
VOLUME_UNIT_CD DOUBLE N Code value for volume unit of the medication. It is used in conjunction with volume to match products.



Relationship Detail - RX_PRODUCT_ASSIGN_ITEM_AUDIT


Child Column in RX_PRODUCT_ASSIGN_ITEM_AUDIT(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
CATALOG_GROUP_ID RX_PRODUCT_ASSIGN_GROUP_AUDIT CATALOG_GROUP_ID




Parent Column in RX_PRODUCT_ASSIGN_ITEM_AUDIT (PK) Child Table Name Child Column Name
Children: CATALOG_ITEM_ID RX_PRODUCT_ASSIGN_AUDIT CATALOG_ITEM_ID


RX_PRODUCT_CHANGE_NOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Product Change Note
Definition: To add and track product notes for a product.
Table Type: ACTIVITY





Column Detail - RX_PRODUCT_CHANGE_NOTE


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date and time that the row was created.
CREATE_PRSNL_ID DOUBLE Y The personnel that caused the insert of the row.
ITEM_ID DOUBLE N The item that the note pertains to. Cannot be null or empty.
PRODUCT_CHANGE_NOTE_CLOB LONGTEXT Y Captured by Formulary Manager and contributes to the product update notes entered by the user for each product/item modification.;
RX_PRODUCT_CHANGE_NOTE_ID DOUBLE N Unique generated number that identifies a single row on the RX_PRODUCT_CHANGE_NOTE 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_PRODUCT_CHANGE_NOTE


Child Column in RX_PRODUCT_CHANGE_NOTE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


RX_PROD_VLDTN_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Product Validation Event
Definition: Stores the history of product validation transactions for workflow monitor statuses.
Table Type: ACTIVITY





Column Detail - RX_PROD_VLDTN_EVENT


Column Name Type Null? Definition
BARCODE_TXT VARCHAR(50) Y The information on the barcode that was scanned.
CONTENT_MATCH_CD DOUBLE N Identifies how the product was found in the system.
DISP_ITEM_ID DOUBLE N The dispense product being validated.
DISP_LABEL_DESCRIPTION_TXT VARCHAR(100) Y Information on the label of the dispense product being validated.
DISP_MANF_DRUG_IDENTIFIER VARCHAR(100) Y Identifies the dispense manufacturer being validated.
DISP_MANF_ITEM_ID DOUBLE N Identifies the dispense manufacturer item being validated.
DISP_VLDTN_QTY DOUBLE N The number of scans expected.
DUPLICATE_PROD_IND DOUBLE N Indicates if the user was prompted with a duplicate product list.
ENTRY_METHOD_CD DOUBLE N Identifies the entry method utilized for the product validation event.
FORMULARY_PROD_IND DOUBLE N Indicates if the product was found in the formulary.
MANUAL_QTY_IND DOUBLE N Identifies whether the user manually set the scan quantity.
MESSAGE_CD DOUBLE N Identifies the message displayed for the product validation event.
OVERRIDE_REASON_CD DOUBLE N Identifies the reason a user selects to override a validation event.
QTY_PER_SCAN_NBR DOUBLE N The multiplier factor for the scanned product.
QTY_PER_SCAN_UNIT_CD DOUBLE N The unit of measure for the scanned product relative to the value in qty_per_scan_nbr.
RX_PROD_VLDTN_EVENT_ID DOUBLE N Unique, generated number that identifies a single row on the RX_PROD_VLDTN_EVENT table.
RX_VERIFY_IND DOUBLE N Indicates if the scan was performed by a user with RXVERIFY privileges.
RX_WORKFLOW_STS_ID DOUBLE N The workflow event this validation pertains to. Foreign key to the RX_WORKFLOW_STS table.
SCAN_ITEM_ID DOUBLE N Identifies the product being used to compare to.
SCAN_LABEL_DESCRIPTION_TXT VARCHAR(100) Y Label description for the scanned product.
SCAN_MANF_DRUG_IDENTIFIER VARCHAR(100) Y Drug identifier for the scanned product.
SCAN_MANF_ITEM_ID DOUBLE N Identifies the manufacturer being used to compare to.
SCAN_QTY DOUBLE N Identifies the quantity being either scanned by a user or entered by a user. The manual_qty_cd field will flag whether or not the user entered a scan quantity amount.
TOTAL_DOSE_NBR DOUBLE N The total dose of the event when a product is scanned.
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.
VLDTN_EVENT_DT_TM DATETIME Y Identifies when the product validation event occurred.
VLDTN_EVENT_TZ DOUBLE N Time Zone associated with the column vldtn_event_dt_tm.
VLDTN_PRSNL_ID DOUBLE N Identifies the person performing the product validation event.
VLDTN_STS_CD DOUBLE N Identifies the validation status of the product validation event.
WORKFLOW_STS_CD DOUBLE N Identifies the status of the workflow sequence associated to an order's dispense.
WORKFLOW_STS_SEQ DOUBLE N An incrementing number for a combination of rx_workflow_sts_id and workflow_sts_cd.



Relationship Detail - RX_PROD_VLDTN_EVENT


Child Column in RX_PROD_VLDTN_EVENT(FK) Parent Table Name Parent Column Name
Parents: VLDTN_PRSNL_ID PRSNL PERSON_ID
RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID


RX_THERAP_SBSTTN_FROM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Therapeutic Substitution From
Definition: Medication therapeutic substitution reference data for a drug that a substitution has been created.
Table Type: REFERENCE





Column Detail - RX_THERAP_SBSTTN_FROM


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.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row isr valid as active current data. This may be valued with the date that the row will become inactive.
COMMENT_LONG_TEXT_ID DOUBLE N Link to any text to be shown during the substitution alert.
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.
FACILITY_CD DOUBLE N Allows facility level flexing of substitutions.
FROM_CATALOG_CD DOUBLE N Order catalog code from the ORDER_CATALOG table. Identifies the row as defining a substitution at the catalog level.
FROM_DRUG_FORM_CD DOUBLE N The drug form that is on the original from synonym to be substituted.
FROM_FREQ_CD DOUBLE N Ordered frequency must match to qualify for the substitution.
FROM_ITEM_ID DOUBLE N Product item id from the MEDICATION_DEFINITION table. Identifies the row as defining a substitution at the product level.
FROM_RTE_CD DOUBLE N Ordered route must match to qualify for the substitution.
FROM_STRENGTH_UNIT_CD DOUBLE N Ordered dose must match to qualify for the substitution.
FROM_STRENGTH_VALUE DOUBLE N Premise dose strength. Ordered dose must match to qualify for the substitution.
FROM_SYNONYM_ID DOUBLE N Order catalog synonym id from the ORDER_CATALOG_SYNONYM table. Identifies the row as defining a substitution at the synonym level.
FROM_VOLUME_UNIT_CD DOUBLE N Ordered dose must match to qualify for the substitution.
FROM_VOLUME_VALUE DOUBLE N Ordered dose must match to qualify for the substitution.
RETAIN_DETAILS_IND DOUBLE N Specifies if details specified with the ordered item but not defined on the substituted item will be brought forward with the substitution. 0 = No, 1 = Yes.
SBSTTN_ACTN_FLAG DOUBLE N Defines whether the substitution is automatic, required with notification or optional/decided by the user.
THERAP_SBSTTN_FROM_ID DOUBLE N Unique, generated number that identifies a single row on the RX_THERAP_SBSTTN_FROM 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.
VENUE_CD DOUBLE N Identifies the venue in which the substitution will be used such as Inpatient, Ambulatory, Discharge Meds, etc.



Relationship Detail - RX_THERAP_SBSTTN_FROM


Child Column in RX_THERAP_SBSTTN_FROM(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
COMMENT_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
FROM_ITEM_ID MEDICATION_DEFINITION ITEM_ID
FROM_CATALOG_CD ORDER_CATALOG CATALOG_CD
FROM_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in RX_THERAP_SBSTTN_FROM (PK) Child Table Name Child Column Name
Children: THERAP_SBSTTN_FROM_ID RX_THERAP_SBSTTN_TO THERAP_SBSTTN_FROM_ID


RX_THERAP_SBSTTN_TO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Therapeutic Substitution To
Definition: Medication therapeutic substitution reference data for a drug that may be substituted.
Table Type: REFERENCE





Column Detail - RX_THERAP_SBSTTN_TO


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.
THERAP_SBSTTN_FROM_ID DOUBLE N The drug that this TO row is a substitute for.
THERAP_SBSTTN_TO_ID DOUBLE N Unique generated number that identifies a single row on the RX_THERAP_SBSTTN_TO table.
TO_CATALOG_CD DOUBLE N Result order catalog code pointing to ORDER_CATALOG table. Only valued when the prms_catalog_cd is valued. Represents the catalog to substitute for what was originally selected to order.
TO_DRUG_FORM_CD DOUBLE N The drug form that will be used on the substituted to synonym.
TO_FREQ_CD DOUBLE N Frequency to be used with the substitution.
TO_ITEM_ID DOUBLE N Points to the MEDICATION_DEFINITION table. Only valued when the prms_item_id is valued Represents the item to substitute for what was originally selected to order.
TO_ORDER_SENTENCE_ID DOUBLE N The order sentence ID that will be used on the substituted to synonym.
TO_RTE_CD DOUBLE N Route of administration to be used with the substitution.
TO_STRENGTH_UNIT_CD DOUBLE N Result dose will be substituted for the ordered dose if the substitution qualifies.
TO_STRENGTH_VALUE DOUBLE N Substitute To Dose strength. Result dose will be substituted for the ordered dose if the substitution qualifies.
TO_SYNONYM_ID DOUBLE N Points to the ORDER_CATALOG_SYNONYM table. Only valued when the prms_synonym_id is valued.
TO_VOLUME_UNIT_CD DOUBLE N Ordered dose must match to qualify for the substitution.
TO_VOLUME_VALUE DOUBLE N Ordered dose must match to qualify for the substitution.
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_THERAP_SBSTTN_TO


Child Column in RX_THERAP_SBSTTN_TO(FK) Parent Table Name Parent Column Name
Parents: TO_ITEM_ID MEDICATION_DEFINITION ITEM_ID
TO_CATALOG_CD ORDER_CATALOG CATALOG_CD
TO_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
TO_ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
THERAP_SBSTTN_FROM_ID RX_THERAP_SBSTTN_FROM THERAP_SBSTTN_FROM_ID