HZ_PARTIES_
The HZ_PARTIES table stores basic information about parties. Although a record in the HZ_PARTIES table represents a unique party, multiple parties can have the same name. The parties can be one of three types: Organization(for example, Oracle Corporation), Person(for example, Jane Doe), Group(for example, World Wide Web Consortium) Party reocrds can be created or updated using third party data sources such as Dun & Bradstreet's Global Data Products. The HZ_PARTIES table contains denormalized information from the HZ_LOCATIONS, HZ_PERSON_PROFILES, HZ_CONTACT_POINTS< HZ_ORGANIZATION_PROFILES< and HZ_PERSON_LANGUAGE tables. The identifying address contained in the HZ_PARTIES table is denormalized from the HZ_LOCATIONS table
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
HZ_PARTIES_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTY_ID | NUMBER | 18 | Yes | Party identifier | |
| PARTY_NUMBER | VARCHAR2 | 30 | Unique identification number for this party | ||
| PARTY_NAME | VARCHAR2 | 360 | Name of this party | ||
| PARTY_TYPE | VARCHAR2 | 30 | The party type can only be Person, Organization, Group. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| PARTY_UNIQUE_NAME | VARCHAR2 | 900 | This is the derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, this is concatenation of person_name and suffix. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| URL | VARCHAR2 | 2000 | Uniform resource locator | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Customer identifier from foreign system. May not be unique. | ||
| SIC_CODE | VARCHAR2 | 30 | Standard Industry Classification (SIC) code | ||
| ANALYSIS_FY | VARCHAR2 | 5 | Fiscal year that financial information is based on | ||
| FISCAL_YEAREND_MONTH | VARCHAR2 | 30 | Month in which fiscal year ends for organization | ||
| YEAR_ESTABLISHED | NUMBER | 4 | Year that the organization began doing business | ||
| GSA_INDICATOR_FLAG | VARCHAR2 | 1 | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | ||
| JGZZ_FISCAL_CODE | VARCHAR2 | 20 | Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe | ||
| MISSION_STATEMENT | VARCHAR2 | 2000 | Corporate charter of organization | ||
| VALIDATED_FLAG | VARCHAR2 | 1 | Indicates if the party was validated. Y for a validated party, N for a party that is not validated. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue this fiscal year | |||
| NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year | |||
| PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | 30 | Salutary introduction, such as Mr. or Herr | ||
| PERSON_FIRST_NAME | VARCHAR2 | 150 | First name of the person | ||
| PERSON_MIDDLE_NAME | VARCHAR2 | 60 | Middle name of the person | ||
| PERSON_LAST_NAME | VARCHAR2 | 150 | Last or surname of the person | ||
| PERSON_NAME_SUFFIX | VARCHAR2 | 30 | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | ||
| PERSON_TITLE | VARCHAR2 | 60 | A professional or family title. For example, Don or The Right Honorable. | ||
| PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | 150 | Previous last or surname of the person | ||
| MARITAL_STATUS | VARCHAR2 | 30 | Denormalization of the MARITAL_STATUS in HZ_PERSON_PROFILES | ||
| GROUP_TYPE | VARCHAR2 | 30 | Lookup for group type | ||
| HQ_BRANCH_IND | VARCHAR2 | 30 | Status of this site. Identifies if the location is the headquarters, a branch, or a single location. | ||
| PERSON_ACADEMIC_TITLE | VARCHAR2 | 30 | Academic title that is part of a person's name, such as Dr. John Smith. | ||
| COUNTRY | VARCHAR2 | 2 | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | ||
| ADDRESS1 | VARCHAR2 | 240 | First line of the Identifying address | ||
| ADDRESS2 | VARCHAR2 | 240 | Second line of the Identifying address | ||
| ADDRESS3 | VARCHAR2 | 240 | Third line of the Identifying address | ||
| ADDRESS4 | VARCHAR2 | 240 | Fourth line of the Identifying address | ||
| CITY | VARCHAR2 | 60 | City of the Identifying address | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal Code of the Identifying address | ||
| STATE | VARCHAR2 | 60 | State of the Identifying address | ||
| PROVINCE | VARCHAR2 | 60 | Province of the Identifying address | ||
| STATUS | VARCHAR2 | 1 | Party status flag. | ||
| COUNTY | VARCHAR2 | 60 | County of the Identifying address | ||
| SIC_CODE_TYPE | VARCHAR2 | 30 | Version of Standard Industry Classification (SIC) code | ||
| EMAIL_ADDRESS | VARCHAR2 | 320 | E-mail address | ||
| EMPLOYEES_TOTAL | NUMBER | Total number of employees | |||
| LANGUAGE_NAME | VARCHAR2 | 30 | Standard name for a language | ||
| CATEGORY_CODE | VARCHAR2 | 30 | User-definable category. Lookup type is CUSTOMER_CATEGORY | ||
| THIRD_PARTY_FLAG | VARCHAR2 | 1 | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. | ||
| SALUTATION | VARCHAR2 | 60 | Phrase used to address a party in any correspondence. | ||
| DUNS_NUMBER_C | VARCHAR2 | 30 | DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CREATED_BY_MODULE | VARCHAR2 | 30 | TCA Who column | ||
| CERTIFICATION_LEVEL | VARCHAR2 | 30 | Certification level an organization party. HZ_PARTY_CERT_LEVEL lookup type | ||
| CERT_REASON_CODE | VARCHAR2 | 30 | Reason for organization party's current certification level assignment. HZ_PARTY_CERT_REASON lookup type | ||
| PRIMARY_PHONE_CONTACT_PT_ID | NUMBER | 18 | Unique identifier of this contact point | ||
| PRIMARY_PHONE_PURPOSE | VARCHAR2 | 30 | Contact point type, such as business or personal | ||
| PRIMARY_PHONE_LINE_TYPE | VARCHAR2 | 30 | Lookup code for the type of phone line. For example, general, fax, inbound or outbound | ||
| PRIMARY_PHONE_COUNTRY_CODE | VARCHAR2 | 10 | International country code for a telephone number. For example, 33 for France | ||
| PRIMARY_PHONE_AREA_CODE | VARCHAR2 | 20 | The area code within a country code | ||
| PRIMARY_PHONE_NUMBER | VARCHAR2 | 40 | A telephone number formatted in local format. The number should not include country code, area code, or extension | ||
| PRIMARY_PHONE_EXTENSION | VARCHAR2 | 20 | Additional number addressed after initial connection to an internal telephone system | ||
| PREFERRED_CONTACT_METHOD | VARCHAR2 | 30 | How a person or organization prefers to be contacted. Validated against lookup HZ_PREFERRED_CONTACT_METHOD. | ||
| HOME_COUNTRY | VARCHAR2 | 2 | Home Country of the organization if the partyis an organization | ||
| PREFERRED_NAME_ID | NUMBER | 18 | Foreign Key to HZ_ADDTNL_PARTY_NAMES.PARTY_NAME_ID. If not NULL contains the ID of the overall Preferred Name for the Party. If NULL the Profile Name (i.e. the name contained in the profile) will be used as overall Preferred name. By default the value is NULL | ||
| PREFERRED_NAME | VARCHAR2 | 360 | Denormalization of the PARTY_NAME field in the HZ_ADDTNL_PARTY_NAMES row identified by PREFERRED_NAME_ID. | ||
| PERSON_LAST_NAME_PREFIX | VARCHAR2 | 30 | Used to capture the Last name prefix (e.g. 'fon', 'van', etc.) for a person. It is used in the same way the new field PERSON_LAST_NAME_PREFIX in HZ_PERSON_PROFILES is used. Corresponds to the field Last Name Prefix in HL7. | ||
| PERSON_SECOND_LAST_NAME | VARCHAR2 | 150 | Used to capture the second last name for a person. In some cultures it is not uncommon to have double last name. It is used in the same way the new field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used. | ||
| PREFERRED_CONTACT_PERSON_ID | NUMBER | 18 | Person PARTY_ID of a preferred contact for a given party. There should be a valid relationship. | ||
| TRADING_PARTNER_IDENTIFIER | VARCHAR2 | 30 | One column to store the FSIO related trading partner codes. This column will store alpha numeric values. This column will also take care of the "Fed vs Non-Fed" attribute requirement. | ||
| USER_GUID | VARCHAR2 | 64 | Stores the "light weight" user Global Unique Id. Light Weight users defined in the Extended Security (XS) System. Foreign key to FND_USER. | ||
| IDEN_ADDR_PARTY_SITE_ID | NUMBER | 18 | Unique identifier of the party site of the identifying address | ||
| IDEN_ADDR_LOCATION_ID | NUMBER | 18 | Unique identifier of the location of the identifying address | ||
| PRIMARY_EMAIL_CONTACT_PT_ID | NUMBER | 18 | Unique identifier of the primary E-mail | ||
| PRIMARY_URL_CONTACT_PT_ID | NUMBER | 18 | Unique identifier of the primary uniform resource locator | ||
| CONFLICT_ID | NUMBER | 18 | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 255 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| DATE_OF_BIRTH | DATE | Denormalization of the DATE_OF_BIRTH in HZ_PERSON_PROFILES | |||
| GENDER | VARCHAR2 | 30 | Denormalization of the GENDER in HZ_PERSON_PROFILES | ||
| INTERNAL_FLAG | VARCHAR2 | 1 | Denormalization of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES | ||
| PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | 15 | Denormalization of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES | ||
| CEO_NAME | VARCHAR2 | 240 | Denormalization of the CEO_NAME in HZ_ORGANIZATION_PROFILES | ||
| COMMENTS | VARCHAR2 | 2000 | Denormalization of the COMMENTS in HZ_GROUP_PROFILES | ||
| CPDRF_VER_SOR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows. | ||
| CPDRF_VER_PILLAR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows | ||
| CPDRF_LAST_UPD | VARCHAR2 | 15 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PERSONAL_ADDRESS_FLAG | VARCHAR2 | 1 | Indicates if the primary address is the personal address of the contact. | ||
| PERSONAL_EMAIL_FLAG | VARCHAR2 | 1 | Indicates if the primary E-mail is the personal E-mail address of the contact. | ||
| PERSONAL_PHONE_FLAG | VARCHAR2 | 1 | Indicates if the primary phone is the personal phone of the contact. | ||
| SALES_ACCOUNT_ID | NUMBER | 18 | Sales account identifier | ||
| OBJECT_TYPE | VARCHAR2 | 30 | Object type for internal use. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. | ||
| MASTER_PARTY_ID | NUMBER | 18 | Master Party identifier is a field to provide the link between survivor and victim records. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_PARTIESN1_ | Non Unique | Default | PARTY_ID, LAST_UPDATE_DATE |
| HZ_PARTIES_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTY_ID |
| HZ_PARTIES_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTY_NUMBER, CONFLICT_ID |