Table of Contents
Claims Sample
Claim import samples are available in the following file formats:
Microsoft Excel Worksheet
Account ID | Account Number | Account Name | Claim ID | Claim Number | Claim Status | Claim Source | Claim Type | Claimant Name | Adjustor Name | Occurrence Number | Coverage Description | Loss Description | Is In Litigation | Major Cause Description | Detail Cause Description | Nature Of Injury Description | Body Part Description | Body Position Description | Loss Paid Amount | Loss Reserved Amount | Expense Paid Amount | Expense Reserved Amount | Total Incurred Amount | Average Weekly Wage | Date Of Loss | Date Reported | Date Closed | Date Reopened | Valued As Of Date | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DIV-A | Division A | C00015358 | Open | External Claim Manager | John Doe | Walter Cruz | Workers Compensation | Sprained ankle stepping off sidewalk | false | Miscellaneous Causes | Ankle | 1397.00 | 0.00 | 0.00 | 0.00 | 1397.00 | 2013-03-25 | 2013-03-25 | 2013-10-15 | ||||||||||
2 | DIV-B | Division B | C00015362 | Closed | External Claim Manager | Sally Smith | Walter Cruz | Auto Collision | Struck parked vehicle | false | Collision | Hit parked vehicle | 523.00 | 0.00 | 0.00 | 0.00 | 523.00 | 2016-06-05 | 2016-06-07 | 2016-06-29 | ||||||||||
3 |
JSON File
{
"claims": [
{
"accountId": "",
"accountNumber": "DIV-A",
"accountName": "Division A",
"claimId": "",
"claimNumber": "C00015358",
"claimStatus": "Open",
"claimSource": "External Claim Manager",
"claimType": "",
"claimantName": "John Doe",
"adjustorName": "Walter Cruz",
"occurrenceNumber": "",
"coverageDescription": "Workers Compensation",
"lossDescription": "Sprained ankle stepping off sidewalk",
"isInLitigation": "false",
"majorCauseDescription": "Miscellaneous Causes",
"detailCauseDescription": "",
"natureOfInjuryDescription": "",
"bodyPartDescription": "Ankle",
"bodyPositionDescription": "",
"lossPaidAmount": "1397.00",
"lossReservedAmount": "0.00",
"expensePaidAmount": "0.00",
"expenseReservedAmount": "0.00",
"totalIncurredAmount": "1397.00",
"averageWeeklyWage": "",
"dateOfLoss": "2013-03-25",
"dateReported": "2013-03-25",
"dateClosed": "2013-10-15",
"dateReopened": "",
"valuedAsOfDate": ""
},
{
"accountId": "",
"accountNumber": "DIV-B",
"accountName": "Division B",
"claimId": "",
"claimNumber": "C00015362",
"claimStatus": "Closed",
"claimSource": "External Claim Manager",
"claimType": "",
"claimantName": "Sally Smith",
"adjustorName": "Walter Cruz",
"occurrenceNumber": "",
"coverageDescription": "Auto Collision",
"lossDescription": "Struck parked vehicle",
"isInLitigation": "false",
"majorCauseDescription": "Collision",
"detailCauseDescription": "Hit parked vehicle",
"natureOfInjuryDescription": "",
"bodyPartDescription": "",
"bodyPositionDescription": "",
"lossPaidAmount": "523.00",
"lossReservedAmount": "0.00",
"expensePaidAmount": "0.00",
"expenseReservedAmount": "0.00",
"totalIncurredAmount": "523.00",
"averageWeeklyWage": "",
"dateOfLoss": "2016-06-05",
"dateReported": "2016-06-07",
"dateClosed": "2016-06-29",
"dateReopened": "",
"valuedAsOfDate": ""
}
]
}
XML Document
<?xml version="1.0"?>
<import>
<claim>
<accountId></accountId>
<accountNumber>DIV-A</accountNumber>
<accountName>Division A</accountName>
<claimId></claimId>
<claimNumber>C00015358</claimNumber>
<claimStatus>Open</claimStatus>
<claimSource>External Claim Manager</claimSource>
<claimType></claimType>
<claimantName>John Doe</claimantName>
<adjustorName>Walter Cruz</adjustorName>
<occurrenceNumber></occurrenceNumber>
<coverageDescription>Workers Compensation</coverageDescription>
<lossDescription>Sprained ankle stepping off sidewalk</lossDescription>
<isInLitigation>false</isInLitigation>
<majorCauseDescription>Miscellaneous Causes</majorCauseDescription>
<detailCauseDescription></detailCauseDescription>
<natureOfInjuryDescription></natureOfInjuryDescription>
<bodyPartDescription>Ankle</bodyPartDescription>
<bodyPositionDescription></bodyPositionDescription>
<lossPaidAmount>1397.00</lossPaidAmount>
<lossReservedAmount>0.00</lossReservedAmount>
<expensePaidAmount>0.00</expensePaidAmount>
<expenseReservedAmount>0.00</expenseReservedAmount>
<totalIncurredAmount>1397.00</totalIncurredAmount>
<averageWeeklyWage></averageWeeklyWage>
<dateOfLoss>2013-03-25</dateOfLoss>
<dateReported>2013-03-25</dateReported>
<dateClosed>2013-10-15</dateClosed>
<dateReopened></dateReopened>
<valuedAsOfDate></valuedAsOfDate>
</claim>
<claim>
<accountId></accountId>
<accountNumber>DIV-B</accountNumber>
<accountName>Division B</accountName>
<claimId></claimId>
<claimNumber>C00015362</claimNumber>
<claimStatus>Closed</claimStatus>
<claimSource>External Claim Manager</claimSource>
<claimType></claimType>
<claimantName>Sally Smith</claimantName>
<adjustorName>Walter Cruz</adjustorName>
<occurrenceNumber></occurrenceNumber>
<coverageDescription>Auto Collision</coverageDescription>
<lossDescription>Struck parked vehicle</lossDescription>
<isInLitigation>false</isInLitigation>
<majorCauseDescription>Collision</majorCauseDescription>
<detailCauseDescription>Hit parked vehicle</detailCauseDescription>
<natureOfInjuryDescription></natureOfInjuryDescription>
<bodyPartDescription></bodyPartDescription>
<bodyPositionDescription></bodyPositionDescription>
<lossPaidAmount>523.00</lossPaidAmount>
<lossReservedAmount>0.00</lossReservedAmount>
<expensePaidAmount>0.00</expensePaidAmount>
<expenseReservedAmount>0.00</expenseReservedAmount>
<totalIncurredAmount>523.00</totalIncurredAmount>
<averageWeeklyWage></averageWeeklyWage>
<dateOfLoss>2016-06-05</dateOfLoss>
<dateReported>2016-06-07</dateReported>
<dateClosed>2016-06-29</dateClosed>
<dateReopened></dateReopened>
<valuedAsOfDate></valuedAsOfDate>
</claim>
</import>