Results for “ghr_positions_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_POSITIONS_V is a valid database view owned by the APPS schema within the GHR - US Federal Human Resources product family. It is defined over the PER_POSITIONS view and exists to supply a constrained, decode-friendly list of values for selection on the PA (Personnel Action) request form. The view does not introduce new persistent data; rather, it projects the position record while appending federally oriented descriptive attributes resolved at runtime through GHR_API functions.

Because the returned values are pre-formatted by API calls, the view simplifies both reporting and form-based lookup logic. Developers integrating with Oracle EBS 12.1.1 or 12.2.2 can query GHR_POSITIONS_V directly to obtain position titles, numbers, sequence numbers, and agency codes without manually invoking the underlying API signature. The object is largely equivalent to the documentation's referenced GHR_PA_POSITIONS_V, sharing the same base object and purpose.

Underlying Base Objects

The documented base objects referenced by this view are GHR_API (PACKAGE), HR_GENERAL (PACKAGE), HR_SECURITY (PACKAGE), and PER_POSITIONS (VIEW). The relationship is straightforward:

• PER_POSITIONS — the driving data source. GHR_POSITIONS_V selects position rows (aliased POS) from this view, inheriting its row-level security and effective-dating behavior.
• GHR_API — supplies the six GET_* functions that derive the federal descriptive columns (title, description/number, sequence number, agency code, and job occupational series) from POSITION_ID and BUSINESS_GROUP_ID.
• HR_GENERAL and HR_SECURITY — inherited indirectly through PER_POSITIONS, enforcing business group and security profile restrictions on the rows returned.

Key Columns

• POSITION_ID — primary identifier of the position; the join key used by the API calls and by downstream foreign references.
• NAME — the position name as stored on PER_POSITIONS.
• BUSINESS_GROUP_ID — the business group context; required by every GHR_API call and by HR_SECURITY.
• POS_TITLE, POS_NUMBER, POS_SEQ_NO, POS_AGENCY_CODE — federally formatted descriptive values resolved via GHR_API.
• DATE_EFFECTIVE / DATE_END — effective-dating bounds for the position record.
• JOB_ID, JOB_OCC_SERIES — the associated job and its occupational series.
• ORGANIZATION_ID, LOCATION_ID, STATUS — organizational placement, work location, and current status of the position.

Common Use Cases and Queries

The view is typically used to populate LOV results on personnel action forms and to feed position listings into federal HR reports. Because the API calls execute per row, queries should be filtered aggressively.

• Lookup positions for a business group by title: SELECT position_id, pos_title, pos_number FROM ghr_positions_v WHERE business_group_id = :p_bg AND UPPER(pos_title) LIKE UPPER(:p_title||'%').
• List active positions by organization: SELECT position_id, name, status, organization_id FROM ghr_positions_v WHERE organization_id = :p_org AND SYSDATE BETWEEN date_effective AND NVL(date_end, SYSDATE).
• Retrieve agency code and occupational series for a position: SELECT pos_agency_code, job_occ_series FROM ghr_positions_v WHERE position_id = :p_position_id.

Consumers should reuse the view rather than re-implementing the GHR_API derivations, ensuring consistent formatting and honoring superseded HR security applied through PER_POSITIONS.