[Home] [Help]
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
Name |
AREA_OF_ASSESSMENT_ID |
ASSESSMENT_ID |
AREA_OF_ASSESSMENT |
AREA_OF_ASSESSMENT_MEANING |
ASSESSMENT_RESULT |
ASSESSMENT_RESULT_MEANING |
ASSESSMENT_CRITERIA |
ASSESSMENT_CRITERIA_MEANING |