Results for “per_assignment_budget_valu_efc”

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

Overview

PER_ASSIGNMENT_BUDGET_VALU_EFC is a table owned by the HR schema within the PER (Human Resources) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is a Euro-as-Functional-Currency (EFC) shadow table: specifically, it is a copy of PER_ASSIGNMENT_BUDGET_VALUES_F that is populated and maintained by the EFC conversion process. The EFC program exists to support organizations that have adopted the Euro as their functional currency, producing parallel records whose monetary amounts are converted into that currency while the original operational rows remain intact. In this sense the table is not a primary transactional store but a segregated, process-generated companion to the assignment budget values entity.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. This is consistent with the table's shape: it is keyed to the parent assignment budget value and carries a foreign key to a process/action table, making it a descriptive, process-tagged extension of the parent business key rather than a hub of its own. Practitioners modeling this structure should treat it as a satellite dependent on the assignment budget value business key, with EFC_ACTION_ID acting as an additional qualifying component.

Key Information Stored

The documented column set is compact (six columns), and the significant columns are as follows:

• ASSIGNMENT_BUDGET_VALUE_ID — the identifier of the underlying assignment budget value record, inherited from the source table. It forms the leading component of the primary key.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the date-effective range of the copied row, preserving the temporal context of the source assignment budget value.
• EFC_ACTION_ID — the EFC process action that produced the row; this is a foreign key to HR_EFC_ACTIONS and is the last component of the primary key, allowing the same assignment budget value and date range to appear under multiple EFC runs.
• VALUE — the budget value amount carried by the copy, expressed for the EFC context.
• EFC_BG_CURRENCY — the currency attribute associated with the EFC budget group conversion.

The surrogate/primary key is PER_ASSIGNMENT_BUDGET_V_EFC_PK, defined over ASSIGNMENT_BUDGET_VALUE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and EFC_ACTION_ID. The metadata documents this single unique index as the business-key candidate; no separate natural-key index is listed. Because EFC_ACTION_ID participates in the unique key, the same logical budget value may be stored once per EFC action, which is an important consideration when deduplicating or reconciling EFC output.

Common Use Cases and Queries

The principal use case is validation and reconciliation of the EFC conversion process. Reporting queries typically join this table back to the source PER_ASSIGNMENT_BUDGET_VALUES_F on ASSIGNMENT_BUDGET_VALUE_ID plus the date-effective range to confirm that converted values exist for every eligible row. A representative pattern:

• Comparing EFC output against source rows: SELECT b.ASSIGNMENT_BUDGET_VALUE_ID, b.VALUE, e.VALUE AS EFC_VALUE FROM PER_ASSIGNMENT_BUDGET_VALUES_F b, PER_ASSIGNMENT_BUDGET_VALU_EFC e WHERE b.ASSIGNMENT_BUDGET_VALUE_ID = e.ASSIGNMENT_BUDGET_VALUE_ID AND e.EFC_ACTION_ID = :action.
• Auditing which EFC run produced a row by joining EFC_ACTION_ID to HR_EFC_ACTIONS.
• As-of reporting on converted budget values, filtering on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to reconstruct historical EFC positions.
• Detecting orphaned or duplicate rows by grouping on the four primary key columns.

Because the table is process-generated, it should not be used as the transactional source of record for assignment budgets; writes are normally performed by the concurrent EFC program rather than by application users.

Related Objects

• PER_ASSIGNMENT_BUDGET_VALUES_F — the source table from which this EFC copy is derived; joined on ASSIGNMENT_BUDGET_VALUE_ID and the effective dates.
• HR_EFC_ACTIONS — referenced by the foreign key PER_ASSIGNMENT_BUDGET_VALU_EFC.EFC_ACTION_ID → HR_EFC_ACTIONS; identifies the EFC action/run that created each row.
• PER_ASSIGNMENT_BUDGET_VALUES_F_EFC and any sibling EFC table for the corresponding _F entity, which follow the same copy-and-convert pattern.
• PER_ASSIGNMENTS_F — the assignment header table to which budget values ultimately relate, useful when reporting EFC amounts by assignment or person.
• Other HR EFC shadow tables governed by the same HR_EFC_ACTIONS foreign key, which allow consolidated EFC reporting across PER entities.