Search Results system_person_type_code




Overview
Explore in AI Chat

Overview

APPS.HRFV_HIRES is a Business Intelligence System (BIS) view owned by the APPS schema and registered in FND Design Data under the product identifier PER (Human Resources). It is classified as VALID and is documented for Oracle EBS 12.1.1 and 12.2.2. The view presents hires into the enterprise, effective as of the employee's hire date, for every period of service served by the employee. Termination dates are also exposed, allowing each period of service to be reported as a discrete hire-to-termination span. Because the object is a view rather than a table, it carries no storage of its own; it is a read-only reporting construct intended for operational and analytical queries against workforce entry data.

The view is particularly relevant to searches involving employee_person_type. It exposes three person type-related columns — PERSON_TYPE, EMPLOYEE_PERSON_TYPE, and USER_CONCAT_PERSON_TYPE — alongside SYSTEM_PERSON_TYPE_CODE and PERSON_TYPE_ID, which together let consumers distinguish system person types (for example, Employee, Applicant, Contingent Worker) from user-defined person types and concatenated display forms. This makes HRFV_HIRES useful where person type must be resolved in the context of a specific hire and period of service.

Underlying Base Objects

The documented dependency list for HRFV_HIRES includes both packages and synonyms to base HR tables. Package dependencies comprise HRI_BPL_PERSON_TYPE, HR_API, HR_BIS, HR_GENERAL, HR_SECURITY, and FND_GLOBAL. The FND_GLOBAL reference is typical of BIS views and is used to resolve session context such as business group and security profile. HRI_BPL_PERSON_TYPE and HR_BIS supply the person type and business intelligence logic, while HR_SECURITY enforces row-level access.

Table-level objects referenced include PER_ALL_PEOPLE_F (the person/employee record), PER_ASSIGNMENTS_F (the assignment record), PER_PERIODS_OF_SERVICE (the periods of service), PER_PERSON_TYPES, PER_PERSON_TYPES_TL, and PER_PERSON_TYPE_USAGES_F, which provide person type definitions, translated names, and usage history. Descriptive attributes are resolved through HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F_TL, HR_LOCATIONS_ALL_TL, PER_GRADES_TL, and PER_JOBS_TL. HR_LOOKUPS supports lookup-driven values such as employment category.

Key Columns

Common Use Cases and Queries

The view supports headcount and hire analysis by person type, business group, organization, and period. A frequent requirement is to separate employees from other person types at the point of hire:

  • Listing hires by person type — SELECT PERSON_NAME, EMPLOYEE_NUMBER, HIRE_DATE, PERSON_TYPE, EMPLOYEE_PERSON_TYPE, SYSTEM_PERSON_TYPE_CODE FROM APPS.HRFV_HIRES WHERE HIRE_DATE BETWEEN :start_date AND :end_date ORDER BY HIRE_DATE;
  • Filtering to a single system person type — SELECT PERSON_NAME, HIRE_DATE, ORGANIZATION_NAME FROM APPS.HRFV_HIRES WHERE SYSTEM_PERSON_TYPE_CODE = 'EMP';
  • Reconciling person type identifiers with definitions — join APPS.HRFV_HIRES to PER_PERSON_TYPES on PERSON_TYPE_ID to obtain the underlying definition behind the concatenated person type columns.
  • Period-of-service reporting — grouping by PERSON_ID and ordering by HIRE_DATE to show multiple hire and termination spans per employee.

Because HR_SECURITY is among the dependencies, results are filtered by the querying user's security profile, and BUSINESS_GROUP_ID may be used to constrain results to a single enterprise. Queries should therefore be run from an APPS-responsibility context that establishes the correct security and business group session values.