KeyOrganizationCustomerCompositeSegment

Entity Definition

Logical Name : KeyOrganizationCustomerCompositeSegment
Physical Name : CO_KY_ORGN_CMPST_SGMT

A composite key customer segment that references composite business demographic characteristics of an organization.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
OrganizationSegmentID (PK) Token ID for a named collection of organizations ID_KY_ORGN_CMPST_SGMT Identity integer
CustomerID (FK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer KeyCustomer(PA_KY_CT)
GlobalBusinessSizeTypeCode (FK) A code that designates the relative GLOBAL size of an Organization. CD_GBL_BSN_TYP Code varchar(20) GlobalBusinessSizeType(LU_GBL_BSN_TYP)
LegalOrgnizationTypeCode (FK) Defines the type of legal organization the Organization is using to conduct business. The code values will vary by country and JurisdictionOfIncorporation. Here are some examples: SOLE_PROPRIETOR PARTNERSHIP LIMITED_PARTNERSHIP S-CORPORATION C-CORPORATION LIMITED_LIAB_COMPANY OTHER CD_LGL_ORGN_TYP Code varchar(20) LegalOrganizationType(LU_LGL_ORGN)
LegalStatusCode (FK) A code that indicates the ORGANIZATION's legal or tax status. For example, this may be Commercial Corporation, Not-for-profit, Non-profit, Academic, Government, etc. CD_LGL_STS Code varchar(20) LegalStatusType(LU_LGL_STS)
BusinessActivityCode (FK) An abbreviated alpha numeric code that defines a category of business activity. In the US this code would be the NAICS (North American Industry ClassificationSystem) which is a numeric system. In ARTS we have generalized the structure so reatilers around the world may adopt different national standards for classifying business activity. CD_BSN_ACTV Code varchar(20) BusinessActivityReference(LU_BSN_ACTV_RFC)
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
ReligionType characterizes KeyOrganizationCustomerCompositeSegment
BusinessActivityReference characterizes KeyOrganizationCustomerCompositeSegment
LegalStatusType characterizes KeyOrganizationCustomerCompositeSegment
LegalOrganizationType characterizes KeyOrganizationCustomerCompositeSegment
GlobalBusinessSizeType characterizes KeyOrganizationCustomerCompositeSegment
KeyCustomer is classified by KeyOrganizationCustomerCompositeSegment

Logical Views containing KeyOrganizationCustomerCompositeSegment

Logical View
Logical 07030 - Customer Segment Independent Characteristics