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 |