[Home] [Help]
View: IGWBV_GRNT_PRPSL_PERS_DEGREE
View Text
SELECT DEGREES.DEGREE_TYPE_CODE
, DEGREES.GRADUATION_DATE
, DEGREES.DEGREE
, DEGREES.DEGREE_SEQUENCE
, DEGREES.FIELD_OF_STUDY
, DEGREES.SPECIALIZATION
, DEGREES.SCHOOL_NAME
, DEGREES.PERSON_DEGREE_ID
, DEGREES.PERSON_ID
, '_DF:IGW:IGW_EDUCATION_DESC_FLEX:DEGREES'
, DEGREES.LAST_UPDATE_DATE
, DEGREES.LAST_UPDATED_BY
, DEGREES.CREATION_DATE
, DEGREES.CREATED_BY
FROM IGW_PERSON_DEGREES DEGREES
, IGW_LOOKUPS_V LKUP1
WHERE LKUP1.LOOKUP_TYPE = 'IGW_DEGREE_TYPES'
AND LKUP1.LOOKUP_CODE = DEGREES.DEGREE_TYPE_CODE WITH READ ONLY
Columns
Name |
DEGREE_TYPE |
GRADUATION_DATE |
DEGREE |
DEGREE_OBTAINED_SEQUENCE |
FIELD_OF_STUDY |
SPECIALIZATION |
SCHOOL_NAME |
PERSON_DEGREE_ID |
PERSON_ID |
"_DF" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |