Search Results per_za_learnership_agreement_v




Overview
Explore in AI Chat

Overview

PER_ZA_LEARNERSHIP_AGREEMENT_V is an Oracle E-Business Suite (EBS) database view owned by the APPS schema and classified under the PER — Human Resources product family. As documented in the ETRM repository (validated against EBS 12.1.1 and 12.2.2), the view exists to maintain the base table PER_ZA_LEARNERSHIP_AGREEMENTS via NQF forms. This is a South Africa–specific localization object supporting learnership administration under the National Qualifications Framework (NQF), a statutory framework governing skills development and workplace learning in South Africa.

Functionally, the view presents a denormalized, reporting-friendly projection of learnership agreements. Rather than exposing raw foreign-key identifiers alone, it joins the underlying agreement table to the PER_ALL_PEOPLE view and resolves coded lookups into human-readable meanings — for example, SETA (Sector Education and Training Authority) descriptions and learner-type designations. This makes the view well-suited for concurrent programs, Oracle Reports, BI Publisher data templates, and external integrations that require fully decoded learnership records without embedding lookup-resolution logic. The view is read-oriented; write operations against learnership agreements occur through the underlying NQF forms, which manipulate the base table.

Underlying Base Objects

The documented metadata identifies the following referenced base objects:

  • PER_ZA_LEARNERSHIP_AGREEMENTS (synonym) — the primary base table holding learnership agreement records.
  • PER_ALL_PEOPLE (view) — joined on PERSON_ID to supply the learner's business group context.
  • PER_ZA_UTILITY_PKG (package) — supplies PER_ZA_TABLE_MEANING, used to translate SETA identifiers into descriptive text.
  • HR_GENERAL (package) — supplies DECODE_LOOKUP, used to translate learner-type codes via the ZA_NQF_LEARNER_TYPES lookup.
  • HR_PERSON_NAME (package) — documented as a referenced object, typically used to resolve person name components.

At its core, the defining query selects from PER_ZA_LEARNERSHIP_AGREEMENTS (aliased LA) and inner-joins PER_ALL_PEOPLE (aliased PAP) on PERSON_ID. The join to PER_ALL_PEOPLE is significant because the business group identifier from PAP is passed into the PER_ZA_UTILITY_PKG call, ensuring that SETA meanings respect the legislative data group / business group context of the learner.

Key Columns

The view exposes seventeen columns, summarized below:

Common Use Cases and Queries

Typical uses include statutory reporting to SETAs, learnership headcount analytics, expiry monitoring, and integration extracts feeding payroll or skills-development systems. A basic listing query is:

SELECT agreement_number, person_id, agreement_start_date, agreement_end_date, status, seta_meaning, learner_type_meaning FROM apps.per_za_learnership_agreement_v;

To identify agreements approaching expiry within the next ninety days:

SELECT agreement_number, person_id, agreement_end_date FROM apps.per_za_learnership_agreement_v WHERE status = 'ACTIVE' AND agreement_end_date BETWEEN SYSDATE AND SYSDATE + 90 ORDER BY agreement_end_date;

To summarize learnerships by SETA and learner type for reporting:

SELECT seta_meaning, learner_type_meaning, COUNT(*) FROM apps.per_za_learnership_agreement_v GROUP BY seta_meaning, learner_type_meaning;

Because the view performs lookup decoding, queries remain simple and consistent across reports, avoiding duplicated decode logic in each extract.