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