Product: | IGW - Grants Proposal (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PAPF.FULL_NAME
, 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
, PER_ALL_PEOPLE_F PAPF
WHERE LKUP1.LOOKUP_TYPE = 'IGW_DEGREE_TYPES'
AND LKUP1.LOOKUP_CODE = DEGREES.DEGREE_TYPE_CODE
AND PAPF.PERSON_ID = DEGREES.PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE WITH READ ONLY