Changes to the CSV Output Format

We’ve implemented several changes to the CSV output produced by the EDI API and the CLI converter.

The purpose of the changes is to make column names more intuitive and to add several missing and derived fields. The derived fields are calculated based on the values in other columns.

Changes to Existing Column Names

We removed the “Person” prefix for all subscriber and patient column names.

For example, the old column name was “SubscriberPersonFirstName.” This column was renamed to “SubscriberFirstName.”

We’ve replaced “LastNameOrOrgName” name suffix with “LastName” for people (subscriber, patient) or “Name” for organizations (Payer, Payee) where appropriate.

For example, the old column name was “PayerLastNameOrOrgName.” This column was renamed to “PayerName.”

You can see more examples of the new names by navigating to our examples and selecting “Export/All Fields.”

New Columns

835

• ServiceDateFrom. The earliest service date based on all service dates from service lines.
• ServiceDateTo. The latest service date based on all service dates from service lines.
• TotalAdjAmount. The sum total of all adjustment amounts from the claims and all lines
• CoverageAmount. Claim supplemental amount of the COVERAGE_AMOUNT type (X12 EDI “AU” qualifier) qualifier. It can also be found in one of the SupplementalAmtAmount columns. It is provided in its own column for convenience.
• LineAllowedAmount. Line supplemental amount of the ALLOWED_ACTUAL type (X12 EDI “B6” qualifier) qualifier. It can also be found in one of the LineSupplementalAmtAmount columns. It is provided in its own column for convenience.

837

• ServiceDateFrom. The earliest service date based on all service dates from service lines.
• ServiceDateTo. The latest service date based on all service dates from service lines.
• PatientBirthDate. Patient birthdate. Note that patient fields are populated only when the patient is different from the subscriber/member.
• PatientGender. Patient gender.