DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_H2PI_EMPLOYEES_V

Object Details
Object Name: HR_H2PI_EMPLOYEES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_H2PI_EMPLOYEES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PERSON_ID NUMBER (10) Yes System generated person primary key from PER_PEOPLE_S.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
EMPLOYEE_NUMBER VARCHAR2 (30)
Number assigned to a person if they have been an employee.
PERSON_TYPE VARCHAR2 (30)
Person type.
LAST_NAME VARCHAR2 (150) Yes Last name.
FIRST_NAME VARCHAR2 (150)
First name.
MIDDLE_NAMES VARCHAR2 (60)
Middle name.
SUFFIX VARCHAR2 (30)
Suffix.
START_DATE DATE
Yes Start date.
TITLE VARCHAR2 (30)
Title.
PRE_NAME_ADJUNCT VARCHAR2 (30)
Name prefix.
DATE_OF_BIRTH DATE

Date of birth.
MARITAL_STATUS VARCHAR2 (30)
Marital status.
REHIRE_REASON VARCHAR2 (60)
Reason for rehire.
SEX VARCHAR2 (30)
Male or female.
NATIONALITY VARCHAR2 (30)
Nationality.
NATIONAL_IDENTIFIER VARCHAR2 (30)
National identifier.
CORRESPONDENCE_LANGUAGE VARCHAR2 (30)
Corresponding language.
REGISTERED_DISABLED_FLAG VARCHAR2 (30)
Registered diabled indicatior.
DATE_OF_DEATH DATE

Date of death.
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address.
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
Address for expese check.
OFFICE_NUMBER VARCHAR2 (45)
Office contact number.
PER_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield.
PER_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION30 VARCHAR2 (150)
Developer flexfield structure defining column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EMPLOYEE_NUMBER
,      PERSON_TYPE
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAMES
,      SUFFIX
,      START_DATE
,      TITLE
,      PRE_NAME_ADJUNCT
,      DATE_OF_BIRTH
,      MARITAL_STATUS
,      REHIRE_REASON
,      SEX
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      CORRESPONDENCE_LANGUAGE
,      REGISTERED_DISABLED_FLAG
,      DATE_OF_DEATH
,      EMAIL_ADDRESS
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      OFFICE_NUMBER
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      PER_INFORMATION21
,      PER_INFORMATION22
,      PER_INFORMATION23
,      PER_INFORMATION24
,      PER_INFORMATION25
,      PER_INFORMATION26
,      PER_INFORMATION27
,      PER_INFORMATION28
,      PER_INFORMATION29
,      PER_INFORMATION30
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM APPS.HR_H2PI_EMPLOYEES_V;

Dependencies

[top of page]

APPS.HR_H2PI_EMPLOYEES_V references the following:

SchemaAPPS
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERSON_TYPES
APPS.HR_H2PI_EMPLOYEES_V is referenced by following:

SchemaAPPS
ViewHR_H2PI_ADDRESSES_V
Package BodyHR_H2PI_ERROR - show dependent code
ViewHR_H2PI_PERIODS_OF_SERVICE_V
Package BodyHR_H2PI_PERSON_UPLOAD - show dependent code
SchemaPUBLIC
SynonymHR_H2PI_EMPLOYEES_V