FINS CoreLogic System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| properties-get-building-characteristics-response | Property Building Characteristics Retrieve Mapping for CoreLogic System |
| properties-get-risks-response | Property Risks Retrieve Mapping for CoreLogic System |
properties-get-building-characteristics-response
Property Building Characteristics Retrieve Mapping for CoreLogic System
Source:
./src/main/resources/dwl/properties-get-building-characteristics-response.dwl
Mapping Tables
Maps CoreLogic Property Building Characteristics to Response format
| Response Object | CoreLogic System Field | Description |
|---|---|---|
| yearBuilt | yrBuilt | Year the property was built |
| assessedValue | assessedValueLandAndImprovements | Total combined value of the assessed land and improvements of the property |
| assessmentYear | assessmentYear | Year of the tax assessment for the property |
| pricePerSquareFoot | pricePerSquareFoot | Sale price of the property in terms of dollar amount per square foot of living area or lot area if no building is present |
| replacementCost | marketValue | Assessed value based on appraisal or market conditions |
| buildingClass | buildingClass | Identifies a county specific building group |
| heatingType | heatingTypeDescription | Type or method of heating |
| exteriorWallType | exteriorWalls | Type of exterior walls for the structure |
| floorType | floorType | Type of floor covering |
| foundationMaterialType | foundationMaterial | The type of foundation material |
| foundationSize | foundationSF | The square footage of foundation |
| garageSize | garageSF | Total garage square feet |
| grossLivingAreaSize | grossLivingAreaSF | Total living area square footage including unfinished areas |
| livingAreaSize | livingArea | Square footage of building |
| bathrooms | baths | Number of bathrooms in building |
| bedrooms | bedrooms | Number of bedrooms in building |
| atticType | atticTypeDescription | Attic type |
| basementType | basementType | Type of basement found in the building |
| basementDescription | basementDescription | Description of basement |
| basementFinishedSize | basementSF | Square Footage of basement |
| hasFireplace | hasFireplace | Identifies the existence of a fireplace(s) (Y or N) |
| fireplaceDescription | fireplaceDescription | The type of fireplace |
| roofType | roofType | Roof type description |
| roofMaterial | roofMaterial | Type of roof material |
| roofAge | null | No mapping |
| roofAgeCalculationMethod | null | No mapping |
| roofAgeConfidence | null | No mapping |
properties-get-risks-response
Property Risks Retrieve Mapping for CoreLogic System
Source:
./src/main/resources/dwl/properties-get-risks-response.dwl
Mapping Tables
Maps CoreLogic Property Crime Risk Score, Earthquake Risk Score, Flood Risk Score and Hail Risk to Response format
| Response Field | CoreLogic System Field | Description | |
|---|---|---|---|
| crimeRisks.propertyCrimeIndex | propertyCrimeIndex | Property crime index where20 is National Average | |
| crimeRisks.violentCrimeIndex | violentCrimeIndex | Violent crime index where20 is National Average | |
| crimeRisks.burglaryIndex | propertyCrimeDetail.burglaryIndex | Burglary index where20 is National Average | |
| crimeRisks.larcenyIndex | propertyCrimeDetail.larcenyIndex | Larceny index where20 is National Average | |
| crimeRisks.assultIndex | violentCrimeDetailassultIndex | Assult index where20 is National Average | |
| crimeRisks.murderIndex | violentCrimeDetailmurderIndex | Homicide index where20 is National Average | |
| crimeRisks.rapeIndex | violentCrimeDetail.rapeIndex | Sexual assault index where20 is National Average | |
| crimeRisks.robberyIndex | violentCrimeDetail.robberyIndex | Robbery index where20 is National Average | |
| earthquakeRisks.riskScore | RiskScore | Earthquake Risk Score based on a sliding scale from 0-100 | |
| earthquakeRisks.riskDescription | RiskDescription | Earthquake Risk Description from No Data to Very High | |
| earthquakeRisks.mmiValue | MMIValue | Value representing MMI | where 1 indicates the least severe earthquake and 10 the most severe |
| earthquakeRisks.damageDescription | MMIDescriptionOfDamage | Description of damage to structures based on the MMI Value | |
| earthquakeRisks.shakingDescription | MMIDescriptionOfShaking | Description of shaking based on the MMI Value | |
| earthquakeRisks.peakGroundAccelerationValue | PeakGroundAccelerationRiskPercent | The Spectral Acceleration risk provided as a percent | |
| earthquakeRisks.peakGroundAccelerationDescription | PeakGroundAccelerationRiskDescription | Description of the Spectral Acceleration | |
| floodRisks.riskRating | riskRating | Flood Risk Score rating from Very Low to Extreme | |
| floodRisks.riskScore | riskScore | Flood Risk Score based on a sliding scale from 10-100 | |
| floodRisks.floodZone | floodZone | Flood zone based on current FEMA Flood Insurance Rate Map (FIRM) | |
| floodRisks.oneHundredYearFloodDistance | distanceOneHundredYearFloodPlainFeet | Distance in feet between the property and the boundary of the 100-year flood zone located in the same catchment or subwatershed | |
| floodRisks.oneHundredYearFloodNote | floodRiskScoreDetail.distanceOneHundredYearFloodPlainNote | Note provided in absence of a distance | |
| floodRisks.fiveHundredYearFloodDistance | distanceFiveHundredYearFloodPlainFeet | Distance in feet between the property and the boundary of the 500-year flood zone | |
| floodRisks.fiveHundredYearFloodNote | floodRiskScoreDetail.distanceFiveHundredYearFloodPlainNote | Note provided in absence of a distance | |
| hailRisks.riskScore | riskScore | Risk score from 1-100 based on 1.0" or greater hail stones impacting property location. | |
| hailRisks.riskRating | riskRating | Risk rating based on 1.0" hail stones impacting property location from Very Low to Extreme | |
| hailRisks.annual075Probability | 075AnnualProbability | Annual probability of 0.75" hail | |
| hailRisks.annual10Probability | 10AnnualProbability | Annual probability of 1.00" hail | |
| hailRisks.annual15Probability | 15AnnualProbability | Annual probability of 1.5" hail | |
| hailRisks.commercialClaims.claimScore | clHailClaimScore | Hail claim risk score based on a sliding scale from 1-100 identifying risk of a hail claim relative to state hail risk | |
| hailRisks.commercialClaims.claimRating | clHailClaimRating | Claim risk rating based on score from Very Low to Extreme | |
| hailRisks.commercialClaims.claimFrequency | clHailClaimFrequency | Probability of a hail claim within 5-year policy term for property location | |
| hailRisks.commercialClaims.averageAnnualLoss | clAvgAnnualLoss | Annual average loss |