Table Detail Report

CHART_PRINT_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Print Queue
Definition: Holds requests that have been queued by the Chart Server for the Chart Spooler to pick up and print.
Table Type: ACTIVITY





Column Detail - CHART_PRINT_QUEUE


Column Name Type Null? Definition
BATCH_ID DOUBLE N Identifies each set of files for a specific chart request process. The same chart request processed and queued twice will have two different batch IDs.
BEGIN_PAGE DOUBLE Y Serves as the first page in the range of begin_page to end_page for a chart.
CHART_PATH VARCHAR(150) N The path where the Chart Spooler should look to find the queued file.
CHART_QUEUE_ID DOUBLE N Primary key for the table. Uniquely identifies each row in the table.
DISTRIBUTION_ID DOUBLE N Foreign key to the chart_distribution table. Identifies the row as belonging to a distribution.
DIST_RUN_DT_TM DATETIME Y Identifies the date and time of the corresponding distribution run that produced the chart request.
DIST_TERMINATOR_IND DOUBLE Y Indicates whether or not the chart request associated with the row is the last chart request in a distribution.
END_PAGE DOUBLE Y Serves as the last page in the range of begin_page to end_page for a chart.
NUM_COPIES DOUBLE Y The number of copies of the file to print.
PRINT_PATH VARCHAR(75) N The description of the printer where the file should be sent.
QUEUED_DT_TM DATETIME Y The date and time that the file was queued.
QUEUE_STATUS_CD DOUBLE N Identifies the status of the file in respect to printing it.
REQUEST_ID DOUBLE N Foreign key to the chart_request table. Identifies the chart request to which the file belongs.
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 - CHART_PRINT_QUEUE


Child Column in CHART_PRINT_QUEUE(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID
REQUEST_ID CHART_REQUEST CHART_REQUEST_ID


CHART_PROBLEM_FORMAT



Column Section Top of Page


Table-level Detail

Description: CHART PROBLEM FORMAT
Definition: This table defines the attributes for problem list section.
Table Type: REFERENCE





Column Detail - CHART_PROBLEM_FORMAT


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 Y 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.
CANCEL_LBL VARCHAR(32) Y The label for the cancel column.
CANCEL_ORD DOUBLE N The order for the cancel column.
CHART_GROUP_ID DOUBLE N chart_group_id. The primary key for rows in this table.
CODE_LBL VARCHAR(32) Y The label for the code column.
CODE_ORD DOUBLE N The order for the code column.
COMMENT_LBL VARCHAR(32) Y The label for the comment column.
CON_STAT_LBL VARCHAR(32) Y The label for the contributor status column.
CON_STAT_ORD DOUBLE N The order for the contributor status column.
COURSE_LBL VARCHAR(32) Y The label for the course column.
COURSE_ORD DOUBLE N The order for the course column.
DATE_EST_LBL VARCHAR(32) Y The label for the date established column.
DATE_RECORDED_LBL VARCHAR(32) Y The label for the recorded date column.
DATE_RECORDED_SEQUENCE_IND DOUBLE N Determines if the chart will print newest to oldest(0) or oldest to newest(1).
LIFE_STAT_LBL VARCHAR(32) Y The label for the life status column.
LIFE_STAT_ORD DOUBLE N The order for the life status column.
ONSET_LBL VARCHAR(32) Y The label for the onset date column.
ONSET_ORD DOUBLE N The order for the onset date column.
PERST_LBL VARCHAR(32) Y The label for the persistence column.
PERST_ORD DOUBLE N The order for the persistence column.
PROB_NAME_LBL VARCHAR(32) Y The label for the problem name column.
PROG_LBL VARCHAR(32) Y The label for the prognosis column.
PROG_ORD DOUBLE N The order for the prognosis column.
PROV_LBL VARCHAR(32) Y The label for the provider column.
RESULT_SEQUENCE_IND DOUBLE N Determines if the chart will print onset date newest to oldest(0) or oldest to newest(1). Keyed off Onset 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.


CHART_PROCHIST_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHART PROCHIST FORMAT
Definition: This table stores section parameters for procedure history section.
Table Type: REFERENCE





Column Detail - CHART_PROCHIST_FORMAT


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 Y 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.
CHART_GROUP_ID DOUBLE N The foreign key to chart_group table
DATE_LBL VARCHAR(32) Y The label for date column.
DATE_ORD DOUBLE Y The order for date column.
LOCATION_LBL VARCHAR(32) Y The label for location column.
LOCATION_ORD DOUBLE Y The order for location column.
PROC_LBL VARCHAR(32) Y The label for procedure column.
PROC_ORD DOUBLE Y The order for procedure column.
PROVIDER_LBL VARCHAR(32) Y The label for provider column.
PROVIDER_ORD DOUBLE Y The order for provider column.
STATUS_LBL VARCHAR(32) Y The label for status column.
STATUS_ORD DOUBLE Y The order for status column.
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 - CHART_PROCHIST_FORMAT


Child Column in CHART_PROCHIST_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID


CHART_RAD_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores info for formatting of Radiology chart sections
Definition: chart radiology format
Table Type: REFERENCE





Column Detail - CHART_RAD_FORMAT


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 Y 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.
CDM_CODE_IND DOUBLE Y The indicator for printing or not printing CDM codes
CDM_DESC_IND DOUBLE Y The indicator for printing or not printing CDM description
CDM_LABEL VARCHAR(100) Y Label for CDM Codes.
CDM_LABEL_STYLE VARCHAR(255) Y The style for CDM label.
CHART_GROUP_ID DOUBLE N FK to chart_group table
COR_FOOTNOTE_IND DOUBLE Y Indicator to store if to suppress the radiology corrected footnote.
CPT4_CODE_IND DOUBLE Y print or not print CPT4 codes
CPT4_DESC_IND DOUBLE Y print or not print CPT4 description
CPT4_LABEL VARCHAR(100) Y label for CPT4 codes
CPT4_LABEL_STYLE VARCHAR(255) Y style for CPT4 labels
GROUP_STYLE VARCHAR(255) Y Style to apply to group heading
REASON_ANNOTATION DOUBLE Y Used to associate procedures with reasons for exam
REASON_CAPTION VARCHAR(100) Y Label for reason for exam
REASON_IND DOUBLE Y Indicates whether or not to print Reason For Exam
RESULT_SEQUENCE DOUBLE Y Oldest to newest or vice versa
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 - CHART_RAD_FORMAT


Child Column in CHART_RAD_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID


CHART_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Request
Definition: This table defines the chart requests that are to be processed by the chart server.
Table Type: ACTIVITY





Column Detail - CHART_REQUEST


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(20) Y This is the accession number for the results that will print on the accession level chart
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 Y 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.
ADDL_COPIES DOUBLE Y This defines whether additional copies of the chart should be printed
BEGIN_DT_TM DATETIME Y This is the date and time that is used to determine how far back the system should look when searching for results to be printed on the chart
BEGIN_PAGE DOUBLE Y The is the page number that the system begins printing at when a page range is specified for a chart
CHART_BATCH_ID DOUBLE N Stores a grouping batch ID for requests. The grouper value will be the PK value of the first Chart Request in the Batch.
CHART_FORMAT_ID DOUBLE N This is the number that uniquely identifies the chart format
CHART_PENDING_FLAG DOUBLE Y This flag determines whether pending or verified or both types of procedures are printed on the chart
CHART_REQUEST_ID DOUBLE N This a unique number assigned to the chart request which allows that chart request to be resubmitted or skipped if needed
CHART_ROUTE_ID DOUBLE N Stores the unique identifier to the Chart Route
CHART_STATUS_CD DOUBLE N Used to store the status of the request. Replaces status_flag.
CHART_TRIGGER_ID DOUBLE N TRIGGER ID VALUE FROM CHART_TRIGGER
CR_MASK_ID DOUBLE N This is a number which uniquely identifies a chart mask
DATE_RANGE_IND DOUBLE Y This field indicates whether a date range is being used when printing the chart
DISTRIBUTION_ID DOUBLE N This is a number which uniquely identifies a chart distribution
DIST_INITIATOR_IND DOUBLE Y An indicator for the distribution initiator
DIST_RUN_DT_TM DATETIME Y This is the date and time that the distribution was started
DIST_RUN_TYPE_CD DOUBLE N This is the code from the code set 22550 which determines what type of chart will be produced (i.e. interim, cummulative)
DIST_TERMINATOR_IND DOUBLE Y An indicator for the distribution terminator
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_DT_TM DATETIME Y This is the date and time when identifies the end of a date range that the system uses when looking for results
END_PAGE DOUBLE Y This is the page number that is the end of the range when a page range is requested to be printed
EVENT_IND DOUBLE Y Identifies whether to chart specific events that are stored in the sub table chart_request_event
FILE_STORAGE_CD DOUBLE N Specifies printer, prn, or rtf
FILE_STORAGE_LOCATION VARCHAR(100) Y Location to write the file out to
GROUP_ORDER_ID DOUBLE N The order id for the parent of the group of orders. The group_order_id will relate to the cs_order_id. The cs_order_id will not always be filled out and can be zero on orders table.
HANDLE_ID DOUBLE N foreign key for the output_ctx table
MCIS_IND DOUBLE Y This field indicates whether a request was an MCIS distribution request (when this field is = 1) or this is a regular expedite request (all other cases). Both times request_type = 2
NON_CE_BEGIN_DT_TM DATETIME Y This is the date/time used to determine how far back the system should look when searching for clinical insignificant data to include on the chart.
NON_CE_END_DT_TM DATETIME Y This is the date/time that marks the end of the date range for clinical insignificant data to be included on the chart.
ORDER_GROUP_FLAG DOUBLE N The type of Orders grouping. 1 = component2 = supergroup3 = parent/child4 = linked0 = not defined
ORDER_ID DOUBLE N This is the number that is uniquely associated with an order
OUTPUT_DEST_CD DOUBLE N This is the code that defines the output destination
OUTPUT_DEVICE_CD DOUBLE N This is the code that identifies the type of device a chart is being printed to
PAGE_RANGE_IND DOUBLE Y This field indicates whether a page range is being used when printing the chart
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRINT_COMPLETE_FLAG DOUBLE Y This field is not used at this time
PROCESS_TIME DOUBLE Y Number of seconds it took to process this request
PRSNL_PERSON_ID DOUBLE N Prnsl who is recieving the chart.
PRSNL_PERSON_R_CD DOUBLE N Role of the prsnl recieving the chart
PRSNL_RELTN_ID DOUBLE N Prsnl_reltn_id of prsnl_reltn table for a provider
READER_GROUP VARCHAR(15) Y This field when defined is used to link one distribution with another
RECOVER_CNT DOUBLE Y Number of times the request went through recovery
RECOVER_DT_TM DATETIME Y Date/Time of last time the request went through recovery
REQUEST_DT_TM DATETIME Y This identifies the date and time when the request was submitted
REQUEST_PRSNL_ID DOUBLE N This is the id of the person submitting the request
REQUEST_TYPE DOUBLE Y This identifies the type of request that has been submitted (i.e. ad hoc, distribution, expedite)
RESUBMIT_CNT DOUBLE Y This field keeps count of the number of times a request has been resubmitted
RESUBMIT_DT_TM DATETIME Y This is the date and time that the request was last resubmitted
RESULT_LOOKUP_IND DOUBLE Y Result Lookup indicator to look up results by either clinical range or posting range.
RRD_AREA_CODE VARCHAR(10) Y This is the area code for the destination of a remote chart
RRD_COUNTRY_ACCESS VARCHAR(3) Y This is the country access number of a destination for a remote chart
RRD_DELIVER_DT_TM DATETIME Y This is the date and time that a remote chart was sent
RRD_EXCHANGE VARCHAR(10) Y This is the exchange number of a destination for a remote chart
RRD_PHONE_SUFFIX VARCHAR(50) Y This is the phone suffix number of a destination for a remote chart
SCOPE_FLAG DOUBLE Y This is the scope of the chart format (i.e. accession, order, encounter)
SEQUENCE_GROUP_ID DOUBLE N Stores the unique identifier to the Chart Sequence Group (route stop)
SERVER_NAME VARCHAR(20) Y The name of the server that last processed the request
STATUS_FLAG DOUBLE Y This is the status of the chart print
SUPPRESS_MRPNODATA_IND DOUBLE N If this indicator is set to 1, then MRP no datas will not print to the printer.
TOTAL_PAGES DOUBLE Y Total pages of chart, replaces outputctx page count
TRIGGER_ID DOUBLE N Trigger_id for ESO
TRIGGER_NAME VARCHAR(100) Y Stores the trigger name that fired the chart request.
TRIGGER_TYPE VARCHAR(15) Y Activity type of the event being charted
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.
USER_ROLE_PROFILE VARCHAR(255) Y User role profile to be used during the processing of the requested chart



Relationship Detail - CHART_REQUEST


Child Column in CHART_REQUEST(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID
CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
CHART_ROUTE_ID CHART_ROUTE CHART_ROUTE_ID
SEQUENCE_GROUP_ID CHART_SEQUENCE_GROUP SEQUENCE_GROUP_ID
CHART_TRIGGER_ID CHART_TRIGGER CHART_TRIGGER_ID
DIST_RUN_TYPE_CD CODE_VALUE CODE_VALUE
CR_MASK_ID CR_MASK CR_MASK_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
TRIGGER_ID ESO_TRIGGER TRIGGER_ID
ORDER_ID ORDERS ORDER_ID
HANDLE_ID OUTPUTCTX HANDLE_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD
PERSON_ID PERSON PERSON_ID
PRSNL_PERSON_ID PRSNL PERSON_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID
PRSNL_RELTN_ID PRSNL_RELTN PRSNL_RELTN_ID




Parent Column in CHART_REQUEST (PK) Child Table Name Child Column Name
Children: CHART_REQUEST_ID CHART_PRINTED_SECTIONS CHART_REQUEST_ID
CHART_PRINT_QUEUE REQUEST_ID
CHART_REQUEST_ENCNTR CHART_REQUEST_ID
CHART_REQUEST_EVENT CHART_REQUEST_ID
CHART_REQUEST_ORDER CHART_REQUEST_ID
CHART_REQUEST_SECTION CHART_REQUEST_ID
CHART_REQ_INERR_EVENT CHART_REQUEST_ID
CHART_SERV_LOG CHART_REQUEST_ID