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