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 |