FND Design Data [Home] [Help]

Table: HR_PATTERN_PURPOSE_USAGES

Product: PER - Human Resources
Description: Valid combinations of entities and pattern purposes.
Implementation/DBA Data: TableHR.HR_PATTERN_PURPOSE_USAGES
Primary Key: HR_PATTERN_PURPOSE_USAGES_PK
  1. ColumnPURPOSE_USAGE_ID
Primary Key: HR_PPU_UK01
  1. ColumnENTITY_NAME
  2. ColumnPATTERN_PURPOSE
Primary Key: HR_PPU_UK02
  1. ColumnPATTERN_PURPOSE
  2. ColumnHIERARCHY_LEVEL
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_CALENDAR_USAGES FK Joins to HR_PATTERN_PURPOSE_USAGES HR_CALENDAR_USAGES.PURPOSE_USAGE_ID