Trading Community Person Details

Person Information.

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

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

Contact Language

Contains

Contact Interest

Contains

Education

Contains

E-Mail

Contains

Source System Reference

Contains

Citizenship

Contains

Web

Contains

Credit Rating

Contains

Phone

Contains

Contact Preference

Contains

Additional Identifier

Contains

Classification Assignment

Contains

Financial Profile

Contains

Relationship

Contains

Employment History

Contains

Instant Messaging

Contains

Usage Assignment

Contains

Additional Contact Name

Contains

Certification

Contains

Contact

Contains

Preference

Contains

Contact Address

Contains

E-Mail Domain

Extended by

Partner Members

Contained by

Sales Party

Contained by

Sales Party Resource

Contained by

My Sales Account

Contained by

Sales Account

Contained by

Sales Party Territory

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

AdditionalPartyId

Additional Identifier

The additional identifier for an organization or person.

AdditionalPersonName

Additional Contact Name

The additional name associated with the person.

Address1

string

The first line of the address.

Address2

string

The second line of the address.

Address3

string

The third line of the address.

Address4

string

The fourth line of the address.

CategoryCode

string

The user-definable category. Lookup type is CUSTOMER_CATEGORY.

CertReasonCode

string

The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type.

Certification

Certification

The certification information for the party.

CertificationLevel

string

The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type.

Citizenship

Citizenship

The citizenship information of a person.

City

string

The name of the city.

CodeAssignment

Classification Assignment

The classification code assigned to the person.

Comments

string

The comments for the record.

ContactPreference

Contact Preference

The contact preference associated with the record.

Country

string

The name of the country.

County

string

The name of the county.

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.

CreditRating

Credit Rating

The credit rating of the person.

DateOfBirth

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The denormalization of the DATE_OF_BIRTH in HZ_PERSON_PROFILES.

Education

Education

The person education information.

Email

E-Mail

The email address associated with the record.

EmailAddress

string

The email address associated with the record.

EmailDomain

E-Mail Domain

The domain name of the e-mail address.

EmploymentHistory

Employment History

The employment history information of a person.

FinancialProfile

Financial Profile

The financial profile information of a person.

GSAIndicatorFlag

boolean

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.

Gender

string

The denormalization of the GENDER in HZ_PERSON_PROFILES.

IdenAddrLocationId

long

The unique identifier of the location of the identifying address.

IdenAddrPartySiteId

long

The unique identifier of the party site of the identifying address.

InstantMessaging

Instant Messaging

The instant messaging information related to the record.

InternalFlag

boolean

The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

JgzzFiscalCode

string

The taxpayer identification number. It can be the unique identifier of the person or organization. It can also be the SSN or income taxpayer ID in US, fiscal code or NIF in Europe.

LanguageName

string

The standard name for a language.

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.

MaritalStatus

string

The denormalization of the MARITAL_STATUS in HZ_PERSON_PROFILES.

MissionStatement

string

The corporate charter of organization.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PartyId

long

The unique identifier of the contact party.
  • Primary Key

PartyName

string

The name of the party.

PartyNumber

string

The unique identification number for the party.

PartyPreference

Preference

The preference associated with the person record.

PartySite

Contact Address

The address information associated with the person.

PartyType

string

The party type of the contact. The party type can only be Person, Organization, or Group.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PartyUsageAssignment

Usage Assignment

The party usage assigned to the person.

PersonAcademicTitle

string

Academic title that is part of a person's name, such as Dr. John Smith.

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.

PersonInterest

Contact Interest

The person interest information associated with a person.

PersonLanguage

Contact Language

The language information associated with a person.

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

Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.

PersonPreNameAdjunct

string

The salutary introduction, such as Mr. or Herr.

PersonPreviousLastName

string

Previous last name or surname of the person.

PersonProfile

Contact

The profile information for a person.

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.

Phone

Phone

The phone information for the entity.

PostalCode

string

The postal code element of the address.

PreferredContactMethod

string

The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD.

PreferredContactPersonId

long

The PARTY_ID of a preferred contact for a given party. There should be a valid relationship.

PreferredFunctionalCurrency

string

The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

PreferredName

string

The denormalized value of the PARTY_NAME field in HZ_ADDTNL_PARTY_NAMES identified by PREFERRED_NAME_ID.

PreferredNameId

long

The foreign key to PARTY_NAME_ID in HZ_ADDTNL_PARTY_NAMES. It contains the ID of the referred name for the party. If it is NULL the Profile Name will be used as preferred name. By default the value is NULL.

PrimaryEmailContactPTId

long

The unique identifier of the primary e-mail.

PrimaryPhoneAreaCode

string

The area code within a country code.

PrimaryPhoneContactPTId

long

The unique identifier of this contact point.

PrimaryPhoneCountryCode

string

The international country code for a telephone number. For example, it is 33 for France.

PrimaryPhoneExtension

string

The additional number required after initial connection to an internal telephone system.

PrimaryPhoneLineType

string

The lookup code for the type of phone line. For example, general, fax, inbound or outbound, and so on.

PrimaryPhoneNumber

string

The telephone number in local format. The number should not include country code, area code, or extension.

PrimaryPhonePurpose

string

The contact point type, such as business or personal.

PrimaryURLContactPTId

long

The unique identifier of the primary uniform resource locator.

Province

string

The name of the province.

Relationship

Relationship

The person relationship information.

RequestId

long

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

SICCode

string

The Standard Industry Classification (SIC) code.

SICCodeType

string

The version of Standard Industry Classification (SIC) code.

Salutation

string

The phrase used to address a party in any correspondence.

SourceSystem

string

The source system name where the record originated.

SourceSystemReferenceValue

string

The identifier for the record from an external source system.

SourceSystemUpdateDate

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

The source system name where the record originated.

State

string

The name of the state.

Status

string

The status of the record.

ThirdPartyFlag

boolean

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, then the Third Party field in the Customers window is mandatory.

URL

string

The destination URL associated with a specific Google AdWords ad.

UserGUID

string

Stores the light weight user global unique id. Light Weight users defined in the Extended Security (XS) System. Foreign key to FND_USER.

ValidatedFlag

boolean

Indicates whether the entity was validated. If the value is Y then the entity was validated.

Web

Web

The web information related to the record.