Contact
The profile information of the trading community person. The profile includes information such as marital status and additional name.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/}PersonProfile
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 |
|
Contained by |
|
Contained by |
|
Contained by |
|
Handled 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 |
---|---|---|
Alias |
string |
Person alias name. |
CertReasonCode |
string |
The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type. |
CertificationLevel |
string |
The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type. |
Comments |
string |
The comments for the record. |
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. |
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. |
CurcyConvRateType |
string |
The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework. |
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
DataCloudStatus |
string |
The enrichment status of the person. |
DateOfBirth |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the person was born. |
DateOfDeath |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the person died. |
DeceasedFlag |
boolean |
Y or N indicates whether the person is deceased or not. |
DeclaredEthnicity |
string |
The declared ethnicity of the person. |
Department |
string |
The free form text used to name the department. |
DepartmentCode |
string |
The list of values for possible department codes. |
Distance |
decimal |
The distance from the input location. |
DoNotCallFlag |
boolean |
Indicator to specify if the user can send mail to the person or not. |
DoNotContactFlag |
boolean |
Indicator to specify if the user can contact the person through phone, e-mail, or mail or not. |
DoNotEmailFlag |
boolean |
Indicator to specify if the user can send e-mail to the person or not. |
DoNotMailFlag |
boolean |
Indicator to specify if the user can send mail to the person or not. |
EffectiveEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date at the end of the date range within which the row is effective. |
EffectiveLatestChange |
string |
The date effective entity. Y indicates that this row represents the latest change in the day. |
EffectiveSequence |
int |
The date effective entity. Indicates the order of different changes made during a day. The lowest value represents the earliest change in the day. |
EffectiveStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date at the beginning of the date range within which the row is effective. |
FavoriteContactFlag |
boolean |
Indicator to specify if the person is key contact. |
Gender |
string |
The gender details such as male, female, or unknown of the person. |
HeadOfHouseholdFlag |
boolean |
The head of household indicator is not used. |
HouseholdIncomeAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The household income amount is not used. |
HouseholdSize |
decimal |
The household size is not used. |
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. |
JobTitle |
string |
The free form text for the job title. |
JobTitleCode |
string |
The code given to the job title. |
LastContactDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the contact was last contacted. |
LastEnrichmentDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the person was last enriched in DaaS. |
LastKnownGPS |
string |
The geophysical location that is, GPS point last reported for the person. |
LastSourceUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated by the source application. |
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. |
LastUpdateSourceSystem |
string |
The source application that last updated the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
MaritalStatus |
string |
The marital status of the person. |
MaritalStatusEffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the marital status of the person changed. |
OrigSystem |
string |
The source system name. |
OrigSystemReference |
string |
The identifier for the record from the original system. |
PartyId |
long |
The unique identifier of the contact party. |
PartyNumber |
string |
The unique identification number for the party. |
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. |
PersonAcademicTitle |
string |
The academic title that is part of the name of a person such as Dr. Jane 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. |
PersonInformation |
The information of the person. |
|
PersonInitials |
string |
The Initials of the name. |
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 identify the Last name prefix such as fon, van and so on 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. |
PersonName |
string |
The combination of title, first, middle, last, and suffix names. |
PersonNameSuffix |
string |
Indicates the place in a family structure. For example, III in Tom Jones III. |
PersonPreNameAdjunct |
string |
Salutary introduction such as Mr., Herr, and so on. |
PersonPreviousLastName |
string |
The previous last or surname of the person. |
PersonProfileId |
long |
The unique identifier of the person profile.
|
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. |
PersonalIncomeAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The estimated gross annual income of the person. |
PlaceOfBirth |
string |
The place where the person was born, including city and country. |
PreferredContactEmail |
string |
The preferred contact e-mail of the person. |
PreferredContactMethod |
string |
The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD. |
PreferredContactName |
string |
The preferred contact name of the person. |
PreferredContactPersonId |
long |
The PARTY_ID of a preferred contact for a given party. There should be a valid relationship. |
PreferredContactPhone |
string |
The preferred contact phone of the person. |
PreferredContactURL |
string |
The preferred contact uniform resource locator of the person. |
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. |
PrimaryAddressCity |
string |
The city of the identifying address. |
PrimaryAddressCountry |
string |
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table for the identifying address. |
PrimaryAddressCounty |
string |
The county of the identifying address. |
PrimaryAddressLatitude |
decimal |
The primary address latitude information for the location for spatial proximity and containment purposes. |
PrimaryAddressLine1 |
string |
The first line of the identifying address. |
PrimaryAddressLine2 |
string |
The second line of the identifying address. |
PrimaryAddressLine3 |
string |
The third line of the identifying address. |
PrimaryAddressLine4 |
string |
The fourth line of the identifying address. |
PrimaryAddressLocationId |
long |
The primary address location ID. |
PrimaryAddressLongitude |
decimal |
The primary address longitude information for the location for spatial proximity and containment purposes. |
PrimaryAddressPostalCode |
string |
The postal code of the identifying address. |
PrimaryAddressProvince |
string |
The province of the identifying address. |
PrimaryAddressState |
string |
The state of the identifying address. |
PrimaryCustomerId |
long |
The customer party identifier of a primary customer for a given person. There should be a valid relationship between the person and the customer. |
PrimaryCustomerName |
string |
The customer party name of a primary customer for a given person. There should be a valid relationship between the person and the customer. |
PrimaryCustomerRelationshipId |
long |
The unique identifier of the primary customer relationship. |
PrimaryEmailAddress |
string |
The e-mail address of the person. |
PrimaryEmailId |
long |
The primary contact point e-mail ID of the person. |
PrimaryFormattedAddress |
string |
The primary formatted address of the person. |
PrimaryFormattedPhoneNumber |
string |
The primary telephone number formatted in the local format of the person. |
PrimaryLanguage |
string |
The standard name for a language. |
PrimaryPhoneAreaCode |
string |
The area code within a country code. |
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. |
PrimaryPhoneId |
long |
The primary contact point phone ID of the person. |
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. |
PrimaryURL |
string |
The uniform resource locator. |
PrimaryWebId |
long |
The unique identifier of the primary uniform resource locator. |
Pronunciation |
string |
The person pronunciation. |
RentOwnInd |
string |
Indicates if the person rents or owns his or her residence. Lookup values include rent, own, lease, and so on. |
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
SalesAffinityCode |
string |
The affinity of a person towards the deploying organization. |
SalesBuyingRoleCode |
string |
The role of a person in the buying process. |
Salutation |
string |
The phrase used to address a party in any correspondence. |
Status |
string |
The status of the record. |
SuffixOverriddenFlag |
boolean |
This attribute has Y if the suffix is overridden by user and N if not. Default value is N. |
UniqueNameSuffix |
string |
Identifies system generated or manually overridden suffix. |
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |