Product: | PER - Human Resources |
---|---|
Description: | DateTracked table holding personal information for employees, applicants and other people. |
Implementation/DBA Data: | HR.PER_ALL_PEOPLE_F |
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 |
|
|
|