Results for “budget_acct_code”

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

Overview

FV_FACTS_BUDGET_ACCOUNTS is a Federal Financials (FV) product table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores budget account codes and their related descriptive and classification information. It functions as a reference or dimension table within the FV facts infrastructure, supplying the budget account codes that are subsequently referenced by transactional fact tables such as FV_FACTS_BUD_FED_ACCTS. The table is owned by the FV schema and is documented as VALID in ETRM, containing 31 columns.

From a heuristic Data Vault modeling perspective, the mined FK structure indicates that FV_FACTS_BUDGET_ACCOUNTS is a standalone table with no outbound foreign keys to other tables; tables such as FV_FACTS_BUD_FED_ACCTS reference it rather than the reverse. This pattern is consistent with a hub-style classification, where BUDGET_ACCT_CODE_ID acts as the durable business key and the remaining descriptive columns behave like satellite attributes. This classification is offered as a modeling suggestion only, based on the mined relationship data.

Key Information Stored

The table's surrogate primary key is defined by FV_FACTS_BUDGET_ACCOUNTS_PK, which is built on the BUDGET_ACCT_CODE_ID column. A second unique index, FV_FACTS_BUDGET_ACCOUNTS_U2, also covers BUDGET_ACCT_CODE_ID. The business-key candidate is captured in the composite unique index FV_FACTS_BUDGET_ACCOUNTS_U1, spanning SET_OF_BOOKS_ID, BUDGET_ACCT_CODE, BUDGET_BUREAU_CODE, and AGENCY_IDENTIFIER.

• BUDGET_ACCT_CODE_ID — surrogate primary key identifying each budget account code record.
• BUDGET_ACCT_CODE — the budget account code itself, part of the business-key candidate.
• BUDGET_ACCT_NAME — descriptive name of the budget account code.
• SET_OF_BOOKS_ID — the ledger context for the account code; this does not appear to be a foreign key to GL_SETS_OF_BOOKS per the mined data.
• AGENCY_IDENTIFIER — the federal agency associated with the account code.
• BUDGET_BUREAU_CODE — the budget bureau classification.
• BEA_CATEGORY — Bureau of Economic Analysis category classification.
• BORROWING_SOURCE — indicator of the borrowing source associated with the account.
• BUDGET_STATUS_INDICATOR — status flag for the budget account.
• BUDGET_FUNCTION — functional classification of the budget account.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard Oracle descriptive flexfield (DFF) columns providing extensibility for agency-specific data.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — standard who-column tracking.

Common Use Cases and Queries

The table is primarily used to resolve budget account codes into descriptive labels for reporting, and to validate or join fact data stored in FV_FACTS_BUD_FED_ACCTS. A typical join retrieves the budget account description alongside federal account facts:

SELECT b.BUDGET_ACCT_CODE, b.BUDGET_ACCT_NAME, b.AGENCY_IDENTIFIER,
       f.FEDERAL_ACCOUNT_ID
FROM   FV.FV_FACTS_BUDGET_ACCOUNTS b,
       FV.FV_FACTS_BUD_FED_ACCTS  f
WHERE  b.BUDGET_ACCT_CODE_ID = f.BUDGET_ACCT_CODE_ID
AND    b.SET_OF_BOOKS_ID = :p_set_of_books_id;

Because the table is small and reference-like, it is also useful for value-set style lookups keyed on BUDGET_ACCT_CODE, for auditing unused account codes, and for agency-specific extracts that filter on AGENCY_IDENTIFIER or BUDGET_BUREAU_CODE. Reporting on the DFF columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1–15) is common where federal agencies store supplemental classifications in the flexfield.

Related Objects

• FV_FACTS_BUD_FED_ACCTS — the principal dependent table; joins on BUDGET_ACCT_CODE_ID, which is a foreign key to FV_FACTS_BUDGET_ACCOUNTS.
• FV_FACTS_BUDGET_ACCOUNTS_PK — the primary key index on BUDGET_ACCT_CODE_ID.
• FV_FACTS_BUDGET_ACCOUNTS_U1 — composite unique index supporting the business-key candidate (SET_OF_BOOKS_ID, BUDGET_ACCT_CODE, BUDGET_BUREAU_CODE, AGENCY_IDENTIFIER).
• FV_FACTS_BUDGET_ACCOUNTS_U2 — unique index on BUDGET_ACCT_CODE_ID.
• Other FV facts and summary tables, plus Federal Financials reports and concurrent programs, consume the budget account codes defined here.