FND Design Data [Home] [Help]

Table: PQP_GAP_ABSENCE_PLANS

Product: PQP - Public Sector Payroll
Description: This table is used to store the generic Absence Plans
Implementation/DBA Data: TableHR.PQP_GAP_ABSENCE_PLANS
Primary Key: PQP_GAP_ABSENCE_PLANS_PK
  1. ColumnGAP_ABSENCE_PLAN_ID
Primary Key: PQP_GAP_ABSENCE_PLANS_UK1
  1. ColumnABSENCE_ATTENDANCE_ID
  2. ColumnPL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePQP_GAP_DAILY_ABSENCES FK Joins to PQP_GAP_ABSENCE_PLANS PQP_GAP_DAILY_ABSENCES.GAP_ABSENCE_PLAN_ID