Search Results month_in_position

Overview

APPS.HRFV_TERMINATIONS is a discoverer-oriented reporting view in Oracle E-Business Suite that consolidates terminated assignment data for HR analytics. The view joins person, assignment, period-of-service, organization, job, grade, position, and lookup information into a single denormalized result set, allowing reporting tools, concurrent programs, and integration interfaces to retrieve termination details without authoring the underlying multi-table joins manually. Its name follows the HR "FV" (Flexfield/View) convention used throughout the HRMS schema for pre-built discoverer views.

The view is registered in ETRM (E-Business Suite Technical Reference Manual) at the 12.1.1 and 12.2.2 releases under owner APPS. It exposes non-key columns derived from PER_PERIODS_OF_SERVICE, PER_ALL_PEOPLE_F, and PER_ASSIGNMENTS_F, combined with decode logic from the HR_BIS package and tenure calculations from the HR_DISCOVERER package. The user search term "month_in_position" corresponds directly to an exposed column, which is produced by the HR_DISCOVERER.TIME_IN function and is one of several tenure metrics calculated at termination.

Underlying Base Objects

The documented base objects reference a mix of synonyms, views, and packages. The principal data objects are PER_PERIODS_OF_SERVICE (termination dates and leaving reason), PER_ALL_PEOPLE_F (person name, employee number, person type), PER_ASSIGNMENTS_F (assignment number, employment category, organization, grade, job, position, location), PER_GRADES_TL, PER_JOBS_TL, PER_JOBS_TL-equivalent HR_ALL_POSITIONS_F_TL, HR_ALL_ORGANIZATION_UNITS_TL, and HR_LOCATIONS_ALL_TL for the descriptive name columns. PER_PERSON_TYPES and PER_PERSON_TYPES_TL supply person type decoding. HR_LOOKUPS supplies lookup values for budget measurement, leaving reason, and employment category.

Several objects are program units rather than tables. HRI_BPL_PERSON_TYPE supplies the employee and user-concatenated person type derivations. HR_DISCOVERER supplies the TIME_IN function used for all tenure columns. HR_BIS supplies BIS_DECODE_LOOKUP for lookup translation. HR_API, HR_GENERAL, and HR_SECURITY are referenced—the latter applying the standard HR security predicate so that the view respects organization and person security profiles configured in the installation.

Key Columns

• business_group_name, person_name, employee_number — Identity and legal employer context for the terminated person.
• termination_date, date_notified — Actual termination date and the notified termination date from PER_PERIODS_OF_SERVICE.
• terminate_reason, employment_category, budget_measurement_type — Lookup-decoded values rendered through HR_BIS.BIS_DECODE_LOOKUP.
• assignment_number, organization_name, grade_name, job_name, position_name, location_name — Assignment context at termination.
• months_in_service, months_in_organization, months_in_grade, months_in_job — Tenure metrics returned by HR_DISCOVERER.TIME_IN using the SERVICE, ORGANIZATION, GRADE, and JOB dimensions respectively.
• month_in_position, month_in_location — Tenure in the current POSITION and LOCATION, again calculated by HR_DISCOVERER.TIME_IN at the TERMINATE point. Of particular interest to users searching "month_in_position," this column reports the number of months the employee occupied the terminated position.
• person_type, employee_person_type, user_concat_person_type, system_person_type_code — Person type classification supplied by HRI_BPL_PERSON_TYPE and PER_PERSON_TYPES during the termination period.
• comments, accepted_by — Free-text comments and the name of the person who accepted the termination.
• assignment_id, business_group_id, grade_id, job_id, location_id, organization_id, period_of_service_id, person_id, position_id, person_type_id — Surrogate keys retained for downstream joins.

Common Use Cases and Queries

Typical uses include termination trend reporting, tenure analysis (for example, average months in position before departure), and feeds to downstream HR data warehouses. The view is frequently filtered by termination date range and business group.

SELECT person_name,
       employee_number,
       terminate_reason,
       termination_date,
       months_in_service,
       month_in_position
  FROM apps.hrfv_terminations
 WHERE termination_date BETWEEN :from_date AND :to_date
   AND business_group_name = :bg_name
 ORDER BY termination_date DESC;

A position-tenure query isolates the searched column to identify roles with unusually short occupancy:

SELECT position_name, COUNT(*) terminations,
       ROUND(AVG(month_in_position), 2) avg_months_in_position
  FROM apps.hrfv_terminations
 WHERE termination_date >= ADD_MONTHS(SYSDATE, -12)
 GROUP BY position_name
 HAVING COUNT(*) > 1
 ORDER BY avg_months_in_position;

Because the view calls PL/SQL functions in HR_DISCOVERER and HR_BIS for every returned row, and applies HR_SECURITY predicates, queries over large populations should be constrained by date and business group to avoid full-scan evaluation of those functions. Organizations matching on the underlying entities should join back on the exposed surrogate ID columns rather than names.