Table Detail Report

WORKLIST_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Worklist Event
Definition: Contains the download and saved date times and users associated with a given worklist.
Table Type: ACTIVITY





Column Detail - WORKLIST_EVENT


Column Name Type Null? Definition
EVENT_DT_TM DATETIME Y The date and time that the worklist event took place.
EVENT_PRSNL_ID DOUBLE N Contains the user that took the action to cause the event row to be written to the database.
EVENT_TYPE_FLAG DOUBLE N Contains the type of event that took place. 1 - Download2 - Save3 - Building4 - Pending5 - In process6 - Complete (system)7 - Complere (manual)8 - Pause9 - Resume
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.
WORKLIST_EVENT_ID DOUBLE N Uniquely identifies download and saved date and times and users associated with a given worklist.
WORKLIST_ID DOUBLE N Uniquely identifies the worklist related to this event.



Relationship Detail - WORKLIST_EVENT


Child Column in WORKLIST_EVENT(FK) Parent Table Name Parent Column Name
Parents: EVENT_PRSNL_ID PRSNL PERSON_ID
WORKLIST_ID WORKLIST WORKLIST_ID


WORKLIST_GROUP



Column Section Top of Page


Table-level Detail

Description: Worklist Group
Definition: Defines the worklists that have been grouped together to run from a single batch request.
Table Type: REFERENCE





Column Detail - WORKLIST_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CHILD_WORKLIST_REF_ID DOUBLE N A unique internal system assigned number that identifies a specific child worklist reference template associated with a grouping of worklist templates. Creates a relationship to the worklist reference table.
PARENT_WORKLIST_REF_ID DOUBLE N A unique internal system assigned number that identifies a specific grouping of one or more worklist reference templates. Creates a relationship to the worklist reference 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.


WORKLIST_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Worklist Order Resolution
Definition: Defines the relationship between a worklist and the orders included on a worklist.
Table Type: ACTIVITY





Column Detail - WORKLIST_ORDER_R


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Defines the date and time the worklist order row was created.
IDENTIFIER VARCHAR(20) Y Identifies the accession by a number for the given worklist. (Currently not implemented)
ORDER_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific order. Creates a relationship to the orders table.
POST_TO_FLAG DOUBLE Y Defines the current status of how the identifier has been used. (Currently not implemented)
SEQUENCE DOUBLE Y Defines the order in which the user has defined the accessions to display on a worklist. This sequence is stored on the worklist order resolution table and the accession order resolution 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.
WORKLIST_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific worklist. Creates a relationship to the worklist table.



Relationship Detail - WORKLIST_ORDER_R


Child Column in WORKLIST_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: WORKLIST_ID WORKLIST WORKLIST_ID


WORKLIST_POS_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Worklist Position Order Relationship
Definition: Holds the relationship between template positions for a worklist and the orders corresponding to those positions.
Table Type: ACTIVITY





Column Detail - WORKLIST_POS_ORDER_R


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N Combined with worklist_id and sequence indicates which QC accession corresponds to this position on the template.
ACCESSION_SEQUENCE DOUBLE N Combined with worklist_id and accession_id indicates which QC accession corresponds to this position on the template.
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.
ORDER_ID DOUBLE N In conjunction with the worklist_id indicates which order corresponds to this position in the template.
PERSON_ACCESSION_IND DOUBLE N Indicates whether the accession_id for this row corresponds to a patient accession (1) or a qc accession (0).
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.
WORKLIST_ID DOUBLE N In conjunction with the orders_id indicates which order corresponds to this position in the template.
WORKLIST_POS_ORDER_R_ID DOUBLE N Uniquely identifies a relationship between tamplate positions for a worklist and the orders corresponding to those positions.
WORKLIST_REF_POS_ID DOUBLE N Uniquely identifies position info for a laboratory worklist template related



Relationship Detail - WORKLIST_POS_ORDER_R


Child Column in WORKLIST_POS_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: WORKLIST_REF_POS_ID WORKLIST_REF_POS WORKLIST_REF_POS_ID


WORKLIST_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Worklist Reference
Definition: Stores the definition of worklist reference information for a worklist.
Table Type: REFERENCE





Column Detail - WORKLIST_REF


Column Name Type Null? Definition
ACCN_SEQ_IND DOUBLE N Indicates whether the worklist is built in accession mode.
ACTIVE_IND DOUBLE Y 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_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AGE_IND DOUBLE N Indicates whether to include the age on the printed worklist.
AUTOMATIC_MAX_ACCN_CNT DOUBLE N Defines the maximum number of accessions (i.e. specimen accessions and QC accessions) that can qualify for a given automatic worklist. This column only applies to automatic worklists of type counted.
AUTOMATIC_WORKLIST_IND DOUBLE N Indicates whether the worklist is defined as an automatic worklist.
AUTOMATIC_WORKLIST_TYPE_CD DOUBLE N A unique code value that identifies the type of automatic worklist (e.g. counted, timed, etc.)
AUTO_ASSIGN_IND DOUBLE N Indicates whether the worklist id will automatically be assigned on the front end application or not.
BACK_FRONT_FLAG DOUBLE N Indicates the fill direction,1 back to front2 front to back
BLANK_LINES DOUBLE Y Defines the number of blank lines to add to the end of worklist for extra accessions that may arrive after the original worklist is printed.
CLIENT_ALIAS_IND DOUBLE N Indicates whether to include the Client Alias for the org that owns the paitient encounter on the printed worklist.
COLLECT_DT_TM_IND DOUBLE N Indicates whether to include the collected date and time on the printed worklist.
COL_ALPHA_IND DOUBLE N Contains the column alpha indicator on the template.
COPIES DOUBLE Y Defines the number of copies to be printed when a worklist is requested.
CROSS_RESOURCE_IND DOUBLE Y Indicates whether qualifying orders for a worklist can cross service resources. A value of 0 does not look across service resources when finding an order. A value of 1 does look across service resources when finding an order.
CUMULATIVE_IND DOUBLE Y Indicates whether a new worklist will show cumulative orders. A value of 0 indicates the orders selected will be all orders not previously placed on a worklist. A value of 1 indicates the orders selected will be all orders not yet completed.
CUST_DOWNLOAD_SCRIPT_CD DOUBLE N The code value corresponding to a custom download script for this worklist.
DISPLAY VARCHAR(20) Y Character description for the worklist.
DISPLAY_KEY VARCHAR(20) Y Uppercase and no spaces character value for display which is used to check and see if the display value entered for a name is new or not.
DISPLAY_KEY_A_NLS VARCHAR(80) Y DISPLAY_KEY_A_NLS column
DISPLAY_KEY_NLS VARCHAR(42) N Stores corresponding non-English character set values for the display_key column.
FACILITY_IND DOUBLE Y Indicates the printing of the facility associated with the patient's location on a worklist report. A value of 0 indicates the facility associated with the patient's location should not be printed on the worklist. A value of 1 indicates that the facility associated with the patient's location should be printed on the worklist.
FILE_DEF_CD DOUBLE N The code value corresponding to the manual download template for this worklist.
FILL_FIRST_FLAG DOUBLE N Indicates whether to fill rows first or columns first.1 - Row2 - Column
FILTER_QC_ASSAYS_IND DOUBLE N Indicates whether the QC assays will be filtered on the worksheet and in Accession Result Entry. A value of 0 indicates that the QC assays will not be filtered. A value of 1 indicates that the QC assays will be filtered.
FIN_IND DOUBLE N Indicates whether to include the financial number on the printed worklist.
INCLUDE_FLAG DOUBLE Y Defines whether or not to include Quality Control on the worklist.
INSTR_IDENT_FLAG DOUBLE Y Defines the identifier type for the worklist. (Currently not implemented)
INTERP_TEXT_IND DOUBLE N Indicates whether to include the Interpretive Text associated with an Alpha Text Interp Result when printing a worksheet.
IN_LAB_IND DOUBLE Y Indicates whether only in lab orders should qualify for a worklist report. A value of 0 indicates include all orders not completed or cancelled on the worklist. A value of 1 indicates include only the orders that are currently in lab.
LANDSCAPE_IND DOUBLE Y Indicates the page orientation of a printed worklist report. A value of 0 indicates the worklist report should print with portrait orientation on the page. A value of 1 indicates that the worklist report should print with landscape orientation on the page.
LEFT_RIGHT_FLAG DOUBLE N Indicates the fill direction:1 - left to right2 - right to left
LOOK_AHEAD_HOURS DOUBLE Y Defines the number of hours to look forward when selecting the orders to place on a worklist. Allows future orders to be placed on the worklist.
MANUAL_DOWNLOAD_IND DOUBLE N Indicates whether manual download of the worklist will be allowed.
MAX_COLS_CNT DOUBLE N Maximun number of columns on the template.
MAX_ROWS_CNT DOUBLE N Maximun number of rows on the template.
MRN_IND DOUBLE N Indicates whether to include the medical record number on the printed worklist.
NEXT_SEQ_NUMBER DOUBLE N Indicates the next sequence number to use for auto-assigning worklist aliases on the worklist table
NUM_SEQ_END DOUBLE Y Defines the ending sequence number for the identifier. (Currently not implemented)
NUM_SEQ_START DOUBLE Y Defines the beginning sequence number for the identifier. (Currently not implemented)
NURSE_UNIT_IND DOUBLE Y Indicates the printing of the nurse unit associated with the patient's location on a worklist report. A value of 0 indicates the nurse unit associated with the patient's location should not be printed on the worklist. A value of 1 indicates that the nurse unit associated with the patient's location should be printed on the worklist.
ORDERING_PHYSICIAN_IND DOUBLE N Indicates whether to include the ordering physician on the printed worklist.
ORDER_COMMENTS_IND DOUBLE Y Indicates the printing of the order comments and footnotes on a worklist report. A value of 0 indicates that order comments and footnotes should not print on the worklist report. A value of 1 indicates that order comments and footnotes should print on the worklist report.
ORDER_STATUS_IND DOUBLE Y Indicates the printing of the department order status on a worklist report. A value of 0 indicates that department order status should not print on the worklist report. A value of 1 indicates that department order status should print on the worklist report.
OUTPUT_DEST_CD DOUBLE N Indicates which printer will be used for this worklist.
PARENT_IND DOUBLE Y Defines whether the worklist reference row is a worklist print group or a worklist template definition. A value of 0 indicates the worklist reference row is a worklist template. A value of 1 indicates the worklist reference row is a worklist print group.
PERSON_COMMENTS_IND DOUBLE Y Indicates the printing of person comments and encounter comments and footnotes on a worklist report. A value of 0 indicates that person and encounter comments and footnotes should not print on the worklist report. A value of 1 indicates that person and encounter comments and footnotes should print on the worklist report.
POSITIONS_PER_SPECIMEN_NBR DOUBLE N Number of positions on the template for each specimen.
PREVIOUS_RESULT_IND DOUBLE Y Indicates the printing of previous result values on a worksheet report. A value of 0 indicates to not include previous results. A value of 1 indicates include previous results.
PRINTER VARCHAR(20) Y Defines the printer where the worklist will be printed.
PRINT_SEQ_LEFT_IND DOUBLE N Indicates whether the printed worklist should display the sequence in a new column on the left.
PRIORITY_IND DOUBLE Y Indicates the priorities to be included on a worklist report. A value of 0 indicates all priorities are selected. A value of 1 indicates only specific priorities should be included.
PROCEDURE_INC_FLAG DOUBLE Y Defines what procedures to include on the worklist.
QC_RANGES_IND DOUBLE N Indicates whether the expected range for a QC assay will print on the worksheet. A value of 0 indicates that the expected range for a QC assay will not print on the worksheet. A value of 1 indecates that the expected range for a QC assay will print on the worksheet.
RACE_IND DOUBLE N Indicates whether to include the race on the printed worklist.
REPORTING_PRIORITY_IND DOUBLE Y Indicates whether the reporting priority for a given order should print on a worklist report. A value of 0 indicates that an order's reporting priority should not print on the worklist report. A value of 1 indicates that an order's reporting priority should print on the worklist report.
REPORT_FORMAT_IND DOUBLE Y Indicates whether worklist orders or worksheet discrete task assays should print vertically or horizontally across the page. A value of 0 indicates the worklist should be printed vertically. A value of 1 indicates the worklist should be printed horizontally.
REPORT_PRIORITY_IND DOUBLE N Indicates whether to include the reporting priority on the printed worklist.
RESULT_COMMENTS_IND DOUBLE Y Indicates whether result comments and footnotes should print on a worksheet report. A value of 0 indicates that result comments and footnotes should not print on the worksheet report. A value of 1 indicates that result comments and footnotes should print on the worksheet report.
RESULT_SPACE_IND DOUBLE Y Indicates whether underlines should print so that results can be manually entered on the printed report. Including spaces for results changes the worklist into a worksheet. A value of 0 indicates do not include a result space on the worklist. A value of 1 indicates include a result space on the worklist.
ROOM_BED_IND DOUBLE N Indicates whether to include the room and bed on the printed worklist.
ROW_ALPHA_IND DOUBLE N Row alpha indicator on the template.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource (instrument, bench, sub-section) to be included on the worklist.
SERV_RES_SORT_IND DOUBLE N Controls whether to sort the assays printed on the worklist by service resource or by catalog_cd. 0 = catalog_cd, 1 - service_resource.
SEX_IND DOUBLE N Indicates whether to include the sex on the printed worklist.
SPACING_IND DOUBLE Y Indicates the line spacing on the printed worklist report. A value of 0 indicates a single spaced worklist. A value of 1 indicates a double spaced worklist.
SPECIMEN_TYPE_IND DOUBLE N Indicates whether to include the specimen type on the printed worklist.
TEMPLATE_IND DOUBLE N Indicates whether this worklist will employ a template.
TEXT_FREETEXT_IND DOUBLE N Indicates whether to include the text or free textresults.
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.
VISIT_REASON_IND DOUBLE Y Indicates the printing of the patient's reason for visit on the worklist report. A value of 0 indicates that the patient's reason for visit should not print on the worklist report. A value of 1 indicates that a patient's reason for visit should print on the worklist report.
WORKLIST_REF_ID DOUBLE N A unique internal system assigned number that identifies a specific worklist reference template.
ZIG_ZAG_IND DOUBLE N Indicates whether to fill the template in a zigzag orientation.



Relationship Detail - WORKLIST_REF




Parent Column in WORKLIST_REF (PK) Child Table Name Child Column Name
Children: WORKLIST_REF_ID WORKLIST_REF_POS WORKLIST_REF_ID
WORKLIST_REF_PRIORITY WORKLIST_REF_ID