InsureFlow
/
Settings

Executive Overview

Field Mapping Studio

Configure mappings from AL3 and ACORD XML to canonical model

Total Mappings

247

Direct Maps

182

Transforms

48

Unmapped

12

Conflicts

5

Source Schemas
AL3 Fields
POL-NUMdirect
INSURED-NAMEdirect
EFF-DATEtransform
COMM-RATEtransform
VEHICLE-SECTIONderived
CLAIM-INDICATORmissing
ACORD XML Fields
GivenNamedirect
VehIdentificationNumberdirect
CoverageCdtransform
PolicyNumberconflict
Mapping Rules
AL3Direct Map
POL-NUMpolicy.id
AL3Direct Map
INSURED-NAMEapplicant.name
AL3Transformed
EFF-DATEpolicy.effectiveDate
transform: parseDate(AL3_DATE_FORMAT)
AL3Transformed
COMM-RATEaccounting.commissions.rate
transform: toPercentage()
ACORD XMLDirect Map
GivenNameapplicant.firstName
ACORD XMLDirect Map
VehIdentificationNumberexposures.vehicles[].vin
ACORD XMLTransformed
CoverageCdcoverages[].code
transform: mapCoverageCode(ACORD_COVERAGE_MAP)
AL3Derived
VEHICLE-SECTIONexposures.vehicles[]
transform: parseVehicleSegment()
AL3Missing
CLAIM-INDICATORunmapped
ACORD XMLConflict
PolicyNumberpolicy.id
Conflicts with MAP-001
Canonical Model

Canonical model entities and fields

applicant
.name.firstName.lastName.dob.ssn.email.phone
household
.type.members[].primaryLocation
locations
.address.city.state.zip.type.occupancy
vehicles
.vin.year.make.model.usage.annualMiles
drivers
.name.dob.license.violations[].accidents[]
policy
.id.effectiveDate.expirationDate.status.carrier
coverages
.code.limit.deductible.premium
accounting
.commissions.rate.commissions.amount.fees[].payments[]

AI Mapping Assistant

12 unmapped fields detected. AI can suggest mappings based on field names and data patterns.