eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Lookup Type: HZ_PERSON_PROFILES

Product:	AR - Receivables
Meaning:	List of attributes of HZ_PERSON_PROFILES table
Description:	A lookup table listing the attributes of HZ_PERSON_PROFILES table

Quick Codes

Code	Meaning	Description
DATE_OF_BIRTH	Date of Birth	Date of Birth
DATE_OF_DEATH	Date of Death	Date of Death
DECLARED_ETHNICITY	Declared Ethnicity	Declared Ethnicity
EFFECTIVE_END_DATE	Effective End Date	Effective End Date
EFFECTIVE_START_DATE	Effective Start Date	Effective Start Date
GENDER	Gender	Gender
HEAD_OF_HOUSEHOLD_FLAG	Head of Household Indicator	Head of Household Indicator
HOUSEHOLD_INCOME	Household Income	Household Income
HOUSEHOLD_SIZE	Household Size	Household Size
INTERNAL_FLAG	Internal Person Indicator	Internal Person Indicator
JGZZ_FISCAL_CODE	Tax Identification Number	Tax Identification Number
KNOWN_AS	Known As	Known As
KNOWN_AS2	Known As 2	Known As 2
KNOWN_AS3	Known As 3	Known As 3
KNOWN_AS4	Known As 4	Known As 4
KNOWN_AS5	Known As 5	Known As 5
LAST_KNOWN_GPS	Last Known GPS	Last Known GPS
MARITAL_STATUS	Marital Status	Marital Status
MARITAL_STATUS_EFFECTIVE_DATE	Marital Status Effective Date	Marital Status Effective Date
MIDDLE_NAME_PHONETIC	Phonetic Middle Name	Phonetic Middle Name
PERSONAL_INCOME	Personal Income	Personal Income
PERSON_ACADEMIC_TITLE	Academic Title	Academic Title
PERSON_FIRST_NAME	First Name	First Name
PERSON_FIRST_NAME_PHONETIC	Phonetic First Name	Phonetic First Name
PERSON_IDENTIFIER	Person Identifier Number	Person Identifier Number
PERSON_IDEN_TYPE	Person Identifier Type	Person Identifier Type
PERSON_INITIALS	Initials	Initials
PERSON_LAST_NAME	Last Name	Last Name
PERSON_LAST_NAME_PHONETIC	Phonetic Last Name	Phonetic Last Name
PERSON_MIDDLE_NAME	Middle Name	Middle Name
PERSON_NAME	Person Name	Name
PERSON_NAME_PHONETIC	Phonetic Name	Phonetic Name
PERSON_NAME_SUFFIX	Name Suffix	Name Suffix
PERSON_PREVIOUS_LAST_NAME	Previous Last Name	Previous Last Name
PERSON_PRE_NAME_ADJUNCT	Salutational Title(1)	Salutational Title(1)
PERSON_PRE_NAME_ADJUNCT	Salutational Title	Salutational Title
PERSON_TITLE	Title	Title
PLACE_OF_BIRTH	Place of Birth	Place of Birth
RENT_OWN_IND	Rent or Own Indicator	Rent or Own Indicator
TAX_NAME	Tax Name	Tax Name
TAX_REFERENCE	Tax Reference Number	Tax Reference Number