Data Import Standards

The following columns display in standardized data import specifications:

  • Field Name - The name for the specific field and what should be the column header in the file. Often from the related database column name.
  • Type (Length)- Identifies what type of value should be sent in this field and the maximum length the field can hold. Updated information available in db model, otherwise follow link to model spreadsheet.
  • Required - Indicates if a field is required. Options include:
    • R - required: Data is required for import to function.
    • O - optional: Data is optional for import.
    • BP - best practice: Data is not required, but provides better usability within EH.
    • CR - conditionally required: Data is required based on conditions defined in spec. Include details for conditionally required data in this column as needed.
  • Description - Description of imported information. Retrieved from db model or model spreadsheet (see link under Type).
  • Example - Example field contents.
  • Data File Column Name Header - Name of column header in CSV file.
  • Displays in EH? - Yes/No - Indicates if field displays in the EH system.
  • Client Using - Indicates if client will use field in their EH system.
  • Client Notes - Open for client use to document questions.
  • MIE Notes - Open for MIE use to document questions.
  • MIE Wiki Link - URL to MIE Wiki page with related information.
  • MIE Legacy Field # - (Use if applicable.) Order of columns from older MIE spec.

Older specifications may display different columns or a different order. The standard specification template is available here.

CSV API wiki pages refer to data as it is named in the Field Name column of the specification, accompanied by the Data File Column Name Header in parentheses. This aides in tying together the details of the specification with the CSV template file used for the import. For example, Name Value Pairs (name_value.NAME)

Specific Coded Values

The following fields require specific codes to represent specific values, and the data won’t be displayed properly in a MIE system if the specific codes are not used.


ISO 2 letter state code (ISO 3166-2) - *


ISO 2 letter country code (ISO 3166-1-alpha-2) -


CDC Race codes -

R1American Indian
R3African American
R4Hawaiian / Pacific Islander
NADeclined to Answer


CDC Ethnicity codes -

E1Hispanic or Latino
E2Not Hispanic or Latino
NADeclined to Answer


NNot applicable

Marital Status

ALegally Separated
CCommon Law

Full/Part Time Employment Status

FFull-Time Employee
PPart-Time Employee

User ID Types

id:usernameWebchart username
id:uidUniversal ID
id:npiNation Provider ID
id:user_idInternal Webchart User ID

Patient ID Types

id:usernameWebchart username
id:ext_idExternal Identifier
id:ssnSocial Security Number (US)
id:sinSocial Insurance Number (Canada)
id:emailemail address
id:pat_idInternal Webchart Patient ID

Data Import User Instructions

The following instructions detail how to import data into an EH system using a CSV file.

These instructions apply only to a CSV file input. If the file you need to convert from is different, or if the client requests fields to be imported that are not covered by the generic data import format, the data must be imported differently.

Accessing Data Import

To access the data import template:

  1. Access the left side menu by clicking the menu icon.
  2. Click the Control Panel tab.
  3. Click the Data Import tab.
  4. Select the appropriate from the drop-down menu. (Example displays generic data import).
  5. Click the Go button.

Template File

Use the template file to establish the required columns and formats for the data import file. Click on the CSV Import Specification link for details about setting up the file.

Import Testing

The import file must be stored as a CSV. If prompted by Excel to save as a different format, make sure the file is saved as a CSV. It is best to first test with only a few rows of data before importing an entire file. Then, if the data imports successfully, delete the rows you just loaded from the original file so that they are not duplicated. To complete a test import:

  1. Input the following information into corresponding fields to upload the form:
    1. Interface: hr_feed
    2. Verbose: Select the Verbose checkbox to see the logging of the import. Usually only needed if there are errors.
    3. Delimiter: select from drop list
    4. Choose/Upload File: Select the file you’re importing.
    5. Click the Upload button.

Any errors encountered during the import display on the import page. Click the Download Failed Generic Test Data File button to view the error file. This file is useful because it only contains the records from the data file that had issues. These issues can be identified and fixed and then the failed file can be uploaded to fill in the gap.

CSV Header Options

Chart Data CSV Header Options

Enterprise Health Documentation

Last Updated:

Last Build: Fri, 07 Jun 2024 13:13:36 EDT
WikiGDrive Version: dd69069d725fca5f553df7ded62e130a49d49ca6