FND Design Data [Home] [Help]

Table: PAY_GB_YEAR_END_ASSIGNMENTS

Product: PAY - Payroll
Description: Extraction table for UK End of Year processing, which holds information about assignments.
Implementation/DBA Data: TableHR.PAY_GB_YEAR_END_ASSIGNMENTS
Primary Key: PAY_GB_YEAR_END_ASSIGNMENT_PK
  1. ColumnASSIGNMENT_ID
  2. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_GB_YEAR_END_ASSIGNMENTS FK Joins to TablePAY_GB_YEAR_END_PAYROLLS PAY_GB_YEAR_END_ASSIGNMENTS.PAYROLL_ID
TablePAY_GB_YEAR_END_VALUES FK Joins to PAY_GB_YEAR_END_ASSIGNMENTS PAY_GB_YEAR_END_VALUES.ASSIGNMENT_ID
PAY_GB_YEAR_END_VALUES.EFFECTIVE_END_DATE