Results for “per_za_assessments”

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

Overview

The PER_ZA_ASSESSMENTS table, owned by the HR schema, is a Human Resources (PER) module object that stores National Qualifications Framework (NQF) assessment information for a person. This table supports South African legislative and regulatory reporting requirements around skills development, learnerships, and qualifications recognition, where formal assessments against registered unit standards and qualifications must be captured against individual employees or applicants. Each row represents a single assessment event, recording the assessor, the institution, the outcome, and the associated accreditation details. The table is classified as VALID within the ETRM 12.2.2 documented physical schema, and the schema mirrors the equivalent structure available in the 12.1.1 code line.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is described as standalone. From a modeling perspective, this suggests the table behaves closer to a link-satellite construct than a pure hub: it captures the intersection of a person, a qualification level, and a point-in-time assessment event, enriched with descriptive attributes such as the assessor, credit value, and certification outcome. It is not a reference or lookup table.

Key Information Stored

The table contains 26 documented columns. The most significant are:

• ASSESSMENT_ID — the surrogate primary key, enforced by the unique index PER_ZA_ASSESSMENTS_PK. It is the only documented business-key candidate.
• PERSON_ID — the foreign key linking the assessment to the assessed person in the core person model.
• LEVEL_ID — the foreign key to MSD_LEVELS, identifying the NQF level the assessment addresses.
• NAME_OF_ASSESSOR and INSTITUTION — the human assessor and the assessing body.
• DATE_OF_ASSESSMENT, ASSESSMENT_START_DATE, and ASSESSMENT_END_DATE — timestamps describing the assessment window.
• FINAL_RESULT and COMPETENCE_ACQUIRED — the outcome and the resulting competency.
• CREDIT — the NQF credit value awarded.
• FIELD_OF_LEARNING and SUB_FIELD — the classification of the learning area.
• CERTIFICATE_NUMBER, CERTIFICATION_DATE, and CERTIFICATION_EXPIRY_DATE — the certificate lifecycle.
• ETQA_NAME, ACCREDITED_BY, and DATE_OF_ACCREDITATION — the Education and Training Quality Assurance body details.

The standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) provide auditability.

Common Use Cases and Queries

Typical usage covers NQF compliance reporting, learnership tracking, and skills-development levy submissions. A common query pattern joins to the person and level entities:

SELECT a.assessment_id, a.person_id, a.final_result,
       a.credit, a.certification_date
FROM   per_za_assessments a
WHERE  a.person_id = :p_person_id
AND    a.final_result = 'COMPETENT';

Reporting use cases include credit accumulation per employee, certification expiry alerts, and assessor throughput analysis. Grouping by FIELD_OF_LEARNING supports SETA submission extracts.

Related Objects

• MSD_LEVELS — joined via LEVEL_ID; the only documented foreign key.
• PER_ALL_PEOPLE_F — the primary person source, joined via PERSON_ID.
• PER_PERSON_TYPES and person extra-information tables — contextualizing the assessed worker.
• HR_LOOKUPS — supplying valid values for FINAL_RESULT and related coded fields.
• Skills and qualification APIs in the OTA/PER competency stack, which reference assessment records for qualification awards.