Table Detail Report

RXS_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Worklist
Definition: Contains worklist parameters for generating pharmacy tasks automatically through an operations job.
Table Type: REFERENCE





Column Detail - RXS_WORKLIST


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.
AUTO_PKG_DEST_FOLDER_NAME VARCHAR(255) N The destination folder where the flat file generated for an auto-packaging machine will be placed.
AUTO_PKG_IND DOUBLE N Indicates if this worklist will generate a flat file to be read by an auto-packaging machine.
AUTO_PKG_PROD_IDENT_TYPE_CD DOUBLE N The product type code that the drugs in the auto-packaging machine are identified by. For example, NDC, HIN, etc.
AUTO_PKG_SCRIPT_CD DOUBLE N Identifies the script that generates the flat file for the auto-packaging machine.
DYNAMIC_PAR_BUFFER_PCT DOUBLE N Defines the percentage to increase or decrease the system calculated refill level.
DYNAMIC_PAR_HRS DOUBLE N Defines how many hours in the future to look for orders while calculating dynamic refill levels.
DYNAMIC_PAR_IND DOUBLE N Indicates whether the system will use the system-calculated refill level (1) or the user-entered refill level (0) when determining items.
LABEL_CD DOUBLE N The format used when the worklist is printed on a label.
LABEL_PRINTER_CD DOUBLE N The printer that labels are spooled to.
PRINT_CONSOLIDATED_RPT_IND DOUBLE N Indicates if the consolidated report is to be printed.
PRINT_DTL_RPT_IND DOUBLE N Indicates if the unit detail report is to be printed.
REPORT_CD DOUBLE N The format used when the worksheet is printed on a report.
REPORT_PRINTER_CD DOUBLE N The printer that reports are spooled to.
RXS_WORKLIST_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_WORKLIST table.
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.
WORKLIST_NAME VARCHAR(255) N The user-defined name for the worklist.
WORKLIST_TYPE_CD DOUBLE N Describes the type of worklist to be run. Examples: Scheduled, Ad hoc



Relationship Detail - RXS_WORKLIST


Child Column in RXS_WORKLIST(FK) Parent Table Name Parent Column Name
Parents: LABEL_PRINTER_CD DEVICE DEVICE_CD
REPORT_PRINTER_CD DEVICE DEVICE_CD




Parent Column in RXS_WORKLIST (PK) Child Table Name Child Column Name
Children: RXS_WORKLIST_ID QUANTITY_REQUIREMENT_INFO DEMAND_WORKLIST_ID
RXS_WORKLIST_DISP_CAT_R RXS_WORKLIST_ID
RXS_WORKLIST_EVENT RXS_WORKLIST_ID
RXS_WORKLIST_LEGAL_STATUS RXS_WORKLIST_ID
RXS_WORKLIST_LOCATION_R RXS_WORKLIST_ID


RXS_WORKLIST_DISP_CAT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Worklist Dispense Category Relationship
Definition: Relationship table between worklist and dispense category filters.
Table Type: REFERENCE





Column Detail - RXS_WORKLIST_DISP_CAT_R


Column Name Type Null? Definition
DISPENSE_CATEGORY_CD DOUBLE N The dispense category that this worklist is filtered by.
INCLUDE_IND DOUBLE Y Indicates if the dispense category for the worklist should be included. 0: Dispense category for the worklist should be excluded.; 1: Dispense category for the worklist should be included.
RXS_WORKLIST_DISP_CAT_R_ID DOUBLE N Unique generated number that identifies a single row on the RXS_WORKLIST_DISP_CAT_R table.
RXS_WORKLIST_ID DOUBLE N The worklist that is being filtered by the dispense category.
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 - RXS_WORKLIST_DISP_CAT_R


Child Column in RXS_WORKLIST_DISP_CAT_R(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_CATEGORY_CD DISPENSE_CATEGORY DISPENSE_CATEGORY_CD
RXS_WORKLIST_ID RXS_WORKLIST RXS_WORKLIST_ID


RXS_WORKLIST_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Worklist Event
Definition: Stores details about the actual executions of each worklist.
Table Type: ACTIVITY





Column Detail - RXS_WORKLIST_EVENT


Column Name Type Null? Definition
EVENT_DT_TM DATETIME N The date and time the worklist was ran.
EVENT_PRSNL_ID DOUBLE N The user who started the worklist job.
EVENT_TZ DOUBLE N The time zone associated with EVENT_DT_TM.
PRINTED_IND DOUBLE N Indicates whether the worklist generated a report to be spooled to a printer. ( 1 - printed, 0 - not printed.)
RXS_WORKLIST_EVENT_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_WORKLIST_EVENT table.
RXS_WORKLIST_ID DOUBLE N The worklist that this event is an occurrence of.
STATUS_CD DOUBLE N Processing status of the worklist. Examples: Pending, Complete, In Process
STATUS_DT_TM DATETIME N The data and time the status_cd was last updated.
STATUS_TZ DOUBLE N The time zone associated with STATUS_DT_TM.
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 - RXS_WORKLIST_EVENT


Child Column in RXS_WORKLIST_EVENT(FK) Parent Table Name Parent Column Name
Parents: EVENT_PRSNL_ID PRSNL PERSON_ID
RXS_WORKLIST_ID RXS_WORKLIST RXS_WORKLIST_ID




Parent Column in RXS_WORKLIST_EVENT (PK) Child Table Name Child Column Name
Children: RXS_WORKLIST_EVENT_ID RXS_LOCATION_TASK RXS_WORKLIST_EVENT_ID


RXS_WORKLIST_LEGAL_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Worklist Legal Status
Definition: Stores legal statuses of items to be printed on a report/label generated from a worklist.
Table Type: REFERENCE





Column Detail - RXS_WORKLIST_LEGAL_STATUS


Column Name Type Null? Definition
LEGAL_STATUS_CD DOUBLE N The legal status of the drug as assigned by the governing body.
RXS_WORKLIST_ID DOUBLE N The worklist that this legal status applies to.
RXS_WORKLIST_LEGAL_STATUS_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_WORKLIST_LEGAL_STATUS 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 - RXS_WORKLIST_LEGAL_STATUS


Child Column in RXS_WORKLIST_LEGAL_STATUS(FK) Parent Table Name Parent Column Name
Parents: RXS_WORKLIST_ID RXS_WORKLIST RXS_WORKLIST_ID


RXS_WORKLIST_LOCATION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Worklist Location Relation
Definition: Stores locations that will be queried for task creation on a worklist.
Table Type: REFERENCE





Column Detail - RXS_WORKLIST_LOCATION_R


Column Name Type Null? Definition
LOC_CD DOUBLE N Location related to the worklist. Could be an type of location in the location model: facility, cluster, device, etc.
RXS_WORKLIST_ID DOUBLE N The worklist that relates to the specified location.
RXS_WORKLIST_LOCATION_R_ID DOUBLE N Unique, generated number that identifies a single row in the RXS_WORKLIST_LOCATION_R 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 - RXS_WORKLIST_LOCATION_R


Child Column in RXS_WORKLIST_LOCATION_R(FK) Parent Table Name Parent Column Name
Parents: LOC_CD LOCATION LOCATION_CD
RXS_WORKLIST_ID RXS_WORKLIST RXS_WORKLIST_ID