[Home] [Help]
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
Name |
TRAINING_ID |
LEVEL_ID |
PERSON_ID |
FIELD_OF_LEARNING |
FIELD_OF_LEARNING_MEANING |
COURSE |
COURSE_MEANING |
SUB_FIELD |
CREDIT |
NOTIONAL_HOURS |
REGISTRATION_DATE |
REGISTRATION_NUMBER |