Search Results za_nqf_seta_information

Overview

The APPS.PER_ZA_LEARNERSHIP_AGREEMENT_V view exposes South African learnership agreement data held in Oracle E-Business Suite Human Resources. A learnership is a structured learning programme registered with a Sector Education and Training Authority (SETA) under South African skills development legislation, combining theoretical instruction with practical workplace experience. The view presents one row per learnership agreement, combining agreement attributes from the base table with human-readable decoded meanings for two coded columns: the SETA and the learner type.

The view's principal purpose is reporting and integration. Because coded identifiers such as the SETA ID are not meaningful to end users, the view resolves them into descriptive text through calls to PER_ZA_UTILITY_PKG.PER_ZA_TABLE_MEANING and HR_GENERAL.DECODE_LOOKUP. This makes the view suitable for statutory reporting, SETA submission extracts, HR analytics, and downstream integrations that require legible attribute values rather than internal codes. The metadata is documented for ETRM 12.2.2 and is equally applicable to 12.1.1, as the underlying localization objects are common to both releases.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

• PER_ZA_LEARNERSHIP_AGREEMENTS (SYNONYM) — the primary source of agreement records, aliased la. In the APPS schema this synonym resolves to the ZA-localized learnership agreement table.
• PER_ALL_PEOPLE (VIEW) — aliased pap, joined on la.PERSON_ID = pap.PERSON_ID. The join supplies BUSINESS_GROUP_ID, which is passed into the SETA meaning lookup to ensure the correct business group context.
• PER_ZA_UTILITY_PKG (PACKAGE) — provides PER_ZA_TABLE_MEANING, used to translate the SETA identifier against the ZA_NQF_SETA_INFORMATION table.
• HR_GENERAL (PACKAGE) — provides DECODE_LOOKUP, used to translate the learner type against the ZA_NQF_LEARNER_TYPES lookup.
• HR_PERSON_NAME (PACKAGE) — a documented referenced object, available for resolving person name details for the learner.

Because the view is a join of an agreement table to PER_ALL_PEOPLE, any agreement whose PERSON_ID does not resolve to a person record will not be returned. The view is read-only and carries no materialized storage of its own.

Key Columns

• AGREEMENT_ID — primary identifier of the learnership agreement record.
• NAME, DESCRIPTION, AGREEMENT_NUMBER — descriptive and reference identifiers for the agreement.
• PERSON_ID — the learner (employee or person) associated with the agreement.
• AGREEMENT_START_DATE, AGREEMENT_END_DATE, ACTUAL_END_DATE, PROBATIONARY_END_DATE — the key dates defining the agreement lifecycle.
• STATUS — the current status of the agreement.
• SETA — the raw SETA identifier code stored on the agreement.
• SETA_MEANING — the decoded, human-readable SETA name, resolved via PER_ZA_UTILITY_PKG.PER_ZA_TABLE_MEANING('ZA_NQF_SETA_INFORMATION', 'ID', la.SETA, pap.BUSINESS_GROUP_ID). This is the column users typically target when searching for seta_meaning.
• LEARNER_TYPE — the raw learner type code.
• LEARNER_TYPE_MEANING — the decoded learner type value from the ZA_NQF_LEARNER_TYPES lookup.
• TERMINATED_BY, REASON_FOR_TERMINATION — details recorded when an agreement is terminated.
• AGREEMENT_HARD_COPY_ID — reference to the hard-copy document attached to the agreement.

Common Use Cases and Queries

Typical uses include producing SETA registers, monitoring agreement status and expiry, reconciling learner types, and driving statutory extracts. A representative query retrieving SETA names for active agreements is:

• SELECT agreement_number, name, person_id, seta, seta_meaning, learner_type_meaning, agreement_start_date, agreement_end_date, status FROM apps.per_za_learnership_agreement_v WHERE status = 'ACTIVE';
• SETA-level aggregation: SELECT seta_meaning, COUNT(*) FROM apps.per_za_learnership_agreement_v GROUP BY seta_meaning;
• Expiry monitoring: SELECT agreement_number, seta_meaning, agreement_end_date FROM apps.per_za_learnership_agreement_v WHERE agreement_end_date BETWEEN SYSDATE AND SYSDATE + 90;

Queries should be run in the correct business group context, since SETA_MEANING resolution depends on BUSINESS_GROUP_ID obtained through the PER_ALL_PEOPLE join.