FND Design Data [Home] [Help]

Table: PQH_RATE_MATRIX_RATES_F

Product: PQH - Public Sector HR
Description: Datetracked table to store the rate value associated with each node in a rate matrix hierarchy.
Implementation/DBA Data: TableHR.PQH_RATE_MATRIX_RATES_F
Primary Key: PQH_RATE_MATRIX_RATES_F_PK
  1. ColumnRATE_MATRIX_RATE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_RATE_MATRIX_RATES_F FK Joins to TablePQH_RATE_MATRIX_NODES PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID
PQH_RATE_MATRIX_RATES_F FK Joins to TablePQH_CRITERIA_RATE_DEFN PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID