DBA Data[Home] [Help]

VIEW: APPS.PER_ZA_AREAS_OF_ASSESSMENT_V

Source

View Text - Preformatted

SELECT AREA_OF_ASSESSMENT_ID, ASSESSMENT_ID, AREA_OF_ASSESSMENT, hr_general.decode_lookup('ZA_NQF_AREAS_OF_ASSESSMENT',AREA_OF_ASSESSMENT) AREA_OF_ASSESSMENT, ASSESSMENT_RESULT, hr_general.decode_lookup('ZA_NQF_AREAS_RESULT',ASSESSMENT_RESULT) ASSESSMENT_RESULT_MEANING, ASSESSMENT_CRITERIA, hr_general.decode_lookup('ZA_NQF_ASSESSMENT_CRITERIA',ASSESSMENT_CRITERIA) ASSESSMENT_CRITERIA_MEANING from per_za_areas_of_assessment
View Text - HTML Formatted

SELECT AREA_OF_ASSESSMENT_ID
, ASSESSMENT_ID
, AREA_OF_ASSESSMENT
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_AREAS_OF_ASSESSMENT'
, AREA_OF_ASSESSMENT) AREA_OF_ASSESSMENT
, ASSESSMENT_RESULT
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_AREAS_RESULT'
, ASSESSMENT_RESULT) ASSESSMENT_RESULT_MEANING
, ASSESSMENT_CRITERIA
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_ASSESSMENT_CRITERIA'
, ASSESSMENT_CRITERIA) ASSESSMENT_CRITERIA_MEANING
FROM PER_ZA_AREAS_OF_ASSESSMENT