Organization

Entity Definition

Logical Name : Organization
Physical Name : PA_ORGN

A company, association, institution, or other enterprise of interest to a retail store or retail enterprise. Note that because this is a RETAIL view of customer organizations is is more limited than a wholesale or manufacturing view of trading partner. This treatment of Organization is not and should not be used as a substitute for B2B trading partner information.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY Identity integer
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)
LegalName The name used by an organization for legal purposes. Usually designates the formal name of an organization that conducts business under a different "doin business as" or trade name. Different alias for the same party. NM_LGL Name varchar(40)
TradeName The name underwhich this organization conducts its business. It may different from its LegalName. NM_TRD Name varchar(40)
TerminationDate Date this organization ceased to operate and was closed for business. DC_TRMN ExpirationDate date
JurisdictionOfIncorporation The name of the territory, state, province or other political subdivision that authorized the incorporation of the Organization. NM_JRDT_OF_INCRP DescriptionShort varchar(255)
IncorporationDate Date this Organization was legally incorporated. This is different from the StartUpDate. Incorporation may occurr before or after a StartUpDate. DC_INCRP DateCalendar date
LegalOrganizationTypeCode (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)
FiscalYearEndDate The date (month and day) this organizations fiscal year ends on. Note that for certain kinds of businesses this can accelerate buying as managers seek to use or lose their spendable budgets. DC_FSC_YR_END DateCalendar date
BusinessActivityCode (FK) A code that identifies the primary type of business the Organzation is engaged in. The coding schema varies from country to country. In the US the UC Census NAICS codes are used. This may be used to indicate the categories of merchandise a given Organization is likely to purchase. CD_BSN_ACTV Code varchar(20) BusinessActivityReference(LU_BSN_ACTV_RFC)
LocalAnnualRevenueAmount Total revenue earned by the organization in the "local" market. Local as used here means the country or next level political subdivison. It' primary use is to distinguish sales volume of a local part of a global or national company from the over all aggregated revenue. MO_LCL_ANN_RVN Money decimal(16,5)
GlobalAnnualRevenueAmount The total revenue for a global or national company. MO_GBL_ANN_RVN Money decimal(16,5)
OpenForBusinessDate The date the Organization opened. DC_OPN_FR_BSN DateCalendar date
ClosedForBusinessDate The date the Organization ceased operating. DC_CLSD_FR_BSN DateCalendar date
DUNSNumber The D&B D-U-N-S Number is a non-indicative, nine-digit number assigned to each business location in the D&B database having a unique, separate, and distinct operation, and is maintained solely by D&B. The D&B D-U-N-S Number is used by industries and organizations around the world as a global standard for business identification and tracking. If you don`t have a D-U-N-S Number, you can get one for free through the SBS site. ID_DUNS_NBR IdentityDunsIdentifier char(9)
BankruptcyFlag A boolean indicator that tell if this Organization has ever experienced bankruptcy or not. This indicator is set to true even if the organization is NOT CURRENTLY bankrupt but has experience bankruptcy in its past. FL_BNKRPTY Flag integer
BankruptcyDate The date the organization declared bankruptcy DC_BNKRPTY DateCalendar date
BankruptcyEmergenceDate The date the Organization emerged from bankruptcy DC_BNKRPTY_EMRGNC DateCalendar date
BankruptcyTypeCode A retailer defined code that tells what kind of bankruptcy proceeding the Organization went through. Examples based on US bankruptcy laws include: CHAPTER_7 - Liquidation CHAPTER_9 - Municipal Bankrupcty (applies only to public bodies) CHAPTER 11 - Reorganization under bankruptcy code CHAPTER 12 - Family Farmer Bankruptcy or family Fisherman Bankruptcy CHAPTER 13 - Individual debit adjustment (applicable to sole proprietors and partners) CHAPTER 15 - Ancillary and other cross Border cases CD_BNKRPTY_TYP Code varchar(20)
EmployeeCountLocal Number of employees locally (in the country, state or municipality). The intepretation of "local" is up to the retailer based on their approach to defining market areas. QU_EM_CNT_LCL QuantityInteger integer
EmployeeCountGlobal Total number of employees for the Organization as a whole. QU_EM_CNT_GBL QuantityInteger integer
DunnAndBradstreetRating A code that indicates the size and credit worthiness of the Organization. The code value is determined by Dunn and Bradstreet. CD_RTG_DUNN_AND_BRDST Code varchar(20)
PrimaryBusiness (FK) A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. ID_LGE_PRMRY Code4External char(4) Language(CO_LGE)
OrganizationDescriptionNarrative Short narrative description of the organization to capture retailer defined unstructured information about an organization. NA_DE_ORGN DescriptionNarrative varchar(4000)
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)
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
GlobalBusinessSizeType validates Organization
ReligionType describes Organization
LegalOrganizationType validates Organization
Language is preferred by Organization
LegalStatusType validates Organization
BusinessActivityReference validates Organization
Organization is described by OrganizationAttributeValue
Organization administers TaxJurisdictionExternalIdentification
Organization issues TaxCertificate
Organization administers TaxRegionExternalIdentification
Party can be a Organization
Organization can be a TaxExemptOrganization

Logical Views containing Organization

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 05050 - Taxation - Registration and Certification View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07020 - Enterprise Anonymous Customer
Logical 07030 - Customer Segment Independent Characteristics
Logical 07042 - Customer Wallet Share