Results for “instance_fk”

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

Overview

The view HR_EDW_WRK_CMPSTN_FCV belongs to the HRI — Human Resources Intelligence product family, which Oracle classifies as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a foreign-key (FK) and measure-bearing workforce composition view designed to feed the HR Intelligence data warehouse and its associated analytics. The "FCV" suffix follows the Oracle Business Intelligence / HRMS Intelligence convention for a fact-style or flattened composition view, while "WRK_CMPSTN" denotes "workforce composition" — a subject area that measures headcount, full-time equivalent (FTE) allocation, and compensation across organizational, job, grade, geography, and time dimensions.

Because HRI is documented as obsolete, the view is not implemented in later ETRM databases and carries only historical or migration significance. Applications in 12.1.1 and early 12.2.2 environments that still reference HR Intelligence ETL processes may encounter it. Users searching for assignment_start_date are typically tracing how assignment tenure is represented in HR analytics extracts, and this view exposes the column ASSIGNMENT_START_DATE directly.

Underlying Base Objects

According to the documented view text, HR_EDW_WRK_CMPSTN_FCV is defined exclusively over a single source object: HR_EDWBV_WRK_CMPSTN_FCV. The "EDWBV" prefix indicates an Enterprise Data Warehouse base view that itself abstracts the physical composition tables and key-lookup joins. ETRM documents no further base tables for this view beyond that underlying EDW view, meaning the visible column list is projected directly from the source with no local aggregation or transformation shown in the outer definition.

The outer view adds no filter predicates or joins of its own; it is a pass-through projection that renames or aligns columns for downstream consumption. The several NULL placeholders in the SELECT list correspond to the USER_MEASURE and USER_ATTRIBUTE extensibility slots that appear in the documented column list but are not populated by the source view at the time of capture.

Key Columns

• COMPOSITION_PK — Primary surrogate key for the composition fact row.
• ASSIGNMENT_START_DATE — Start date of the assignment; used for tenure, service-band derivation, and as-of-date comparisons.
• SNAPSHOT_DATE — Effective date of the workforce snapshot, critical for time-series analytics.
• ASG_ASSIGNMENT_ID, ASG_PERSON_ID, ASG_BUSINESS_GROUP_ID — Assignment, person, and business group identifiers.
• ASG_GRADE_ID, ASG_JOB_ID, ASG_POSITION_ID, ASG_ORGANIZATION_ID, ASG_LOCATION_ID — Assignment dimension references for grade, job, position, organization, and location.
• AGE_BAND_FK, SERVICE_BAND_FK, TIME_FK, PERSON_TYPE_FK, GEOGRAPHY_FK, CURRENCY_FK — Conformed dimension foreign keys.
• COMPOSITION_HEADCOUNT, COMPOSITION_FTE — Core workforce composition measures.
• CRNT_ANNLZED_SLRY, CRNT_ANNLZED_SLRY_BC, CRRNCY_CNVRSN_RATE — Current annualized salary, salary in business-group currency, and conversion rate.
• LWST_GRD_SLRY, HGHST_GRD_SLRY — Grade salary range boundaries.
• USER_MEASURE1–5, USER_ATTRIBUTE1–15, USER_FK1–5 — Extensibility columns.

Common Use Cases and Queries

Typical usage involves extracting composition facts joined to dimensions for headcount, FTE, and compensation reporting. A representative query filtering by assignment start date is:

• SELECT COMPOSITION_PK, ASSIGNMENT_START_DATE, SNAPSHOT_DATE, COMPOSITION_HEADCOUNT, COMPOSITION_FTE, CRNT_ANNLZED_SLRY FROM HR_EDW_WRK_CMPSTN_FCV WHERE ASSIGNMENT_START_DATE BETWEEN :p_start AND :p_end;
• Aggregating FTE by grade: SELECT ASG_GRADE_ID, SUM(COMPOSITION_FTE) FROM HR_EDW_WRK_CMPSTN_FCV GROUP BY ASG_GRADE_ID;
• Snapshot headcount trend: SELECT SNAPSHOT_DATE, SUM(COMPOSITION_HEADCOUNT) FROM HR_EDW_WRK_CMPSTN_FCV GROUP BY SNAPSHOT_DATE ORDER BY 1;

Because the view is obsolete, new development should target current HR analytics extracts rather than this object.