Search Results asg_change_headcount




Overview
Explore in AI Chat

Overview

HR_EDW_WRK_ACTVTY_FCV is an Oracle E-Business Suite view owned by the APPS schema and classified under the HRI (Human Resources Intelligence) product family. It is a flattened, denormalized extraction view built to feed the Human Resources data warehouse and related analytical reporting layers. The view materializes one row per workforce activity / assignment change event, capturing the transactional and descriptive attributes that HR intelligence reporting requires without forcing downstream consumers to join the base HR transactional tables themselves.

Because it exposes foreign-key surrogate columns (for example PERSON_FK, ASSIGNMENT_FK, JOB_FROM_FK, JOB_TO_FK, GRADE_FROM_FK, GRADE_TO_FK, ORGANIZATION_FROM_FK, ORGANIZATION_TO_FK) alongside descriptive business keys such as ASSIGNMENT_NUMBER and CHANGE_REASON, the view is intended to support star-schema style loading. The "FCV" suffix indicates a flattened/derived view used as a staging or fact-source object rather than a transactional entity maintained by end users.

Underlying Base Objects

The ETRM 12.2.2 metadata documents no explicit referenced base objects for this view, and the supplied view text is expressed purely as a column projection list. In practice, the column set — movement, reason, probation, employment category, assignment, person, and organization attributes — corresponds to the HR assignment-change and workforce-activity sources maintained by Oracle HRMS (PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_CHANGES / movement history, PER_PEOPLE_F, and associated lookups and flexfield references). The view therefore sits above those transactional HRMS tables, resolving their foreign keys and code values into a single analytical projection.

The presence of surrogate *_FK columns and facts such as ASG_CHANGE_HEADCOUNT, ASG_CHANGE_FTE, and the DAYS_SINCE_LAST_* measures confirms its role as a bridge between HRMS transactional storage and the HR intelligence dimensional model.

Key Columns

Common Use Cases and Queries

Typical usage centres on workforce movement, probation tracking, and FTE/headcount trending. Because PROBATION_UNIT is exposed directly, analysts commonly filter or group by it when reporting upcoming probation end dates.

  • Probation reporting by unit: SELECT PROBATION_UNIT, PROBATION_PERIOD, COUNT(*) FROM APPS.HR_EDW_WRK_ACTVTY_FCV WHERE DATE_PROBATION_END IS NOT NULL GROUP BY PROBATION_UNIT, PROBATION_PERIOD;
  • Movement analysis: count of job, grade, or organization changes within a period using the *_CHANGE_FLAG columns and EFFECTIVE_START_DATE.
  • Headcount and FTE impact: aggregate ASG_CHANGE_HEADCOUNT and ASG_CHANGE_FTE by REASON_FK and BUSINESS_GROUP_ID.
  • Tenure analytics: use the DAYS_SINCE_LAST_* measures to profile time since last promotion or transfer.

The view should be treated as read-only reporting infrastructure; joins to HR intelligence dimension tables are made on the *_FK surrogate keys.