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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Extended by |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AdditionalPartyId |
The additional identifier for an organization or person. |
|
|
AdditionalPersonName |
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 |
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 |
The citizenship information of a person. |
|
|
City |
string |
The name of the city. |
|
CodeAssignment |
The classification code assigned to the person. |
|
|
Comments |
string |
The comments for the record. |
|
ContactPreference |
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 |
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 |
The person education information. |
|
|
|
The email address associated with the record. |
|
|
EmailAddress |
string |
The email address associated with the record. |
|
EmailDomain |
The domain name of the e-mail address. |
|
|
EmploymentHistory |
The employment history information of a person. |
|
|
FinancialProfile |
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 |
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 |
The identifier for the record from the original system. |
|
|
PartyId |
long |
The unique identifier of the contact party.
|
|
PartyName |
string |
The name of the party. |
|
PartyNumber |
string |
The unique identification number for the party. |
|
PartyPreference |
The preference associated with the person record. |
|
|
PartySite |
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 |
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 |
The person interest information associated with a person. |
|
|
PersonLanguage |
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 |
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 |
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 |
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 |
The web information related to the record. |