Search Results hrfv_hires




Overview
Explore in AI Chat

Overview

HRFV_HIRES is an APPS-owned business view in the Oracle E-Business Suite Human Resources (PER) product family. It is a flexfield view template from which the flexfield view is generated, and it is catalogued in ETRM with a status of VALID for the 12.1.1 and 12.2.2 releases. In practical terms, the view consolidates the core attributes of an employee hire event into a single denormalized result set: the business group, the person, the period of service hire date, the assignment, the employment category, the organization, grade, job, position, location, and person type.

Because the view resolves the foreign keys of the assignment and period of service records into descriptive names, it serves as a convenient reporting and integration surface for hire-related analytics. Rather than joining PER_ALL_PEOPLE_F, PER_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, and the various translation and lookup tables directly, a report or interface can query HRFV_HIRES and obtain a readable hire record. The column naming is deliberately aligned with the flexfield view template convention, which allows the view to be regenerated or extended by the flexfield view generation process while preserving a stable column contract for consumers.

The search term "employment_category" maps directly to a column exposed by this view, EMPLOYMENT_CATEGORY, which is derived from PER_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY and decoded through the HR_BIS.BIS_DECODE_LOOKUP function against the EMP_CAT lookup type.

Underlying Base Objects

The ETRM metadata for release 12.2.2 documents the base objects referenced by HRFV_HIRES, including PER_ALL_PEOPLE_F, PER_ASSIGNMENTS_F (view), PER_PERIODS_OF_SERVICE, PER_PERSON_TYPES, PER_PERSON_TYPES_TL, PER_PERSON_TYPE_USAGES_F, PER_GRADES_TL, PER_JOBS_TL, HR_ALL_POSITIONS_F_TL, HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL_TL, and HR_LOOKUPS (view), together with the HR_BIS, HR_API, HR_GENERAL, HR_SECURITY, and HRI_BPL_PERSON_TYPE packages.

The view text joins the assignment to its period of service on PERIOD_OF_SERVICE_ID (outer join), then to the person, and constrains the assignment effective date to fall within the person's effective date range and the person type usage effective range. The person type usage link restricts the population to the system person type EMP, and the person type translation is filtered to USERENV('LANG'). Organization, grade, job, and position joins are outer joins, meaning an assignment without a grade, job, or position still returns a row with those descriptive columns null. The business group is resolved from a second instance of HR_ALL_ORGANIZATION_UNITS_TL. Session language filtering is applied consistently to the translated organization and person type name columns.

Key Columns

Common Use Cases and Queries

Typical uses include new-hire reporting, headcount analysis by employment category, and data extraction feeds into downstream systems. A common pattern is to summarize hires by employment category over a date range:

  • Counting hires per employment category for a period: SELECT EMPLOYMENT_CATEGORY, COUNT(*) FROM APPS.HRFV_HIRES WHERE HIRE_DATE BETWEEN :start_date AND :end_date GROUP BY EMPLOYMENT_CATEGORY;
  • Listing current employee hires with organizational detail: SELECT PERSON_NAME, EMPLOYEE_NUMBER, HIRE_DATE, EMPLOYMENT_CATEGORY, ORGANIZATION_NAME, JOB_NAME FROM APPS.HRFV_HIRES WHERE PERSON_TYPE = 'Employee';
  • Extracting hires for an interface keyed on PERSON_ID and ASSIGNMENT_ID: SELECT PERSON_ID, ASSIGNMENT_ID, HIRE_DATE, EMPLOYMENT_CATEGORY FROM APPS.HRFV_HIRES ORDER BY HIRE_DATE;

Because EMPLOYMENT_CATEGORY is returned as a decoded lookup meaning rather than a code, consumers that require the raw code should join back to HR_LOOKUPS or use the underlying assignment column directly. Reports should also be aware that the view is a template and that data security in EBS is normally enforced through HR_SECURITY rather than within the view definition itself.