[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_PERSON_PROFILES |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_PERSON_PROFILES
|
| Subobject Name: | |
| Status: | VALID |
The HZ_PERSON_PROFILES table stores personal and family information about a party of the Person type. For example, this table could contain the correct spelling and phonetic pronunciation of the person's name. Note that some information in this table may also be entered into the HZ_PARTIES table.
.
The primary key for this table is PERSON_PROFILE_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_PERSON_PROFILES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_PROFILE_ID
|
| HZ_PERSON_PROFILES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_PROFILE_ID | NUMBER | (15) | Yes | Unique identifier for the person profile |
| PARTY_ID | NUMBER | (15) | Yes | Identifier for the party. Foreign key to the HZ_PARTIES table. |
| PERSON_NAME | VARCHAR2 | (450) | The combination of title, first, middle, last, and suffix names. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| WH_UPDATE_DATE | DATE | No longer used | ||
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Not currently used | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Not currently used | |
| PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | Salutary introduction such as Mr., Herr, etc. | |
| PERSON_FIRST_NAME | VARCHAR2 | (150) | First name of the person | |
| PERSON_MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
| PERSON_LAST_NAME | VARCHAR2 | (150) | Last or surname of the person | |
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | Indicates the place in a family structure. For example, in "Tom Jones III", the "III". | |
| PERSON_TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
| PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of the person's name such as Dr. Jane Smith | |
| PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | Previous last or surname of the person | |
| PERSON_INITIALS | VARCHAR2 | (6) | Name initials | |
| KNOWN_AS | VARCHAR2 | (240) | An alias or other name by which a person is known | |
| TAX_NAME | VARCHAR2 | (60) | No longer used | |
| PERSON_NAME_PHONETIC | VARCHAR2 | (320) | Japanese Kana, or phonetic representation of person name | |
| PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's first name | |
| PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's last name | |
| TAX_REFERENCE | VARCHAR2 | (60) | Taxpayer registration number, also known as the VAT number. | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | 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 | |
| PRIMARY_CONTACT_ID | NUMBER | (15) | No longer used | |
| PERSON_IDEN_TYPE | VARCHAR2 | (30) | Personal identifier type, such as driver's license or passport. Lookup type for PERSON_IDENTIFIER column | |
| PERSON_IDENTIFIER | VARCHAR2 | (60) | Personal identifier, such as driver's license or passport number, or country-specific identifier for person located or doing business in multiple countries | |
| DATE_OF_BIRTH | DATE | Date the person was born | ||
| PLACE_OF_BIRTH | VARCHAR2 | (60) | Where the person was born. Typically, the city and country. | |
| DATE_OF_DEATH | DATE | Date the person died | ||
| GENDER | VARCHAR2 | (30) | The gender (male, female, unknown) of the person | |
| DECLARED_ETHNICITY | VARCHAR2 | (60) | The declared ethnicity of the person | |
| MARITAL_STATUS | VARCHAR2 | (30) | Marital status of the person | |
| MARITAL_STATUS_EFFECTIVE_DATE | DATE | Date when the person's marital status changed. | ||
| PERSONAL_INCOME | NUMBER | The estimated gross annual income of the person | ||
| HEAD_OF_HOUSEHOLD_FLAG | VARCHAR2 | (1) | Indicates if the person is the head of the household. Y for the head of a household, N for people who are not the head of a household. | |
| HOUSEHOLD_INCOME | NUMBER | Income of the household that this person is a part of | ||
| HOUSEHOLD_SIZE | NUMBER | The size of the household this person is a part of | ||
| RENT_OWN_IND | VARCHAR2 | (30) | Indicates if the person rents or owns his or her residence. Lookup of values for rent, own, lease, and so on. | |
| LAST_KNOWN_GPS | VARCHAR2 | (60) | The geophysical location (GPS point) that was last reported for the person | |
| BEST_TIME_CONTACT_BEGIN | DATE | No longer used | ||
| BEST_TIME_CONTACT_END | DATE | No longer used | ||
| EFFECTIVE_START_DATE | DATE | Yes | For date tracking capabilities | |
| EFFECTIVE_END_DATE | DATE | For date tracking capabilities | ||
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Source of data content |
| CONTENT_SOURCE_NUMBER | VARCHAR2 | (30) | No longer used | |
| INTERNAL_FLAG | VARCHAR2 | (1) | Indicates whether the person is internal or external to the user's organization. Y for a person who is a member of the user's organization, N for a person who is not a member of the user's organization. | |
| KNOWN_AS2 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS3 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS4 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS5 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| MIDDLE_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of person's middle name | |
| STATUS | VARCHAR2 | (1) | Record status flag | |
| OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes | ||
| CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
| APPLICATION_ID | NUMBER | TCA Who column | ||
| ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | Yes | Additional Content Source Type column for backward compatibility. |
| DECEASED_FLAG | VARCHAR2 | (1) | Y or N indicates whether the person is deceased or not | |
| VERSION_NUMBER | NUMBER | Person's profile version number |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_PROFILE_ID
, PARTY_ID
, PERSON_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PREVIOUS_LAST_NAME
, PERSON_INITIALS
, KNOWN_AS
, TAX_NAME
, PERSON_NAME_PHONETIC
, PERSON_FIRST_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC
, TAX_REFERENCE
, JGZZ_FISCAL_CODE
, PRIMARY_CONTACT_ID
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, DATE_OF_BIRTH
, PLACE_OF_BIRTH
, DATE_OF_DEATH
, GENDER
, DECLARED_ETHNICITY
, MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_DATE
, PERSONAL_INCOME
, HEAD_OF_HOUSEHOLD_FLAG
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, RENT_OWN_IND
, LAST_KNOWN_GPS
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, CONTENT_SOURCE_TYPE
, CONTENT_SOURCE_NUMBER
, INTERNAL_FLAG
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, MIDDLE_NAME_PHONETIC
, STATUS
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, ACTUAL_CONTENT_SOURCE
, DECEASED_FLAG
, VERSION_NUMBER
FROM AR.HZ_PERSON_PROFILES;
AR.HZ_PERSON_PROFILES does not reference any database object
AR.HZ_PERSON_PROFILES is referenced by following:
AR
HZ_PERSON_PROFILES#
|
|
|
|