Search Results hrfv_terminations




Overview
Explore in AI Chat

Overview

APPS.HRFV_TERMINATIONS is a business view template within the Oracle E-Business Suite Human Resources (PER) module, delivered under the APPS schema and marked VALID in the ETRM repository for releases 12.1.1 and 12.2.2. As documented, it is the business view template from which the flexfield view is generated, meaning it consolidates termination-related person, assignment, and period-of-service attributes into a single denormalized reporting structure. The view is a read-only construct; it exposes HR termination data for reporting, discovery, and integration purposes without requiring direct joins across the numerous PER base tables that store the underlying transactional records. Because it incorporates HR security and decode logic through packaged functions, it is typically consumed by Oracle Discoverer workbooks, custom reports, and downstream extracts rather than by transactional forms.

Underlying Base Objects

The documented metadata lists a broad set of base objects. These include PER_ALL_PEOPLE_F (people and applicant records), PER_ASSIGNMENTS_F (the assignment view that resolves effective-dated assignment rows), PER_PERIODS_OF_SERVICE (the termination record itself, aliased as PPOS), PER_PERSON_TYPES and PER_PERSON_TYPES_TL (person type definitions), plus the translated grade, job, and position tables PER_GRADES_TL, PER_JOBS_TL, and HR_ALL_POSITIONS_F_TL. Organizational context comes from HR_ALL_ORGANIZATION_UNITS_TL (joined twice for both the operating organization and the business group) and HR_LOCATIONS_ALL_TL for location details. Lookup decoding is provided by HR_LOOKUPS via the HR_BIS package, which implements the BIS_DECODE_LOOKUP function used for terminate reason, employment category, and budget measurement type. Length-of-service calculations are delegated to the HR_DISCOVERER package, while HRI_BPL_PERSON_TYPE, HR_API, HR_GENERAL, and HR_SECURITY supply supporting PL/SQL logic, including row-level security enforcement.

Key Columns

The view surfaces several categories of columns. Identifying attributes include BUSINESS_GROUP_NAME, PERSON_NAME, EMPLOYEE_NUMBER, and PERSON_TYPE. Termination specifics are carried in TERMINATION_DATE (PPOS.ACTUAL_TERMINATION_DATE), DATE_NOTIFIED, TERMINATE_REASON (decoded from the LEAV_REAS lookup), COMMENTS, and ACCEPTED_BY. Assignment context is represented by ASSIGNMENT_NUMBER, ORGANIZATION_NAME, GRADE_NAME, JOB_NAME, POSITION_NAME, LOCATION_NAME, EMPLOYMENT_CATEGORY, and BUDGET_MEASUREMENT_TYPE/CODE. Tenure metrics are exposed as MONTHS_IN_SERVICE, MONTHS_IN_ORGANIZATION, MONTHS_IN_GRADE, MONTHS_IN_JOB, MONTH_IN_POSITION, and MONTH_IN_LOCATION, all computed via HR_DISCOVERER.TIME_IN with a 'TERMINATE' mode. A complete set of surrogate keys follows—ASSIGNMENT_ID, PERSON_ID, BUSINESS_GROUP_ID, GRADE_ID, JOB_ID, LOCATION_ID, ORGANIZATION_ID, POSITION_ID, PERIOD_OF_SERVICE_ID, and PERSON_TYPE_ID—supporting drill-down and join operations in reporting tools.

Common Use Cases and Queries

Typical uses include termination trend analysis, turnover and tenure reporting, and feeds into HR or payroll reconciliation processes. A representative query follows:

  • Headcount attrition by organization and reason: SELECT ORGANIZATION_NAME, TERMINATE_REASON, COUNT(*) FROM HRFV_TERMINATIONS WHERE TERMINATION_DATE BETWEEN :start_date AND :end_date GROUP BY ORGANIZATION_NAME, TERMINATE_REASON;
  • Average tenure of leavers: SELECT AVG(MONTHS_IN_SERVICE) FROM HRFV_TERMINATIONS WHERE TERMINATION_DATE >= :start_date;
  • Detailed leaver listing: SELECT EMPLOYEE_NUMBER, PERSON_NAME, JOB_NAME, GRADE_NAME, TERMINATION_DATE, MONTHS_IN_SERVICE FROM HRFV_TERMINATIONS ORDER BY TERMINATION_DATE DESC;

Because the view relies on HR_SECURITY and HR_BIS decoding, results are automatically filtered to the querying user's security profile, and coded values are returned as their display meanings rather than raw lookup codes.