Search Results current_employee_flag_code




Overview
Explore in AI Chat

Overview

APPS.HRFV_COMPETENCE_PROFILES is a Business Intelligence System (BIS) view in Oracle E-Business Suite, owned by the APPS schema and validated in both 12.1.1 and 12.2.2. It is registered under the FND Design Data identifier PER.HRFV_COMPETENCE_PROFILES and presents competence profile information for people within an enterprise, spanning both employees and applicants. The view consolidates person identity, competence definition, proficiency rating, certification detail, and currency-of-status indicators into a single denormalised reporting structure, which makes it suitable for HR analytics, competency gap analysis, and downstream integration extracts where a flat, human-readable projection is preferred over the normalised PER schema tables.

Underlying Base Objects

The view is defined over a set of PER and HR objects. Organizational context is supplied by HR_ALL_ORGANIZATION_UNITS_TL, which provides the business group name. Person details flow through PER_PEOPLE_X and the HR_PERSON_NAME package. Competence data is sourced from PER_COMPETENCES_VL, PER_COMPETENCE_DEFINITIONS, and PER_COMPETENCE_ELEMENTS. Proficiency ranking draws on PER_RATING_LEVELS and PER_RATING_LEVELS_TL. Runtime resolution logic is embedded through the HR_BIS, HR_GENERAL, and HR_SECURITY packages; HR_SECURITY in particular enforces row-level access so that a query returns only the people visible to the current responsibility. The view is not referenced by any other database object, confirming its role as a terminal reporting artefact rather than a building block.

Key Columns

The view exposes descriptive, date, and identifier columns. BUSINESS_GROUP_NAME, PERSON_NAME, and COMPETENCE_NAME provide the readable core. DATE_FROM and DATE_TO bound the validity of the competence assignment, while CERTIFICATION_DATE and NEXT_REVIEW_DATE track certification currency. PROFICIENCY_RATING_SOURCE, CERTIFICATION_METHOD, STEP_VALUE, and PROFICIENCY_LEVEL describe the assessed rating. The currency flags are of particular interest to users searching on CURRENT_APPLICANT_FLAG_CODE: both CURRENT_EMPLOYEE_FLAG_CODE and CURRENT_APPLICANT_FLAG_CODE appear alongside their display counterparts CURRENT_EMPLOYEE_FLAG and CURRENT_APPLICANT_FLAG. The *_CODE columns carry a 30-character code value suitable for filtering and joining, while the flag columns hold a longer formatted description for presentation. Business key identifiers — BUSINESS_GROUP_ID, COMPETENCE_ID, PERSON_ID, and PROFICIENCY_LEVEL_ID — support joins back to base tables.

Common Use Cases and Queries

Typical scenarios include producing a competency inventory per person, identifying expired certifications, and distinguishing applicant competences from employee competences via the flag code columns. The following example restricts output to applicants:

  • SELECT person_name, competence_name, proficiency_level, certification_date, current_applicant_flag_code FROM apps.hrfv_competence_profiles WHERE current_applicant_flag_code = 'Y';
  • SELECT person_name, competence_name, date_from, date_to FROM apps.hrfv_competence_profiles WHERE next_review_date < SYSDATE;
  • SELECT business_group_name, competence_name, COUNT(*) FROM apps.hrfv_competence_profiles GROUP BY business_group_name, competence_name;

Because HR_SECURITY is invoked within the view, results are automatically filtered by the querying user's security profile, so no additional predicate is normally required. For extraction into external systems, the *_CODE columns should be preferred over the display flag columns to avoid dependence on translated or formatted text.