Results for “new_master_flag”

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

Overview

PA_PROJECT_ASSET_LINES_ALL is a core Projects (PA) module table that stores summarized Capitalized Interest and Project (CIP) costs eligible for capitalization and transfer to Oracle Assets (FA). It acts as the staging and audit backbone for the Project-to-Assets integration flow, capturing the aggregated cost lines that Projects generates before they are passed to Fixed Assets as mass additions, asset invoices, or adjustments. Each row represents a summarized asset line tied to a project, task, and project asset definition, with amounts expressed in both original and current asset cost terms.

The ETRM metadata classifies this table heuristically as satellite-leaning in Data Vault terms. This reflects its role as a detail-bearing structure that holds descriptive and financial attributes around a central project asset business key, rather than acting as a pure hub or associative link. Practitioners modeling this table in a Data Vault or dimensional context should treat PROJECT_ASSET_LINE_ID as the durable business key and the surrounding cost, category, and transfer attributes as satellite payload.

Key Information Stored

The table contains 46 documented columns. The most operationally significant include:

• PROJECT_ASSET_LINE_ID — surrogate primary key, enforced by PA_PROJECT_ASSET_LINES_PK and the unique index PA_PROJECT_ASSET_LINES_U1; the primary business-key candidate.
• PROJECT_ASSET_ID — foreign key to PA_PROJECT_ASSETS_ALL, linking the line to its parent asset definition.
• PROJECT_ID and TASK_ID — foreign keys to PA_PROJECTS_ALL and PA_TASKS, identifying the originating project and task.
• ASSET_CATEGORY_ID — foreign key to FA_CATEGORIES_B, defining the asset category used at transfer.
• ORIGINAL_ASSET_COST and CURRENT_ASSET_COST — the summarized cost amounts carried from CIP to FA.
• CIP_CCID and ASSET_COST_CCID — the CIP and asset cost distribution account combinations.
• TRANSFER_STATUS_CODE and TRANSFER_REJECTION_REASON — status and diagnostic information for lines sent to Assets.
• GL_DATE and FA_PERIOD_NAME — accounting date and the Fixed Assets period into which the line was transferred.
• CAPITAL_EVENT_ID — foreign key to PA_CAPITAL_EVENTS, tying the line to the capital event that generated it.
• REV_PROJ_ASSET_LINE_ID / REV_FROM_PROJ_ASSET_LINE_ID — self-referencing reversal linkage for reversal and adjustment processing.
• LINE_TYPE and RETIREMENT_COST_TYPE — classify the line for transfer and retirement handling.

Common Use Cases and Queries

Typical uses include reconciling CIP balances transferred to Fixed Assets, diagnosing rejected mass additions, and reporting capitalized cost by project or category. A general reconciliation query:

• Join PA_PROJECT_ASSET_LINES_ALL to PA_PROJECTS_ALL and PA_TASKS to report cost by project and task, filtering on TRANSFER_STATUS_CODE to isolate pending, transferred, or rejected lines.
• Join to FA_MASS_ADDITIONS and FA_ASSET_INVOICES on PROJECT_ASSET_LINE_ID to confirm which lines reached Assets and to trace asset numbers.
• Filter on RET_ADJUSTMENT_TXN_ID to identify lines tied to retirement or adjustment transactions in FA_TRANSACTION_HEADERS.
• Group by ASSET_CATEGORY_ID and FA_PERIOD_NAME for period-close capitalization reporting.

The user query fa_deleted_mass_additions is directly relevant: FA_DELETED_MASS_ADDITIONS references this table via PROJECT_ASSET_LINE_ID, so investigators tracing deleted or purged mass additions should join that FA table back to PA_PROJECT_ASSET_LINES_ALL to recover the original CIP source line and project context.

Related Objects

• PA_PROJECTS_ALL and PA_TASKS — parent project and task, joined on PROJECT_ID and TASK_ID.
• PA_PROJECT_ASSETS_ALL — parent project asset, joined on PROJECT_ASSET_ID.
• FA_CATEGORIES_B — asset category definition, joined on ASSET_CATEGORY_ID.
• PA_CAPITAL_EVENTS — capital event source, joined on CAPITAL_EVENT_ID.
• FA_ASSET_INVOICES, FA_MASS_ADDITIONS, FA_DELETED_MASS_ADDITIONS, and FA_MC_ASSET_INVOICES — downstream Assets objects referencing PROJECT_ASSET_LINE_ID.
• PA_PROJECT_ASSET_LINE_DETAILS — detail-level breakdown, linked via PROJECT_ASSET_LINE_DETAIL_ID.
• FA_TRANSACTION_HEADERS — retirement and adjustment transactions, joined on RET_ADJUSTMENT_TXN_ID.