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 |