Table Detail Report

ROUTE_FORM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Route form compatibility relationship table
Definition: Route/dosage form compatibilities
Table Type: REFERENCE





Column Detail - ROUTE_FORM_R


Column Name Type Null? Definition
FORM_CD DOUBLE N Dosage form code from code_value table
ROUTE_CD DOUBLE N Route of administration code from code_value 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 - ROUTE_FORM_R


Child Column in ROUTE_FORM_R(FK) Parent Table Name Parent Column Name
Parents: FORM_CD CODE_VALUE CODE_VALUE
ROUTE_CD CODE_VALUE CODE_VALUE


RX_ADMIN_DISPENSE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Administration Dispense History
Definition: Stores the historical pharmacy information related to the administrations associated with a dispense event.
Table Type: ACTIVITY





Column Detail - RX_ADMIN_DISPENSE_HX


Column Name Type Null? Definition
ADMIN_DT_TM DATETIME Y The date and time of the administration that has been dispensed.
ADMIN_TOTAL_PRICE_AMT DOUBLE N The total price for this dispensed administration.
ADMIN_TZ DOUBLE N The time zone associated with the administration date and time.
CHARGE_DT_TM DATETIME Y The date and time at which the administration was charged to the patient.
CHARGE_FLAG DOUBLE N Indicates the charge status of the administration.
CHARGE_TZ DOUBLE N Time zone associated with the charge date and time.
DISPENSE_HX_ID DOUBLE N Identifies the dispense event to which this administration dispense is associated.
DOSE_AMT DOUBLE N The number of doses that are dispensed or credited for this administration.
REF_RX_ADMIN_DISPENSE_HX_ID DOUBLE N Identifies a reference administration dispense to this administration dispense.
RESIDUAL_DOSE_AMT DOUBLE N The number of doses remaining after a reverse has occurred.
RESIDUAL_PRICE_AMT DOUBLE N The price to be charged after a reverse has occurred. (Original price less credited price)
REVERSE_IND DOUBLE N Indicates that this administration dispense charge has been reversed.
REV_RX_ADMIN_DISPENSE_HX_ID DOUBLE N Identifies the admin dispense history row that is being reversed by this entry.
RX_ADMIN_DISPENSE_HX_ID DOUBLE N Unique, generated number that identifies a single row on the RX_ADMIN_DISPENSE_HX table.
SUPPRESS_CHARGE_FLAG DOUBLE Y Indicates whether the charges have been suppressed for the inpatient dispense
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_ADMIN_DISPENSE_HX


Child Column in RX_ADMIN_DISPENSE_HX(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
REF_RX_ADMIN_DISPENSE_HX_ID RX_ADMIN_DISPENSE_HX RX_ADMIN_DISPENSE_HX_ID
REV_RX_ADMIN_DISPENSE_HX_ID RX_ADMIN_DISPENSE_HX RX_ADMIN_DISPENSE_HX_ID




Parent Column in RX_ADMIN_DISPENSE_HX (PK) Child Table Name Child Column Name
Children: RX_ADMIN_DISPENSE_HX_ID PHA_BATCH_REPORT_ACT_DTL RX_ADMIN_DISPENSE_HX_ID
RX_ADMIN_DISPENSE_HX REF_RX_ADMIN_DISPENSE_HX_ID
RX_ADMIN_DISPENSE_HX REV_RX_ADMIN_DISPENSE_HX_ID
RX_ADMIN_PROD_DISPENSE_HX RX_ADMIN_DISPENSE_HX_ID
RX_INPT_CLAIM_HX RX_ADMIN_DISPENSE_HX_ID


RX_ADMIN_PROD_DISPENSE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Administration Product Dispense History
Definition: Stores the historical pharmacy information related to the products of administrations assoiated with a dispense event.
Table Type: ACTIVITY





Column Detail - RX_ADMIN_PROD_DISPENSE_HX


Column Name Type Null? Definition
CDM_OPTION_IND DOUBLE N Indicates if the product is charged at the manufacturer level (0) or the drug formulary level (1).
CHARGE_QTY DOUBLE N The product quantity to be charged.
CREDIT_QTY DOUBLE N The product quantity to be credited.
INGRED_SEQUENCE DOUBLE N The order the ingredients are displayed.
ITEM_ID DOUBLE N The medication definition pharmacy product.
MANF_ITEM_ID DOUBLE N Information about the manufacturer of the dispensed product.
PRICE_AMT DOUBLE N The price of the dispensed product.
PRICE_SCHED_ID DOUBLE N The price schedule of the dispensed product.
RESIDUAL_PRICE_AMT DOUBLE N The price to be charged after a reverse has occurred.
RESIDUAL_QTY DOUBLE N The quantity to be charged after a reverse has occurred.
RESIDUAL_TAX_AMT DOUBLE N The tax amount to be charged after a reverse has occurred.
RX_ADMIN_DISPENSE_HX_ID DOUBLE N Identifies the admin dispense event to which this product is associated.
RX_ADMIN_PROD_DISPENSE_HX_ID DOUBLE N Unique, generated number that identifies a single row on the RX_ADMIN_PROD_DISPENSE_HX table.
TAX_AMT DOUBLE N The amount of tax to be charged.
TNF_ID DOUBLE N The template non-formulary key that is associated with this admin prod dispense. A type of product that does not relate to a real medication.
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_ADMIN_PROD_DISPENSE_HX


Child Column in RX_ADMIN_PROD_DISPENSE_HX(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
MANF_ITEM_ID MANUFACTURER_ITEM ITEM_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID
RX_ADMIN_DISPENSE_HX_ID RX_ADMIN_DISPENSE_HX RX_ADMIN_DISPENSE_HX_ID




Parent Column in RX_ADMIN_PROD_DISPENSE_HX (PK) Child Table Name Child Column Name
Children: RX_ADMIN_PROD_DISPENSE_HX_ID PHA_BATCH_REPORT_ACT_DTL RX_ADMIN_PROD_DISPENSE_HX_ID
RX_INPT_CLAIM_HX RX_ADMIN_PROD_DISPENSE_HX_ID


RX_AGE_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Age Range
Definition: Reference data for definition of age ranges for use in pharmacy solutions.
Table Type: REFERENCE





Column Detail - RX_AGE_RANGE


Column Name Type Null? Definition
DISPLAY_TXT VARCHAR(100) N The text that gets displayed on the screen that describes this age range.
FROM_AGE_IN_DAYS DOUBLE N Number of days that is the lowest end of the age range.
FROM_AGE_NBR DOUBLE N The lowest end of the age range expressed in terms of FROM_AGE_UNIT_CD.
FROM_AGE_UNIT_CD DOUBLE N The unit of measurement in which the lowest value of the age range is specified.
RX_AGE_RANGE_ID DOUBLE N Unique, generated number that identifies a single row on the RX_AGE_RANGE table.
TO_AGE_IN_DAYS DOUBLE N Number of days that is the highest end of the age range.
TO_AGE_NBR DOUBLE N The highest end of the age range expressed in terms of TO_AGE_UNIT_CD.
TO_AGE_UNIT_CD DOUBLE N The unit of measurement in which the highest value of the age range is specified.
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_AGE_RANGE




Parent Column in RX_AGE_RANGE (PK) Child Table Name Child Column Name
Children: RX_AGE_RANGE_ID RX_MED_ORD_DETAIL RX_AGE_RANGE_ID


RX_AUTO_VERIFY_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy auto verify audit table.
Definition: The table is used to log information relevant to decisions made by system around pharmacy product assignment and verification.
Table Type: ACTIVITY





Column Detail - RX_AUTO_VERIFY_AUDIT


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N Personnel id of the user who is taking the action on the order.
ACTION_SEQUENCE DOUBLE N Order action sequence that is performed on the order.
ACTION_TYPE_CD DOUBLE N Order action that is performed on the order.
AUTO_VERIFY_FAIL_REASON_CD DOUBLE N Codified values for rx auto verification failure reasons.
CATALOG_GROUP_ID DOUBLE N Unique identifier used to trace back to rx_product_assign_group_audit, rx_product_assign_item_audit, and rx_product_assign_audit tables for the order that is being tried for rx auto product assign.
COMMUNICATION_TYPE_CD DOUBLE N The code value of the communication type between ordering provider and action personnel.
DISCERN_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Discern Alerts. For IV set, this is the flag on the catalog of the matching IV set.
DISPENSE_STATUS_FLAG DOUBLE N Rx dispense status flag:0: not set 1: Rx dispense service is called, but dispense is not guaranteed to be successful 2: Rx dispense service is not called
IC_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Interaction Checking. For IV set, this is the flag on the catalog of the matching IV set.
ORDER_ID DOUBLE N Order ID to which this record is associated.
ORDER_PROVIDER_AV_PRIV_FLAG DOUBLE N Order provider's Auto Verification privilege
ORDER_PROVIDER_ID DOUBLE N Personnel_id of the ordering physician who authorizes the action on the order.
PRODUCT_ASSIGN_STATUS_FLAG DOUBLE N Rx auto product assign status flag
PRSNL_AUTO_VERIFY_PRIV_FLAG DOUBLE N Auto Verification privilege (RXAUTOVERIFY) of the user who is taking the action:0: not set. Privilege for Auto Verification has not been evaluated when the record is written.1: privilege for Auto Verification is considered on for this order 2: privilege for Auto Verification is considered off for this order
PRSNL_RX_VERIFY_PRIV_FLAG DOUBLE N Rx Verify privilege (RXVERIFY) of the user who is taking the action:0: not set. Privilege for Rx verify has not been evaluated when the record is written.1: Rx Verify privilege is on 2: Rx Verify privilege is off
RX_AUTO_VERIFY_AUDIT_ID DOUBLE N Unique identifier for rx auto verification audit.
STATUS_STRING VARCHAR(2000) N Text description of the status of rx auto product verification.
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_AUTO_VERIFY_AUDIT


Child Column in RX_AUTO_VERIFY_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ACTION_PERSONNEL_ID PRSNL PERSON_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID
CATALOG_GROUP_ID RX_PRODUCT_ASSIGN_GROUP_AUDIT CATALOG_GROUP_ID




Parent Column in RX_AUTO_VERIFY_AUDIT (PK) Child Table Name Child Column Name
Children: RX_AUTO_VERIFY_AUDIT_ID RX_AUTO_VERIFY_ING_AUDIT RX_AUTO_VERIFY_AUDIT_ID