VIEW: APPS.PER_ZA_ASSESSMENTS_V

Source

View Text - Preformatted

SELECT ASSESSMENT_ID, PERSON_ID, LEVEL_ID, NAME_OF_ASSESSOR, INSTITUTION, CREDIT, DATE_OF_ASSESSMENT, FINAL_RESULT, hr_general.decode_lookup('ZA_NQF_FINAL_RESULT',FINAL_RESULT) FINAL_RESULT_MEANING, ASSESSMENT_NUMBER, LOCATION_WHERE_ASSESSED, FIELD_OF_LEARNING, hr_general.decode_lookup('ZA_NQF_FIELDS_OF_LEARNING',FIELD_OF_LEARNING) FIELD_OF_LEARNING_MEANING, SUB_FIELD, ASSESSMENT_START_DATE, ASSESSMENT_END_DATE, COMPETENCE_ACQUIRED, hr_general.decode_lookup('ZA_NQF_COMPETENCE_ACQUIRED',COMPETENCE_ACQUIRED) COMPETENCE_ACQUIRED_MEANING, ETQA_NAME, hr_general.decode_lookup('ZA_NQF_ETQA_NAMES',ETQA_NAME) ETQA_NAME_MEANING, CERTIFICATION_DATE, CERTIFICATE_NUMBER, ACCREDITED_BY, DATE_OF_ACCREDITATION, CERTIFICATION_EXPIRY_DATE from per_za_assessments

View Text - HTML Formatted

SELECT ASSESSMENT_ID
, PERSON_ID
, LEVEL_ID
, NAME_OF_ASSESSOR
, INSTITUTION
, CREDIT
, DATE_OF_ASSESSMENT
, FINAL_RESULT
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_FINAL_RESULT'
, FINAL_RESULT) FINAL_RESULT_MEANING
, ASSESSMENT_NUMBER
, LOCATION_WHERE_ASSESSED
, FIELD_OF_LEARNING
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_FIELDS_OF_LEARNING'
, FIELD_OF_LEARNING) FIELD_OF_LEARNING_MEANING
, SUB_FIELD
, ASSESSMENT_START_DATE
, ASSESSMENT_END_DATE
, COMPETENCE_ACQUIRED
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_COMPETENCE_ACQUIRED'
, COMPETENCE_ACQUIRED) COMPETENCE_ACQUIRED_MEANING
, ETQA_NAME
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_ETQA_NAMES'
, ETQA_NAME) ETQA_NAME_MEANING
, CERTIFICATION_DATE
, CERTIFICATE_NUMBER
, ACCREDITED_BY
, DATE_OF_ACCREDITATION
, CERTIFICATION_EXPIRY_DATE
FROM PER_ZA_ASSESSMENTS