The below table presents an example of how data is mapped from "Single Online Home" to the "Standard Data Model". The scope of this table covers how a "person" is mapped.
| Single Online Home Field | Required As Field DM | Transformation | Standard Data Model Field | Type | CV Details: |
|---|---|---|---|---|---|
| insuranceCompany | Y | Direct Mapping (Target object: self) | insuranceCompany | string (1-100) | |
| insurancePolicyNumber | Y | Direct Mapping (Target object: self) | insurancePolicyNumber | string (-) | |
| nextOfKinKnown | N | Direct Mapping (Target object: self) | nextOfKinKnown | boolean (-) | |
| nextOfKinFirstName | Y | New POLE entity created value remains the same (Target object: nextOfKin) | givenName | array[string] (1-35) | |
| nextOfKinSurname | Y | New POLE entity created value remains the same (Target object: nextOfKin) | surname | string (1-35) | |
| registeredGp | Y | Direct Mapping (Target object: self) | registeredGp | string (-) | |
| title | Y | Concat with titleListOther | titleOther | string (1-35) | |
| firstName | Y | Direct Mapping | givenName | array[string] (1-35) | |
| middleName1 | Y | Concat with middleName2 | middleName | array[string] (1-35) | |
| middleName2 | Y | Concat with middleName1 | middleName | array[string] (1-35) | |
| surname | Y | Direct Mapping | surname | string (1-35) | |
| dateOfBirthKnown | Y | Direct Mapping | dateofBirthKnown | boolean (-) | |
| genderSelfDescribe | Y | Direct Mapping | genderSelfDescribe | string (-) | gender |
| personDescription | Y | Direct Mapping | personDescription | string (1-2000) | |
| ageKnown | Y | Direct Mapping | ageKnown | boolean (-) | |
| ageDetails | Y | Direct Mapping | age | number (0-200) | |
| approximateAgeString | Y | Populate approximateAgeFrom and approximateAgeTo with approximateAgeString | approximateAgeFrom | number (0-200) | |
| inVehicle | Y | Direct Mapping | inVehicle | boolean (-) | |
| approximateHeight | Y | Direct Mapping | approximateHeight | string (1-20) | |
| communicationNeeds | Y | Direct Mapping | communicationNeeds | boolean (-) | |
| communicationNeedsDescription | Y | Direct Mapping | communicationNeedsDetails | string (1-4000) | |
| connectedToAnyOneElse | N | Direct Mapping | connectedToAnyOneElse | boolean (-) | |
| contactPreferenceCv | Y | Direct Mapping | contactPreference | array[$ref] (-) | contactPreference |
| additionalCitizenship | Y | Direct Mapping | hasAdditionalCitizenship | boolean (-) | |
| ageAtTimeOfIncident | Y | Direct Mapping | ageAtTimeOfIncident | number (0-200) | |
| alias | Y | Direct Mapping | alias | string (1-40) | |
| build | Y | Direct Mapping | buildDetails | string (3-35) | |
| clothingAtTimeOfIncident | Y | Direct Mapping | clothingAtTimeOfIncident | string (1-2000) | |
| complexion | Y | Direct Mapping | complexion | $ref (-) | complexion |
| educationLocation | Y | Direct Mapping | educationLocation | string (1-2000) | |
| englishFirstLanguage | Y | Direct Mapping | englishFirstLanguage | boolean (-) | |
| englishSpeaking | Y | Direct Mapping | englishSpeaking | boolean (-) | |
| eyeColour | Y | Direct Mapping | eyeColourDetails | string (1-40) | |
| facialHair | Y | Direct Mapping | facialHair | boolean (-) | |
| facialHairTypeOtherDetails | Y | Direct Mapping | facialHairDetails | string (1-2000) | |
| fatherForename1 | Y | Concat with fatherForename2 | fatherForename | array[string] (1-35) | |
| fatherForename2 | Y | Concat with fatherForename1 | fatherForename | array[string] (1-35) | |
| fatherSurname | Y | Direct Mapping | fatherSurname | string (1-35) | |
| genderSameAsBirth | Y | Direct Mapping | genderSameAsBirth | Boolean (-) | |
| habitsMannersismsDetails | Y | Direct Mapping | habitsMannersismsDetails | string (1-2000) | |
| hairColour | Y | Concat with hairColourListOtherDetails | hairColourDetails | string (1-40) | |
| hairColourListOtherDetails | Y | Concat with hairColour | hairColourDetails | string (1-40) | |
| hairDescription | Y | Direct Mapping | hairDescription | string (1-1000) | |
| hairLength | Y | Direct Mapping | hairLength | string (1-40) | |
| hairStyleDetails | Y | Direct Mapping | hairStyleDetails | string (1-1000) | |
| heightFromCm | Y | Direct Mapping | heightFromCm | integer (-) | |
| heightToCm | Y | Direct Mapping | heightToCm | integer (-) | |
| identifyingMarks | Y | Pass information as distinguishingFeatureDetails in distinguishingFeature group | distinguishingFeatureDetails | string (1-1000) | |
| inEducation | Y | Direct Mapping | educationStatus | boolean (-) | |
| languagesSpoken | Y | Direct Mapping | languagesSpokenDetails | string (1-1000) | |
| languagesSpokenList | Y | Direct Mapping | languagesSpoken | array[$ref] (-) | language |
| motherForename1 | Y | Concat with motherForename2 | motherForename | array[string] (1-35) | |
| motherForename2 | Y | Concat with motherForename1 | motherForename | array[string] (1-35) | |
| motherSurname | Y | Direct Mapping | motherSurname | string (1-35) | |
| nationalInsuranceNumber | Y | Direct Mapping | nationalInsuranceNumber | string (9-9) | |
| nationality | Y | Direct Mapping | nationalityDetails | string (1-100) | |
| occupation | Y | Direct Mapping | occupation | string (1-200) | |
| personNotes | Y | Direct Mapping | personNotes | string (1-2000) | |
| physicalCharacteristics | Y | Direct Mapping | physicalCharacteristics | string (1-2000) | |
| religion | Y | Direct Mapping | religionOther | string (1-40) | |
| religionListOther | Y | Concat with religion | religionOther | string (1-40) | |
| surnameUnknown | N | Direct Mapping | surnameUnknown | boolean (-) | |
| titleListOther | Y | Concat with title | titleOther | string (1-35) | |
| unavailabilityDetail | Y | Direct Mapping | unavailabilityDetails | string (1-2000) | |
| usualClothing | Y | Direct Mapping | usualClothing | string (1-2000) | |
| victimSuspectRelationship | Y | Direct Mapping | victimRelationshipToSuspectDetails | string (1-100) | |
| willingToAttendCourt | Y | Direct Mapping | willingToAttendCourt | boolean (-) | |
| workStartTime | Y | Direct Mapping | workStartTimeDetails | string (1-100) | |
| workEndTime | Y | Direct Mapping | workEndTimeDetails | string (1-100) | |
| distinguishingFeature | Y | Direct Mapping | distinguishingFeature | $ref (-) | distinguishingFeature |
| alcoholDependency | Y | Direct Mapping | alcoholDependency | boolean (-) | |
| alcoholDependencyDetails | Y | Direct Mapping | alcoholDependencyDetails | string (1-1000) | |
| disability | Y | Direct Mapping | disability | boolean (-) | |
| disabilityCategoriesCv | Y | Direct Mapping | disabilityCategory | array[string] (-) | disabilityCategory |
| disabilityCategoriesOther | Y | Direct Mapping | disabilityDetails | string (1-4000) | |
| drugOrSubstanceDependency | Y | Direct Mapping | drugOrSubstanceDependency | boolean (-) | |
| drugOrSubstanceDependencyDetails | Y | Direct Mapping | drugOrSubstanceDependencyDetails | string (1-1000) | |
| riskDueToUnsuitableAttire | Y | Direct Mapping | riskDueToUnsuitableAttire | boolean (-) | |
| riskDueToUnsuitableAttireDetails | Y | Direct Mapping | riskDueToUnsuitableAttireDetails | string (1-2000) | |
| riskOfAllegedSexualOffending | Y | Direct Mapping | riskOfAllegedSexualOffending | boolean (-) | |
| riskOfAllegedSexualOffendingDetails | Y | Direct Mapping | riskOfAllegedSexualOffendingDetails | string (1-2000) | |
| riskOfBeingBullied | Y | Direct Mapping | riskOfBeingBullied | boolean (-) | |
| riskOfBeingBulliedDetails | Y | Direct Mapping | riskOfBeingBulliedDetails | string (1-2000) | |
| riskOfBeingPhysicallyHarmed | Y | Direct Mapping | riskOfBeingPhysicallyHarmed | boolean (-) | |
| riskOfBeingPhysicallyHarmedDetails | Y | Direct Mapping | riskOfBeingPhysicallyHarmedDetails | string (1-2000) | |
| riskOfBeingVictimOfSexualExploitation | Y | Direct Mapping | riskOfBeingVictimOfSexualExploitation | boolean (-) | |
| riskOfBeingVictimOfSexualExploitationDetails | Y | Direct Mapping | riskOfBeingVictimOfSexualExploitationDetails | string (1-2000) | |
| riskOfBeingUnableToLookAfterThemselves | Y | Direct Mapping | riskOfBeingUnableToLookAfterThemselves | boolean (-) | |
| riskOfBeingUnableToLookAfterThemselvesDetails | Y | Direct Mapping | riskOfBeingUnableToLookAfterThemselvesDetails | string (1-2000) | |
| riskOfBeingVictimOfDomesticAbuse | Y | Direct Mapping | riskOfBeingVictimOfDomesticAbuse | boolean (-) | |
| riskOfBeingVictimOfDomesticAbuseDetails | Y | Direct Mapping | riskOfBeingVictimOfDomesticAbuseDetails | string (1-2000) | |
| riskOfCommittingDomesticAbuse | Y | Direct Mapping | riskOfCommittingDomesticAbuse | boolean (-) | |
| riskOfCommittingDomesticAbuseDetails | Y | Direct Mapping | riskOfCommittingDomesticAbuseDetails | string (-) | |
| knownMentalDisability | Y | Direct Mapping | knownMentalDisability | boolean (-) | |
| mentalDisabilityDetails | Y | Direct Mapping | mentalDisabilityDetails | string (1-4000) | |
| knownMentalHealthIssues | Y | Direct Mapping | knownMentalHealthIssues | boolean (-) | |
| knownMentalHealthIssuesDetails | Y | Direct Mapping | knownMentalHealthIssuesDetails | string (1-4000) | |
| riskOfSelfHarm | Y | Direct Mapping | riskOfSelfHarm | boolean (-) | |
| riskOfSelfHarmDetails | Y | Direct Mapping | riskOfSelfHarmDetails | string (1-2000) | |
| riskOfViolentBehaviour | Y | Direct Mapping | riskOfViolentBehaviour | boolean (-) | |
| riskOfViolentBehaviourDetails | Y | Direct Mapping | riskOfViolentBehaviourDetails | string (1-2000) | |
| welfareRisk | Y | Direct Mapping | welfareRisk | boolean (-) | |
| welfareRiskDetails | Y | Direct Mapping | welfareRiskDetails | string (1-4000) | |
| previousCrimeExperienced | Y | Direct Mapping | previousCrimeExperienced | boolean (-) | |
| previousCrimeExperiencedDetail | Y | Direct Mapping | previousCrimeExperiencedDetails | string (1-4000) | |
| onMedication | Y | Direct Mapping | onMedication | boolean (-) | |
| onMedicationDetails | Y | Direct Mapping | onMedicationDetails | string (1-1000) | |
| outcomeOfMissedMedication | Y | Direct Mapping | outcomeOfMissedMedication | string (1-4000) | |
| knownAllergies | Y | Direct Mapping | knownAllergies | boolean (-) | |
| knownAllergiesDetail | Y | Direct Mapping | knownAllergiesDetail | string (1-4000) | |
| restrainingOrder | Y | Direct Mapping | restrainingOrder | boolean (-) | |
| restrainingOrderDetails | Y | Direct Mapping | restrainingOrderDetails | string (1-2000) | |
| personUnder18 | Y | Direct Mapping (Event related field on person) | under18 | boolean (-) | |
| contactGuardian | Y | Direct Mapping | contactGuardian | boolean (-) | |
| guardianDetails | Y | New POLE entity created value remains the same (Points to separate POLE entity) | _PersonFields | (-) | |
| ethnicityAsianOther | Y | Direct Mapping | ethnicitySelfDefinedDetails | string (1-200) | |
| ethnicityBlackOther | Y | Direct Mapping | ethnicitySelfDefinedDetails | string (1-200) | |
| ethnicityMixedOther | Y | Direct Mapping | ethnicitySelfDefinedDetails | string (1-200) | |
| ethnicityWhiteOther | Y | Direct Mapping | ethnicitySelfDefinedDetails | string (1-200) | |
| ethnicityAnotherOther | Y | Direct Mapping | ethnicitySelfDefinedDetails | string (1-200) | |
| known | Y | New POLE entity created value remains the same (Points to separate POLE entity) | _PersonFields | (-) | |
| unknown | Y | New POLE entity created value remains the same (Points to separate POLE entity) | _PersonFields | (-) | |
| victimSupport | Y | Direct Mapping | victimSupport | boolean (-) | |
| victimSupportWitness | Y | Direct Mapping | victimSupportWitness | boolean (-) | |
| victimKnown | Y | Direct Mapping | victimKnown | boolean (-) | |
| victimAwareReported | Y | Direct Mapping | victimAwareReported | boolean (-) | |
| connectedToWho | N | New POLE entity created value remains the same | _PersonFields | (-) | |
| connectedHow | N | New POLE entity created value remains the same | _PersonFields | (-) | |
| connectionToVictim | Y | New POLE entity created value remains the same (Link reason between victim) | _PersonFields | (-) | |
| relationshipToVictimOtherDetails | Y | New POLE entity created value remains the same (Link reason between victim) | _PersonFields | (-) | |
| unavailableDates | Y | Direct Mapping | attendanceUnavailableDates | string (1-1000) | |
| attendanceRequirements | Y | Direct Mapping | attendanceRequirements | string (1-1000) | |
| independentWitness | Y | Direct Mapping | independentWitness | boolean (-) | |
| independentWitnessDetails | Y | Direct Mapping | independentWitnessDetails | string (1-1000) | |
| witnessNeeds | Y | Direct Mapping | witnessNeeds | boolean (-) | |
| witnessNeedsDetails | Y | Direct Mapping | witnessNeedsDetails | string (1-2000) | |
| vulnerableWitness | Y | Direct Mapping | vulnerableWitness | boolean (-) | |
| vulnerableWitnessDetails | Y | Direct Mapping | vulnerableWitnessDetails | string (1-2000) | |
| witnessConsent | Y | Direct Mapping | witnessConsent | boolean (-) | |
| connections | Y | New POLE entity created value remains the same | _PersonFields | (-) | |
| witness | N | New POLE entity created value remains the same (Witness links) | _PersonFields | (-) | |
| distinguishingFeatureAdditionalDetail | Y | Direct Mapping | distinguishingFeatureDetails | string (1-1000) | |
| dateOfBirth | Y | Direct Mapping | dateOfBirth | string (Date) (10-10) | |
| genderCv | Y | Direct Mapping | gender | $ref (-) | gender |
| ageRangeOcrCv | Y | Merge into single field ageRange (Target object: self) | ageRange | $ref (-) | ageRange |
| ageRangeChildCv | Y | Merge into single field ageRange (Target object: self) | ageRange | $ref (-) | ageRange |
| ageRangeAdultCv | Y | Merge into single field ageRange (Target object: self) | ageRange | $ref (-) | ageRange |
| ageRangeMispersCv | Y | Merge into single field ageRange (Target object: self) | ageRange | $ref (-) | ageRange |
| accentCv | Y | Direct Mapping | accent | $ref (-) | accent |
| additionalCitizenshipListCv | Y | Direct Mapping | additionalCitizenship | $ref (-) | nationality |
| buildListCv | Y | Direct Mapping | build | $ref (-) | buildList |
| countryOfBirthCv | Y | Direct Mapping | placeOfBirth | $ref (-) | country |
| employmentStatusCv | Y | Direct Mapping | employmentStatus | $ref (-) | employmentStatus |
| englishFluencyCv | Y | Direct Mapping | englishFluency | $ref (-) | englishFluency |
| eyeColourListCv | Y | Maps into eyeColourLeft & eyeColourRight based on value | eyeColourLeft | $ref (-) | eyeColour |
| eyeColourListLeftCv | Y | Direct Mapping | eyeColourLeft | $ref (-) | eyeColour |
| eyeColourListRightCv | Y | Direct Mapping | eyeColourRight | $ref (-) | eyeColour |
| eyewearCv | Y | Direct Mapping | eyewear | $ref (-) | eyewear |
| facialHairTypeCv | Y | Direct Mapping | facialHairType | $ref (-) | facialHairType |
| hairColourListCv | Y | Direct Mapping | hairColourList | $ref (-) | hairColourList |
| hairStyleListCv | Y | Direct Mapping | hairStyle | $ref (-) | hairStyleList |
| handednessCv | Y | Direct Mapping | handedness | $ref (-) | handedness |
| maritalStatusCv | Y | Direct Mapping | maritalStatus | $ref (-) | maritalStatus |
| nationalityAcquisitionMethodCv | Y | Direct Mapping | nationalityAcquisitionMethod | $ref (-) | nationalityAcquisitionMethod |
| nationalityListCv | Y | Direct Mapping | nationality | $ref (-) | nationality |
| preferredLanguageSpokenListCv | Y | Direct Mapping | preferredLanguageSpoken | $ref (-) | language |
| preferredLanguageWrittenListCv | Y | Direct Mapping | preferredLanguageWritten | $ref (-) | language |
| previousNationalityListCv | Y | Direct Mapping | previousNationality | $ref (-) | nationality |
| religionListCv | Y | Direct Mapping | religion | $ref (-) | religionList |
| speechDescriptionListCv | Y | Direct Mapping | speechDescription | $ref (-) | speechDescriptionList |
| titleListCv | Y | Direct Mapping | title | $ref (-) | titleList |
| victimSuspectRelationshipListCv | Y | Direct Mapping | victimRelationshipToSuspect | $ref (-) | personToPersonRelationships |
| workStartTimeClock | Y | Direct Mapping | workStartTime | string (Time) (1-100) | |
| workEndTimeClock | Y | Direct Mapping | workEndTime | string (Time) (1-100) | |
| ethnicityCv | Y | Direct Mapping | ethnicityGroup | $ref (-) | ethnicityGroup |
| ethnicityAsianCv | Y | Direct Mapping | ethnicitySelfDefined | $ref (-) | ethnicitySelfDefined |
| ethnicityBlackCv | Y | Direct Mapping | ethnicitySelfDefined | $ref (-) | ethnicitySelfDefined |
| ethnicityMixedCv | Y | Direct Mapping | ethnicitySelfDefined | $ref (-) | ethnicitySelfDefined |
| ethnicityWhiteCv | Y | Direct Mapping | ethnicitySelfDefined | $ref (-) | ethnicitySelfDefined |
| ethnicityAnotherCv | Y | Direct Mapping | ethnicitySelfDefined | $ref (-) | ethnicitySelfDefined |
| suspectKnownCv | Y | Direct Mapping | suspectKnown | $ref (-) | suspectKnown |
| relationshipToVictimCv | Y | New POLE entity created value remains the same (Link reason between victim) | _PersonFields | (-) | |
| distinguishingFeatureTypeCv | Y | Direct Mapping | distinguishingFeatureType | $ref (-) | distinguishingFeatureType |
| distinguishingFeatureLocationCv | Y | Direct Mapping | distinguishingFeatureLocation | $ref (-) | distinguishingFeatureLocation |