Skip to main content

Claims File

Claims data file containing claim information for processing.

File Information

PropertyValue
File TypeCSV
Delimitercomma (,)
Includes HeadersYes

Fields

PositionHeader NameDescriptionRequiredTypeFormatValid ValuesExample
1Client IDEmployer-specific unique identifier in partner's systemYesStringCLIENT-12345
2Employee IDEmployee-specific unique identifier in payroll systemYesStringEMPLOYEE-12345
3Plan IDPlan-specific unique identifier in partner's system that must match the Plan ID in the eligibility file (for validation)YesStringPLAN-12345
4Plan Year StartPlan year-specific start dateYesDateYYYY-MM-DD2020-01-01
5Plan Year EndPlan year-specific end dateYesDateYYYY-MM-DD2020-01-01
6Transaction IDTransaction-specific unique identifier in partner's system (for duplicate checking)YesUUID550e8400-e29b-41d4-a716-446655440000
7Claim IDClaim-specific unique identifier in partner's system (for matching with original claim id if adjustment or reversal)YesStringCLAIM-12345
8Claim TypeOriginal, Adjustment, ReversalYesStringOriginal, Adjustment, ReversalOriginal
9Date of ServiceDate when employee receives care (could be in the past)YesDateYYYY-MM-DD1900-01-01
10Processing DateDate when claim is adjudicatedYesDateYYYY-MM-DD1900-01-01
10Employee ResponsibilityAmount employee is responsible for (could be positive or negative)YesDecimal100.00
12Billed AmountAmount provider billed insurance forYesDecimal100.00
13Service DescriptionProcedure or medication name (open text)YesStringOffice Visit
14Service CategoryMedical, PharmacyYesStringMedical
15Provider NameProvider or pharmacy name (open text)YesStringDr. John Smith
16Plan NetworkInNetwork, OutOfNetworkNoStringInNetwork, OutOfNetworkInNetwork

Example

Client ID,Employee ID,Plan ID,Plan Year Start,Plan Year End,Transaction ID,Claim ID,Claim Type,Date of Service,Processing Date,Employee Responsibility,Billed Amount,Service Description,Service Category,Provider Name,Plan Network
CLIENT-12345,EMPLOYEE-12345,PLAN-12345,2020-01-01,2020-01-01,550e8400-e29b-41d4-a716-446655440000,CLAIM-12345,Original,1900-01-01,1900-01-01,100.00,100.00,Office Visit,Medical,Dr. John Smith,InNetwork