Results for “do_not_purge_flag”

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

Overview

FV_TREASURY_SYMBOLS_HISTORY is a base table in the FV (Federal Financials) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It serves as the historical repository populated by the Purge Treasury Symbols process, archiving treasury symbol records that have been superseded, expired, or otherwise removed from the operational FV_TREASURY_SYMBOLS table before purging. The table is owned by the FV schema and contains 64 documented columns in the 12.2.2 physical schema.

Heuristic Data Vault classification derived from the foreign-key structure is standalone. No parent-child dependencies were mined from the FK graph, which suggests a self-contained, audit-oriented archival design rather than a classic dimensional hub or satellite. Modelers treating this table as a satellite should note that the absence of a documented hub FK limits the strict Data Vault interpretation.

Key Information Stored

The table preserves the full treasury-symbol record set for historical and audit reporting. The most significant columns include:

• TREASURY_SYMBOL and TREASURY_SYMBOL_ID — the business identifier and surrogate for each treasury symbol (TAFS/TAS combination) archived from the transactional source.
• SET_OF_BOOKS_ID — the ledger context; combined with TREASURY_SYMBOL it forms the unique business key FV_TREASURY_SYM_HIST_TSSOB_UNQ.
• SF224_TYPE_CODE and the four SF224_QTR1–QTR4_OUTLAY columns — Treasury SF-224 quarterly outlay balances.
• FUND_GROUP_CODE, FUND_TYPE, BUSINESS_LINE, RESOURCE_TYPE — fund and resource classification attributes.
• DEPARTMENT_ID and BUREAU_ID — organizational ownership; DEPARTMENT_ID carries an FK to BOM_DEPARTMENTS.
• FEDERAL_ACCT_SYMBOL_ID — FK to FV_FACTS_FEDERAL_ACCOUNTS, tying the row to a federal account symbol.
• DATE_PURGED, REQUEST_ID — audit trail identifying when and by which concurrent request the row was purged.
• DO_NOT_PURGE_FLAG, TS_FLAG, OPEN_FLAG, DEF_INDEF_FLAG — control flags retained for retention decisions.
• ESTABLISHED_FISCAL_YR, EXPIRATION_DATE, CANCELLATION_DATE, START_DATE — lifecycle dates.
• ORG_ID — multi-org operating unit context.

Two primary key indexes are documented: FV_TREASURY_SYM_HIST_TSSOB_UNQ on (TREASURY_SYMBOL, SET_OF_BOOKS_ID), and FV_TREASURY_SYM_HIST_TS_UNQ on (TREASURY_SYMBOL). The ATTRITBUTE1–15 and ATTRIBUTE_CATEGORY columns preserve the flexible descriptive flexfield values from the source record.

Common Use Cases and Queries

The primary use case is post-purge audit reconstruction: verifying that a treasury symbol removed from FV_TREASURY_SYMBOLS was correctly archived, and retrieving the last-known balances and attributes. A representative audit query:

• SELECT treasury_symbol, set_of_books_id, date_purged, request_id FROM fv.fv_treasury_symbols_history WHERE treasury_symbol = :symbol;
• Reconstruction of SF-224 outlay data for a prior fiscal year: join on TREASURY_SYMBOL and SET_OF_BOOKS_ID against current-year balances.
• Retention reporting using DO_NOT_PURGE_FLAG and EXPIRATION_DATE to confirm statutory holding periods.
• Reconciliation between treasury symbols purged by a specific concurrent request and the FV_FACTS_FEDERAL_ACCOUNTS authoritative set.

Related Objects

• FV_TREASURY_SYMBOLS — the operational source table from which rows are archived prior to purge; join on TREASURY_SYMBOL and SET_OF_BOOKS_ID.
• BOM_DEPARTMENTS — joined via DEPARTMENT_ID; supplies department names for historical reporting.
• FV_FACTS_FEDERAL_ACCOUNTS — joined via FEDERAL_ACCT_SYMBOL_ID; the federal account symbol master.
• FND_CONCURRENT_REQUESTS — joined via REQUEST_ID to identify the originating Purge Treasury Symbols run.
• HR_ALL_ORGANIZATION_UNITS — resolved through ORG_ID for multi-org reporting context.