Database Reference
In-Depth Information
PII Attributes
Table
Column
HZ_PARTIES
PARTY_NAME PERSON_FIRST_
NAME, PERSON_LAST_NAME,
PERSON_LAST_NAME_PREFIX,
PERSON_MIDDLE_NAME, PERSON_
TITLEPERSON_ACADEMIC_TITLE,
PERSON_NAME_SUFFIX, PERSON_PRE_
NAME_ADJUNCT, PERSON_SECOND_
LAST_NAME, PREFERRED_NAME,
SALUTATION
HZ_ADDTNL_PARTY_
NAMES
PERSON_FIRST_NAME PERSON_LAST_
NAME, PERSON_LAST_NAME_PREFIX,
PERSON_MIDDLE_NAME, PERSON_
NAME_SUFFIX, PERSON_PREVIOUS_
LAST_NAME, PERSON_PRE_NAME_
ADJUNCT, PERSON_SECOND_LAST_
NAME, PERSON_TITLE
Maiden name
HZ_PARTIES
PERSON_PREVIOUS_LAST_NAME
HZ_ADDTNL_PARTY_
NAMES
PARTY_NAME
Business address
HZ_PARTIES COUNTRY, ADDRESS1, ADDRESS2,
ADDRESS3, ADDRESS4, CITY,
STATE,POSTAL_CODE, PROVINCE,
COUNTY, HOME_COUNTRY
HZ_ADDTNL_PARTY_IDS COUNTRY, STATE_PROVINCE
HZ_LOCATIONS
ADDRESS1, ADDRESS2, ADDRESS3,
ADDRESS4, COUNTRY, CITY,
POSTAL_CODE, ADDRESS_LINES_
PHONETIC, POSTAL_PLUS4_CODE,
SALES_TAX_GEOCODE, GEOMETRY
HZ_LOCATION_
PROFILES
ADDRESS1, ADDRESS2, ADDRESS3,
ADDRESS4, CITY, POSTAL_CODE,
COUNTY, COUNTRY, STATE,
PROVINCE
Business telephone
number
HZ_PARTIES
PRIMARY_PHONE_COUNTRY_CODE
PRIMARY_PHONE_AREA_CODE
PRIMARY_PHONE_NUMBER, PRIMARY_
PHONE_EXTENSION
Search WWH ::
Custom Search