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. |