Results for “za_nqf_courses”

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

Overview

APPS.PER_ZA_TRAINING_V is a South Africa–specific Oracle E-Business Suite view owned by the APPS schema. It presents training and qualification information for South African employees, exposing records stored in the PER_ZA_TRAINING table together with decoded lookup meanings for the National Qualifications Framework (NQF) attributes. The view is primarily used for legislative and statutory reporting related to South African skills development, including Employment Equity and Skills Development reporting obligations.

The view does not store data; it is a read-only projection over the base training table, enriching coded values with human-readable descriptions. Because the coded columns (FIELD_OF_LEARNING and COURSE) are translated through HR_GENERAL.DECODE_LOOKUP, the view allows reporting tools, concurrent programs, and integrations to consume both the stored code and its meaning without embedding decode logic locally.

Underlying Base Objects

The documented metadata identifies two referenced objects:

• PER_ZA_TRAINING (SYNONYM) — the base table holding the actual training records. The view selects directly from this synonym, so all columns except the two decoded meaning columns originate here.
• HR_GENERAL (PACKAGE) — the HR utility package providing DECODE_LOOKUP, which resolves Fast Formula/QuickCode lookup values into their display meanings.

The view therefore acts as a decoded wrapper: the raw training rows remain in PER_ZA_TRAINING, and the view augments two of those rows with lookup-derived descriptions via the ZA_NQF_FIELDS_OF_LEARNING and ZA_NQF_COURSES lookup types.

Key Columns

• TRAINING_ID — primary identifier for the training record.
• LEVEL_ID — identifier linking the training to an NQF level.
• PERSON_ID — the employee or person associated with the training record.
• FIELD_OF_LEARNING — coded NQF field of learning.
• FIELD_OF_LEARNING_MEANING — decoded description of the field of learning via ZA_NQF_FIELDS_OF_LEARNING.
• COURSE — coded NQF course value.
• COURSE_MEANING — decoded course description via ZA_NQF_COURSES.
• SUB_FIELD — sub-category within the field of learning.
• CREDIT — NQF credit value awarded for the training.
• NOTIONAL_HOURS — notional learning hours associated with the training.
• REGISTRATION_DATE — date the training was registered.
• REGISTRATION_NUMBER — registration reference for the training record.

Common Use Cases and Queries

The view supports skills development and NQF reporting, employee training history enquiries, and data extraction for statutory submissions. A typical query retrieving decoded training data for a person is:

SELECT person_id,
       field_of_learning_meaning,
       course_meaning,
       credit,
       notional_hours,
       registration_date,
       registration_number
FROM   apps.per_za_training_v
WHERE  person_id = :p_person_id;

For aggregated NQF credit reporting by field of learning:

SELECT field_of_learning_meaning,
       SUM(credit)          total_credit,
       SUM(notional_hours)  total_hours
FROM   apps.per_za_training_v
GROUP  BY field_of_learning_meaning;

Because the view joins only via the HR_GENERAL.DECODE_LOOKUP function rather than a physical join, queries remain efficient when filtered by PERSON_ID or TRAINING_ID. Note that the decoded meanings depend on the presence and correctness of the underlying lookup values; if a code is missing from the lookup, the meaning column returns null even though the coded value is present.