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.PER_ALL_PEOPLE_F

Object Details

Object Name:	PER_ALL_PEOPLE_F
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_ALL_PEOPLE_F
Subobject Name:
Status:	VALID

[PER_ALL_PEOPLE_F is the DateTracked table that holds personal
information for employees, applicants, ex-employees, ex-applicants,
contacts and other people. The columns START_DATE,
EFFECTIVE_START_DATE and EFFECTIVE_END_DATE are all maintained
by DateTrack. The START_DATE is the date when the first record for
this person was created. The earliest EFFECTIVE_START_DATE for a
person is equal to the START_DATE.
NOTE: Users must not enter information into the Developer Descriptive
Flexfield columns. These are reserved for the use of localization and
verticalization teams, for entry and maintenance of legislative or
industry-specific data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_PEOPLE_F_PK

PERSON_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PEOPLE_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_PEOPLE_F_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_PEOPLE_F_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_TYPE_ID
PER_PEOPLE_F_N1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("FULL_NAME")
PER_PEOPLE_F_N2	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("LAST_NAME")
PER_PEOPLE_F_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_NAME
PER_PEOPLE_F_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_NUMBER
PER_PEOPLE_F_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICANT_NUMBER
PER_PEOPLE_F_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NATIONAL_IDENTIFIER
PER_PEOPLE_F_N54	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FULL_NAME
PER_PEOPLE_F_N55	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
PER_PEOPLE_F_N56	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NPW_NUMBER
PER_PEOPLE_F_N57	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("GLOBAL_NAME")
PER_PEOPLE_F_N58	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("LOCAL_NAME")
PER_PEOPLE_F_N59	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMAIL_ADDRESS
PER_PEOPLE_F_N60	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GLOBAL_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ALL_PEOPLE_F		HR_ALL_ORGANIZATION_UNITS	PER_ALL_PEOPLE_F BUSINESS_GROUP_ID
PER_ALL_PEOPLE_F		PER_PERSON_TYPES	PER_ALL_PEOPLE_F PERSON_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
PERSON_TYPE_ID	NUMBER	(15)	Yes	Foreign key to PER_PERSON_TYPES.
LAST_NAME	VARCHAR2	(150)	Yes	Last name of the person, (surname, family name).
START_DATE	DATE		Yes	Start date for the person (not the DateTrack attribute).
APPLICANT_NUMBER	VARCHAR2	(30)		Number assigned to person if ever classed as an applicant.
BACKGROUND_CHECK_STATUS	VARCHAR2	(30)		Background check status.
BACKGROUND_DATE_CHECK	DATE			Background date check.
BLOOD_TYPE	VARCHAR2	(30)		Blood group.
COMMENT_ID	NUMBER	(15)		Foreign key reference to remark.
CORRESPONDENCE_LANGUAGE	VARCHAR2	(30)		Correspondence Language validated against FND_LANGUAGES.
CURRENT_APPLICANT_FLAG	VARCHAR2	(30)		Yes or null.
CURRENT_EMP_OR_APL_FLAG	VARCHAR2	(30)		Yes or null.
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(30)		Yes or null.
DATE_EMPLOYEE_DATA_VERIFIED	DATE			Date when the employee last verified the data.
DATE_OF_BIRTH	DATE			Date of birth.
EMAIL_ADDRESS	VARCHAR2	(240)		Holds actual email identifier.
EMPLOYEE_NUMBER	VARCHAR2	(30)		Number assigned to a person if they have been an employee.
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)		Mailing address.
FAST_PATH_EMPLOYEE	VARCHAR2	(30)		Currently unsupported.
FIRST_NAME	VARCHAR2	(150)		First name of person.
FTE_CAPACITY	NUMBER	(5)		Full-time employment capacity.
FULL_NAME	VARCHAR2	(240)		Concatenation of last name, title, first name, middle names and the name the person is known by.
HOLD_APPLICANT_DATE_UNTIL	DATE			Hold applicant until.
HONORS	VARCHAR2	(45)		Honors.
INTERNAL_LOCATION	VARCHAR2	(45)		Internal location.
KNOWN_AS	VARCHAR2	(80)		Preferred name, if different from first name.
LAST_MEDICAL_TEST_BY	VARCHAR2	(60)		Last medical test by.
LAST_MEDICAL_TEST_DATE	DATE			Last medical test date.
MAILSTOP	VARCHAR2	(45)		Internal mail location.
MARITAL_STATUS	VARCHAR2	(30)		Marital status.
MIDDLE_NAMES	VARCHAR2	(60)		Middle names.
NATIONALITY	VARCHAR2	(30)		Nationality.
NATIONAL_IDENTIFIER	VARCHAR2	(30)		Number by which a person is identified in a given legislation.
OFFICE_NUMBER	VARCHAR2	(45)		Office number.
ON_MILITARY_SERVICE	VARCHAR2	(30)		On military service.
ORDER_NAME	VARCHAR2	(240)		Concatenated name used for ordering on select.
PRE_NAME_ADJUNCT	VARCHAR2	(30)		Name prefix.
PREVIOUS_LAST_NAME	VARCHAR2	(150)		Previous last name of person (if applicable).
PROJECTED_START_DATE	DATE			Currently unsupported.
REHIRE_AUTHORIZOR	VARCHAR2	(30)		Currently unsupported.
REHIRE_REASON	VARCHAR2	(60)		Reason for re-hiring.
REHIRE_RECOMMENDATION	VARCHAR2	(30)		Re-hire recommendation.
RESUME_EXISTS	VARCHAR2	(30)		Resume exists.
RESUME_LAST_UPDATED	DATE			Date resume last updated.
REGISTERED_DISABLED_FLAG	VARCHAR2	(30)		Flag indicating whether person is classified as disabled.
SECOND_PASSPORT_EXISTS	VARCHAR2	(30)		Second passport available flag.
SEX	VARCHAR2	(30)		Legal gender.
STUDENT_STATUS	VARCHAR2	(30)		Student status.
SUFFIX	VARCHAR2	(30)		Suffix after the surname e.g. Sr., Jr., III
TITLE	VARCHAR2	(30)		Title e.g. Mr, Mrs, Dr.
VENDOR_ID	NUMBER	(15)		Not used.
WORK_SCHEDULE	VARCHAR2	(30)		Work schedule.
WORK_TELEPHONE	VARCHAR2	(60)		Unsupported.
COORD_BEN_MED_PLN_NO	VARCHAR2	(30)		Coordination of benefits medical group plan number.
COORD_BEN_NO_CVG_FLAG	VARCHAR2	(30)		Coordination of benefits no other coverage flag
DPDNT_ADOPTION_DATE	DATE			Dependent adoption date
DPDNT_VLNTRY_SVCE_FLAG	VARCHAR2	(30)		Dependent voluntary service flag
RECEIPT_OF_DEATH_CERT_DATE	DATE			Receipt of death certificate date
USES_TOBACCO_FLAG	VARCHAR2	(30)		Uses tabacco flag
BENEFIT_GROUP_ID	NUMBER	(15)		Foreign key to benefits group table.
REQUEST_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining 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.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
PER_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
PER_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
PER_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
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 descriptive flexfield.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
DATE_OF_DEATH	DATE			Date of death.
ORIGINAL_DATE_OF_HIRE	DATE			Original date of hire.
TOWN_OF_BIRTH	VARCHAR2	(90)		Town that the person was born in
REGION_OF_BIRTH	VARCHAR2	(90)		Region that the person was born in
COUNTRY_OF_BIRTH	VARCHAR2	(90)		Country that the person was born in
GLOBAL_PERSON_ID	VARCHAR2	(30)		Global person identifier.
COORD_BEN_MED_PL_NAME	VARCHAR2	(80)		Benefits: Medical plan name.
COORD_BEN_MED_INSR_CRR_NAME	VARCHAR2	(80)		Benefits: Insurance carrier name.
COORD_BEN_MED_INSR_CRR_IDENT	VARCHAR2	(80)		Benefits: Insurance carrier identification number.
COORD_BEN_MED_EXT_ER	VARCHAR2	(80)		Used for benefits.
COORD_BEN_MED_CVG_STRT_DT	DATE			Benefits: start date of coverage plan.
COORD_BEN_MED_CVG_END_DT	DATE			Benefits: end date of coverage plan.
PARTY_ID	NUMBER	(15)		Party identifier.
NPW_NUMBER	VARCHAR2	(30)		Number for contingent worker
CURRENT_NPW_FLAG	VARCHAR2	(30)		Indicator of contingent worker status
GLOBAL_NAME	VARCHAR2	(240)		Stores personal name according to the defined Global List Name format
LOCAL_NAME	VARCHAR2	(240)		Stores personal name according to the defined Local List Name format

Query Text

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


SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      COMMENT_ID
,      CORRESPONDENCE_LANGUAGE
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FAST_PATH_EMPLOYEE
,      FIRST_NAME
,      FTE_CAPACITY
,      FULL_NAME
,      HOLD_APPLICANT_DATE_UNTIL
,      HONORS
,      INTERNAL_LOCATION
,      KNOWN_AS
,      LAST_MEDICAL_TEST_BY
,      LAST_MEDICAL_TEST_DATE
,      MAILSTOP
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      OFFICE_NUMBER
,      ON_MILITARY_SERVICE
,      ORDER_NAME
,      PRE_NAME_ADJUNCT
,      PREVIOUS_LAST_NAME
,      PROJECTED_START_DATE
,      REHIRE_AUTHORIZOR
,      REHIRE_REASON
,      REHIRE_RECOMMENDATION
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      REGISTERED_DISABLED_FLAG
,      SECOND_PASSPORT_EXISTS
,      SEX
,      STUDENT_STATUS
,      SUFFIX
,      TITLE
,      VENDOR_ID
,      WORK_SCHEDULE
,      WORK_TELEPHONE
,      COORD_BEN_MED_PLN_NO
,      COORD_BEN_NO_CVG_FLAG
,      DPDNT_ADOPTION_DATE
,      DPDNT_VLNTRY_SVCE_FLAG
,      RECEIPT_OF_DEATH_CERT_DATE
,      USES_TOBACCO_FLAG
,      BENEFIT_GROUP_ID
,      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
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      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
,      OBJECT_VERSION_NUMBER
,      DATE_OF_DEATH
,      ORIGINAL_DATE_OF_HIRE
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      GLOBAL_PERSON_ID
,      COORD_BEN_MED_PL_NAME
,      COORD_BEN_MED_INSR_CRR_NAME
,      COORD_BEN_MED_INSR_CRR_IDENT
,      COORD_BEN_MED_EXT_ER
,      COORD_BEN_MED_CVG_STRT_DT
,      COORD_BEN_MED_CVG_END_DT
,      PARTY_ID
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      GLOBAL_NAME
,      LOCAL_NAME
FROM HR.PER_ALL_PEOPLE_F;

Dependencies

[top of page]

HR.PER_ALL_PEOPLE_F does not reference any database object

HR.PER_ALL_PEOPLE_F is referenced by following:

APPS: BEN_EXT_PER_EVT; GHR_PER_ALL_PEOPLE_F_AFIUD; HR_PAY_IF_PERSON_ARU; HR_PA_MAINTN_PEP_HIST_BRU; PERALLPEOPLEF_2131D_DYT; PERALLPEOPLEF_57U_DYT; PER_ALL_PEOPLE_F; PER_ALL_PEOPLE_F_ARIU; PER_ALL_PEOPLE_F_OVN; PER_ALL_PEOPLE_F_WHO; SSP_PER_T1