Additional Contact Name

An additional name that can be associated with a trading community person. For example, maiden name or alias.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/}AdditionalPersonName

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Source System Reference

Contained by

Trading Community Person Details

Handled by

Company and User Registration

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Sales Party Resource Service

Handled by

Sales Party Territory service

Handled by

Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name Type Description

CreatedBy

string

The user who created the record.

CreatedByModule

string

The module that created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

Description

string

The free text description of the record.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

OrigSystem

string

The source system name.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

OverallPreferredFlag

boolean

The preferred additional name of a person.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PartyNameId

long

The unique identifier. This attribute is the primary key and is system-generated.
  • Primary Key

PartyNameType

string

The 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.

PersonAcademicTitle

string

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.

PersonFirstName

string

The first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Given Name in HL7.

PersonLastName

string

The last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Family Name in HL7.

PersonLastNamePrefix

string

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.

PersonMiddleName

string

The middle name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Middle Initial or Name in HL7.

PersonNameSuffix

string

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.

PersonPreNameAdjunct

string

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. This is validated against lookup CONTACT_TITLE.

PersonPreviousLastName

string

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.

PersonSecondLastName

string

The second last name for a person. In some cultures it is not uncommon to have double last names. It is used in the same way the field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used.

PersonTitle

string

The professional or family title. For example, Don or The Right Honorable.

PreferredFlag

boolean

Identifies the name as preferred name for this party within this name type. Possible values are 'Y' and 'N'. Default is 'N'.

RequestId

long

A system-generated read-only attribute used by the application framework.

StatusFlag

boolean

The record status flag used to soft delete the record. The accepted values are: 'A' (active), 'I' (inactive), 'D' (logically deleted), and 'M' (merged). The default is 'A'.

TransliterationLang

string

Used to capture the language used for the name. It is validated against FND_LANGUAGES.LANGUAGE_CODE. Default value is the Session Language.