Table: PER_BF_PROCESSED_ASSIGNMENTS

Product:	PER - Human Resources
Description:	Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
Implementation/DBA Data:	HR.PER_BF_PROCESSED_ASSIGNMENTS

Primary Key: PER_BF_PROCESSED_ASSIGNS_PK

1. PROCESSED_ASSIGNMENT_ID

Primary Key: PER_BF_PROCESSED_ASSIGNS_UK1

1. PAYROLL_RUN_ID
2. ASSIGNMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_BF_PROCESSED_ASSIGNMENTS		PER_BF_PAYROLL_RUNS	PER_BF_PROCESSED_ASSIGNMENTS.PAYROLL_RUN_ID
PER_BF_BALANCE_AMOUNTS		PER_BF_PROCESSED_ASSIGNMENTS	PER_BF_BALANCE_AMOUNTS.PROCESSED_ASSIGNMENT_ID
PER_BF_PAYMENT_DETAILS		PER_BF_PROCESSED_ASSIGNMENTS	PER_BF_PAYMENT_DETAILS.PROCESSED_ASSIGNMENT_ID