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]

Table: PER_ALL_PEOPLE_F

Product:	PER - Human Resources
Description:	DateTracked table holding personal information for employees, applicants and other people.
Implementation/DBA Data:	HR.PER_ALL_PEOPLE_F

Primary Key: PER_PEOPLE_F_PK

PERSON_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

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
PJI_RESOURCES_DENORM	PER_ALL_PEOPLE_F	PJI_RESOURCES_DENORM.PERSON_ID PJI_RESOURCES_DENORM.RESOURCE_NAME PJI_RESOURCES_DENORM.END_DATE
WMS_DISPATCHED_TASKS_ARCH	PER_ALL_PEOPLE_F	WMS_DISPATCHED_TASKS_ARCH.PERSON_ID WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_START_DATE WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_END_DATE
WMS_DISPATCHED_TASKS	PER_ALL_PEOPLE_F	WMS_DISPATCHED_TASKS.PERSON_ID WMS_DISPATCHED_TASKS.EFFECTIVE_START_DATE WMS_DISPATCHED_TASKS.EFFECTIVE_END_DATE
WMS_DISPATCHED_TASKS_HISTORY	PER_ALL_PEOPLE_F	WMS_DISPATCHED_TASKS_HISTORY.PERSON_ID WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_START_DATE WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_END_DATE
WMS_EXCEPTIONS	PER_ALL_PEOPLE_F	WMS_EXCEPTIONS.PERSON_ID WMS_EXCEPTIONS.EFFECTIVE_START_DATE WMS_EXCEPTIONS.EFFECTIVE_END_DATE
WMS_SKIP_TASK_EXCEPTIONS	PER_ALL_PEOPLE_F	WMS_SKIP_TASK_EXCEPTIONS.PERSON_ID WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_START_DATE WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_END_DATE