Table Detail Report

CHART_GRP_EVNT_SUPPRESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Group Event Suppress
Definition: Stores the DTAs / Event Codes that were suppressed for a procedure within a chart group.
Table Type: REFERENCE





Column Detail - CHART_GRP_EVNT_SUPPRESS


Column Name Type Null? Definition
CHART_EVNT_SUPPRESS_ID DOUBLE N A number that uniquely identifies a row on this table
CHART_GROUP_ID DOUBLE N The unique number associated with the chart group into which these procedures will print.
EVENT_CD DOUBLE N The event code suppressed from printing with the associated procedure (not used at this time)
EVENT_SET_NAME VARCHAR(40) N The name of the event set for the procedure defined to print within the chart group that contains suppressed event codes (not used at this time)
ORDER_CATALOG_CD DOUBLE N The catalog code for the procedure defined to print within the chart group that contains suppressed DTAs.
TASK_ASSAY_CD DOUBLE N Discrete Task Assay Code. The DTA suppressed from printing with the associated procedure.
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_GRP_EVNT_SUPPRESS


Child Column in CHART_GRP_EVNT_SUPPRESS(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GRP_EVNT_SET CHART_GROUP_ID
EVENT_SET_NAME CHART_GRP_EVNT_SET EVENT_SET_NAME
ORDER_CATALOG_CD CHART_GRP_EVNT_SET ORDER_CATALOG_CD
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


CHART_HLA_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines attributes in Chart HLA section.
Definition: Chart HLA Format
Table Type: REFERENCE





Column Detail - CHART_HLA_FORMAT


Column Name Type Null? Definition
ABO_RH_LABEL VARCHAR(32) Y The label for ABO column.
ABO_RH_ORDER DOUBLE Y The order for ABO column.
ABO_RPT DOUBLE Y The repeat indicator for ABO column label.
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 Chart group id. The foreign key value from CHART_GROUP
DATE_LABEL VARCHAR(32) Y The label for collected date column.
DATE_ORDER DOUBLE Y The order for collected date column.
DATE_RPT DOUBLE Y The repeat indicator for collected date column label.
HAPLOID1_LABEL VARCHAR(32) Y The label for Haplotype ID 1 column.
HAPLOID1_ORDER DOUBLE Y The order for Haplotype ID 1 column.
HAPLOID2_LABEL VARCHAR(32) Y The label for Haplotype ID 2 column.
HAPLOID2_ORDER DOUBLE Y The order for Haplotype ID 2 column.
HAPLOTYPE1_LABEL VARCHAR(32) Y The label for Haplotype result 1 column.
HAPLOTYPE1_ORDER DOUBLE Y The order for Haplotype result 1 column.
HAPLOTYPE2_LABEL VARCHAR(32) Y The label for Haplotype result 2 column.
HAPLOTYPE2_ORDER DOUBLE Y The order for Haplotype result 2 column.
HLA_TYPE DOUBLE Y The type of HLA section. 0 -- HLA Typing. 1 -- HLA Haplotype.
LINE_INDICATOR DOUBLE Y The indicator for results pair printed in one line or two lines.
MRN_LABEL VARCHAR(32) Y The label for MRN column.
MRN_ORDER DOUBLE Y The order for MRN column.
MRN_RPT DOUBLE Y The repeat indicator for MRN column label.
PRSN_NAME_LABEL VARCHAR(32) Y The label for person name column.
PRSN_NAME_ORDER DOUBLE Y The order for person name column.
PRSN_NAME_RPT DOUBLE Y The repeat indicator for person name column label.
RELATION_LABEL VARCHAR(32) Y The label for relationship column.
RELATION_ORDER DOUBLE Y The order for relationship column.
RELATION_RPT DOUBLE Y The repeat indicator for relationship column label.
RESULT_ORDER DOUBLE Y The order for HLA typing result column.
RESULT_SEQ_FLAG DOUBLE Y The flag for sorting results.
RH_IND DOUBLE N Indicator for displaying RH with ABO on a 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_HLA_FORMAT


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


CHART_HORZ_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the attributes for a horizontal section type
Definition: chart horizontal format
Table Type: REFERENCE





Column Detail - CHART_HORZ_FORMAT


Column Name Type Null? Definition
ABNML_HILITE_FLAG DOUBLE Y This defines the type of highlighting that should be used 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 is a unique number that identifies the chart group
CRIT_HILITE_FLAG DOUBLE Y This defines the type of highlighting that should be used for critical results
DATE_FORMAT_CD DOUBLE N This defines the way the date will be formatted
DATE_MASK VARCHAR(50) Y This field stores a date mask to be used on all date within this group
DATE_ORDER DOUBLE Y This defines in which order the date will print
ENCNTR_ALIAS_ORDER DOUBLE Y the order of encounter alias column
FLOWSHEET_IND DOUBLE Y This identifies if the user selected Horizontal section or Horizontal Flowsheet section.
FTNOTE_LOC_FLAG DOUBLE Y This defines where footnotes will print on the chart
INTERP_LOC_FLAG DOUBLE Y This defines where interpretive data will print on the chart
NORMALH_LBL_ORDER DOUBLE Y This defines the order in which the normal high label will print
NORMALL_LBL_ORDER DOUBLE Y This defines the order in which the normal low label will print
NORMAL_HIGH_LBL VARCHAR(32) Y This defines the normal high label that will print on the chart
NORMAL_LOW_LBL VARCHAR(32) Y This defines the normal low label that will print on the chart
PERFID_LBL VARCHAR(32) Y This defines the performed_id label
PERFID_LBL_ORDER DOUBLE Y This defines the order in which the performed_id label will print
REFER_LBL_ORDER DOUBLE Y This defines the order in which the reference range label will print
REF_RANGE_LBL VARCHAR(32) Y This defines the reference range label that will print on the chart
REF_RNG_FORM_FLAG DOUBLE Y This defines the formatting of the reference ranges
RSLT_SEQ_FLAG DOUBLE Y This defines whether results will be printed newest to oldest or oldest to newest
RSLT_START_COL DOUBLE Y This field is not used at this time
STAYDAYS_ORDER DOUBLE Y This defines the order in which the day of stay will print on the chart
TEST_LBL VARCHAR(32) Y This defines the procedure label
TEST_LBL_ORDER DOUBLE Y This defines the order in which the test label will print
TIME_FORMAT_FLAG DOUBLE Y This defines the format that the time will print on the chart
TIME_MASK VARCHAR(32) Y This field stores time mask used to format all times within this group.
TIME_ORDER DOUBLE Y This defines the order in which the time should print
UNITS_LBL VARCHAR(32) Y This defines the units label that will print on the chart
UNITS_LBL_ORDER DOUBLE Y This defines the order in which the units 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.
WEEKDAY_ORDER DOUBLE Y This defines the order in which the weekday will print on the chart
WKDAY_FORMAT_FLAG DOUBLE Y This defines the format for the weekday that will print on the chart



Relationship Detail - CHART_HORZ_FORMAT


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


CHART_IMAGE_MM_FLDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart format image mail merge fields
Definition: This table is used to store the mail merge fields to be used by all image pages for a single chart format.
Table Type: REFERENCE





Column Detail - CHART_IMAGE_MM_FLDS


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.
CDF_MEANING VARCHAR(12) N This is the CDF Meaning from code set 14005 for the data elements defined to print in thne chart header/footer.
CHART_FORMAT_ID DOUBLE N This is the FK value from table CHART_FORMAT and is a number assigned to each unique chart format. It is used here, in conjunction with a Field Sequence, to uniquely identify rows in this table.
FIELD_SEQ DOUBLE N The field sequence. Used with the CHART_FORMAT_ID to uniquely identify rows in this table.
LOCATION_IND DOUBLE N Indicates if header or footer. Header = 0 and footer = 1
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_IMAGE_MM_FLDS


Child Column in CHART_IMAGE_MM_FLDS(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID


CHART_IMMUNIZ_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Immuniz Format
Definition: Immunization Format for Charting
Table Type: REFERENCE





Column Detail - CHART_IMMUNIZ_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.
ADMIN_NOTE_IND DOUBLE Y Indicates whether or not to show the admin_note for an immunization.
ADMIN_PERSON_LBL VARCHAR(32) Y The label to display next to the admin person
AMOUNT_IND DOUBLE Y Indicates whether or not to display the dosage amount of the immunization.
AMOUNT_LBL VARCHAR(32) Y The label to display next to the dosage amount
CHART_GROUP_ID DOUBLE N The foreign key to the CHART_GROUP table
DATE_GIVEN_IND DOUBLE Y Indicates whether or not to display the date an immunization was given.
DATE_GIVEN_LBL VARCHAR(32) Y The label to display next to the date given
DATE_MASK VARCHAR(50) N The format in which dates in this section will display
EXP_DT_IND DOUBLE Y Indicates whether or not to display the expiration date of an immunization.
EXP_DT_LBL VARCHAR(32) Y The label to display next to the expiration date.
EXP_TM_IND DOUBLE Y Indicates whether or not to display the expiration time of an immunization next to its expiration date.
LOT_NUM_IND DOUBLE Y Indicates whether or not to display the lot # of an immunization substance.
LOT_NUM_LBL VARCHAR(32) Y The label to display next to the lot #
MANUFACT_IND DOUBLE Y Indicates whether or not to display the immunization substance manufacturer.
MANUFACT_LBL VARCHAR(32) Y The label to display next to the substance manufacturer.
PROVIDER_IND DOUBLE Y Indicates whether or not to display the immunization provider.
PROVIDER_LBL VARCHAR(32) Y The label to display next to the provider.
RESULT_SEQ_IND DOUBLE Y Indicates the sequencing of immunizations (1 = reverse chronological; 0 = chronological)
SITE_IND DOUBLE Y Indicates whether or not to display the site the immunizations was administered.
SITE_LBL VARCHAR(32) Y The label to display next to the site.
TIME_GIVEN_IND DOUBLE Y Indicates whether or not to display the time that an immunization was given along with the date given.
TIME_MASK VARCHAR(32) N The format in which dates in this section will display
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.
VACCINE_LBL VARCHAR(32) Y The label to display next to the vaccine.



Relationship Detail - CHART_IMMUNIZ_FORMAT


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