Search Results gl_hr_employees_current_v




Overview
Explore in AI Chat

Overview

The APPS.GL_HR_EMPLOYEES_CURRENT_V view is a General Ledger (GL) product database object that exposes a consolidated, query-friendly projection of current employee records for use in GL reporting, concurrent programs, and integration logic. Its status is documented as VALID in the ETRM 12.2.2 metadata, and it is owned by the APPS schema. Unlike a base table, this view does not store data; it derives its result set at runtime by joining human-resources person and assignment data, delivering a denormalized row per current primary employee assignment. This makes the view particularly useful where a GL component needs to resolve an employee name, title, supervisor, or set of books association without navigating the full HR schema directly.

The view is commonly surfaced when users search for the column employee_name, which corresponds to the FULL_NAME attribute of the underlying person record, aliased as EMPLOYEE_NAME. Because the view filters to current, primary employee assignments, it presents a stable and predictable snapshot suitable for list-of-values lookups, reporting joins, and lightweight integration extracts.

Underlying Base Objects

The view text documents a definition built over two HR views: PER_PEOPLE_X (aliased P) and PER_ASSIGNMENTS_X (aliased A). The join is driven by BUSINESS_GROUP_ID matched between the two sources, with the additional predicate that A.PERSON_ID equals P.PERSON_ID. Documented ETRM metadata identifies the referenced base objects as PER_PEOPLE_X and PER_ASSIGNMENTS_X, alongside supporting packages HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY. The HR_SECURITY package is significant because it enforces security profile access, meaning rows returned are subject to the security context of the querying user.

Key Columns

  • EMPLOYEE_ID — The PERSON_ID from PER_PEOPLE_X, uniquely identifying the employee.
  • EMPLOYEE_NAME — The person's FULL_NAME; this is the column most frequently searched by users.
  • TITLE — The employee's title from the person record.
  • BUSINESS_GROUP_ID — The HR business group that scopes the employee and assignment.
  • ORGANIZATION_ID — The organization associated with the assignment.
  • SUPERVISOR_ID — Identifier of the employee's supervisor.
  • SET_OF_BOOKS_ID — The ledger associated with the assignment, relevant for GL accounting context.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically queried to resolve employee names for GL reporting, to populate LOVs, or to join employee attributes to accounting data. A representative query retrieves current employees for a ledger:

  • SELECT employee_id, employee_name, title, supervisor_id FROM gl_hr_employees_current_v WHERE set_of_books_id = :p_sob_id;
  • SELECT employee_name FROM gl_hr_employees_current_v WHERE employee_id = :p_person_id;
  • SELECT v.employee_name, v.title FROM gl_hr_employees_current_v v WHERE v.organization_id = :p_org_id ORDER BY v.employee_name;

Because the result set is restricted to current primary assignments with a non-null employee number, the view is well suited to operational and reporting scenarios that require the active workforce only.