Person

Entity Definition

Logical Name : Person
Physical Name : PA_PRS

A sub-type of party that represents an individual of interest to the retail store or retail enterprise.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PersonPartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY_PRS Identity integer
LanguageID (FK) A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. ID_LGE Code4External char(4) Language(CO_LGE)
Salutation Extra words that don't form part of the person's name but are normally printed before the FirstName as a courtesy title. For instance, Mr. Ms., Miss, Dr., Prof. etc. This represents the primary salutation for this Person. NM_PRS_SLN Name varchar(40)
FirstName A person's first name. In western cultures, this is the given name, in other cultures it may be the family name. This represents a person's most current first name. FN_PRS Name varchar(40)
FirstNameType A code denoting what kind of name the FirstName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic TY_NM_FS Code2 char(2)
MiddleNames One or more middle names, that are printed between the person's first and last names. This represents a person's most current first name. MD_PRS Name varchar(40)
MiddleNameType A code denoting what kind of name the MiddleName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic TY_NM_MID Code2 char(2)
LastName A person's last name. In western cultures, this is the family (or patronymic) name, in other cultures it may be the given name. This represents a person's most current first name. LN_PRS Name varchar(40)
LastNameType A code denoting what kind of name the LastName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic TY_NM_LS Code2 char(2)
Suffix Extra words that don't form part of the person's name but are normally printed after the LastName to help identify the person. Example values include, Sr, Jr, III This represents a person's primary Suffix. NM_PRS_SFX Name varchar(40)
GenderTypeCode A code for specifying a persons gender. TY_GND_PRS Code2 char(2)
SortingName A culturally sensitive version of the person's name that is used when producing a sorted list of names. Examples: Jones, W S McGrigor, S F Tryggvi, T NM_PRS_SR Name varchar(40)
MailingName A culturally sensitive version of the person's name that is used when contacting them Examples: Bill Jones, Stuey McGrigor Tryggvi Thordarson NM_PRS_ML Name varchar(40)
OfficialName A culturally sensitive version of the person's name that is used for all legal documents. Examples: William Stephen Jones Stuart Fergus McGrigor Tryggvi Magnus Thordarson NM_PRS_OFCL Name varchar(40)
DateOfBirth Year, month, and day a Person was born on. DC_PRS_BRT DateCalendar date
AnnualIncomeRangeCode (FK) A customer's annual salary or income. CD_ANN_INCM_RNGE Code varchar(20) AnnualIncomeRange(LU_ANN_INCM_RNGE)
MaritalStatusCode (FK) A code that describes a CUSTOMER's current marital status. For instance, married, single, etc. CD_MRTL_STS Code varchar(20) MaritalStatus(LU_MRTL_STS)
RaceCode (FK) Retailer determined code for indicating a Person's race. CD_RC Code varchar(20) RaceType(LU_RC_TYP)
PersonalityTypeCode (FK) A retailer assigned value that assigns a personality named pattern of behavior to a Person. This plays a role in segmentation Sample Values: COMPULSIVE AUTHORITARIAN GREGARIOUS AMBITIOUS INTROVERTED CD_PRSNLTY_TYP Code varchar(20) PersonalityType(LU_PRSNLTY_TYP)
LifestyleTypeCode (FK) Retailer assigned code that assigns a Person to a named lifestyle pattern. This is used for segmentation purposes. Samples include: LONGHAIRS MODERN FASHIONERS RELIGIOUS_STYLE WORKAHOLIC CD_LFSTYL_TYP Code varchar(20) LifestyleTypeCode(LU_LFSTYL_TYP)
PersonalValueTypeCode (FK) A retailer assigned value that assigns a named pattern of personal values to a Person. This plays a role in segmentation. Sample values include: FAMILY_ORIENTED MATERIALISTIC SPIRITUALISTIC IDEALISTIC CD_PRSL_VL_TYP Code varchar(20) PersonalValueType(LU_PRSL_VL_TYP)
OccupationTypeCode (FK) A retailer assigned code that assigns a Person to an occupation category. This is used in demographic CD_OCCPTN_TYP Code varchar(20) OccupationType(LU_OCCPTN_TYP)
ConsumerCreditScore The credit rating assigned by an independent credit rating service like Fair Isaac, Transunion or Experian in the US CD_CNS_CR_SCOR Code varchar(20)
ConsumerCreditRatingServiceName The name of the ConsumerCreditScore provider. NM_CNS_CR_RTG_SV Name varchar(40)
LifeStageCode (FK) Defines the current family situation of a Person based on characterized composition of family, member ages, and marital status. Examples: Single No Child The primary head of household is single, divorced, separated, or widowed and is younger than 45 years of age. The household supports no dependent children, and the household is not a retired household. Married No Child The primary head of household is married and is younger than 45 years of age. The household supports no dependent children, and the household is not a retired household. Oldest Child 0–11 The household supports at least one dependent child age 11 or younger. It supports no dependent children 12 years of age or older. Oldest Child 12–17 The household supports at least one dependent child between the ages of 12 and 17 years of age. It supports no dependent children age 18 years or older. Oldest Child 18 or Older The household supports at least one dependent child 18 years of age or older. Preretired The primary head of household is 45 years of age or older. The household supports no dependent children, and the household is not a retired household. Younger Retired The primary head of household is 70 years of age or younger. The household supports no dependent children, and the household is a retired household. Older Retired The primary head of household is 70 years of age or older. The household supports no dependent children, and the household is a retired household. CD_LF_STG Code varchar(20) LifeStageType(LU_LF_STG_TYP)
EthnicityTypeCode (FK) Indicates the cultural background of a Person. This is different from race in that it tells about a mixture of language, culture separate from a person's race. Examples include: Hispanic Han Chinese Persian West European East European Retailers should define codes that are relevant to their business. CD_ETHNC_TYP Code varchar(20) EthnicType(LU_ETHNC_TYP)
EducationLevelCode (FK) Designates a level of education completed by a party.. Examples include: ELEMENTARY MIDDLE _SCHOOL HIGH_SCHOOL TWO_YEARS_COLLEGE FOUR_YEAR_COLLEGE TWO_YEAR_GRAD FOUR_YEAR_GRAD POST_GRAD CD_EDC_LV Code varchar(20) EducationLevel(LU_EDC_LV)
EmploymentStatusCode (FK) A code that defines the employment condition of a person. This code is used in segementing customers. Sample values include: STUDENT UNEMPLOYED PART_TIME_UNDEREMPLOYED EMPLOYED SEMI_RETIRED RETIRED CD_EMPLMT_STS Code varchar(20) EmploymentStatusType(LU_EMPLMT_STS_TYP)
ValueAttitudeLifestyleTypeCode (FK) Code used to characterize a consuer/customer value-attitude-lifestyle. Sample VALS values include: INNOVATORS – The class of consumer at the top of the vals framework. They are characterized by High income and high resource individuals for whom independence is very important. They have their own individual taste in things and are motivated in achieving the finer things in life. THINKERS – A well educated professional is an excellent example of Thinkers in the vals framework. These are the people who have high resources and are motivated by their knowledge. These are the rational decision making consumers and are well informed about their surroundings. These consumers are likely to accept any social change because of their knowledge level. BELIEVERS – The subtle difference between thinkers and believers is that thinkers make their own decisions whereas believers are more social in nature and hence also believe other consumers. They are characterized by lower resources and are less likely to accept innovation on their own. They are the best class of word of mouth consumers. ACHIEVERS – The achievers are mainly motivated by – guess what – Achievements. These individuals want to excel at their job as well in their family. Thus they are more likely to purchase a brand which has shown its success over time. The achievers are said to be high resource consumers but at the same time, if any brand is rising, they are more likely to adopt that brand faster. STRIVERS – Low resource consumer group which wants to reach some achievement are known as strivers. These customers do not have the resources to be an achiever. But as they have values similar to an achiever, they fall under the striver category. If a striver can gain the necessary resources such as a high income or social status then he can move on to becoming an achiever. EXPERIENCERS – The group of consumers who have high resources but also need a mode of self expression are known as Experiencers. Mostly characterized by young adults, it consists of people who want to experience being different. This class of consumers is filled up with early adopters who spend heavily on food, clothing and other youthful products and services. MAKERS – These are consumers who also want self expression but they are limited by the number of resources they have. Thus they would be more focused towards building a better family rather than going out and actually spending higher amount of money. Making themselves into better individuals and families becomes a form of self expression for the Makers. SURIVORS – The class of consumers in the Vals framework with the least resources and therefore the least likely to adopt any innovation. As they are not likely to change their course of action regularly, they form into brand loyal customers. An example can include old age pension earners living alone for whom the basic necessities are important and they are least likely to concentrate on anything else. CD_VL_ATTD_LFSTL Code varchar(20) ValueAttitudeLifestyleType(LU_VL_ATTD_LFSTL)
DietaryHabitTypeCode (FK) Code that identifies a particular dietary habit. CD_DTRY_HBT_TYP Code varchar(20) DietaryHabitType(LU_DTRY_HBT)
DisabilityImpairmentTypeCode (FK) Identifies a retailer specified disability or impairment. CD_DSBLTY_IMPRMNT_TYP Code varchar(20) DisabilityImpairmentType(LU_DSBLTY_IMPRMNT)
ReligionName (FK) Name of religion sect within a religion family. 1 Abrahamic religions 1.1 Babism 1.2 Bahá'í Faith 1.3 Christianity 1.3.1 Other groups 1.4 Druze 1.5 Gnosticism 1.6 Islam 1.7 Judaism 1.8 Rastafari movement 1.9 Mandaeans and Sabians 1.10 Samaritanism 1.11 Shabakism 2 Indian religions 2.1 Ayyavazhi 2.2 Bhakti movement 2.3 Buddhism 2.4 Din-i-Ilahi 2.5 Hinduism 2.6 Jainism 2.7 Meivazhi 2.8 Sikhism 3 Iranian religions 3.1 Manichaeism 3.2 Mazdakism 3.3 Mithraism 3.4 Yazdânism 3.5 Zoroastrianism 4 East Asian religions 4.1 Confucianism 4.2 Shinto 4.3 Taoism 4.4 Other 5 African diasporic religions 6 Indigenous traditional religions 6.1 African 6.2 American 6.3 Eurasian 6.4 Oceania/Pacific 6.4.1 Cargo cults 7 Historical polytheism 7.1 Ancient Near Eastern 7.2 Indo-European 7.3 Hellenistic 8 Mysticism and Occult 8.1 Esotericism and mysticism 8.2 Occult and magic 9 Neopaganism 9.1 Syncretic 9.2 Ethnic 10 New religious movements 10.1 Creativity 10.2 New Thought 10.3 Shinshukyo 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others NM_RLGN Code varchar(20) ReligionType(LU_RLGN_TYP)
ReligionFamilyCode (FK) Abrahamic religions 2 Indian religions 3 Iranian religions 4 East Asian religions 5 African diasporic religions 6 Indigenous traditional religions 7 Historical polytheism 8 Mysticism and Occult 9 Neopaganism 10 New religious movements 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others CD_RLGN_FMY Code varchar(20) ReligionType(LU_RLGN_TYP)

Relationships

Parent Entity Verb Phrase Child Entity
RaceType defines Person
DisabilityImpairmentType defines Person
EducationLevel defines Person
DietaryHabitType defines Person
PersonalValueType defines Person
ReligionType describes Person
EthnicType defines Person
ValueAttitudeLifestyleType defines Person
LifeStageType defines Person
OccupationType defines Person
Language is preferred by Person
MaritalStatus defines Person
AnnualIncomeRange defines Person
EmploymentStatusType defines Person
LifestyleTypeCode defines Person
PersonalityType defines Person
Person is physiologically described by BiometricInformationRecord
Person is known by PersonName
Person is addressed by PersonSalutation
Person engages in PersonActivityInterest
Person is described by PersonAttibuteValue
Person uses PersonNameSuffix
Party can be a Person

Logical Views containing Person

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 05050 - Taxation - Registration and Certification View
Logical 06310 - Party - Role View
Logical 06315 - Party - Person Names View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 06600 - Language Support
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07020 - Enterprise Anonymous Customer
Logical 07030 - Customer Segment Independent Characteristics
Logical 07042 - Customer Wallet Share
Logical 11100 - Worker - Macro View