DW_PARTY_D

This table contains details of Organization, Person, and Group party types.

Details

Module:

Key Columns

PARTY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PARTY_ID NUMBER 38 0 True Party identifier. It is used as the primary key.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier.
PARTY_NAME VARCHAR2 512 Party name.
PARTY_NUMBER VARCHAR2 32 Party number.
PARTY_UNIQUE_NAME VARCHAR2 999 Unique party name.
ORGANIZATION_PROFILE_ID NUMBER 38 0 Organization Profile Identifier
PERSON_TITLE VARCHAR2 64 Title prefixed to a person's name.
PERSON_FIRST_NAME VARCHAR2 256 First name of a person.
PERSON_MIDDLE_NAME VARCHAR2 64 Middle name of a person.
PERSON_LAST_NAME VARCHAR2 256 Last name of a person.
PERSON_NAME_SUFFIX VARCHAR2 32 Suffix added to a person's name.
PERSON_ACADEMIC_TITLE VARCHAR2 32 Academic title of a person.
PARTY_TYPE VARCHAR2 32 Party type.
GROUP_TYPE VARCHAR2 32 Group type code.
GROUP_SIZE NUMBER 38 0 Group size.
GENDER VARCHAR2 32 Gender of a person.
AVERAGE_AGE NUMBER 38 0 Average age.
MEDIAN_AGE NUMBER 38 0 Median age.
NUMBER_OF_CHILDS_0_TO_6 NUMBER 38 0 Number of children aged 0 to 6 years.
NUMBER_OF_CHILDS_7_TO_12 NUMBER 38 0 Number of children aged 7 to 12 years.
NUMBER_OF_CHILDS_13_TO_18 NUMBER 38 0 Number of children aged 13 to 18 years.
NUMBER_OF_DEPENDENTS NUMBER 38 0 Number of dependents.
ESTABLISHED_YEAR NUMBER 38 0 Year of establishment.
DECLARED_ETHNICITY VARCHAR2 64 Ethnicity declared by a person.
DATE_OF_BIRTH TIMESTAMP Date of birth.
DATE_OF_DEATH TIMESTAMP Date of death.
PLACE_OF_BIRTH VARCHAR2 64 Place of birth.
LAST_CONTACT_DATE TIMESTAMP Last contact date.
STATUS VARCHAR2 16 Account status.
CUSTOMER_CATEGORY_CODE VARCHAR2 32 Customer category code. Values are from the table DW_CUSTOMER_CATEGORY_LKP_TL with CODE_TYPE = CUSTOMER_CATEGORY. DW_CUSTOMER_CATEGORY_LKP_TL CUSTOMER_CATEGORY_LKP_CODE
CUSTOMER_SINCE_DATE TIMESTAMP Date when the party became a customer.
ORGANIZATION_TYPE_CODE VARCHAR2 64 Organization type code. Values are from the table DW_ORGANIZATION_TYPE_LKP_TL with CODE_TYPE = ORGANIZATION_TYPE. DW_ORGANIZATION_TYPE_LKP_TL ORGANIZATION_TYPE_LKP_CODE
MARITAL_STATUS VARCHAR2 32 Marital status of a person.
INTERNET_HOME_PAGE VARCHAR2 999 Home page of the organization website.
EMAIL_ADDRESS VARCHAR2 512 Email.
PRIMARY_PHONE_NUMBER VARCHAR2 64 Primary phone number.
PRIMARY_PHONE_AREA_CODE VARCHAR2 32 Primary phone area code.
PRIMARY_PHONE_COUNTRY_CODE VARCHAR2 16 Primary phone country code.
PRIMARY_PHONE_EXTENSION VARCHAR2 32 Primary phone extension.
PREFERRED_CONTACT_METHOD VARCHAR2 32 Preferred contact method.
PREFERRED_CONTACT_NAME VARCHAR2 512 Preferred contact name.
PRIMARY_RELATIONSHIP_ID NUMBER 38 0 Primary customer relationship identifier.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 16 Currency code.
CITY VARCHAR2 64 City.
COUNTY VARCHAR2 64 County.
PROVINCE VARCHAR2 64 Province.
STATE VARCHAR2 64 State.
COUNTRY VARCHAR2 16 Country.
POSTAL_CODE VARCHAR2 64 Postal code.
ADDRESS_LINE_1 VARCHAR2 256 First line of address.
ADDRESS_LINE_2 VARCHAR2 256 Second line of address.
ADDRESS_LINE_3 VARCHAR2 256 Third line of address.
ADDRESS_LINE_4 VARCHAR2 256 Fourth line of address.
ANNUAL_INCOME NUMBER Annual income.
SUPPLIER_ID NUMBER 38 0 Supplier identifier.
PARENT_SUPPLIER_ID NUMBER 38 0 Parent supplier identifier.
SUPPLIER_GROUP_CODE VARCHAR2 32 Supplier group code.
SUPPLIER_NUMBER VARCHAR2 32 Supplier number.
SUPPLIER_SINCE_DATE TIMESTAMP Date when the party became a supplier.
SUPPLIER_TYPE_CODE VARCHAR2 32 Supplier type code.
SIC_CODE VARCHAR2 32 Standard Industry Classification (SIC) code. Use combination of SIC_CODE and SIC_CODE_TYPE to lookup on table DW_PARTY_SIC_CODE_TYPE_TL. DW_PARTY_SIC_CODE_TYPE_TL SIC_CODE_TYPE,SIC_CODE
SIC_CODE_TYPE VARCHAR2 32 Standard Industry Classification (SIC) code type DW_PARTY_SIC_CODE_TYPE_TL SIC_CODE_TYPE,SIC_CODE
DNB_CREDIT_RATING VARCHAR2 16 Dun and Bradstreet rating.
DUNS_NUMBER VARCHAR2 32 D-U-N-S number of the party.
PARENT_DUNS_NUMBER VARCHAR2 32 D-U-N-S number of the parent organization. Parent is a corporation that owns more than 50% of the organization's capital stock.
GLOBAL_ULT_DUNS_NUMBER VARCHAR2 32 D-U-N-S number of the topmost entity in global organization hierarchy.
DOMESTIC_ULT_DUNS_NUMBER VARCHAR2 32 D-U-N-S number of the topmost entity in domestic organization hierarchy.
INDUSTRY_CODE VARCHAR2 64 Industry code. Values are from the table DW_INDUSTRY_LKP_TL with CODE_TYPE=SIC_CODE. DW_INDUSTRY_LKP_TL INDUSTRY_LKP_CODE
LINE_OF_BUSINESS VARCHAR2 256 Line of business.
MINORITY_GROUP_CODE VARCHAR2 32 Minority group code.
DISADV_8A_INDICATOR VARCHAR2 32 Indicates a company that is considered disadvantaged by the US government under Title 8A. Possible values are Yes or No.
OUT_OF_BUSINESS_INDICATION VARCHAR2 32 Indicates if this organization is out of business. Y for businesses that are out of business, N for active businesses.
NUMBER_OF_EMPLOYEES NUMBER Number of employees.
ORGANIZATION_SIZE VARCHAR2 32 Organizational size based on revenue, number of employees, and so on. Possible values are small, medium, large, and so on.
ANNUAL_REVENUE NUMBER Annual revenue.
REVENUE_GROWTH NUMBER Revenue growth in percentage.
SALES_ACCOUNT_SINCE_DATE TIMESTAMP Date when sales account is created.
STOCK_SYMBOL VARCHAR2 32 Stock symbol.
SALES_AFFINITY_CODE VARCHAR2 32 Sales affinity code.
SALES_BUYING_ROLE_CODE VARCHAR2 32 Sales buying role code.
WEALTH_AMOUNT NUMBER Wealth Amount.
ACTIVE_FLAG VARCHAR2 16 Indicates that the party is still active in business. Possible values are Yes or No.
CONTACT_FLAG VARCHAR2 16 Indicates the customer contact. Possible values are Yes or No.
BRANCH_FLAG VARCHAR2 16 Indicates a branch of an organization. Possible values are Yes or No.
COMPETITOR_FLAG VARCHAR2 16 Indicates a competitor. Possible values are Yes or No.
CUSTOMER_FLAG VARCHAR2 16 Indicates a customer. Possible values are Yes or No.
DISABLED_VETERAN_OWNED_FLAG VARCHAR2 16 Indicates an entity owned by a disabled veteran. Possible values are Yes or No.
HUB_ZONE_FLAG VARCHAR2 16 Indicates a business located in a HUBZone. Possible values are Yes or No.
MANUFACTURER_FLAG VARCHAR2 16 Indicates a manufacturer. Possible values are yes or No.
INTERNAL_FLAG VARCHAR2 16 Indicates an internal customer. Possible values are Yes or No.
PARTNER_FLAG VARCHAR2 16 Indicates a partner. Possible values are Yes or No.
MINORITY_OWNED_FLAG VARCHAR2 16 Indicates a minority owned business. Possible values are Yes or No.
PROSPECT_FLAG VARCHAR2 16 Indicates that the party is a prospective customer. Possible values are Yes or No.
PUBLIC_LISTING_FLAG VARCHAR2 16 Indicates the presence of a public listing. Possible values are Yes or No.
SALES_REFERENCE_FLAG VARCHAR2 16 Indicates a sales reference. Possible values are Yes or No.
SALES_ACCOUNT_FLAG VARCHAR2 16 Indicates a sales account. Possible values are Yes or No.
SMALL_BUSINESS_FLAG VARCHAR2 16 Indicates a small business. Possible values are Yes or No.
SUPPLIER_ACTIVE_FLAG VARCHAR2 16 Indicates an active supplier. Possible values are Yes or No.
SUPPLIER_FLAG VARCHAR2 16 Indicates a supplier. Possible values are Yes or No.
SUPPLIER_ONE_TIME_FLAG VARCHAR2 16 indicates that the party is a one-time supplier. Possible values are Yes or No.
SUPPRESS_CALL_FLAG VARCHAR2 16 Indicates that the party's phone number is suppressed. Possible values are Yes or No.
SUPPRESS_EMAIL_FLAG VARCHAR2 16 Indicate that the party's Email is suppressed. Possible values are Yes or No.
SUPPRESS_MAIL_FLAG VARCHAR2 16 Indicates that party's mailing address is suppressed. Possible values are Yes or No.
VETERAN_OWNED_FLAG VARCHAR2 16 Indicates a veteran owned business. Possible values are Yes or No.
WOMAN_OWNED_FLAG VARCHAR2 16 Indicates a woman owned business. Possible values are Yes or No.
DECEASED_FLAG VARCHAR2 16 Indicates a deceased person. Possible values are Yes or No.
EMPLOYEE_FLAG VARCHAR2 16 Indicates an employee. Possible values are Yes or No.
SUPPLIER_END_DATE_ACTIVE DATE Date on which the supplier became inactive
SUPPLIER_CREATION_SOURCE VARCHAR2 32 Displays the lookup code of the source from which the supplier was created. Values are derived from the table DW_SUPPLIER_SOURCE_LKP_TL with CODE_TYPE=POZ_CREATION_SOURCE. The possible values are: MANUAL, IMPORT, REGISTRATION and INTERNAL_REGISTRATION. DW_SUPPLIER_SOURCE_LKP_TL SUPPLIER_SOURCE_LKP_CODE
SUPPLIER_CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
JOB_TITLE VARCHAR2 128 Job title of the person - this is outside the context of any relationship the person may have.
JOB_TITLE_CODE VARCHAR2 32 Code given to the job title
OWNER_PARTY_ID NUMBER 38 0 The PARTY_ID of the resource designated as the owner of the Sales Profile. Foreign key to the HZ_PARTIES table.
LATITUDE NUMBER Used to store Latitude Information for the Location for Spatial Proximity and containment purposes
LONGITUDE NUMBER Used to store Longitude Information for the Location for Spatial Proximity and containment purposes
ACCOUNT_BASE_CURRENCY_CODE VARCHAR2 16 CURRENCY_CODE
ACCOUNT_CORP_CURRENCY_CODE VARCHAR2 16 CORP_CURRENCY_CODE
NEXT_FY_POTENTIAL_REVENUE NUMBER Organization's potential revenue for next fiscal year