Parties

The party view object stores basic information about parties. Although a record in the view represents a unique party, multiple parties can have the same name with unique party identifier. The parties can be Organization, Person, or Group.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartyExtractPVO

Primary Keys : PartyId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
Address1 First line of the identifying address.
Address2 Second line of the identifying address.
Address3 Third line of the identifying address.
Address4 Fourth line of the identifying address.
AnalysisFy Fiscal year that financial information is based on.
Attribute1 A segment for the Party descriptive flexfield.
Attribute10 A segment for the Party descriptive flexfield.
Attribute11 A segment for the Party descriptive flexfield.
Attribute12 A segment for the Party descriptive flexfield.
Attribute13 A segment for the Party descriptive flexfield.
Attribute14 A segment for the Party descriptive flexfield.
Attribute15 A segment for the Party descriptive flexfield.
Attribute16 A segment for the Party descriptive flexfield.
Attribute17 A segment for the Party descriptive flexfield.
Attribute18 A segment for the Party descriptive flexfield.
Attribute19 A segment for the Party descriptive flexfield.
Attribute2 A segment for the Party descriptive flexfield.
Attribute20 A segment for the Party descriptive flexfield.
Attribute21 A segment for the Party descriptive flexfield.
Attribute22 A segment for the Party descriptive flexfield.
Attribute23 A segment for the Party descriptive flexfield.
Attribute24 A segment for the Party descriptive flexfield.
Attribute25 A segment for the Party descriptive flexfield.
Attribute26 A segment for the Party descriptive flexfield.
Attribute27 A segment for the Party descriptive flexfield.
Attribute28 A segment for the Party descriptive flexfield.
Attribute29 A segment for the Party descriptive flexfield.
Attribute3 A segment for the Party descriptive flexfield.
Attribute30 A segment for the Party descriptive flexfield.
Attribute4 A segment for the Party descriptive flexfield.
Attribute5 A segment for the Party descriptive flexfield.
Attribute6 A segment for the Party descriptive flexfield.
Attribute7 A segment for the Party descriptive flexfield.
Attribute8 A segment for the Party descriptive flexfield.
Attribute9 A segment for the Party descriptive flexfield.
AttributeCategory The context name for the Party descriptive flexfield.
AttributeDate1 A date segment for the Party descriptive flexfield.
AttributeDate10 A date segment for the Party descriptive flexfield.
AttributeDate11 A date segment for the Party descriptive flexfield.
AttributeDate12 A date segment for the Party descriptive flexfield.
AttributeDate2 A date segment for the Party descriptive flexfield.
AttributeDate3 A date segment for the Party descriptive flexfield.
AttributeDate4 A date segment for the Party descriptive flexfield.
AttributeDate5 A date segment for the Party descriptive flexfield.
AttributeDate6 A date segment for the Party descriptive flexfield.
AttributeDate7 A date segment for the Party descriptive flexfield.
AttributeDate8 A date segment for the Party descriptive flexfield.
AttributeDate9 A date segment for the Party descriptive flexfield.
AttributeNumber1 A number segment for the Party descriptive flexfield.
AttributeNumber10 A number segment for the Party descriptive flexfield.
AttributeNumber11 A number segment for the Party descriptive flexfield.
AttributeNumber12 A number segment for the Party descriptive flexfield.
AttributeNumber2 A number segment for the Party descriptive flexfield.
AttributeNumber3 A number segment for the Party descriptive flexfield.
AttributeNumber4 A number segment for the Party descriptive flexfield.
AttributeNumber5 A number segment for the Party descriptive flexfield.
AttributeNumber6 A number segment for the Party descriptive flexfield.
AttributeNumber7 A number segment for the Party descriptive flexfield.
AttributeNumber8 A number segment for the Party descriptive flexfield.
AttributeNumber9 A number segment for the Party descriptive flexfield.
CategoryCode The user-definable code indicates the category of the party. A list of valid category codes is defined using the lookup CUSTOMER_CATEGORY. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CeoName The name of the party's chief executive officer.
CertReasonCode The code indicating the reason for the organization party's current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CertificationLevel The certification level of the organization party. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
City The city of the identifying address.
Comments It's a denormalization column stores the description for a group.
Country The country of the identifying address
County The county of the Identifying address
CreatedBy The user who created the record.
CreatedByModule The module through which the record was created.
CreationDate The date and time of creating the record.
CurrFyPotentialRevenue The organization's potential revenue for this fiscal year.
DateOfBirth A denormalization column of person stores the date the person was born.
DunsNumberC Stores the DUNS_NUMBER in VARCHAR format which the value isn't restricted to nine digit Duns Number.
EmailAddress The email address of the party associated with.
EmployeesTotal The total number of employees in the organization.
FiscalYearendMonth The month in which fiscal year ends for the organization.
Gender A denormalization column of person stores the gender such as male, female, or unknown of the person.
GroupType The the group type code of the party.
GsaIndicatorFlag 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 aren't served by the GSA.
HomeCountry The home country of the organization.
HqBranchInd The status of this site, such as HQ, a branch, or a single location. A list of accepted values are defined in the lookup type HQ_BRANCH_IND.
IdenAddrLocationId The unique identifier of the location of the identifying address.
IdenAddrPartySiteId The unique identifier of the party site of the identifying address.
InternalFlag This a denormalization column. For person, the internal flag indicates whether the person is internal or external to the user's organization. For organization, the internal flag indicates whether this is an internal organization or external organization.
JgzzFiscalCode The taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe.
LanguageName The standard name for a language, example US.
LastUpdateDate The date and time of last update of the record.
LastUpdateLogin The login of the user who last updated the record.
LastUpdatedBy The user who last updated the record.
MaritalStatus A denormalization column of person stores the marital status of the person.
MasterPartyId The unique identifier of the master party associated with the nonduplicate record which provides the link between survivor and victim records.
MissionStatement Corporate charter of organization
NextFyPotentialRevenue The organization's potential revenue for its next fiscal year.
ObjectType The object type for internal use.
OrigSystemReference The customer identifier from foreign system. May not be unique.
PartyId The unique identifier of party. This is the primary key of the party view.
PartyName The name of this party.
PartyNumber The unique identification number for this party.
PartyType The type of the party, such as Person, Organization, Group.
PartyUniqueName This is a derived column. For Organization, it's concatenation of unique_name_alias and suffix. For Person, it's concatenation of person_name and suffix.
PersonAcademicTitle The academic title that's part of a person's name, such as Dr. John Smith.
PersonFirstName The first name of the person.
PersonLastName The last or surname of the person.
PersonLastNamePrefix The prefix for the last name of a person.
PersonMiddleName The middle name of the person.
PersonNameSuffix The suffix for the name of a person.
PersonPreNameAdjunct The preferred name adjacency of a person, such as Mr. or Herr.
PersonPreviousLastName The previous last or surname of a person.
PersonSecondLastName The second last name for a person.
PersonTitle A professional or family title. For example, Don or The Right Honorable.
PersonalAddressFlag Indicates whether the primary address is the personal address of the contact.
PersonalEmailFlag Indicates whether the primary E-mail is the personal E-mail address of the contact.
PersonalPhoneFlag Indicates whether the primary phone is the personal phone of the contact.
PostalCode The postal code of the identifying address.
PrefFunctionalCurrency The default currency code for this person or organization.
PreferredContactMethod How a person prefers to be contacted. Validated against lookup HZ_PREFERRED_CONTACT_METHOD.
PreferredContactPersonId The unique identifier of the preferred contact person for this party.
PreferredName The preferred name for this party.
PreferredNameId The ID of the preferred name for the party. If NULL, the profile name, the name contained in the profile, will be used as the preferred name. By default the value is NULL.
PrimaryEmailContactPtId The unique identifier of the primary E-mail.
PrimaryPhoneAreaCode The phone area code of the party.
PrimaryPhoneContactPtId The unique identifier of the primary phone.
PrimaryPhoneCountryCode The phone country code of the party. For example, 33 for France.
PrimaryPhoneExtension The phone extension code of the party.
PrimaryPhoneLineType The type of the phone line of the party. For example, general, fax, inbound or outbound.
PrimaryPhoneNumber The primary phone number of the party. The number should not include country code, area code, or extension.
PrimaryPhonePurpose Contact point phone purpose type, such as business or personal
PrimaryUrlContactPtId The unique identifier of the primary uniform resource locator.
Province The province of the Identifying address.
SalesAccountId The unique identifier of the sales account.
Salutation A phrase used to address a party in any correspondence.
SicCode The standard Industry Classification (SIC) code of the party.
SicCodeType The version of Standard Industry Classification (SIC) code of the party.
State The state of the identifying address.
Status The status of the record.
ThirdPartyFlag Indicates whether the party is a third party. Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory.
TradingPartnerIdentifier The FSIO related trading partner codes.
Url The uniform resource locator or a website containing information about the party.
UserGuid The global unique identifier of the user.
UserLastUpdateDate The date and time when the record was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server).
ValidatedFlag Indicates whether the party was validated. Y for a validated party, N for a party that isn't validated.
YearEstablished The year that the organization began doing business