FND Design Data [Home] [Help]

Table: PQH_CRITERIA_RATE_DEFN

Product: PQH - Public Sector HR
Description: Table to store different criteria rate definitions.
Implementation/DBA Data: TableHR.PQH_CRITERIA_RATE_DEFN
Primary Key: PQH_CRITERIA_RATE_DEFN_PK
  1. ColumnCRITERIA_RATE_DEFN_ID
Primary Key: PQH_CRITERIA_RATE_DEFN_UK1
  1. ColumnSHORT_NAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_CRITERIA_RATE_DEFN FK Joins to TableHR_ALL_ORGANIZATION_UNITS PQH_CRITERIA_RATE_DEFN.BUSINESS_GROUP_ID
TablePQH_CRITERIA_RATE_ELEMENTS FK Joins to PQH_CRITERIA_RATE_DEFN PQH_CRITERIA_RATE_ELEMENTS.CRITERIA_RATE_DEFN_ID
TablePQH_CRITERIA_RATE_FACTORS FK Joins to PQH_CRITERIA_RATE_DEFN PQH_CRITERIA_RATE_FACTORS.CRITERIA_RATE_DEFN_ID
TablePQH_CRITERIA_RATE_FACTORS FK Joins to PQH_CRITERIA_RATE_DEFN PQH_CRITERIA_RATE_FACTORS.PARENT_CRITERIA_RATE_DEFN_ID
TablePQH_RATE_MATRIX_RATES_F FK Joins to PQH_CRITERIA_RATE_DEFN PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID