1. Tables and Views for Sales and Fusion Service
  2. HZ_ADDTNL_PARTY_NAMES

HZ_ADDTNL_PARTY_NAMES

HZ_ADDTNL_PARTY_NAMES is used to capture all additional names/aliases, associated to a party. For example, the Legal name or Maiden Name information for a party would be stored as a entry in the HZ_ADDTNL_PARTY_NAMES table with the PARTY_NAME_TYPE column storing the Legal Name or Maiden Name and PARTY_NAME_TYPE as LEGAL or MAIDEN. In addition to the seeded types, customers or applications can define additional types as needed.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_ADDTNL_PARTY_NAMES_PK

PARTY_NAME_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PARTY_NAME_ID NUMBER 18 Yes Unique identifier. Primary Key. System generated.
PARTY_ID NUMBER 18 Yes Party ID. Foreign key reference to the HZ_PARTIES. The party type should be consistent with the party type that the PARTY_NAME_TYPE can be applied to.
PARTY_NAME_TYPE VARCHAR2 30 Yes Type of the name. It is a value defined by the Additional Party Name and Identifier Type entity. The party type should be consistent with the party type that the PARTY_NAME_TYPE can be applied to.
STATUS_FLAG VARCHAR2 1 Yes Record Status Flag used to soft delete entity. Possible values are 'A' (active), 'I' (inactive), 'D' (logically deleted), and 'M' (merged). 'M' will not be used for this entity. Default is 'A'. Active
ACTUAL_CONTENT_SOURCE VARCHAR2 30 Yes Source system that provides this name. Default with USER_ENTERED. Foreign key to HZ_ORIG_SYSTEMS_B Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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. Active
CREATED_BY_MODULE VARCHAR2 30 Yes TCA Who column Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
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.
PARTY_NAME VARCHAR2 360 Typically used to store the additional name for the party. In the case of Persons it will be used to store the formatted name if necessary for the name type.
PERSON_TITLE VARCHAR2 60 A professional or family title. For example, Don or The Right Honorable. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used
PERSON_ACADEMIC_TITLE VARCHAR2 30 Used to capture the Academic title for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Degree in HL7.
PERSON_PRE_NAME_ADJUNCT VARCHAR2 30 Used to capture the name prefix (Mr. Ms, Dr., etc.) for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Prefix in HL7. Validate against lookup CONTACT_TITLE
PERSON_FIRST_NAME VARCHAR2 150 Used to capture the first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Given Name in HL7.
PERSON_MIDDLE_NAME VARCHAR2 60 Used to capture the middle name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Middle Initial or Name in HL7.
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_LAST_NAME VARCHAR2 150 Used to capture the last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Family Name 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.
PERSON_PREVIOUS_LAST_NAME VARCHAR2 150 Used to capture the previous last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It has no mapping in HL7.
PERSON_NAME_SUFFIX VARCHAR2 30 Used to capture the name suffix (e.g. Junior. Sr, the third, etc.) for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Suffix in HL7.
TRANSLITERATION_LANG VARCHAR2 4 Used to capture the language used for the name. It is validated against FND_LANGUAGES.LANGUAGE_CODE. Default value is the Session Language. Active
PREFERRED_FLAG VARCHAR2 1 Identify the name as preferred name for this party within this name type. Possible values are 'Y' and 'N'. Default is 'N'.
DESCRIPTION VARCHAR2 240 Free text comment/description. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
CONFLICT_ID NUMBER 18 Yes 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). Active
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). Active
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.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_ADDTNL_PARTY_NAMES hz_parties PARTY_ID
hey_person_names_extension hz_addtnl_party_names PARTY_NAME_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_ADDTNL_PARTY_NAMES_N1 Non Unique Default PARTY_NAME
HZ_ADDTNL_PARTY_NAMES_N2 Non Unique Default PARTY_ID
HZ_ADDTNL_PARTY_NAMES_N3 Non Unique Default LAST_UPDATE_DATE, PARTY_NAME_ID
HZ_ADDTNL_PARTY_NAMES_N4 Non Unique Default UPPER("PARTY_NAME"), PARTY_NAME_TYPE
HZ_ADDTNL_PARTY_NAMES_N5 Non Unique Default UPPER("PERSON_FIRST_NAME")
HZ_ADDTNL_PARTY_NAMES_N6 Non Unique Default UPPER("PERSON_MIDDLE_NAME")
HZ_ADDTNL_PARTY_NAMES_N7 Non Unique Default UPPER("PERSON_LAST_NAME")
HZ_ADDTNL_PARTY_NAMES_N8 Non Unique Default REQUEST_ID
HZ_ADDTNL_PARTY_NAMES_PK Unique Default PARTY_NAME_ID