Search Results budgetary_controls_id




Overview
Explore in AI Chat

Overview

The GMS_BUDGETARY_CONTROLS table is a core data object within the Oracle E-Business Suite Grants Accounting (GMS) module, specifically in versions 12.1.1 and 12.2.2. It serves as the master repository for defining the budgetary control level for sponsored awards. This table is fundamental to enforcing financial compliance by determining the granularity at which budget versus actual expenditure tracking and validation occurs. The control level can be set at various organizational dimensions, including the award, task, resource group, and resource levels, thereby providing the flexibility to meet specific sponsor or institutional requirements for fund management.

Key Information Stored

The table's primary purpose is to store distinct budgetary control configurations. As indicated by the provided ETRM metadata, its central and primary key column is BUDGETARY_CONTROLS_ID. This unique identifier acts as a foreign key in numerous transactional and control tables throughout the GMS schema. While the full column list is not detailed in the excerpt, based on its described function, the table typically stores records that define the combination of control levels (e.g., Award-Task-Resource) and link to the specific award or project. Other likely columns include AWARD_ID, TASK_ID, and flags or codes designating the enabled control levels for budget checking and funds reservation.

Common Use Cases and Queries

The primary use case is to retrieve the budgetary control setup for a specific award or project to determine the rules for expenditure validation. This is critical during invoice creation, expenditure batch processing, and funds reservation. A common reporting need is to list all awards with their corresponding budgetary control levels. Sample SQL to achieve this, joining to the award master table, would be:

  • SELECT gbc.BUDGETARY_CONTROLS_ID, pa.AWARD_NUMBER, gbc.* FROM GMS_BUDGETARY_CONTROLS gbc, GMS_AWARDS_ALL pa WHERE gbc.AWARD_ID = pa.AWARD_ID;

Another frequent query involves checking if a specific task or resource group is under budgetary control for a given award by filtering on the BUDGETARY_CONTROLS_ID and the relevant level identifier.

Related Objects

The GMS_BUDGETARY_CONTROLS table is a key reference table with a primary key relationship to many other GMS tables. As documented, the primary key constraint GMS_BUDGETARY_CONTROLS_PK is defined on the BUDGETARY_CONTROLS_ID column. This column is consequently referenced as a foreign key in transactional tables that require budget validation. Common related objects include expenditure tables (e.g., GMS_EXPENDITURE_ITEMS_ALL), funds reservation tables, and budget revision tables. These child tables will contain a BUDGETARY_CONTROLS_ID column to enforce referential integrity and ensure every financial transaction is associated with a defined control level.