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 |