Table Detail Report

CHART_SEQUENCE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Sequence Group
Definition: Stores the different groups and their sequence numbers. Each group belongs to a group type (either Provider or Organization) and the sequence numbers are in reference to a specific group type.
Table Type: REFERENCE





Column Detail - CHART_SEQUENCE_GROUP


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.
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.
CHART_ROUTE_ID DOUBLE N Chart Route ID. Foreign Key for unique identifier to the CHART_ROUTE table.
GROUP_NAME VARCHAR(255) N Stores the group name.
GROUP_TYPE_FLAG DOUBLE N 1=Provider, 2=Organization This column became OBSOLETE when new table CHART_ROUTE was created and implemented. CAPE-128299.
SEQUENCE_GROUP_ID DOUBLE N A number that uniquely identifies a row on this table.
SEQUENCE_NBR DOUBLE N Stores the sequence number of the group. Only groups within the same group_type_flag are related by their sequence number.
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.



Relationship Detail - CHART_SEQUENCE_GROUP


Child Column in CHART_SEQUENCE_GROUP(FK) Parent Table Name Parent Column Name
Parents: CHART_ROUTE_ID CHART_ROUTE CHART_ROUTE_ID




Parent Column in CHART_SEQUENCE_GROUP (PK) Child Table Name Child Column Name
Children: SEQUENCE_GROUP_ID CHART_REQUEST SEQUENCE_GROUP_ID
CHART_SEQ_GROUP_RELTN SEQUENCE_GROUP_ID
CR_REPORT_REQUEST ROUTE_STOP_ID


CHART_SEQ_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart sequence group relationship
Definition: For a given group, this table stores the selected items related to the group. If the group type is 'provider', then this table stores the assigned providers to a group. Likewise if the group type is 'organization', then this table stores the assigned organizations.
Table Type: REFERENCE





Column Detail - CHART_SEQ_GROUP_RELTN


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.
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.
GROUP_RELTN_ID DOUBLE N A number that uniquely identifies a row on this table.
LOCATION_CD DOUBLE N Stores the Location code added to the route stop. Value comes from LOCATION.LOCATION_CD
ORGANIZATION_ID DOUBLE N The unique number associated with a specified organization.
PRSNL_ID DOUBLE N The unique number associated with a specified provider.
SEQUENCE_GROUP_ID DOUBLE N The unique number associated with a specified CHART Sequence Group.
SEQUENCE_NBR DOUBLE N The assigned sequence number to the provider or organization within a group
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_SEQ_GROUP_RELTN


Child Column in CHART_SEQ_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: SEQUENCE_GROUP_ID CHART_SEQUENCE_GROUP SEQUENCE_GROUP_ID
LOCATION_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID


CHART_SERVER_PRINTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Server Printers
Definition: A current listing of all the front end printers installed on the chart servers.
Table Type: REFERENCE





Column Detail - CHART_SERVER_PRINTER


Column Name Type Null? Definition
CHART_SERVER_PRINTER_ID DOUBLE N Primary Key. Value from CHART_VIEW_SEQ
CS_PARAM_ID DOUBLE N Foreign Key to chart server settings table
OUTPUT_DEST_CD DOUBLE N Ouitput_dest_cd installed on chart server.
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_SERVER_PRINTER


Child Column in CHART_SERVER_PRINTER(FK) Parent Table Name Parent Column Name
Parents: CS_PARAM_ID CHART_SERVER_SETTINGS CS_PARAM_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD


CHART_SERVER_SETTINGS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to store settings for the chart servers
Definition: chart_server_settings
Table Type: REFERENCE





Column Detail - CHART_SERVER_SETTINGS


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.
ADHOC_IND DOUBLE N AdHoc Indicator
ASCII_OUTPUT_DEST_CD DOUBLE N This is the ASCII Output Destination Code
AUTO_SAVE_RATE_NBR DOUBLE Y The number of results that should pass before automatically saving the document.
CRM_RETRY DOUBLE Y Number of times the server will retry a CRM call
CS_PARAM_ID DOUBLE N This is the id that uniquely defines the chart server settings row.
CYCLE_RATE DOUBLE Y Chart server will be cycled after this many requests have been processed.
DISTRIBUTION_IND DOUBLE N Distribution Indicator
DOC_IMAGE_RETRY DOUBLE N Stores the number of times to attempt to export the document image.
ENABLE_DMS_IND DOUBLE N Indicates if the DMS option in Chart Server is enabled.
EXPEDITE_IND DOUBLE N Expedite Indicator
LOG_LEVEL DOUBLE Y Server can log errors warnings, script calls, printers depending how hight the log level was set.
MRP_IND DOUBLE N MRP Indicator
PRINTING_IND DOUBLE Y Printing can be truned off by setting this field to 0.
PRINT_CUTOFF DOUBLE Y Serves as the page count that a chart must be greater than or equal to in order for a non-distribution request to be queued.
PURGE_DAYS DOUBLE Y Temp files will be purged after this many days.
QUEUE_DIST_IND DOUBLE Y Indicates whether or not to queue all distribution requests.
QUEUE_IND DOUBLE Y Indicates whether or not to queue large charts for the Chart Spooler application to pick up and send to the printer.
QUEUE_MRP_IND DOUBLE N Stores whether to queue MRP requests or not
RECOVER_IND DOUBLE Y Tells if this is a recovery server.
RTF_OUTPUT_DEST_CD DOUBLE N This is the RTF output destination code
SAVE_AS_PDF_IND DOUBLE N Indicates whether to save as a PDF in the chart server.
SAVE_FILES_IND DOUBLE Y Save rtf files depending on this indicator.
SERVER_NAME VARCHAR(20) Y Network name for each server.
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_SERVER_SETTINGS




Parent Column in CHART_SERVER_SETTINGS (PK) Child Table Name Child Column Name
Children: CS_PARAM_ID CHART_SERVER_PRINTER CS_PARAM_ID


CHART_SERV_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to log messages from the chart server
Definition: chart_serv_log
Table Type: ACTIVITY





Column Detail - CHART_SERV_LOG


Column Name Type Null? Definition
CHART_LOG_NUM DOUBLE N Unique identifier
CHART_REQUEST_ID DOUBLE N Unique identifier from the chart_request table
LOG_DT_TM DATETIME Y Log Date Time
LOG_LEVEL DOUBLE Y Log Level of the message
MESSAGE_TEXT VARCHAR(150) Y message text
SERVER_NAME VARCHAR(30) Y Computer/Server Name
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_SERV_LOG


Child Column in CHART_SERV_LOG(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID