Table: PER_ALL_ASSIGNMENTS_F

Product:	PER - Human Resources
Description:	Employee and applicant assignment details.
Implementation/DBA Data:	HR.PER_ALL_ASSIGNMENTS_F

Primary Key: PER_ASSIGNMENTS_F_PK

1. ASSIGNMENT_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ALL_ASSIGNMENTS_F		IRC_POSTING_CONTENTS	PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID
PER_ALL_ASSIGNMENTS_F		HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID
PER_ALL_ASSIGNMENTS_F		PER_RECRUITMENT_ACTIVITIES	PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID
PER_ALL_ASSIGNMENTS_F		HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F		HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F		PAY_PEOPLE_GROUPS	PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID
PER_ALL_ASSIGNMENTS_F		HR_SOFT_CODING_KEYFLEX	PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID
PER_ALL_ASSIGNMENTS_F		PER_ALL_VACANCIES	PER_ALL_ASSIGNMENTS_F.VACANCY_ID
PER_ALL_ASSIGNMENTS_F		PER_PAY_BASES	PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID
PER_ALL_ASSIGNMENTS_F		HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID
PER_ALL_ASSIGNMENTS_F		PER_COLLECTIVE_AGREEMENTS	PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID
PER_ALL_ASSIGNMENTS_F		PER_CAGR_GRADES_DEF	PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID
PER_ALL_ASSIGNMENTS_F		PER_GRADES	PER_ALL_ASSIGNMENTS_F.GRADE_ID
PER_ALL_ASSIGNMENTS_F		PER_ALL_POSITIONS	PER_ALL_ASSIGNMENTS_F.POSITION_ID
PER_ALL_ASSIGNMENTS_F		PER_JOBS	PER_ALL_ASSIGNMENTS_F.JOB_ID
PER_ALL_ASSIGNMENTS_F		PER_APPLICATIONS	PER_ALL_ASSIGNMENTS_F.APPLICATION_ID
PER_ALL_ASSIGNMENTS_F		PER_PERIODS_OF_SERVICE	PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID
PER_ALL_ASSIGNMENTS_F		PER_ASSIGNMENT_STATUS_TYPES	PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_F		HR_LOCATIONS_ALL	PER_ALL_ASSIGNMENTS_F.LOCATION_ID