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.

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

TABLE: HR.HR_H2PI_EMPLOYEES

Object Details

Object Name:	HR_H2PI_EMPLOYEES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_H2PI_EMPLOYEES
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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPD_DATE	DATE			Last update date
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group ID
CLIENT_ID	NUMBER	(15)	Yes	Client id
PERSON_ID	NUMBER	(10)	Yes	System generated person primary key from PER_PERSON_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 employee
PERSON_TYPE	VARCHAR2	(30)		Person Type
LAST_NAME	VARCHAR2	(150)	Yes	Last name of the person,(surname, family name)
FIRST_NAME	VARCHAR2	(150)		First name of the person
MIDDLE_NAMES	VARCHAR2	(60)		Middle name of the person
SUFFIX	VARCHAR2	(30)		Suffix after the surname e.g. Sr., Jr., III
START_DATE	DATE		Yes	Start date of person ( not the DateTrace attribute)
TITLE	VARCHAR2	(30)		Title e.g. Mr., Mrs.,Dr.
PRE_NAME_ADJUNCT	VARCHAR2	(30)		Name perfix
DATE_OF_BIRTH	DATE			Date of birth
MARITAL_STATUS	VARCHAR2	(30)		Marital status
REHIRE_REASON	VARCHAR2	(60)		Reason for re-hiring
SEX	VARCHAR2	(30)		Legal gender
NATIONALITY	VARCHAR2	(30)		Nationality
NATIONAL_IDENTIFIER	VARCHAR2	(30)		Number by which a person is identified in a given legislation
CORRESPONDENCE_LANGUAGE	VARCHAR2	(30)		Corrospondence language
REGISTERED_DISABLED_FLAG	VARCHAR2	(30)		Flag indicating whether person is classified as disabled
DATE_OF_DEATH	DATE			Date of death
EMAIL_ADDRESS	VARCHAR2	(240)		Email address
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)		Mailing address
OFFICE_NUMBER	VARCHAR2	(45)		Office number
PER_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfiled column
PER_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfiled column
PER_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfiled column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Developer flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfiled column
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfiled column
STATUS	VARCHAR2	(1)		Status of record for upload

Query Text

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


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      CLIENT_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
,      STATUS
FROM HR.HR_H2PI_EMPLOYEES;

Dependencies

[top of page]

HR.HR_H2PI_EMPLOYEES does not reference any database object

HR.HR_H2PI_EMPLOYEES is referenced by following:

APPS: HR_H2PI_EMPLOYEES
PUBLIC: HR_H2PI_EMPLOYEES