Results for “fv_tp_treasury_symbols”

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

Overview

FV_TP_TREASURY_SYMBOLS is a Federal Financials (FV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores Treasury symbol definitions used in federal accounting and funds management. A Treasury symbol (also called a Treasury Account Symbol, or TAS) is the standardized account identifier that links an agency's accounting data to the U.S. Treasury's central accounting system. This table holds the mapping between Treasury symbol components — such as the sub-level prefix code, agency identifier, main account code, and sub-account code — and the derived federal account symbol name, along with fiscal year and availability attributes that govern how funds may be used.

The table resides in the FV schema and contains 39 documented columns. Under the supplied heuristic Data Vault classification, which is mined from the foreign key structure and indicates a standalone object, the table is best modeled as a hub or reference dimension. It anchors Treasury symbol identities without participating in a link structure to other hubs in the documented schema. This classification is a modeling suggestion rather than an enforced design; in practice the table functions as a master reference dataset consulted by federal accounting and reporting processes.

The sole documented foreign key relationship is FV_TP_TREASURY_SYMBOLS.AGENCY_ID referencing FV_DMS_AGENCY_DEFINITIONS_ALL, confirming that every Treasury symbol is owned by a defined agency record within the Federal Financials data model.

Key Information Stored

The physical primary key is not documented in the supplied metadata, so the surrogate key is believed to be Treasury_Symbol_Id, which uniquely identifies each Treasury symbol row. The documented unique index FV_TP_TREASURY_SYMBOL_COMB_U1 defines the business key and is composed of eight columns: Sub_Level_Prefix_Code, Dept_Transfer, Agency_Id, Established_Fiscal_Yr, End_Year_Avail, Availability_Type_Code, Main_Acct_Code, and Sub_Acct_Code. Together these columns represent the composite Treasury symbol combination that must remain unique.

The most significant columns include:

• TREASURY_SYMBOL — the formatted Treasury account symbol value itself.
• FEDERAL_ACCT_SYMBOL_NAME — the descriptive name associated with the symbol, used in reports and inquiries.
• AGENCY_ID — the owning agency, with a documented foreign key to FV_DMS_AGENCY_DEFINITIONS_ALL.
• MAIN_ACCT_CODE and SUB_ACCT_CODE — the principal and subordinate account components of the symbol.
• SUB_LEVEL_PREFIX_CODE and DEPT_TRANSFER — allocation and transfer indicators used in federal accounting.
• AVAILABILITY_TYPE_CODE, ESTABLISHED_FISCAL_YR, and END_YEAR_AVAIL — define the period during which funds are available for obligation.
• AUTHORITY_DURATION_CODE — the duration authority governing the account.
• SET_OF_BOOKS_ID and ORG_ID — multi-organization and ledger context, enabling the same symbol to be used across different ledgers or operating units.
• AUTO_CREATE_FLAG#1 and AUTO_CREATE_FLAG_BETC — flags controlling automatic symbol creation behavior.
• START_DATE and END_DATE — effective dating for the Treasury symbol record.
• Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and fifteen ATTRIBUTE columns plus ATTRIBUTE_CATEGORY provide extensibility.

Common Use Cases and Queries

Typical uses include validating Treasury symbols during federal accounting entry, populating Treasury symbol lists in funds-availability and budget execution reports, and reconciling agency accounting data with Treasury central accounting records. Organizations often query this table to verify that a symbol combination exists for a given fiscal year before posting transactions.

A representative query joins the table to the agency definitions to display agency names alongside Treasury symbols:

• SELECT t.treasury_symbol, t.federal_acct_symbol_name, a.agency_name
• FROM fv.fv_tp_treasury_symbols t, fv.fv_dms_agency_definitions_all a
• WHERE t.agency_id = a.agency_id AND t.set_of_books_id = :ledger_id;

Filtering by availability attributes supports funds-availability analysis:

• SELECT treasury_symbol, availability_type_code, established_fiscal_yr, end_year_avail
• FROM fv.fv_tp_treasury_symbols
• WHERE availability_type_code = :avail_code AND agency_id = :agency_id;

Because the business key spans eight columns, lookup queries should always constrain the composite combination rather than a single column to avoid ambiguity. Reporting use cases include Treasury Account Symbol listings, agency allocation reports, and reconciliation extracts delivered to Treasury systems.

Related Objects

The most significant related objects in the documented and inferred data model are:

• FV_DMS_AGENCY_DEFINITIONS_ALL — referenced by the documented foreign key FV_TP_TREASURY_SYMBOLS.AGENCY_ID. This is the highest-confidence relationship and the natural join partner for agency-level reporting.
• FV_TP_TREASURY_SYMBOLS itself as the master reference for Treasury account symbols within Federal Financials.
• Funds control and budget execution tables in the FV schema that consume Treasury symbol identifiers for availability and appropriation processing.
• Federal accounting transaction tables that store the Treasury symbol as part of the accounting distribution.
• Set of books / ledger definitions referenced through SET_OF_BOOKS_ID, and operating unit definitions referenced through ORG_ID.

The documented relationship data classifies this table as standalone, so no additional foreign key dependencies to other hubs are formally documented. Any other associations should be confirmed against the specific EBS release and Federal Financials patch level in use.