View: PER_ZA_AREAS_OF_ASSESSMENT_V

Product:	PER - Human Resources
Description:	PER_ZA_AREAS_OF_ASSESSMENT_V is used to maintain table PER_ZA_AREAS_OF_ASSESSMENT via NQF forms.
Implementation/DBA Data:	APPS.PER_ZA_AREAS_OF_ASSESSMENT_V

View Text

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

Columns