Results for “salary_entry_grade_desc”

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

Overview

APPS.HR_ALL_POSITIONS_D is a supplementary view in the Oracle E-Business Suite Human Resources (PER) application, exposed under the APPS schema and registered in FND Design Data as PER.HR_ALL_POSITIONS_D. Its documented status is VALID. The view is explicitly identified as a "supplementary view used to simplify forms coding," which means it exists primarily to support Oracle Forms-based user interfaces rather than to serve as a stable, documented integration or reporting interface. Oracle's own documentation carries a direct warning: it does not recommend querying or altering data through this view, since its definition may change dramatically in subsequent minor or major releases. In EBS 12.1.1 and 12.2.2, the view is therefore best treated as a read-only convenience construct that flattens code-based lookups and descriptive flexfield values associated with position definitions into a single, forms-friendly result set.

The view resolves the user's search term, "pay_freq_payroll_desc," as one of its exposed columns. PAY_FREQ_PAYROLL_DESC (VARCHAR2, 200) provides a human-readable description of the payroll frequency associated with a position record, allowing forms and ad hoc queries to display a descriptive label instead of an underlying lookup code.

Underlying Base Objects

Per the documented 12.2.2 metadata, the view is defined over the following objects:

• HR_ALL_POSITIONS_F (synonym) — the core datable position definition entity holding effective-dated position rows.
• PER_POSITION_DEFINITIONS (synonym) — position definition attributes, including descriptive flexfield context data.
• PAY_GRADE_RULES (view) — payroll and grade-related rule resolution used to derive descriptive values such as payroll frequency.
• FND_FLEX_EXT (package) — Oracle Application Object Library routines for extracting and decoding descriptive flexfield segments.
• HR_GENERAL (package) — general HR utility routines used for decoding and date handling.
• FND_USER (synonym) — the application user repository, used to resolve LAST_UPDATED_BY into an auditable identity.

The dependency profile confirms that HR_ALL_POSITIONS_D is a flattening and decoding layer: it joins effective-dated position data to lookup and rules-based sources and converts coded identifiers into descriptive text. Because it references a package (FND_FLEX_EXT), the flexfield-expanded columns (for example ENTRY_STEP_DESC and JOB_DESC) reflect the flexfield context configured in the target environment.

Key Columns

• POSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — the effective-dated primary identifier of the position record.
• NAME (VARCHAR2 4000) — the position name.
• PAY_FREQ_PAYROLL_DESC (VARCHAR2 200) — descriptive label for the payroll frequency assigned to the position; the column matching the user's search.
• JOB_DESC, LOCATION_DESC, ORGANIZATION_DESC, ENTRY_GRADE_DESC — decoded descriptions for job, location, organization, and entry grade.
• SUPERVISOR_POSITION_DESC, SUCCESSOR_POSITION_DESC, RELIEF_POSITION_DESC — descriptive labels resolving related position hierarchies.
• AVAILABILITY_STATUS_DESC, POSITION_TYPE_DESC, BARGAINING_UNIT_DESC — decoded status and classification attributes.
• FTE, MAX_PERSONS, WORKING_HOURS, PROBATION_PERIOD, OVERLAP_PERIOD — numeric staffing and term metrics, with OVERLAP_UNIT_DESC and PROBATION_UNIT_DESC providing their units.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns; LAST_UPDATED_BY is typed VARCHAR2(100), indicating it is resolved to a user identity rather than a raw numeric ID.

Common Use Cases and Queries

The principal use case is Forms-based display and light ad hoc inspection of decoded position data. A minimal payroll-frequency lookup can be issued as follows:

• SELECT position_id, name, pay_freq_payroll_desc FROM apps.hr_all_positions_d WHERE pay_freq_payroll_desc IS NOT NULL;
• SELECT position_id, effective_start_date, effective_end_date, job_desc, organization_desc, fte FROM apps.hr_all_positions_d WHERE sysdate BETWEEN effective_start_date AND effective_end_date;
• SELECT a.name, a.supervisor_position_desc, a.location_desc FROM apps.hr_all_positions_d a WHERE a.organization_desc = :org;

Because the view is explicitly designated a forms-coding aid and Oracle warns against dependence on it, production reports and integrations should retrieve the same descriptive values from the documented base entities — HR_ALL_POSITIONS_F, PER_POSITION_DEFINITIONS, and the relevant lookup and payroll rule sources — rather than binding to HR_ALL_POSITIONS_D. Where the view is queried for investigation or validation, callers should restrict results by effective dates and expect column semantics to shift across patch levels in both 12.1.1 and 12.2.2.