FND Design Data [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: TableHR.PER_ALL_PEOPLE_F
Primary Key: PER_PEOPLE_F_PK
  1. ColumnPERSON_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ALL_PEOPLE_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID
PER_ALL_PEOPLE_F FK Joins to TablePER_PERSON_TYPES PER_ALL_PEOPLE_F.PERSON_TYPE_ID
TablePJI_RESOURCES_DENORM FK Joins to PER_ALL_PEOPLE_F PJI_RESOURCES_DENORM.PERSON_ID
PJI_RESOURCES_DENORM.RESOURCE_NAME
PJI_RESOURCES_DENORM.END_DATE
TableWMS_DISPATCHED_TASKS_ARCH FK Joins to PER_ALL_PEOPLE_F WMS_DISPATCHED_TASKS_ARCH.PERSON_ID
WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS_ARCH.EFFECTIVE_END_DATE
TableWMS_DISPATCHED_TASKS FK Joins to PER_ALL_PEOPLE_F WMS_DISPATCHED_TASKS.PERSON_ID
WMS_DISPATCHED_TASKS.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS.EFFECTIVE_END_DATE
TableWMS_DISPATCHED_TASKS_HISTORY FK Joins to PER_ALL_PEOPLE_F WMS_DISPATCHED_TASKS_HISTORY.PERSON_ID
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_END_DATE
TableWMS_EXCEPTIONS FK Joins to PER_ALL_PEOPLE_F WMS_EXCEPTIONS.PERSON_ID
WMS_EXCEPTIONS.EFFECTIVE_START_DATE
WMS_EXCEPTIONS.EFFECTIVE_END_DATE
TableWMS_SKIP_TASK_EXCEPTIONS FK Joins to PER_ALL_PEOPLE_F WMS_SKIP_TASK_EXCEPTIONS.PERSON_ID
WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_START_DATE
WMS_SKIP_TASK_EXCEPTIONS.EFFECTIVE_END_DATE