Search Results per_za_learnership_agreements




Overview
Explore in AI Chat

Overview

The HR.PER_ZA_LEARNERSHIP_AGREEMENTS table is a South African localization object within the Oracle E-Business Suite Human Resources (PER) module. It stores details of National Qualifications Framework (NQF) learnership agreements established between a person (learner) and the employing organization. Learnerships are structured workplace learning programmes registered under South African skills development legislation, and this table captures the contractual and administrative attributes required to manage, monitor, and report on them.

The object is documented as a TABLE owned by the HR schema, with a status of VALID in both EBS 12.1.1 and 12.2.2. Based on the mined foreign-key structure, the heuristic Data Vault classification is standalone, suggesting that in a dimensional or Data Vault model this object could reasonably be treated as an independent hub or reference entity rather than a dependent satellite or link. This classification is a modelling suggestion derived from the FK topology, not a prescriptive requirement.

Key Information Stored

The table is documented with 20 columns. The most significant are summarised below.

  • AGREEMENT_ID — The surrogate primary key, enforced by the unique index PER_ZA_LEARN_AGREEMENTS_PK. It uniquely identifies each learnership agreement record. This is the only documented business-key candidate.
  • PERSON_ID — Identifies the learner party to the agreement. This is the principal join key to the person/employee records in the HR schema.
  • AGREEMENT_NUMBER — The externally meaningful reference number for the agreement, used in correspondence and reporting.
  • NAME and DESCRIPTION — Descriptive text identifying the learnership programme or agreement.
  • AGREEMENT_START_DATE and AGREEMENT_END_DATE — The contractual period of the learnership.
  • ACTUAL_END_DATE — The date the agreement in fact concluded, which may differ from the planned end date.
  • PROBATIONARY_END_DATE — The date on which the learner's probationary period expires.
  • STATUS — The current lifecycle state of the agreement (for example active, completed, or terminated).
  • SETA — The Sector Education and Training Authority under which the learnership is registered.
  • LEARNER_TYPE — Classifies the learner (for example unemployed or employed learner).
  • TERMINATED_BY and REASON_FOR_TERMINATION — Capture who ended the agreement and the reason, supporting compliance reporting.
  • AGREEMENT_HARD_COPY_ID — References the stored hard-copy document, typically via an attachment or document-management identifier.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard EBS who/when auditability.

Common Use Cases and Queries

Typical scenarios include statutory SETA reporting, learnership headcount analytics, expiry monitoring, and audit of terminated agreements. A representative pattern for active agreements per person is:

  • Filter by STATUS and AGREEMENT_START_DATE/AGREEMENT_END_DATE to identify agreements approaching expiry for renewal or exit processing.
  • Join to person records on PERSON_ID to report learner names, assignments, and organizational units against AGREEMENT_NUMBER.
  • Group by SETA and LEARNER_TYPE to produce skills-development reporting for grants and levy submissions.
  • Query TERMINATED_BY, REASON_FOR_TERMINATION, and ACTUAL_END_DATE for non-completion and attrition analysis.

A simple access path uses the primary key for single-record retrieval, e.g. SELECT * FROM hr.per_za_learnership_agreements WHERE agreement_id = :id, while set-based reporting filters on status or date ranges.

Related Objects

Because the mined relationship data classifies this table as standalone, no foreign-key dependencies are documented within the ETRM excerpt. The significant related objects derive chiefly from the PERSON_ID linkage:

  • PER_ALL_PEOPLE_F — joined on PERSON_ID to resolve learner identity and effective-dated person details.
  • PER_ALL_ASSIGNMENTS_F — provides assignment and organizational context for employed learners via PERSON_ID.
  • HR_LOOKUPS / FND_LOOKUPS — resolve coded values for STATUS, LEARNER_TYPE, and REASON_FOR_TERMINATION.
  • FND_ATTACHED_DOCUMENTS — referenced through AGREEMENT_HARD_COPY_ID where the hard copy is stored as an attachment.
  • HR.PER_ZA_LEARNERSHIP_DETAILS and related ZA localization tables — commonly queried alongside this entity for full learnership reporting.

Where delivered PL/SQL APIs are required, localized HR APIs and concurrent programs that maintain South African learnership data are the customary integration points, though these should be confirmed against the specific EBS patch level in use.