FND Design Data [Home] [Help]

Table: PER_ESTABLISHMENT_ATTENDANCES

Product: PER - Human Resources
Description: A record of educational establishments that a person is currently attending or has previously attended.
Implementation/DBA Data: TableHR.PER_ESTABLISHMENT_ATTENDANCES
Primary Key: PER_ESTABLISHMENT_ATTEND_PK
  1. ColumnATTENDANCE_ID
Primary Key: PER_ESTABLISHMENT_ATTEND_UK
  1. ColumnATTENDED_START_DATE
  2. ColumnPERSON_ID
  3. ColumnESTABLISHMENT_ID
  4. ColumnBUSINESS_GROUP_ID
  5. ColumnESTABLISHMENT
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ESTABLISHMENT_ATTENDANCES FK Joins to TablePER_ESTABLISHMENTS PER_ESTABLISHMENT_ATTENDANCES.ESTABLISHMENT_ID
PER_ESTABLISHMENT_ATTENDANCES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ESTABLISHMENT_ATTENDANCES.BUSINESS_GROUP_ID
TablePER_QUALIFICATIONS FK Joins to PER_ESTABLISHMENT_ATTENDANCES PER_QUALIFICATIONS.ATTENDANCE_ID