Individual Customer in ESG data model

Traits

Traits for this entity are listed here.

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"4.3"	string	semantic version number of the entity

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Base entity from which all ESG Data Model entities are derived. en An 'individual customer' is one of the two types of customers upon which the Microsoft data models focus. 'Legal entity customer' is the other. The definition of 'customer' is of critical importance for every organization. It's the customer that is the focus of product planning, marketing, sales, service, reporting and analytics. Without 'customer' there would be no need for the organization to exist since its purpose is to serve the customer and profit from that interaction. The definition of 'customer' must be consistent with how customers exist and interact with the organization in the real world. An artificial or conceptual definition of 'customer' that is not consistent with these two objectives is doomed to fail because the data will not be consistent with the definition and employees will not accept concepts or terms that aren't consistent with what they see, know and how they interact with customers on a working basis. Microsoft defines 'customer' to meet these objectives. When we look out into the real world we see two dominant types of customers: human beings ('individual customers') and legal entities ('legal entity customers')> Individual customers are human beings, male and female individuals, of various ages, sex, demographics and a variety of similar dimensions that describe and define those who purchase products, good and services. Legal entities are those legally-defined entities such as corporations, partnerships, non-profit organizations, government organizations etc. that purchase products, goods and services. This view of 'customer' is consistent with the real world and consistent with how employees view and interact with customers. Of course, that is just the start of identifying, defining and understanding each corresponding type of 'customer'. There's a great deal of detail, complexity and related data that can be used to define each type of customer to various levels of detail and different dimensions of information. Microsoft implements these detailed concepts and related data via two distinct business area models that expand the coverage and complexity of each type of customer: INDIVIDUAL CUSTOMER Business Area Model LEGAL ENTITY CUSTOMER Business Area Model Note: Each of the Microsoft models - enterprise, business area or data warehouse - have a representative level of detail for the appropriate type of customer, which is a 'subset' of the total data available in the associated INDIVIDUAL CUSTOMER or LEGAL ENTITY CUSTOMER business area models.. Reference either of those models to expand the coverage or level of detail in each respective data model. The actual customer implemented in each model depends upon the dominant use of customer for that industry. For example, in the pharmaceutical industry the customer is a legal entity, which represents another corporation, company, government organization etc. that purchases the pharmaceutical product and then distributes that product to the end-customer, which is an individual in a retail environment or a government-distribution scheme. For this example, the pharmaceutical models will have the legal entity customer represented but not the individual 'end customer' since that is represented in the appropriate retail industry models, which are a different offering. Of course, the entire set of data available for a legal entity customer is contained in the associated LEGAL ENTITY CUSTOMER Business Area Model. Reference the LEGAL ENTITY CUSTOMER Business Area Model to incorporate more data that may be of relevance. In many industries both types of customers are represented since a legal entity or individual can purchase products, goods or services and enter into contracts. For these industries, both types of customers are represented by some of the more significant or relevant data derived from the associated LEGAL ENTITY or INDIVIDUAL CUSTOMER business area models. These models can be used to expand the scope or level of detail in any of the enterprise, business area or data warehouse models.	entity	a reference to the constant entity holding the list of localized text

minimumObjectModelVersion
Minimum version of the object model required to fully understand the data schema used.

Parameter	Value	Data type	Explanation
versionNumber	"1.2.3"	string

is.IDM.modelVersion
Semantic version number of the IDM.

Parameter	Value	Data type	Explanation
versionNumber	"2.0.0"	string

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{0B837303-29E9-42B9-B164-9BEFE1C6D66F}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nativeTo.businessArea
The name of the business area from which the entity originates.

Parameter	Value	Data type	Explanation
name	"Customer"	string

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Individual Customer	entity	a reference to the constant entity holding the list of localized text

has.entitySchemaAbstractionLevel
A level of abstraction assigned to an Entity schema. Logical schema descriptions use complex dataTypes, inheritance, and entities as attributes. Resolved descriptions contain none of those things, only final trait and attribute sets are shown. A composition schema manipulates, guides, or restates parts of logical schemas to produce one resolved schema.

Parameter	Value	Data type	Explanation
level	"resolved"	string	Possible values: logical, composition, resolved

Attributes

Name	Description	First Included in Instance
CustomerId	The unique identifier of a Customer.	Sustainability/esg-data-model/IndividualCustomer
IndividualCustomerName	The name of the Individual Customer.	Sustainability/esg-data-model/IndividualCustomer
IndividualCustomerPhoneticName	The phonetic name shows the pronunciation of the Individual Customer Name using the international phonetic alphabet, which uses special signs to represent the different sounds made by the voice in speech.	Sustainability/esg-data-model/IndividualCustomer
DateOfBirth	The date of birth of the individual customer.	Sustainability/esg-data-model/IndividualCustomer
DateOfDeath	The date of death of the individual customer.	Sustainability/esg-data-model/IndividualCustomer
SexId	The unique identifier of a Sex.	Sustainability/esg-data-model/IndividualCustomer
GenderId	The unique identifier of a Gender.	Sustainability/esg-data-model/IndividualCustomer
EthnicCategoryId	The unique identifier of an Ethnic Category.	Sustainability/esg-data-model/IndividualCustomer
RacialCategoryId	The unique identifier of a Racial Category.	Sustainability/esg-data-model/IndividualCustomer

CustomerId

The unique identifier of a Customer. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Customer ID
description	The unique identifier of a Customer.
isPrimaryKey	true
dataFormat	int64

Traits

List of traits for the CustomerId attribute are listed here.

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.identifiedBy
names a specific identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	IndividualCustomer/(resolvedAttributes)/CustomerId	attribute

is.linkedEntity.identifier
Marks the attributes that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference Customer.cdm.json/Customer CustomerId	entity	a reference to the constant entity holding the list of entity references

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Customer ID	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The unique identifier of a Customer.	entity	a reference to the constant entity holding the list of localized text

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{0A62D879-DAD1-4E9D-A015-F7DB975C28C4}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

IndividualCustomerName

The name of the Individual Customer. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Individual Customer Name
description	The name of the Individual Customer.
dataFormat	string
maximumLength	256
isNullable	true

Traits

List of traits for the IndividualCustomerName attribute are listed here.

is.dataFormat.character
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{1B2FD1CA-EF54-48FD-ADA6-2AF75464FDDC}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Individual Customer Name	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The name of the Individual Customer.	entity	a reference to the constant entity holding the list of localized text

is.constrained
maximum length or value constraints

Parameter	Value	Data type	Explanation
maximumLength	"256"	integer

is.dataFormat.character
is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

IndividualCustomerPhoneticName

The phonetic name shows the pronunciation of the Individual Customer Name using the international phonetic alphabet, which uses special signs to represent the different sounds made by the voice in speech. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Individual Customer Phonetic Name
description	The phonetic name shows the pronunciation of the Individual Customer Name using the international phonetic alphabet, which uses special signs to represent the different sounds made by the voice in speech.
dataFormat	string
maximumLength	256
isNullable	true

Traits

List of traits for the IndividualCustomerPhoneticName attribute are listed here.

is.dataFormat.character
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{1934B0E5-F9A1-4BEE-BF59-E8F654F20375}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Individual Customer Phonetic Name	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The phonetic name shows the pronunciation of the Individual Customer Name using the international phonetic alphabet, which uses special signs to represent the different sounds made by the voice in speech.	entity	a reference to the constant entity holding the list of localized text

is.constrained
maximum length or value constraints

Parameter	Value	Data type	Explanation
maximumLength	"256"	integer

is.dataFormat.character
is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

DateOfBirth

The date of birth of the individual customer. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Date Of Birth
description	The date of birth of the individual customer.
dataFormat	date
isNullable	true

Traits

List of traits for the DateOfBirth attribute are listed here.

is.dataFormat.date
means.measurement.date
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{0DAF6323-8A2B-44BC-8667-D7F90DA7B6A7}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Date Of Birth	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The date of birth of the individual customer.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

DateOfDeath

The date of death of the individual customer. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Date Of Death
description	The date of death of the individual customer.
dataFormat	date
isNullable	true

Traits

List of traits for the DateOfDeath attribute are listed here.

is.dataFormat.date
means.measurement.date
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{282B7CD9-905D-4EF3-BA06-FD1026DA458E}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Date Of Death	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The date of death of the individual customer.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

SexId

The unique identifier of a Sex. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Sex ID
description	The unique identifier of a Sex.
dataFormat	int32
isNullable	true

Traits

List of traits for the SexId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{09C446A0-C078-4851-B188-464B4DC72FC3}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Sex ID	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The unique identifier of a Sex.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

GenderId

The unique identifier of a Gender. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Gender ID
description	The unique identifier of a Gender.
dataFormat	int32
isNullable	true

Traits

List of traits for the GenderId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{0665FCB1-0DF5-4E46-98B6-2E8CED476617}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Gender ID	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The unique identifier of a Gender.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

EthnicCategoryId

The unique identifier of an Ethnic Category. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Ethnic Category ID
description	The unique identifier of an Ethnic Category.
dataFormat	int32
isNullable	true

Traits

List of traits for the EthnicCategoryId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{0483A0D1-DFBF-44C9-B9C1-063BE0D96163}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Ethnic Category ID	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The unique identifier of an Ethnic Category.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

RacialCategoryId

The unique identifier of a Racial Category. First included in: Sustainability/esg-data-model/IndividualCustomer (this entity)

Properties

Name	Value
displayName	Racial Category ID
description	The unique identifier of a Racial Category.
dataFormat	int32
isNullable	true

Traits

List of traits for the RacialCategoryId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

Parameter	Value	Data type	Explanation
identifier	"{17267FC6-3C01-4BC3-959B-4196548394FE}"	string	The identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Racial Category ID	entity	a reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en The unique identifier of a Racial Category.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer