Table Detail Report

RX_TOD_DOW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Time of Day Day of Week
Definition: Stores unique combinations of times of day and days of week.
Table Type: REFERENCE





Column Detail - RX_TOD_DOW


Column Name Type Null? Definition
DAYS_OF_WEEK_TEXT VARCHAR(15) N String representation of the days of week of a VDA frequency. Expected format is DOW1;DOW2;DOW3;etc. For example a frequency with Monday, Wednesday, Friday will display as 2;4;6
RX_TOD_DOW_ID DOUBLE N Unique, generated number that identifies a single row on the RX_TOD_DOW table.
TIMES_OF_DAY_TEXT VARCHAR(1000) N String representation of the times of day of a VDA frequency in minutes from midnight. Expected format is TOD1;TOD2;TOD3;etc. For example, a frequency with 0800 and 2000 times of day will display as 480;1200
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_TOD_DOW




Parent Column in RX_TOD_DOW (PK) Child Table Name Child Column Name
Children: RX_TOD_DOW_ID FREQUENCY_SCHEDULE RX_TOD_DOW_ID


RX_VIEW_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy View Configuration
Definition: Configuration of various views corresponding to users individually and in a group(system level views).
Table Type: REFERENCE





Column Detail - RX_VIEW_CONFIG


Column Name Type Null? Definition
CONFIG_TYPE_CD DOUBLE N Code value representing the Configuration type.
CONSULT_FUTURE_ORDER_HRS DOUBLE Y Indicates the number of hours until start for which future consult orders will be displayed.
CONSULT_FUTURE_ORDER_IND DOUBLE Y Indicates if future consult orders should be displayed.
CONSULT_FUTURE_ORDER_ONLY_IND DOUBLE Y Indicates if only future consult orders should be displayed.
DISCHARGE_DAYS DOUBLE N Number of discharge days to retrieve
DISPLAY_NAME VARCHAR(40) N The display name of the configuration.
FUTURE_ORDER_HRS DOUBLE N Indicates the number of hours until start for which future orders will be displayed.
FUTURE_ORDER_IND DOUBLE N Indicates if future orders should be displayed.
FUTURE_ORDER_ONLY_IND DOUBLE Y Indicates if only future orders should be displayed.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MED_RECONCILIATION_FLAG DOUBLE N Differentiates between pharmacy review or supply review or both.
PRSNL_ID DOUBLE N ID of the person to whom this view belongs to. Zero if a system-level view.
RX_VIEW_CONFIG_ID DOUBLE N Unique, generated number that identifies a single row on the RX_VIEW_CONFIG table.
SCHEDULED_ORDER_FLAG DOUBLE N Indicates values for filtering the orders based on whether they are scheduled or Non Scheduled or include all orders."
SPLIT_VERIFICATION_FLAG DOUBLE N Differentiates between product assign or clinical assign or both.
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.
VERIFICATION_PROGRESS_FLAG DOUBLE Y Allows the user to specify how they would like multiple verification orders to be displayed.



Relationship Detail - RX_VIEW_CONFIG


Child Column in RX_VIEW_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in RX_VIEW_CONFIG (PK) Child Table Name Child Column Name
Children: RX_VIEW_CONFIG_ID RX_VIEW_CONFIG_DETAIL RX_VIEW_CONFIG_ID


RX_VIEW_CONFIG_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy View Configuration Detail
Definition: Contains information around each filter associated with a view
Table Type: REFERENCE





Column Detail - RX_VIEW_CONFIG_DETAIL


Column Name Type Null? Definition
CONFIG_DETAIL_MEAN VARCHAR(32) N Based the detail_type_cd, the meaning will be a unique string representing the specific configuration detail. It is not required for all configuration details.
CONFIG_DETAIL_SEQ DOUBLE N Based on the detail_type_cd, the sequence will represent the order of the configuration details for that detail type. It is not required for all configuration details.
CONFIG_DETAIL_SORT_FLAG DOUBLE Y Based on detail_type_cd, the indicator will represent the sort direction for the specific configuration detail. It is required for the configuration detail that is used for sorting
DETAIL_TYPE_CD DOUBLE N The type of filter this row is defining.
FACILITY_CD DOUBLE N The facility that is associated with the view.
PARENT_ENTITY_ID DOUBLE N ID of the detail type that is updated on this row
PARENT_ENTITY_NAME VARCHAR(32) N The detail type that is updated on this row.
RX_VIEW_CONFIG_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the RX_VIEW_CONFIG_DETAIL table.
RX_VIEW_CONFIG_ID DOUBLE N The header information for this pharmacy view.
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_VIEW_CONFIG_DETAIL


Child Column in RX_VIEW_CONFIG_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
RX_VIEW_CONFIG_ID RX_VIEW_CONFIG RX_VIEW_CONFIG_ID


RX_WF_WS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Workflow Worksheet
Definition: Contains activity data with Worksheet information for Workflow events.
Table Type: ACTIVITY





Column Detail - RX_WF_WS


Column Name Type Null? Definition
ACTUAL_LABOR_COST_AMT DOUBLE N The labor cost required to actually create the product.
ACTUAL_LABOR_NBR DOUBLE N The amount of time required to create the product.
ASSEMBLE_DT_TM DATETIME Y Date/time the manufacturing process began.
ASSEMBLE_PRSNL_ID DOUBLE N Person who began the manufacturing process.
ASSEMBLE_TZ DOUBLE N Time zone associated with ASSEMBLE_DT_TM.
CHECKED_DT_TM DATETIME Y Date/time that a verification that the assembly included everything was performed.
CHECKED_PRSNL_ID DOUBLE N Person who performed the verification that the assembly included everything.
CHECKED_TZ DOUBLE N Time Zone associated with CHECKED_DT_TM.
EXP_DT_TM DATETIME Y The date/time the product will expire. (production date + stability information)
EXP_TZ DOUBLE N Time Zone associated with EXP_DT_TM.
FINAL_CHK_DT_TM DATETIME Y Date/time of the last check of the worksheet before actual creation of the product.
FINAL_CHK_PRSNL_ID DOUBLE N Person who performed the last check of the worksheet before actual creation of the product.
FINAL_CHK_TZ DOUBLE N Time zone associated with FINAL_CHK_DT_TM.
FINAL_PROD_CHK_DT_TM DATETIME Y Date/time of the very last check of the created product.
FINAL_PROD_CHK_PRSNL_ID DOUBLE N Person that performed the very last check of the created product.
FINAL_PROD_CHK_TZ DOUBLE N Time zone associated with FINAL_PROD_CHK_DT_TM.
MANF_DT_TM DATETIME Y Date/time of the completion of the creation of the product using the ingredients and instructions on the worksheet.
MANF_PRSNL_ID DOUBLE N Person who completed the creation of the product using the ingredients and instructions on the worksheet.
MANF_TZ DOUBLE N Time zone associated with MANF_DT_TM.
MIXING_INSTR_TEXT_ID DOUBLE N Instructions for the manufacturing of the product.
PREPARE_QTY DOUBLE N The quantity of product to prepare to satisfy the requirements of this worksheet. Calculated by (charge qty / product dispense qty) * dispense doses
PRODUCTION_DT_TM DATETIME Y Date/time the manufacturing process began.
PRODUCTION_TZ DOUBLE N Time zone associated with PRODUCTION_DT_TM.
QC_APPROVED_DT_TM DATETIME Y Date/time the Quality Control function indicated that the created product was correct.
QC_APPROVED_PRSNL_ID DOUBLE N The person that performing the Quality Control function that indicated that the created product was correct.
QC_APPROVED_TZ DOUBLE N Time zone associated with QC_APPROVED_DT_TM.
QC_RECONCILE_DT_TM DATETIME Y Date and time that person doing the quality control process signs off on their role.
QC_RECONCILE_PRSNL_ID DOUBLE N Person that signs off on the quality control process.
QC_RECONCILE_TZ DOUBLE N Time zone associated with QC_RECONCILE_DT_TM.
QC_SAMPLE_AMT DOUBLE N The amount of the product in the quality control sample.
QC_SAMPLE_FORM_CD DOUBLE N The form of the product supplied in the quality control sample.
QC_SAMPLE_NBR DOUBLE N The size of the quality control sample.
QC_SAMPLE_RELEASED_AMT DOUBLE N The number of quality control samples released for use.
QC_SAMPLE_TXT VARCHAR(255) N The Quality Control notes created as a result of examining the samples.
QC_SAMPLE_UNIT_CD DOUBLE N The unit of measure of the quality control sample.
REJECTED_DOSE_NBR DOUBLE N The number of doses rejected and/or wasted.
RX_WF_WS_ID DOUBLE N Unique, generated number that identifies a single row on the RX_WF_WS table.
RX_WORKFLOW_STS_ID DOUBLE N The workflow associated to this worksheet.
RX_WS_FAC_RELTN_HX_ID DOUBLE N FK to the RX_WS_FAC_RELTN_HX table. This is the worksheet that this workflow implemented.
STATUS_FLAG DOUBLE N Status of worksheet. 0 = not completed, 1 = Completed.
TOTAL_COST_AMT DOUBLE N The total cost of the product including item costs and labor costs.
TOTAL_ITEM_COST_AMT DOUBLE N The total cost of the product only counting the cost of the items.
TOTAL_RELEASED_DOSE_NBR DOUBLE N The number of doses released after quality control has been completed. (Total_dose_nbr - rejected_dose_nbr)
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_WF_WS


Child Column in RX_WF_WS(FK) Parent Table Name Parent Column Name
Parents: MIXING_INSTR_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
ASSEMBLE_PRSNL_ID PRSNL PERSON_ID
CHECKED_PRSNL_ID PRSNL PERSON_ID
FINAL_CHK_PRSNL_ID PRSNL PERSON_ID
FINAL_PROD_CHK_PRSNL_ID PRSNL PERSON_ID
MANF_PRSNL_ID PRSNL PERSON_ID
QC_APPROVED_PRSNL_ID PRSNL PERSON_ID
QC_RECONCILE_PRSNL_ID PRSNL PERSON_ID
RX_WORKFLOW_STS_ID RX_WORKFLOW_STS RX_WORKFLOW_STS_ID
RX_WS_FAC_RELTN_HX_ID RX_WS_FAC_RELTN_HX RX_WS_FAC_RELTN_HX_ID




Parent Column in RX_WF_WS (PK) Child Table Name Child Column Name
Children: RX_WF_WS_ID RX_WF_WS_ITEM_RELTN RX_WF_WS_ID


RX_WF_WS_ITEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Workflow Worksheet Item Relation
Definition: Contains activity data for a Worksheet used by a Workflow.
Table Type: ACTIVITY





Column Detail - RX_WF_WS_ITEM_RELTN


Column Name Type Null? Definition
ITEM_QTY DOUBLE N The amount of the Pharmacy or Supply item actually used to create the Pharmacy Worksheet item, expressed in terms of the quantity unit.
RX_WF_WS_ID DOUBLE N The worksheet this item was used for. Foreign key to the RX_WF_WS table.
RX_WF_WS_ITEM_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RX_WF_WS_ITEM_RELTN table.
RX_WS_FAC_ITEM_HX_ID DOUBLE N identifies the item used in the creation of a parent item on a worksheet at a particular location. Foreign key to the RX_WS_FAC_ITEM_HX 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_WF_WS_ITEM_RELTN


Child Column in RX_WF_WS_ITEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: RX_WF_WS_ID RX_WF_WS RX_WF_WS_ID
RX_WS_FAC_ITEM_HX_ID RX_WS_FAC_ITEM_HX RX_WS_FAC_ITEM_HX_ID