FND Design Data [Home] [Help]

Table: PQH_BUDGET_PERIODS

Product: PQH - Public Sector HR
Description: Period details for budget
Implementation/DBA Data: TableHR.PQH_BUDGET_PERIODS
Primary Key: PQH_BUDGET_PERIODS_PK
  1. ColumnBUDGET_PERIOD_ID
Primary Key: PQH_BUDGET_PERIODS_UK
  1. ColumnBUDGET_DETAIL_ID
  2. ColumnEND_TIME_PERIOD_ID
  3. ColumnSTART_TIME_PERIOD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_BUDGET_PERIODS FK Joins to TablePQH_BUDGET_DETAILS PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID
PQH_BUDGET_PERIODS FK Joins to TablePER_TIME_PERIODS PQH_BUDGET_PERIODS.START_TIME_PERIOD_ID
PQH_BUDGET_PERIODS FK Joins to TablePER_TIME_PERIODS PQH_BUDGET_PERIODS.END_TIME_PERIOD_ID
TablePQH_BUDGET_SETS FK Joins to PQH_BUDGET_PERIODS PQH_BUDGET_SETS.BUDGET_PERIOD_ID