Sample CSV Format for Uploading Geographic Rating Areas
Let us assume that a file request type with the below field transformation details is used for uploading the geographic rating area information in the system.
| Sequence | Field Name | Map Field XPath |
|---|---|---|
| 1 | GEO_RATING_AREA | C1-GeoRatingArea/geoRatingArea |
| 2 | STATE | C1-GeoRatingArea/state |
| 3 | ZIP_FROM | C1-GeoRatingArea/zipFrom |
| 4 | ZIP_PLUS4_FROM | C1-GeoRatingArea/zipPlus4From |
| 5 | ZIP_TO | C1-GeoRatingArea/zipTo |
| 6 | ZIP_PLUS4_TO | C1-GeoRatingArea/zipPlus4To |
| 7 | START_DT | C1-GeoRatingArea/startDate |
| 8 | END_DT | C1-GeoRatingArea/endDate |
| 9 | PLAN_NBR | C1-GeoRatingArea/0/geoRatingAreaRelatedObject/planNumber |
| 10 | HEALTH_PLAN_CD | C1-GeoRatingArea/0/geoRatingAreaRelatedObject/healthPlanCode |
| 11 | POLICY_NBR | C1-GeoRatingArea/0/geoRatingAreaRelatedObject/policyNumber |
| 12 | SOURCE_SYSTEM_CD | C1-GeoRatingArea/0/geoRatingAreaRelatedObject/sourceSystem |
| 13 | STATUS | C1-GeoRatingArea/boStatus |
In such case, you need to ensure that the sample CSV file contains records with comma-separated values in the sequence as mentioned in the above table.
Sample CSV
100,AR,15000,0,15000,10,02/02/2019,02/02/2030,45675767565,MED_PLN_01,7.87E+11,SOURCE,ACTIVERelated Topics
| For more information on... | See... |
|---|---|
| Uploading a Geographic Rating Area File in the CSV Format | Uploading a Geographic Rating Area File in the CSV Format |
| CSV File Format for Uploading Geographic Rating Areas | CSV File Format for Uploading Geographic Rating Areas |