MDM Extension for Data 360 > Predefined MDM Extension for Data 360 assets > Data mappings
  

Data mappings

Data mappings define how fields in a data lake object (DLO) correspond to fields in a data model object (DMO). Data 360 uses these mappings to route and transform data from DLO fields to their corresponding DMO fields.
When you integrate Customer 360 SaaS with Data 360, data streams populate the DLO from the Customer 360 SaaS. These mappings connect Customer 360 SaaS fields to their target Data 360 DMO fields.
The following table shows how Customer 360 SaaS business entities map to Data 360 data model objects:
Customer 360 SaaS Business Entity
Data 360 Data Model Object Name
Organization
Account
Person
Individual

Mapping of Organization business entity and Data 360 DMO fields

The fields in the Organization business entity are mapped to the target fields in Data 360 data model object (DMO).

General fields of the Organization business entity

The following table lists the General fields that are mapped to Data 360 DMOs:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Name
name
Account Name
Number of Employees
numberOfEmployees
Employee Count
Date of Incorporation
dateOfIncorporation
Date of Incorporation
Industry
industry
Primary Industry
Website
website
Website
Country of Incorporation
countryOfIncorporation
Country of Incorporation
State of Incorporation
stateOfIncorporation
State of Incorporation
Company Logo
imageUrl
Company Logo
Company Type
companyType
Company Type

Address field group of the Organization business entity

The following table lists the fields in the Address field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Address Type
address Type
Contact Point Type
Usage Type
usage Type
Usage Type
Address Status
address Status
Is Active
Address Line 1
address Line 1
Address Line 1
Address Line 2
address Line 2
Address Line 2
Address Line 3
address Line 3
Address Line 3
Country
country
Country
State
state
State Province
City
city
City
County
county
County
Postal Code
postal Code
Postal Code
PostalCode Extension
postalCode Extension
PostalCode Extension
Coordinate System
coordinateSystem
Coordinate System
Location Coordinate Desc
locationCoordinateDesc
Location Coordinate Desc
Start Date
Start Date
Active From Date
End Date
End Date
Active To Date
Latitude
Latitude
Geo Latitude
Longitude
Longitude
Geo Longitude
Enriched Indicator
enriched Indicator
Enriched Indicator
Verification Status Code
statusCode
Verification Status Code
Verification Message
statusMessage
Verification Message
Elevation
elevation
Elevation

Alternate Name field group of the Organization business entity

The following table lists the fields in the Alternate Name field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Name Type
alternateNameType
Name Type
Alternate Name
AlternateName
Alternate Name
Effective Start Date
effectiveStartDate
Effective Start Date
Effective End Date
effectiveEndDate
Effective End Date

Email field group of the Organization business entity

The following table lists the fields in the Email field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Usage Type
usageType
Usage Type
Electronic Address
electronicAddress
Email Address
Electronic Address Status
electronicAddressStatus
Is Active
Effective Start Date
effectiveStartDate
Active From Date
Effective End Date
effectiveEndDate
Active To Date
Net Protect Code
netProtectCode
Net Protect Code
Verification Status Code
validationStatusCode
Is Verified
Verification Message
validationMessage
Verification Message
Hygiene Status
hygieneStatus
Hygiene Status
Enriched Indicator
enrichedIndicator
Enriched Indicator

Financial field group of the Organization business entity

The following table lists the fields in the Financial field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Currency
currency
Currency
Unit
unit
Unit
Finance Reliability
financeReliability
Finance Reliability
Time Period
timePeriod
Time Period
Time Period Type
timePeriodType
Time Period Type
Finance Info Type
financeInfoType
Finance Info Type
Amount
amount
Amount

Identification field group of the Organization business entity

The following table lists the fields in the Identification field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Identification Type
alternateIdentifierType
Identification Name
Identification Value
alternateIdentifierValue
Identification number
Issuing Authority
issuingAuthority
Issued By Authority
Status
identifierStatus
Status
Effective Start Date
effectiveStartDate
Issued Date
Effective End Date
effectiveEndDate
Expiry Date

Indicator field group of the Organization business entity

The following table lists the fields in the Indicator field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Indicator Type
indicatorType
Indicator Type
Indicator Value
value
Indicator Value

Key People field group of the Organization business entity

The following table lists the fields in the Key People field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Name
name
Name
Executive Type
executiveType
Executive Type
Designation
designation
Designation

Phone field group of the Organization business entity

The following table lists the fields in the Phone field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Do Not Call Indicator
doNotCallIndicator
Do Not Call Indicator
Phone Usage Type
phoneUsageType
Usage Type
Phone Type
phoneType
Contact Point Type
Phone Number
phoneNumber
Phone number
Phone Number Extension
phoneNumberExtension
Extension number
Prefix Number
prefixNumber
Prefix Number
International Prefix
internationalPrefix
International Prefix
National Prefix
nationalPrefix
National Prefix
Cell Prefix
cellPrefix
Cell Prefix
Effective Start Date
effectiveStartDate
Active From Date
Effective End Date
effectiveEndDate
Active To Date
National Destination Code
nationalDestinationCode
National Destination Code
National Destination Code Indicator
nationalDestinationCodeIndicator
National Destination Code Indicator
National Format
nationalFormat
Formatted National Phone number
International Format
internationalFormat
Formatted International Phone number
ISO
iso
ISO
Verification Status Code
validationStatusCode
Verification Status Code
Enriched Indicator
enrichedIndicator
Enriched Indicator
Verification Message
validationMessage
Verification Message
Status
status
Is Active

Social Media field group of the Organization business entity

The following table lists the fields in the Social Media field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Social Media Handle
socialMediaHandle
Social Handle ID
Social Media Type
socialHandleType
Social Network Provider

Status field group of the Organization business entity

The following table lists the fields in the Status field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Status Type
statusType
Status Type
Status Value
statusValue
Status Value

Stock field group of the Organization business entity

The following table lists the fields in the Stock field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Stock Exchange
stockExchangeName
Stock Exchange
Ticker Symbol
tickerSymbol
Ticker Symbol
Country
country
Country

Tax Details field group of the Organization business entity

The following table lists the fields in the Tax Details field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Tax Number Type
taxNumberType
Tax Number Type
Tax Number
taxNumber
Tax Number
Tax Authority
taxAuthority
Tax Authority
Tax Paid
taxPaid
Tax Paid
Taxpayer Type
taxPayerType
Taxpayer Type
Currency
currency
Currency
Country
country
Country
State
state
State
Effective Start Date
effectiveStartDate
Effective Start Date
Effective End Date
effectiveEndDate
Effective End Date

Mapping of Person business entity and Data 360 DMO

The fields in the Person business entity are mapped to the target fields in Data 360 data model object (DMO).

General fields of the Person business entity

The following table lists the General fields that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
First Name
first Name
First Name
Middle Name
middle Name
Middle Name
Last Name
last Name
Last Name
Full Name
full Name
Person Name
Prefix Name
prefix Name
Prefix Name
Suffix Name
suffix Name
Name Suffix
Title
title
Title
Designation
designation
Designation
Birth Place
birth Place
Birth Place
Birth Date
birth date
Birth Date
Gender
gender
Gender
Image
imageUrl
Photo URL
Marital Status
marital Status
Marital Status

Address field group of the Person business entity

The following table lists the fields in the Address field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Address Type
address Type
Contact Point Type
Usage Type
usage Type
Usage Type
Address Status
address Status
Is Active
Address Line 1
address Line 1
Address Line 1
Address Line 2
address Line 2
Address Line 2
Address Line 3
address Line 3
Address Line 3
Country
country
Country
State
state
State Province
City
city
City
County
county
County
Postal Code
postal Code
Postal Code
PostalCode Extension
postalCode Extension
PostalCode Extension
Coordinate System
coordinateSystem
Coordinate System
Location Coordinate Desc
locationCoordinateDesc
Location Coordinate Desc
Start Date
Start Date
Active From Date
End Date
End Date
Active To Date
Latitude
Latitude
Geo Latitude
Longitude
Longitude
Geo Longitude
Enriched Indicator
enriched Indicator
Enriched Indicator
Verification Status Code
statusCode
Verification Status Code
Verification Message
statusMessage
Verification Message
Elevation
elevation
Elevation

Alternate Name field group of the Person business entity

The following table lists the fields in the Alternate Name field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Name Type
alternateNameType
Name Usage Type
Alternate Name
AlternateName
Full Name
Effective Start Date
effectiveStartDate
Begin Effective Date
Effective End Date
effectiveEndDate
End Effective Date

Citizenship field group of the Person business entity

The following table lists the fields in the Citizenship field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Citizen of Country
citizenOfCountry
Citizen of Country
Citizenship Status
citizenshipStatus
Citizenship Status
Supporting Document Name
supportingDocumentName
Supporting Document Name
Effective Start Date
effectiveStartDate
Effective Start Date
Effective End Date
effectiveEndDate
Effective End Date

Demographics field group of the Person business entity

The following table lists the fields in the Demographics field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Demographic Type
demographicType
Demographic Type
Demographic Value
demographicValue
Demographic Value

Education field group of the Person business entity

The following table lists the fields in the Education field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Qualification Type
qualificationType
Education Level
Qualification Name
qualificationName
Education Name
Qualification Status
qualificationStatus
Comment
Institution Name
institutionName
Institution Name
Student Number
studentNumber
Identifier
Effective Start Date
effectiveStartDate
Valid From Date
Effective End Date
effectiveEndDate
Valid To Date
Address Line 1
addressLine1
Address Line 1
Address Line 2
addressLine2
Address Line 2
Country
country
Country
State
state
State
City
city
City
Postal Code
postalCode
Postal Code
Postal Code Extension
postalCodeExtension
Postal Code Extension

Education field group of the Person business entity

The following table lists the fields in the Education field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Qualification Type
qualificationType
Education Level
Qualification Name
qualificationName
Education Name
Qualification Status
qualificationStatus
Comment
Institution Name
institutionName
Institution Name
Student Number
studentNumber
Identifier
Effective Start Date
effectiveStartDate
Valid From Date
Effective End Date
effectiveEndDate
Valid To Date
Address Line 1
addressLine1
Address Line 1
Address Line 2
addressLine2
Address Line 2
Country
country
Country
State
state
State
City
city
City
Postal Code
postalCode
Postal Code
Postal Code Extension
postalCodeExtension
Postal Code Extension

Email field group of the Person business entity

The following table lists the fields in the Email field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Usage Type
usageType
Usage Type
Electronic Address
electronicAddress
Email Address
Electronic Address Status
electronicAddressStatus
Is Active
Effective Start Date
effectiveStartDate
Active From Date
Effective End Date
effectiveEndDate
Active To Date
Net Protect Code
netProtectCode
Net Protect Code
Verification Status Code
validationStatusCode
Is Verified
Verification Message
validationMessage
Verification Message
Hygiene Status
hygieneStatus
Hygiene Status
Enriched Indicator
enrichedIndicator
Enriched Indicator

Employment field group of the Person business entity

The following table lists the fields in the Employment field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Designation
designation
Position Text
Employer Name
employerName
Employer Name
Location
location
Location
Employment Type
employmentType
Employment Type
Employment Status
employmentStatus
Employment Status
Line of Business
lineOfBusiness
Line of Business
Effective Start Date
effectiveStartDate
Start Date
Effective End Date
effectiveEndDate
End Date

Financial field group of the Person business entity

The following table lists the fields in the Financial field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Currency
currency
Currency
Unit
unit
Unit
Finance Reliability
financeReliability
Finance Reliability
Time Period
timePeriod
Time Period
Time Period Type
timePeriodType
Time Period Type
Finance Info Type
financeInfoType
Finance Info Type
Amount
amount
Amount

Identification field group of the Person business entity

The following table lists the fields in the Identification field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Identification Type
alternateIdentifierType
Identification Name
Identification Value
alternateIdentifierValue
Identification number
Issuing Authority
issuingAuthority
Issued By Authority
Status
identifierStatus
Status
Effective Start Date
effectiveStartDate
Issued Date
Effective End Date
effectiveEndDate
Expiry Date

Lifestyle field group of the Person business entity

The following table lists the fields in the Lifestyle field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Lifestyle Type
lifestyleType
Lifestyle Type
Lifestyle Value
lifestyleValue
Lifestyle Value

Phone field group of the Person business entity

The following table lists the fields in the Phone field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Default Indicator
defaultIndicator
Default Indicator
Do Not Call Indicator
doNotCallIndicator
Do Not Call Indicator
Phone Usage Type
phoneUsageType
Usage Type
Phone Type
phoneType
Contact Point Type
Phone Number
phoneNumber
Phone number
Phone Number Extension
phoneNumberExtension
Extension number
Prefix Number
prefixNumber
Prefix Number
International Prefix
internationalPrefix
International Prefix
National Prefix
nationalPrefix
National Prefix
Cell Prefix
cellPrefix
Cell Prefix
Effective Start Date
effectiveStartDate
Active From Date
Effective End Date
effectiveEndDate
Active To Date
National Destination Code
nationalDestinationCode
National Destination Code
National Destination Code Indicator
nationalDestinationCodeIndicator
National Destination Code Indicator
National Format
nationalFormat
Formatted National Phone number
International Format
internationalFormat
Formatted International Phone number
ISO
iso
ISO
Verification Status Code
validationStatusCode
Verification Status Code
Enriched Indicator
enrichedIndicator
Enriched Indicator
Verification Message
validationMessage
Verification Message
Status
status
Is Active

Social Media field group of the Person business entity

The following table lists the fields in the Social Media field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Social Media Handle
socialMediaHandle
Social Handle ID
Social Media Type
socialHandleType
Social Network Provider

Specialization field group of the Person business entity

The following table lists the fields in the Specialization field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Specialty Type
specialtyType
Specialty Type
Specialty
speciality
Specialty
Board Certification Flag
boardCertificationFlag
Board Certification Flag

Status field group of the Person business entity

The following table lists the fields in the Status field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Status Type
statusType
Status Type
Status Value
statusValue
Status Value

Tax Details field group of the Person business entity

The following table lists the fields in the Tax Details field group that are mapped to Data 360 DMO fields:
Customer 360 Display Name
Customer 360 Internal ID
Data 360 DMO Field Name
Tax Number Type
taxNumberType
Tax Number Type
Tax Number
taxNumber
Tax Number
Tax Authority
taxAuthority
Tax Authority
Tax Paid
taxPaid
Tax Paid
Taxpayer Type
taxPayerType
Taxpayer Type
Currency
currency
Currency
Country
country
Country
State
state
State
Effective Start Date
effectiveStartDate
Effective Start Date
Effective End Date
effectiveEndDate
Effective End Date