Results for “encumb_period_to_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMS_BALANCES is a core table in the Oracle E-Business Suite Grants Accounting (GMS) module, present in both release 12.1.1 and 12.2.2. It stores the balance of budgets, actual costs, and encumbrance costs associated with sponsored projects, tasks, and awards. The table functions as a summarized repository of period-based financial activity, allowing grants administrators and project accountants to compare planned values against committed and actual expenditures across a defined accounting timeline.

The table is owned by the GMS schema and holds 21 documented columns in the ETRM 12.2.2 physical schema. Because its row identity is composed entirely of foreign key references and descriptive attributes rather than a single surrogate numeric key, the metadata's heuristic Data Vault classification of this object as a link is appropriate. In a Data Vault modeling exercise, GMS_BALANCES would typically be treated as a link table connecting projects, tasks, awards, budgets, resources, and the general ledger set of books, with the period-to-date measures modeled as link satellites or effectivity satellites.

Key Information Stored

The most important columns in GMS_BALANCES fall into two groups: the composite key elements and the balance measures.

• PROJECT_ID — references PA_PROJECTS_ALL and identifies the sponsored project whose balances are recorded.
• TASK_ID — references PA_TASKS and narrows the balance to a specific project task.
• AWARD_ID — references IGF_AW_AWARD_ALL and identifies the funding award behind the transaction.
• RESOURCE_LIST_MEMBER_ID and PARENT_MEMBER_ID — both reference PA_RESOURCE_LIST_MEMBERS, linking balances to resource list members and their parent hierarchy.
• SET_OF_BOOKS_ID — references GL_SETS_OF_BOOKS_11I and identifies the ledger in which the amounts reside.
• BUDGET_VERSION_ID — references PA_BUDGET_VERSIONS and identifies the budget version against which balances are tracked.
• START_DATE and END_DATE — define the validity window for the balance record.
• BALANCE_TYPE — classifies the balance category.
• PERIOD_NAME — the GL accounting period for the balance row.
• ACTUAL_PERIOD_TO_DATE, REVENUE_PERIOD_TO_DATE, BUDGET_PERIOD_TO_DATE, and ENCUMB_PERIOD_TO_DATE — the four primary period-to-date measures representing actual cost, revenue, budget, and encumbrance amounts.

The unique index GMS_BALANCES_U1 on (PROJECT_ID, AWARD_ID, TASK_ID, SET_OF_BOOKS_ID, BUDGET_VERSION_ID, RESOURCE_LIST_MEMBER_ID, BALANCE_TYPE, START_DATE, END_DATE) serves as the business-key candidate for the table.

Common Use Cases and Queries

Reporting against GMS_BALANCES typically addresses budget-versus-actual comparisons, encumbrance tracking, and award-level fund utilization. A representative query pattern joins the table to PA_PROJECTS_ALL and PA_TASKS for descriptive context:

• Budget-to-actual variance reporting by project, task, and ledger, using BUDGET_PERIOD_TO_DATE and ACTUAL_PERIOD_TO_DATE.
• Encumbrance exposure analysis by filtering on ENCUMB_PERIOD_TO_DATE for a given PERIOD_NAME.
• Award-level period comparison across consecutive periods to detect spending trends.
• Reconciliation extracts feeding downstream grant billing and letter-of-credit drawdown processes.

Queries commonly drill from PROJECT_ID and AWARD_ID, filter by SET_OF_BOOKS_ID and PERIOD_NAME, and aggregate the four period-to-date amount columns.

Related Objects

GMS_BALANCES depends on the following principal objects through documented foreign keys:

• PA_PROJECTS_ALL via PROJECT_ID — project definition master.
• PA_TASKS via TASK_ID — task structure for the project.
• PA_TOP_TASKS_IT via TOP_TASK_ID — top-level task reference.
• IGF_AW_AWARD_ALL via AWARD_ID — award header information.
• PA_BUDGET_VERSIONS via BUDGET_VERSION_ID — budget version definition.
• PA_RESOURCE_LIST_MEMBERS via RESOURCE_LIST_MEMBER_ID and PARENT_MEMBER_ID — resource list linkage and rollup hierarchy.
• GL_SETS_OF_BOOKS_11I via SET_OF_BOOKS_ID — ledger definition.

These relationships confirm the table's role as a convergence point for project costing, budgeting, awards, and general ledger structures within Grants Accounting.