View: PER_ZA_TRAINING_V

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

View Text

SELECT TRAINING_ID
, LEVEL_ID
, PERSON_ID
, FIELD_OF_LEARNING
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_FIELDS_OF_LEARNING'
, FIELD_OF_LEARNING) FIELD_OF_LEARNING_MEANING
, COURSE
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_COURSES'
, COURSE) COURSE_MEANING
, SUB_FIELD
, CREDIT
, NOTIONAL_HOURS
, REGISTRATION_DATE
, REGISTRATION_NUMBER
FROM PER_ZA_TRAINING

Columns