# 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 |  |

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