Search Results pqh_budgets_pk

Overview

PQH_BUDGETS is a Public Sector HR (PQH) table owned by the HR schema that stores master-level budget definitions for public sector and public sector-adjacent budgeting processes in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents a single budget, identified by its surrogate primary key BUDGET_ID and constrained by the unique business key BUDGET_NAME (index PQH_BUDGETS_UK). As documented, the table holds 32 columns, covering budget naming, budgeted entity and style attributes, calendar and currency context, hierarchical budget unit assignments, positional control flags, and GL/Grants transfer options.

The heuristic Data Vault classification for PQH_BUDGETS is satellite-leaning. In modeling terms, BUDGET_ID functions as the hub-like surrogate, while descriptive attributes such as BUDGET_STYLE_CD, PERIOD_SET_NAME, CURRENCY_CODE, and the three BUDGET_UNITn_AGGREGATE flags behave as satellite descriptive columns that would typically be split into time-versioned child satellites in a formal Data Vault design. BUDGET_NAME serves as the natural business key carried alongside the surrogate.

Key Information Stored

BUDGET_ID — surrogate primary key (PQH_BUDGETS_PK).
BUDGET_NAME — unique business-key identifier (PQH_BUDGETS_UK).
BUSINESS_GROUP_ID — partitioning of the budget by HR business group.
START_ORGANIZATION_ID and ORG_STRUCTURE_VERSION_ID — define the organization hierarchy context (the latter referencing PER_ORG_STRUCTURE_VERSIONS).
BUDGETED_ENTITY_CD and BUDGET_STYLE_CD — determine what is budgeted and the budgeting style (positional, aggregate, etc.).
PERIOD_SET_NAME — foreign key to PAY_CALENDARS, binding the budget to a payroll period set.
GL_SET_OF_BOOKS_ID, CURRENCY_CODE, and GL_BUDGET_NAME — GL accounting context for downstream transfer.
BUDGET_START_DATE / BUDGET_END_DATE — effective budget period.
BUDGET_UNIT1_ID, BUDGET_UNIT2_ID, BUDGET_UNIT3_ID — up to three shared-type budget dimension references to PER_SHARED_TYPES (this is the object the user's "per_shared_types" search relates to).
BUDGET_UNIT1_AGGREGATE, BUDGET_UNIT2_AGGREGATE, BUDGET_UNIT3_AGGREGATE — aggregate-level indicators for each unit.
STATUS, TRANSFER_TO_GL_FLAG, TRANSFER_TO_GRANTS_FLAG, PSB_BUDGET_FLAG, VALID_GRADE_REQD_FLAG, and POSITION_CONTROL_FLAG — lifecycle and control attributes.
DFLT_BUDGET_SET_ID — FK to PQH_DFLT_BUDGET_SETS for defaulting behavior.
Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Budget administrators and reporting analysts query PQH_BUDGETS to enumerate active budgets, drive positional-control reporting, and prepare GL or Grants transfers. A typical listing joins the shared-type dimensions referenced by the three budget unit columns:

List budgets with their period set: SELECT b.budget_name, b.status, p.period_set_name FROM pqh_budgets b, pay_calendars p WHERE b.period_set_name = p.period_set_name;
Resolve budget unit names via PER_SHARED_TYPES using BUDGET_UNIT1_ID (repeat for UNIT2/UNIT3).
Identify GL-ready budgets: filter on TRANSFER_TO_GL_FLAG = 'Y' and GL_SET_OF_BOOKS_ID IS NOT NULL.
Trace versions of a budget: JOIN to PQH_BUDGET_VERSIONS on BUDGET_ID.
Find worksheets associated with a budget: JOIN to PQH_WORKSHEETS on BUDGET_ID.

Related Objects

PER_SHARED_TYPES — referenced three times via BUDGET_UNIT1_ID, BUDGET_UNIT2_ID, and BUDGET_UNIT3_ID.
PAY_CALENDARS — referenced via PERIOD_SET_NAME.
PER_ORG_STRUCTURE_VERSIONS — referenced via ORG_STRUCTURE_VERSION_ID.
PQH_DFLT_BUDGET_SETS — referenced via DFLT_BUDGET_SET_ID.
PQH_BUDGET_VERSIONS — child table referencing PQH_BUDGETS.BUDGET_ID.
PQH_WORKSHEETS — child table referencing PQH_BUDGETS.BUDGET_ID.

Table: PQH_BUDGETS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_BUDGETS, object_name:PQH_BUDGETS, status:VALID, product: PQH - Public Sector HR , description: Stores information on budgets , implementation_dba_data: HR.PQH_BUDGETS ,
INDEX: HR.PQH_BUDGETS_PK 12.2.2
owner:HR, object_type:INDEX, object_name:PQH_BUDGETS_PK, status:VALID,
INDEX: HR.PQH_BUDGETS_PK 12.1.1
owner:HR, object_type:INDEX, object_name:PQH_BUDGETS_PK, status:VALID,
Table: PQH_BUDGETS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_BUDGETS, object_name:PQH_BUDGETS, status:VALID, product: PQH - Public Sector HR , description: Stores information on budgets , implementation_dba_data: HR.PQH_BUDGETS ,
TABLE: HR.PQH_BUDGETS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_BUDGETS, object_name:PQH_BUDGETS, status:VALID,
TABLE: HR.PQH_BUDGETS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_BUDGETS, object_name:PQH_BUDGETS, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.PQH_BGT_SHD 12.2.2
PACKAGE BODY: APPS.PQH_BGT_SHD 12.1.1
APPS.PQH_BGT_BUS dependencies on PQH_BUDGETS 12.2.2
APPS.PQH_BGT_BUS dependencies on PQH_BUDGETS 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.PQH_BGT_SHD dependencies on PQH_BUDGETS 12.2.2
APPS.PQH_BGT_SHD dependencies on PQH_BUDGETS 12.1.1
APPS.PQH_BGT_SHD dependencies on HR_UTILITY 12.2.2
APPS.PQH_BGT_SHD dependencies on HR_UTILITY 12.1.1
APPS.PQH_BGT_BUS dependencies on PQH_BGT_SHD 12.1.1
PACKAGE BODY: APPS.PQH_BGT_BUS 12.2.2
APPS.PQH_BGT_BUS dependencies on PQH_BGT_SHD 12.2.2
PACKAGE BODY: APPS.PQH_BGT_BUS 12.1.1
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,