FND Design Data [Home] [Help]

Table: HR_EXCEPTION_USAGES

Product: PER - Human Resources
Description: Identifies usage of defined exceptions to a repeating pattern.
Implementation/DBA Data: TableHR.HR_EXCEPTION_USAGES
Primary Key: HR_EXCEPTION_USAGES_PK
  1. ColumnEXCEPTION_USAGE_ID
Primary Key: HR_EXU_UK01
  1. ColumnEXCEPTION_ID
  2. ColumnCALENDAR_ID
Primary Key: HR_EXU_UK02
  1. ColumnEXCEPTION_ID
  2. ColumnCALENDAR_USAGE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_EXCEPTION_USAGES FK Joins to TableHR_CALENDARS HR_EXCEPTION_USAGES.CALENDAR_ID
HR_EXCEPTION_USAGES FK Joins to TableHR_CALENDAR_USAGES HR_EXCEPTION_USAGES.CALENDAR_USAGE_ID
HR_EXCEPTION_USAGES FK Joins to TableHR_PATTERN_EXCEPTIONS HR_EXCEPTION_USAGES.EXCEPTION_ID