835 (ERA) CSV Data Dictionary
Payment
| Name | Description | Type | EDI Reference |
|---|---|---|---|
id | Unique payment identifier assigned by the converter | String | |
transactionType | Transaction set identifier code | String | ST01 |
fileName | Converted X12 EDI file name | String | |
transactionControlNumber | Transaction set control number | String | ST02 |
patientControlNumber | Identifier used to track a claim from creation by the health care provider through payment | String | CLP01 |
claimStatus | Claim status | String | |
chargeAmount | Charge amount | Number | CLP03 |
paymentAmount | Payment amount | Number | CLP04 |
patientResponsibilityAmount | Patient responsibility amount | Number | CLP05 |
claimFilingIndicatorCode | Claim filing indicator code | String | CLP06 |
payerControlNumber | Payer control number | String | CLP07 |
facility | Place of service code (professional/dental) or UB facility code (institutional) from the original claim | CLP08 | |
frequencyTypeCode | Frequency type code | String | CLP09 |
drgCode | Diagnosis-related group code. Institutional claims only. | String | CLP11 |
drgWeight | Adjudicated DRG weight. Institutional claims only. | Number | CLP12 |
dischargeFraction | Adjudicated discharge fraction. Institutional claims only. This is a percentage expressed as decimal. | Number | CLP13 |
totalPaymentAmount | Total payment amount | Number | BPR02 |
creditOrDebitFlagCode | Credit or debit flag code | String | BPR03 |
paymentMethodType | Payment method type | String | BPR04 |
receiverAccountNumber | Receiver account number | String | BPR15 |
paymentDate | Payment date | Date | BPR16 |
checkOrEftTraceNumber | Check or eft trace number | String | TRN02 |
payerEin | Payer identifier. This must be a '1' followed by the payer EIN. This field is also copied to the payerIdentifier field if it wasn't provided in N104. | String | TRN03 |
productionDate | Production date | Date | DTP03*405 |
totalAdjAmount | Sum total of all adjustments from all service lines | Number | |
adjs | Claim adjustments | List of Adjustment | CAS |
payer | Payer | N1*PR | |
payee | Payee | N1*PE | |
patient | The insured (subscriber) or patient from the original claim | NM1*QC | |
subscriber | The insured (subscriber) from the original claim if the insured is different from the patient | NM1*44 | |
correctedPatient | Corrected patient | NM1*74 | |
serviceProvider | Service provider | NM1*SJ | |
crossoverCarrier | Crossover carrier | NM1*TT | |
correctedPayer | Corrected priority payer, meaning that current payer believes that another payer has priority for making a payment | NM1*PR | |
otherSubscriber | Other subscriber | NM1*GB | |
otherClaimRelatedIds | Other claim-related identifications | List of Reference | REF |
serviceDateFrom | The earliest service date from service lines | Date | |
serviceDateTo | The latest service date from service lines | Date | |
statementDateFrom | Statement date from | Date | DTP03*232 |
statementDateTo | Statement date to | Date | DTP03*233 |
coverageExpirationDate | Coverage expiration date | Date | DTP03*036 |
claimReceivedDate | Claim received date | Date | DTP03*050 |
coverageAmount | Coverage amount from the list of supplemental amounts | Number | AMT02*AU |
supplementalAmts | Supplemental claim/payment amounts, such as coverage amount, discount amount, etc. | List of Amount | AMT |
supplementalQties | Supplemental claim/payment quantities | List of Quantity | QTY |
lines | Service payment information | List of PaymentLineCsv | 2110 |
Service Line
| Name | Description | Type | EDI Reference |
|---|---|---|---|
controlNumber | Line item control number from 837 | String | REF02*6R |
procedure | Adjudicated procedure code | SVC01*HC SVC01*AD SVC01*WK SVC01*IV | |
revenueCode | Adjudicated revenue code | SVC01*RC,NU SVC04*RC,NU | |
drugCode | Adjudicated drug code (NDC) | String | SVC01 |
chargeAmount | Charge amount | Number | SVC02 |
paidAmount | Paid amount | Number Required | SVC03 |
unitCount | Unit count | Number | SVC05 |
originalProcedure | Submitted procedure code from the claim if it is different from the adjudicated procedure | SVC06*HC SVC06*AD SVC06*WK SVC06*IV | |
originalRevenueCode | Submitted revenue code from the claim if it is different from the adjudicated revenue code | SVC06*RC,NU | |
originalDrugCode | Submitted drug (NDC) code from the claim if it is different from the adjudicated drug code | SVC06 | |
originalUnitCount | Original unit count | Number | SVC07 |
serviceDateFrom | Service period start date | Date | DTP03*472 DTP03*150 |
serviceDateTo | Service period end date. If not provided in EDI (single day), it is set to 'serviceDateFrom' | Date | DTP03*151 |
totalAdjAmount | Sum total of all adjustments for this service line | Number | |
adjs | Line adjustments | List of Adjustment | CAS |
serviceIds | Related service-specific identifiers that were used in the process of adjudicating this service | List of Reference | REF |
healthcarePolicyId | Healthcare policy id | String | REF02*0K |
renderingProviderIds | Rendering provider identifiers | List of Reference | REF |
allowedAmount | Allowed amount -- this is one of the amounts from the list of supplemental amounts | Number | |
supplementalAmts | Supplemental amounts, such as allowed amount, deduction amount, etc. | List of Amount | AMT |
supplementalQties | Supplemental quantities | List of Quantity | QTY |
remarkCodes | Remark codes | List of String | LQ |
Adjustment
| Name | Description | Type | EDI Reference |
|---|---|---|---|
group | Claim adjustment group code as a string constant Values: CONTRACTUAL(CO), CORRECTION(CR), OTHER(OA), PATIENT_RESPONSIBILITY(PR), PAYOR_INITIATED(PI) | String (enum) Required | CAS01 |
reason | Claim adjustment reason code | Required | CAS02 |
amount | Adjustment amount | Number Required | CAS03 |
quantity | Adjustment quantity | Number | CAS04 |
Organization Or Person ID and Name
| Name | Description | Type | EDI Reference |
|---|---|---|---|
entityRole | Entity role | String Required | NM101 N101 |
entityType | Type of this entity: 'BUSINESS' for organization, 'INDIVIDUAL' for person Values: BUSINESS(2), INDIVIDUAL(1) | String (enum) Required | NM102 |
identificationType | Identification type, e.g., NPI or EIN. This is a qualifier code translated to a string constant (enum) | String | NM108 N103 |
identifier | Identifier | String | NM109 N104 |
taxId | Tax id | String | REF02*TJ REF02*SY REF02*EI |
lastNameOrOrgName | Organization name or person last name | String | NM103 N102 |
firstName | First name | String | NM104 |
middleName | Middle name | String | NM105 |
Organization or Person (Party)
| Name | Description | Type | EDI Reference |
|---|---|---|---|
address | Address | ||
contacts | Contacts | List of ContactInfo | |
additionalIds | Other identifications | List of Reference | REF |
Address
| Name | Description | Type | EDI Reference |
|---|---|---|---|
line | Line | String Required | N301 |
line2 | Line2 | String | N302 |
city | City | String Required | N401 |
stateCode | State code | String | N402 |
zipCode | Zip code | String | N403 |
countryCode | Country code | String | N404 |
Contact Info
| Name | Description | Type | EDI Reference |
|---|---|---|---|
functionCode | Function code | String Required | PER01 |
name | Name | String | PER02 |
contactNumbers | Contact numbers | List of ContactNumber |
Contact Number
| Name | Description | Type | EDI Reference |
|---|---|---|---|
type | Type of contact number Values: ALTERNATE_PHONE, BEEPER, CELL_PHONE, EMAIL, EXTENSION, FAX, HOME_PHONE, PHONE, UNKNOWN, URL, WORK_PHONE | String (enum) Required | PER03 PER05 PER07 |
number | Number | String Required | PER04 PER06 PER08 |
Procedure
| Name | Description | Type | EDI Reference |
|---|---|---|---|
modifiers | Modifiers | List of Code | 837P:SV101-3-6 837I:SV201-3-6 835:SVC01-3-6 277:SVC01-3-6 |
Code
| Name | Description | Type |
|---|---|---|
subType | Healthcare code subtype, such as CPT, HCPCS, ICD_10, NDC | String |
code | Healthcare code | String Required |
desc | Code description | String |
Amount
| Name | Description | Type | EDI Reference |
|---|---|---|---|
qualifierCode | Code specifying the type of amount (amount qualifier code) | String Required | AMT01 |
type | Type of amount; qualifier code translated to a mnemonic string constant (enum) | String | AMT01 |
amount | Amount | Number Required | AMT02 |
Quantity
| Name | Description | Type | EDI Reference |
|---|---|---|---|
qualifierCode | Code specifying the type of quantity (quantity qualifier code) | String Required | QTY01 |
type | Type of quantity; qualifier code translated to a mnemonic string constant (enum) | String | QTY01 |
quantity | Quantity | Number Required | QTY02 |
Reference Identifications
| Name | Description | Type | EDI Reference |
|---|---|---|---|
qualifierCode | Code qualifying the reference identification | String Required | REF01 |
type | Type of reference; qualifier code as a string constant (enum) | String | REF01 |
identification | Reference identification | String Required | REF02 |