FND Design Data [Home] [Help]

Table: PQH_BUDGET_DETAILS

Product: PQH - Public Sector HR
Description: Budget Details for hr entities
Implementation/DBA Data: TableHR.PQH_BUDGET_DETAILS
Primary Key: PQH_BUDGET_DETAILS_PK
  1. ColumnBUDGET_DETAIL_ID
Primary Key: PQH_BUDGET_DETAILS_UK
  1. ColumnBUDGET_VERSION_ID
  2. ColumnGRADE_ID
  3. ColumnJOB_ID
  4. ColumnORGANIZATION_ID
  5. ColumnPOSITION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_BUDGET_DETAILS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PQH_BUDGET_DETAILS.ORGANIZATION_ID
PQH_BUDGET_DETAILS FK Joins to TablePQH_BUDGET_VERSIONS PQH_BUDGET_DETAILS.BUDGET_VERSION_ID
PQH_BUDGET_DETAILS FK Joins to TablePER_JOBS PQH_BUDGET_DETAILS.JOB_ID
PQH_BUDGET_DETAILS FK Joins to TablePER_GRADES PQH_BUDGET_DETAILS.GRADE_ID
TablePQH_BUDGET_PERIODS FK Joins to PQH_BUDGET_DETAILS PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID
TablePQH_WORKSHEET_DETAILS FK Joins to PQH_BUDGET_DETAILS PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID