Partner Public Contact

The point of contact used for the public profile.

QName: {http://xmlns.oracle.com/apps/partnerMgmt/partnerCenter/}PartnerPublicContact

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

Contained by

Partner

Handled by

Deal Registration Service

Handled by

Company and User Registration

Handled by

Partner Service

Handled by

Partner Program Enrollment Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

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.

AnalysisFy

string

The fiscal year that the financial information is based on.

CategoryCode

string

The user-defined category. The lookup type is CUSTOMER_CATEGORY.

CeoName

string

The name of the chief executive officer. It is the denormalized value of the CEO_NAME in HZ_ORGANIZATION_PROFILES.

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.

City

string

The name of the city.

Comments1

string

The denormalization of the COMMENTS in HZ_GROUP_PROFILES.

Country

string

The name of the country.

County

string

The name of the county.

CreatedBy1

string

The user who created the account record.

CreatedByModule1

string

The module that created the account record.

CreationDate1

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

The date when the record was created.

CurrencyFyPotentialRevenue

decimal

The potential revenue of the organization in this fiscal year.

DUNSNumber

string

DUNS_NUMBER in VARCHAR format. Column value is not restricted to nine digit DUNS number.

DateOfBirth

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

The denormalization of the DATE_OF_BIRTH in HZ_PERSON_PROFILES.

EmailAddress

string

The email address associated with the record.

EmployeesTotal

decimal

The total number of employees.

FiscalYearendMonth

string

The month when the fiscal year ends for the organization.

FormattedAddress

string

The formatted address of the contact.

FormattedPhoneNumber

string

The formatted phone number.

Gender

string

The denormalization of the GENDER in HZ_PERSON_PROFILES.

GroupType

string

The lookup for the group type.

HQBranchInd

string

The status of the site. Identifies if the location is the headquarters, a branch, or a single location.

HomeCountry

string

The home country associated with the party.

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.

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.

LastUpdateDate1

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

The date when the record was last updated.

LastUpdateLogin1

string

The login of the user who last updated the record.

LastUpdatedBy1

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 the organization.

NextFyPotentialRevenue

decimal

The potential revenue of the organization for the next fiscal year.

OrigSystemReference

string

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.

PartyType

string

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

PersonAcademicTitle

string

An academic title that is part of the name of a person, 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.

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

PersonNameSuffix

string

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

PersonPreNameAdjunct

string

The salutary introduction such as Mr. or Herr.

PersonPreviousLastName

string

The previous last or surname of the 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.

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 key to primary e-mail contact point.

PrimaryPhoneAreaCode

string

The area code within a country code.

PrimaryPhoneContactPTId

long

The key to the primary 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 key to the primary URL contact point.

Province

string

The name of the province.

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.

State

string

The name of the state.

Status1

string

The party status indicator.

TradingPartnerIdentifier

string

One column to store the FSIO related trading partner codes. This column stores alpha numeric values. The column also addresses Fed vs. Non-Fed attribute requirement.

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 are defined in the Extended Security (XS) system. Foreign key to FND_USER.

YearEstablished

int

The year when the organization began doing business.