FND Design Data [Home] [Help]

Table: PER_ABS_ATTENDANCE_REASONS

Product: PER - Human Resources
Description: Valid absence reasons for an absence type.
Implementation/DBA Data: TableHR.PER_ABS_ATTENDANCE_REASONS
Primary Key: PER_ABS_ATTENDANCE_REASONS_PK
  1. ColumnABS_ATTENDANCE_REASON_ID
Primary Key: PER_ABS_ATTENDANCE_REASONS_UK2
  1. ColumnNAME
  2. ColumnABSENCE_ATTENDANCE_TYPE_ID
  3. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ABS_ATTENDANCE_REASONS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ABS_ATTENDANCE_REASONS.BUSINESS_GROUP_ID
PER_ABS_ATTENDANCE_REASONS FK Joins to TablePER_ABSENCE_ATTENDANCE_TYPES PER_ABS_ATTENDANCE_REASONS.ABSENCE_ATTENDANCE_TYPE_ID
TablePER_ABSENCE_ATTENDANCES FK Joins to PER_ABS_ATTENDANCE_REASONS PER_ABSENCE_ATTENDANCES.ABS_ATTENDANCE_REASON_ID