Results for “original_flag”

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

Overview

PA_BUDGET_VERSIONS_AR is an Oracle Projects (PA) archive/purge table owned by the PA schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the archive counterpart to the transactional PA_BUDGET_VERSIONS table, holding rows that have been extracted from the production budget-versions structures during an archive or purge operation. As documented in the ETRM metadata, the table exists specifically to support Archive/Purge processing, and its column semantics mirror those of the main table ("Refer to comments on the columns in the main table"). Each record represents an archived project budget version — a discrete, numbered iteration of a project's cost or revenue budget — together with the purge context that identifies the batch and release under which the row was archived.

The heuristic Data Vault classification derived from the foreign-key structure is standalone. This reflects the fact that PA_BUDGET_VERSIONS_AR does not itself act as a hub or link within the derived model; it is better modeled as a type-2 satellite-style history or archival store keyed by its own surrogate identifier, with a single documented outbound foreign key to PA_PURGE_BATCHES_ALL.

Key Information Stored

The table contains 48 documented columns. The most significant are:

• PURGE_BATCH_ID — Foreign key to PA_PURGE_BATCHES_ALL; identifies the purge batch that archived the row and is the anchor for the archive/purge framework.
• PURGE_RELEASE — The release identifier associated with the purge batch.
• PURGE_PROJECT_ID — The project identifier under which the purge was executed.
• BUDGET_VERSION_ID — Surrogate primary key of the archived budget version; the principal unique identifier for a row.
• PROJECT_ID — Business-key candidate; the project to which the budget version belongs.
• BUDGET_TYPE_CODE — Indicates whether the version is a cost budget or a revenue budget.
• VERSION_NUMBER and VERSION_NAME — Business-key candidates forming the user-visible version identity alongside PROJECT_ID and BUDGET_TYPE_CODE.
• BUDGET_STATUS_CODE — Lifecycle state of the version (for example, working, submitted, or baselined).
• CURRENT_FLAG, ORIGINAL_FLAG, and CURRENT_ORIGINAL_FLAG — Indicators of which version is current and/or original for the project.
• BASELINED_BY_PERSON_ID and BASELINED_DATE — Who baselined the version and when.
• LABOR_QUANTITY, RAW_COST, BURDENED_COST, REVENUE — Monetary and quantity measures summarizing the version.
• FIRST_BUDGET_PERIOD and PM_PRODUCT_CODE — Period context and product-origin indicator.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield columns.

Common Use Cases and Queries

Because the table is archival, queries typically support audit, reconciliation, and reporting on purged budget data rather than live transaction processing. A common pattern joins the archive table to the purge batch table to identify what was removed in a specific run:

• Select all archived budget versions for a purge batch: SELECT * FROM pa.pa_budget_versions_ar WHERE purge_batch_id = :batch_id;
• Reconcile counts between archive and source: SELECT project_id, COUNT(*) FROM pa.pa_budget_versions_ar GROUP BY project_id;
• Recover historical measures for a project: SELECT version_number, raw_cost, burdened_cost FROM pa.pa_budget_versions_ar WHERE project_id = :project_id;
• Audit who baselined archived versions: SELECT baselined_by_person_id, baselined_date FROM pa.pa_budget_versions_ar;

Related Objects

The principal related objects are:

• PA_PURGE_BATCHES_ALL — Joined via PURGE_BATCH_ID; the parent purge-batch definition.
• PA_BUDGET_VERSIONS — The live source table from which archived rows originate.
• PA_BUDGET_LINES and PA_BUDGET_LINES_AR — Line-level details corresponding to each archived version.
• PA_PROJECTS_ALL — Projects referenced via PROJECT_ID.
• PA_BUDGET_TYPES — Lookup for BUDGET_TYPE_CODE semantics.
• PER_ALL_PEOPLE_F — Person details for BASELINED_BY_PERSON_ID.