Table Detail Report

CHART_FORM_SECTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the chart sections associated with a chart format
Definition: chart form sections
Table Type: REFERENCE





Column Detail - CHART_FORM_SECTS


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_FORMAT_ID DOUBLE N This is a unique number assigned to each chart format
CHART_SECTION_ID DOUBLE N This is a unique number that is assigned to each chart section within a chart format
CS_SEQUENCE_NUM DOUBLE Y This is a sequence number assigned to a chart section which defines the order in which it will print on the chart
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_FORM_SECTS


Child Column in CHART_FORM_SECTS(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
CHART_SECTION_ID CHART_SECTION CHART_SECTION_ID


CHART_GENERIC_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Generic Format
Definition: This table is used for storing generic sections of the chart format.
Table Type: REFERENCE





Column Detail - CHART_GENERIC_FORMAT


Column Name Type Null? Definition
CHART_DISCERN_REQUEST_ID DOUBLE N The request associated to a given discern report section. FK from CHART_DISCERN_REQUEST
CHART_GROUP_ID DOUBLE N Foreign Key from CHART GROUP. Also the primary key for this table.
INCLUDE_IMG_FOOTER_IND DOUBLE N Indicator for displaying the footer.
INCLUDE_IMG_HEADER_IND DOUBLE N Indicator for displaying the header.
PARAM_LONG_TEXT_ID DOUBLE N Long text reference id where the parameters for this section are stored. FK from the Long_Text_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.



Relationship Detail - CHART_GENERIC_FORMAT


Child Column in CHART_GENERIC_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_DISCERN_REQUEST_ID CHART_DISCERN_REQUEST CHART_DISCERN_REQUEST_ID
CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID
PARAM_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


CHART_GL_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHART GL FORMAT
Definition: This table defines the attributes in LAB (text) section of a chart.
Table Type: REFERENCE





Column Detail - CHART_GL_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 from the CHART_GROUP table
GROUP_STYLE VARCHAR(255) Y group style for LAB format
RESULT_SEQ_FLAG DOUBLE Y sequence flag for results. 0 - oldest -> newest, 1 - newest -> oldest.
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_GL_FORMAT


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


CHART_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the chart groups for a given chart section
Definition: chart group
Table Type: REFERENCE





Column Detail - CHART_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 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.
CG_SEQUENCE DOUBLE Y This is number that is assigned to the chart group that defines the order in which it will print within a section
CHART_GROUP_DESC VARCHAR(64) Y Description of the Chart Group
CHART_GROUP_ID DOUBLE N This is a unique number assigned to a chart group within a chart format
CHART_SECTION_ID DOUBLE N This is a unique number assigned to a section within a chart format
ENHANCED_LAYOUT_IND DOUBLE Y This identifies if the user selected this section (to which this group belongs) to be an enhanced layout.
MAX_RESULTS DOUBLE Y This field is not used at this time
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_GROUP


Child Column in CHART_GROUP(FK) Parent Table Name Parent Column Name
Parents: CHART_SECTION_ID CHART_SECTION CHART_SECTION_ID




Parent Column in CHART_GROUP (PK) Child Table Name Child Column Name
Children: CHART_GROUP_ID CHART_AP_FORMAT CHART_GROUP_ID
CHART_DOC_FORMAT CHART_GROUP_ID
CHART_DYN_ZONE_FORM CHART_GROUP_ID
CHART_FLEX_FORMAT CHART_GROUP_ID
CHART_FORMAT_CODES CHART_GROUP_ID
CHART_GENERIC_FORMAT CHART_GROUP_ID
CHART_GL_FORMAT CHART_GROUP_ID
CHART_GRP_EVNT_SET CHART_GROUP_ID
CHART_HLA_FORMAT CHART_GROUP_ID
CHART_HORZ_FORMAT CHART_GROUP_ID
CHART_IMMUNIZ_FORMAT CHART_GROUP_ID
CHART_LISTVIEW_FORMAT CHART_GROUP_ID
CHART_MAR_FORMAT CHART_GROUP_ID
CHART_MICRO_FORMAT CHART_GROUP_ID
CHART_NAME_HIST_FORMAT CHART_GROUP_ID
CHART_ORDERS_FORMAT CHART_GROUP_ID
CHART_ORD_SUM_FILTER CHART_GROUP_ID
CHART_PROCHIST_FORMAT CHART_GROUP_ID
CHART_RAD_FORMAT CHART_GROUP_ID
CHART_VERT_FORMAT CHART_GROUP_ID
CHART_XENCNTR_FORMAT CHART_GROUP_ID
CHART_ZONAL_FORMAT CHART_GROUP_ID


CHART_GRP_EVNT_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the event sets that are associated with a chart group
Definition: chart group event sets
Table Type: REFERENCE





Column Detail - CHART_GRP_EVNT_SET


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 This is a unique number assigned to chart groups within a section
DISPLAY_NAME VARCHAR(32) Y This field is not used at this time
EVENT_SET_NAME VARCHAR(40) N This is the event set name for the event sets defined to print within the chart group
EVENT_SET_SEQ DOUBLE Y This is a sequence number to define the order in which the event sets should print within the chart group
ORDER_CATALOG_CD DOUBLE N Catalog Cd
PROCEDURE_TYPE_FLAG DOUBLE Y This flag specifies if the row is an event set or a catalog cd
SYNONYM_ID DOUBLE N Synonym id that is related to an order catalog cd
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.
ZONE DOUBLE Y This is the zone for zonal section types that the event sets defined on this table should print in



Relationship Detail - CHART_GRP_EVNT_SET


Child Column in CHART_GRP_EVNT_SET(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID
ORDER_CATALOG_CD ORDER_CATALOG CATALOG_CD
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in CHART_GRP_EVNT_SET (PK) Child Table Name Child Column Name
Children: CHART_GROUP_ID CHART_GRP_EVNT_SUPPRESS CHART_GROUP_ID
EVENT_SET_NAME CHART_GRP_EVNT_SUPPRESS EVENT_SET_NAME
ORDER_CATALOG_CD CHART_GRP_EVNT_SUPPRESS ORDER_CATALOG_CD