Results for “dept_transfer”

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

Overview

FV_TREASURY_SYMBOLS is a Federal Financials (FV) base table in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the configuration store for Treasury Symbol definitions maintained through the Define Appropriation Parameters form. A Treasury Symbol (also referred to as a TAS — Treasury Account Symbol) represents the appropriation or fund account structure used for federal budgeting, execution, and reporting. Each row in this table describes how a specific Treasury Symbol behaves for a given ledger, including its fund group, time frame, availability period, and reporting characteristics.

The table resides in the FV schema and contains 63 documented columns. Its structure supports the definition of appropriation parameters, SF-224 outlay reporting, GTAS reportability, and FACTS federal account reporting. From a Data Vault modeling perspective, the mined heuristic classification is standalone, meaning the table does not behave as a classic hub, link, or satellite, but rather as an independent reference or configuration entity. Modelers may treat the natural business key (Treasury Symbol combined with Set of Books) as a candidate hub key, with descriptive and fiscal attributes acting as satellite-style data, though the table itself is a conventional base table.

Key Information Stored

The primary key is defined by the unique index FV_TREASURY_SYMBOL_ID (TREASURY_SYMBOL_ID), which is the surrogate identifier for each appropriation parameter record. A second unique index, FV_TREASURY_SYMBOL_TSSOB_UNQ, defines the business-key candidate combination of TREASURY_SYMBOL and SET_OF_BOOKS_ID, ensuring that a Treasury Symbol is uniquely defined within a ledger. An additional unique constraint, FV_TREASURY_SYMBOL_TS_UNQ, exists on TREASURY_SYMBOL alone.

The most significant columns include:

• TREASURY_SYMBOL and TREASURY_SYMBOL_ID — the human-readable and surrogate identifiers of the appropriation account.
• SET_OF_BOOKS_ID — the ledger to which the symbol belongs.
• SF224_TYPE_CODE — governs SF-224 reporting classification.
• FUND_GROUP_CODE, FUND_TYPE, and FINANCING_ACCOUNT — define fund classification and financing behavior.
• TIME_FRAME, ESTABLISHED_FISCAL_YR, YEARS_AVAILABLE, END_YEAR_AVAIL, and START_DATE — control appropriation period and availability.
• DEPARTMENT_ID, BUREAU_ID, and FEDERAL_ACCT_SYMBOL_ID — organizational and federal account linkage.
• TAFS_SUB_ACCT, TAFS_SPLIT_CODE, TAFS_SPLIT_NAME, and PUBLIC_LAW_CODE — TAFS-level detail and legislative references.
• SF224_QTR1_OUTLAY through SF224_QTR4_OUTLAY — quarterly outlay amounts.
• FACTS_REPORTABLE_INDICATOR and GTAS_REPORTABLE_INDICATOR — drive downstream federal reporting.
• AUTO_CREATE, AUTO_CREATE_FLAG_BETC, and AVAILABILITY_TYPE_CODE — automate appropriation setup and availability rules.

Common Use Cases and Queries

Typical use cases include validating appropriation parameters, reconciling SF-224 outlay data, and extracting Treasury Symbol configurations for GTAS and FACTS reporting. A common query retrieves all symbols for a ledger:

• SELECT treasury_symbol, fund_group_code, years_available, gtas_reportable_indicator FROM fv_treasury_symbols WHERE set_of_books_id = :ledger_id;
• Join to FV_FACTS_FEDERAL_ACCOUNTS on federal_acct_symbol_id to enrich federal account attributes.
• Join to BOM_DEPARTMENTS on department_id for organizational reporting.
• Filter on sf224_type_code or facTS_reportable_indicator for specific report extracts.

Related Objects

FV_TREASURY_SYMBOLS has two documented foreign key relationships and participates in federal reporting integrations. Significant related objects include:

• BOM_DEPARTMENTS — referenced via DEPARTMENT_ID for organizational context.
• FV_FACTS_FEDERAL_ACCOUNTS — referenced via FEDERAL_ACCT_SYMBOL_ID for federal account definitions.
• FV_APPROPRIATION_PARAMETERS (logical form target) — the Define Appropriation Parameters form populates and maintains this table.
• GL_SETS_OF_BOOKS / GL_LEDGERS — joined via SET_OF_BOOKS_ID for ledger validation.
• FV_SF224-related reporting objects — consume SF224_TYPE_CODE and quarterly outlay columns.
• GTAS and FACTS extraction programs — rely on GTAS_REPORTABLE_INDICATOR and FACTS_REPORTABLE_INDICATOR flags.