View: PER_ZA_ASSESSMENTS_V

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

View Text

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

Columns