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 |