Table Detail Report
CHART_ZN_FORM_ZONE
Column Section | Top of Page |
Table-level Detail
Description: | This table defines the attributes for a paticular zone in a zonal section |
Definition: | chart zone format zone |
Table Type: | REFERENCE |
Column Detail - CHART_ZN_FORM_ZONE
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. |
ALL_RSLT_COL | DOUBLE | Y | This defines whether all results will print in a single column on the chart |
ALL_RSLT_LBL | VARCHAR(32) | Y | This defines the all results label that should print on the chart |
ALPHA_ABN_RSLT_COL | DOUBLE | Y | This is defines the column where abnormal alpha results will print |
ALPHA_ABN_RSLT_LBL | VARCHAR(32) | Y | This defines the abnormal alpha result label that should print on the chart |
CHART_GROUP_ID | DOUBLE | N | This number uniquely identifies the chart group |
CRIT_RSLT_COL | DOUBLE | Y | This identifies the column in which critical results should print |
CRIT_RSLT_LBL | VARCHAR(32) | Y | This defines the critical results label that should print on the chart |
HIGH_RSLT_COL | DOUBLE | Y | This defines the column in which high results should print |
HIGH_RSLT_LBL | VARCHAR(32) | Y | This defines the high results label that should print on the chart |
LOW_RSLT_COL | DOUBLE | Y | This defines the column in which low results should print |
LOW_RSLT_LBL | VARCHAR(32) | Y | This defines the low results label that should print on the chart |
NORMAL_RSLT_COL | DOUBLE | Y | This defines the column in which the normal results should print |
NORMAL_RSLT_LBL | VARCHAR(32) | Y | This defines the normal results label that should print on the chart |
REF_RANGE_COL | DOUBLE | Y | This defines the column in which the reference ranges should print |
REF_RANGE_LBL | VARCHAR(32) | Y | This defines the reference range label that should print on the chart |
TEST_COL | DOUBLE | Y | This defines the column in which the procedure name should print |
TEST_LBL | VARCHAR(32) | Y | This defines the test label that should print on the chart |
UNITS_COL | DOUBLE | Y | This defines the column units should print in |
UNITS_LBL | VARCHAR(32) | Y | This defines the units label that should 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. |
ZONE_SEQ | DOUBLE | N | This defines the zone within the zonal section |
CHART_ZN_RESULT_COL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Zone result columns |
Definition: | Contains the result columns for a zone in the new version of the zonal section. |
Table Type: | REFERENCE |
Column Detail - CHART_ZN_RESULT_COL
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 | A number that uniquely identifies a chart group. |
COLUMN_SEQ | DOUBLE | N | The column number of the result column. The value should always be greater than 0 because a 0 value would imply that it does not appear on the chart, and it should not be in the table if it is not in the chart. |
COL_INDEX | DOUBLE | Y | The relative column number among other result columns in the zone. A value of 1 means that it is the first result column, a value of 2 means that it is the second, etc. This is used in part of the interface in the Chart Format Builder. |
DESCRIPTION | VARCHAR(32) | Y | The column header. |
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_SEQ | DOUBLE | N | The order sequence of the zone containing this result column. |
Relationship Detail - CHART_ZN_RESULT_COL
Child Column in CHART_ZN_RESULT_COL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_GROUP_ID | CHART_DYN_ZONE_FORM | CHART_GROUP_ID |
ZONE_SEQ | CHART_DYN_ZONE_FORM | ZONE_SEQ |
Parent Column in CHART_ZN_RESULT_COL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CHART_GROUP_ID | CHART_ZN_RESULT_COL_CDS | CHART_GROUP_ID |
COLUMN_SEQ | CHART_ZN_RESULT_COL_CDS | COLUMN_SEQ | |
ZONE_SEQ | CHART_ZN_RESULT_COL_CDS | ZONE_SEQ |
CHART_ZN_RESULT_COL_CDS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Result column normalcy codes for new version of zonal section |
Definition: | The normalcy codes assigned to a result column in a new version zone. |
Table Type: | REFERENCE |
Column Detail - CHART_ZN_RESULT_COL_CDS
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 | A number that uniquely identifies a chart group. |
COLUMN_SEQ | DOUBLE | N | The order sequence of the result column containing these normalcy codes. |
NORMALCY_CD | DOUBLE | N | The code value for the defined normalcy code |
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_SEQ | DOUBLE | N | The order sequence for the containing zone. |
Relationship Detail - CHART_ZN_RESULT_COL_CDS
Child Column in CHART_ZN_RESULT_COL_CDS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_GROUP_ID | CHART_ZN_RESULT_COL | CHART_GROUP_ID |
COLUMN_SEQ | CHART_ZN_RESULT_COL | COLUMN_SEQ | |
ZONE_SEQ | CHART_ZN_RESULT_COL | ZONE_SEQ |
CHART_ZONAL_FORMAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table defines the formatting for a zonal section |
Definition: | chart zone format |
Table Type: | REFERENCE |
Column Detail - CHART_ZONAL_FORMAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNML_HILITE_FLAG | DOUBLE | Y | This defines the type of highlighting for abnormal results |
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 number uniqely identifies the chart group |
COLLECT_DATE_CHK | DOUBLE | Y | Contains a value of either 1 or 0 indicating whether the collection date should appear above all zones in the new version of the zonal section. |
COLLECT_DATE_LBL | VARCHAR(32) | Y | The label that appears before the collection date and time above a zone in the new version of the zonal section. This only appears if the collect_date_chk = 1 |
CRIT_HILITE_FLAG | DOUBLE | Y | This defines the highlighting for critical results |
DATE_FORMAT_CD | DOUBLE | N | This code defines the type of formatting that should be used when the date is printed on the chart |
DATE_MASK | VARCHAR(50) | Y | This field stores a date mask to be used on all date within this group. |
FTNOTE_LOC_FLAG | DOUBLE | Y | This defines where footnotes should be printed on the chart |
INTERP_LOC_FLAG | DOUBLE | Y | This defines where the interpretive data should print |
ORDER_GROUP_IND | DOUBLE | N | Indicator for noting to group results by order_id |
REF_RNG_FORM_FLAG | DOUBLE | Y | This defines the format that the reference range should use when printing on the chart |
RSLT_SEQ_FLAG | DOUBLE | Y | This defines the order in which the results should print |
TIME_FORMAT_FLAG | DOUBLE | Y | This defines the format that the time should used when printed on the chart |
TIME_MASK | VARCHAR(32) | Y | This field stores time mask used to format all times for this 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_ZONAL_FORMAT
Child Column in CHART_ZONAL_FORMAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_GROUP_ID | CHART_GROUP | CHART_GROUP_ID |
FORMAT_ORG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FORMAT ORG RELTN |
Definition: | Contains the relationship between a chart_format and an organization. |
Table Type: | REFERENCE |
Column Detail - FORMAT_ORG_RELTN
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CHART_FORMAT_ID | DOUBLE | N | Unique identifier of the chart_format table which is the chart_format that is being associated to an organization. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
ORGANIZATION_ID | DOUBLE | N | Contains the unique identifier of the organization that the chart_format is associated to. |
PRIMARY_FORMAT_IND | DOUBLE | Y | Indicator to determine if the chart format is the primary for to be used by the MRP Dll |
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 - FORMAT_ORG_RELTN
Child Column in FORMAT_ORG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |