Table Detail Report
CHART_EXCLUDE
Column Section | Top of Page |
Table-level Detail
Description: | CHART EXCLUDE |
Definition: | This table a temporary table to hold disqualified encounters in distr. |
Table Type: | ACTIVITY |
Column Detail - CHART_EXCLUDE
Column Name | Type | Null? | Definition |
---|---|---|---|
DISTRIBUTION_ID | DOUBLE | N | This is the distribution_id of encounter/distribution being excluded from qualifying encounters. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
CHART_FLEX_FORMAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table defines which type of blood bank results will print in the section |
Definition: | chart flex (blood bank) section format |
Table Type: | REFERENCE |
Column Detail - CHART_FLEX_FORMAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABO_RH_LBL | VARCHAR(32) | Y | This is the label for ABO/Rh column. |
ABO_RH_ORDER | DOUBLE | Y | This is the order for ABO/Rh column in the flex section of a chart format. |
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 the id uniquely defined for the chart group |
COLLECTED_DT_TM_LBL | VARCHAR(32) | Y | This is the label for collected date and time (crossmatch) or transfused date and time (transfused) column. |
COLLECTED_DT_TM_ORDER | DOUBLE | Y | This is the order for collected/transfused date & time column in the flex section of a chart format |
CROSSMATCH_RESULT_LBL | VARCHAR(32) | Y | This is the label for a result column in a crossmatch section of a chart format. |
CROSSMATCH_RESULT_ORDER | DOUBLE | Y | This is the order for a result column in a crossmatch section of a chart format. |
DESCRIPTION_LBL | VARCHAR(32) | Y | This is the label for a product description column in a flex section of a chart format. |
DESCRIPTION_ORDER | DOUBLE | Y | This is the order for a product description column in a flex section of a chart format. |
DISPLAY_LBL | VARCHAR(32) | Y | This is the label for a product display column in a flex section of a chart format. |
DISPLAY_ORDER | DOUBLE | Y | This is the order for a product display column in a flex section of a chart format. |
FLEX_TYPE | DOUBLE | Y | This defines whether the section type is crossmatched or transfused |
ORDER_SEQ_FLAG | DOUBLE | Y | This flag indicates that the printed results are in the oldest-to- newest order or in the newest-to-oldest order. |
PRODUCT_NBR_LBL | VARCHAR(32) | Y | This is the label for a product number column in a flex section of a chart format. |
PRODUCT_NBR_ORDER | DOUBLE | Y | This is the order for a product number column in a flex section of a chart format. |
PRODUCT_STATUS_LBL | VARCHAR(32) | Y | This is the label for a Product Status column in a Flexible section of a chart format. |
PRODUCT_STATUS_ORDER | DOUBLE | Y | This is the order for a Product Status colun in a Flexible section of a chart format. |
RECEIVED_DT_TM_LBL | VARCHAR(32) | Y | This is the label for specimen received date and time for the Flexible section. |
RECEIVED_DT_TM_ORDER | DOUBLE | Y | This is the order for specimen received date and time for the Flexible section. |
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. |
VERIFIED_DT_TM_LBL | VARCHAR(32) | Y | This is the label for a verified date & time column in a flex section of a chart format. |
VERIFIED_DT_TM_ORDER | DOUBLE | Y | This is the order for a verified date & time column in a flex section of a chart format. |
Relationship Detail - CHART_FLEX_FORMAT
Child Column in CHART_FLEX_FORMAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_GROUP_ID | CHART_GROUP | CHART_GROUP_ID |
CHART_FORMAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table stores the different chart formats and their associated symbols |
Definition: | chart format |
Table Type: | REFERENCE |
Column Detail - CHART_FORMAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_SYMBOL | VARCHAR(1) | Y | This defines the symbol that will print beside 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. |
ADDITIONAL_INFO_ID | DOUBLE | N | Long text ID of additional information for a chart format. Foreign key link to long_text_reference table. |
ADDRESS_COL_NBR | DOUBLE | N | Determines the starting column where the address will be placed in the report. |
ADDRESS_PAGE_IND | DOUBLE | N | Indicates if an address cover page needs to be printed for this document. |
ADDRESS_ROTATE_IND | DOUBLE | N | Indicates whether or not to rotate the address page 90 degrees. |
ADDRESS_ROW_NBR | DOUBLE | N | Determines the starting row where the address will be placed in the report. |
ASCII_IND | DOUBLE | N | ASCII format indicator. 1 = ASCII format, 0 = not ASCII |
BLANK_PAGE_STMT | VARCHAR(132) | Y | Defines the statement that should print on the last page of the chart if the last page is blank. |
CHART_FORMAT_DESC | VARCHAR(64) | Y | This is the chart format name |
CHART_FORMAT_ID | DOUBLE | N | This is the id that uniquely defines the chart format |
CORRECTED_SYMBOL | VARCHAR(1) | Y | This is the symbol that is defined to print beside a corrected result |
CRITICAL_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a critical result |
DATE_MASK | VARCHAR(50) | Y | This field stores a date mask to be used on all date within this group. |
DOCUMENT_NAME | VARCHAR(100) | Y | This is the name of the facesheet that the user selects in Chart Format Builder |
E_DOC_FTR_NBR | DOUBLE | N | Stores the document image footer margin to be applied when exclude footers has been selected |
E_DOC_HDR_NBR | DOUBLE | N | Stores the document image header margin to be applied when exclude headers has been selected |
FTNOTES_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a result that has a result comment, corrected footnote or any other footnote. |
FTNOTE_LOC_FLAG | DOUBLE | Y | Defines where footnotes will print on the chart. Applies to the entire chart. |
HEADER_PAGE_IND | DOUBLE | Y | Indicator for header page. |
HIGH_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a high result |
INCLUDE_PRSNL_HIST_IND | DOUBLE | N | Indicator noting whether or not to include a personnel history at the end of the report. |
INTERP_DATA_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a procedure that is defined with interpretive data |
INTERP_LOC_FLAG | DOUBLE | Y | Defines where interp data will print on the chart. Applies to the entire chart. |
I_DOC_FTR_NBR | DOUBLE | N | Stores the document image footer margin to be applied when include footers has been selected |
I_DOC_HDR_NBR | DOUBLE | N | Stores the document image header margin to be applied when include headers has been selected |
LEFT_MARGIN_NBR | DOUBLE | N | Stores the document image left margin to be applied |
LOW_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a low result |
NEW_RESULT_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside a new result |
ORD_COMMENT_FLAG | DOUBLE | Y | Tells whether order comments are suppressed for this chart or not. |
PAGE_BRK_IND | DOUBLE | Y | Format level page break indicator. |
PRESERVE_INTERP_IND | DOUBLE | N | 0 - Ignore RTF formatting for interpretive data in the printed chart. (Strip out plain text will occur.) 1 - Preserve RTF formatting for interpretive data in the printed chart. (Strip out plain text will NOT occur.) |
PROGRAM_NAME | VARCHAR(100) | Y | This is the actual program name of the facesheet. |
PRSNL_IDENT_FLAG | DOUBLE | Y | The personnel identifier for the chart format. This is used for corrected footnotes. |
REF_LAB_FLAG | DOUBLE | Y | Tells whether refrance lab footnotes are suppressed |
REF_LAB_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside the name of the procedure if it has been performed at a reference lab |
REPAGINATE_OFF_IND | DOUBLE | N | Indicator to NOT repaginate while printing charts. |
RESUBMIT_DISCLAIMER_ID | DOUBLE | N | ID to the long_text table which contains the resubmit disclaimer. |
REVIEW_SYMBOL | VARCHAR(1) | Y | This is the symbol that is defined to print beside the result if the result has been flagged for review |
RIGHT_MARGIN_NBR | DOUBLE | N | Stores the document image right margin to be applied |
SEX_AGE_CHANGE_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print beside the result if a change to age or sex has been made causing the reference ranges to change |
STAT_SYMBOL | VARCHAR(1) | Y | This is the symbol that will print next to the result of a procedure that has been ordered stat |
SUPPRESS_NA_IND | DOUBLE | N | the Suppress N/A Indicator |
TEMPLATE_LOC | VARCHAR(255) | Y | This is the location and name of the template portion of the chart format |
TIME_MASK | VARCHAR(50) | Y | This field stores time mask to be used to format all times within this chart format. |
UNIQUE_IDENT | VARCHAR(60) | Y | the Unique Identifier |
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_FORMAT
Child Column in CHART_FORMAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADDITIONAL_INFO_ID | LONG_TEXT | LONG_TEXT_ID |
RESUBMIT_DISCLAIMER_ID | LONG_TEXT | LONG_TEXT_ID |
Parent Column in CHART_FORMAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CHART_FORMAT_ID | CHART_FORMAT_CODES | CHART_FORMAT_ID |
CHART_FORM_MM_FLDS | CHART_FORMAT_ID | ||
CHART_FORM_SECTS | CHART_FORMAT_ID | ||
CHART_IMAGE_MM_FLDS | CHART_FORMAT_ID | ||
CHART_REQUEST | CHART_FORMAT_ID | ||
CHART_TRIGGER | CHART_FORMAT_ID | ||
EXPEDITE_FORMAT | CHART_FORMAT_ID | ||
EXPEDITE_MANUAL | CHART_FORMAT_ID | ||
EXPEDITE_PARAMS | CHART_FORMAT_ID | ||
LOCATION | CHART_FORMAT_ID |
CHART_FORMAT_CODES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains all event_codes or order catalog codes for a particular CF |
Definition: | Used by chart server to find all event_codes and order_catalog codes contained in a Chart Format |
Table Type: | REFERENCE |
Column Detail - CHART_FORMAT_CODES
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. |
AP_HISTORY_FLAG | DOUBLE | Y | Print or don't print history |
CF_CODE_ID | DOUBLE | N | This is the id that uniquely defines the chart_format_codes table |
CG_SEQUENCE_NUM | 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_FORMAT_ID | DOUBLE | N | This is the id that uniquely defines the chart format |
CHART_GROUP_ID | DOUBLE | N | This is a unique number assigned to chart groups within a section |
CHART_SECTION_ID | DOUBLE | N | This is the number that uniquely identifies a chart section |
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 |
EVENT_CD | DOUBLE | N | Event Code |
EVENT_SET_NAME | VARCHAR(40) | Y | 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 |
FLEX_TYPE_FLAG | DOUBLE | Y | This field identifies which Flex type (Transfusion or XMatch) |
HLA_TYPE_FLAG | DOUBLE | Y | This field identifies which HLA type (HLA Typing) |
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 |
SECTION_TYPE_FLAG | DOUBLE | Y | This field identifies the type of section (i.e. horizontal, vertical etc.) |
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 | zone value |
Relationship Detail - CHART_FORMAT_CODES
Child Column in CHART_FORMAT_CODES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_FORMAT_ID | CHART_FORMAT | CHART_FORMAT_ID |
CHART_GROUP_ID | CHART_GROUP | CHART_GROUP_ID | |
CHART_SECTION_ID | CHART_SECTION | CHART_SECTION_ID |
CHART_FORM_MM_FLDS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | The data elements that are being used within the header/footer of chart |
Definition: | chart format mail merge fields |
Table Type: | REFERENCE |
Column Detail - CHART_FORM_MM_FLDS
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. |
CDF_MEANING | VARCHAR(12) | Y | This is the CDF meaning from the code set for the data elements defined to print in the chart header/footer. |
CHART_FORMAT_ID | DOUBLE | N | This is a number uniquely assigned to each chart format |
FIELD_DESC | VARCHAR(60) | Y | This is the description of the data field defined to print in the header/footer. |
FIELD_SEQ | DOUBLE | N | This is a unique identifier for the table key |
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_MM_FLDS
Child Column in CHART_FORM_MM_FLDS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_FORMAT_ID | CHART_FORMAT | CHART_FORMAT_ID |