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   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_CODE_VALUES_LKP_TL with CODE_TYPE = CUSTOMER_CATEGORY.    
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_CODE_VALUES_LKP_TL with CODE_TYPE = ORGANIZATION_TYPE.    
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_CODE_VALUES_LKP_TL with CODE_TYPE=SIC_CODE. DW_CODE_VALUES_LKP_TL 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_CODE_VALUES_LKP_TL with CODE_TYPE=POZ_CREATION_SOURCE. The possible values are: MANUAL, IMPORT, REGISTRATION and INTERNAL_REGISTRATION. DW_CODE_VALUES_LKP_TL 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    

Copyright © 2019, 2022, Oracle and/or its affiliates.