View: IGSFV_GR_GRADUAND

View Text

SELECT HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, GR.CREATE_DT
, GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, GR.COURSE_CD
, CRV1.TITLE
, GR.AWARD_COURSE_CD
, GR.AWARD_CRS_VERSION_NUMBER
, CRV2.TITLE
, GR.AWARD_CD
, AW1.AWARD_TITLE
, GR.HONOURS_LEVEL
, HL.DESCRIPTION
, GR.CONFERRAL_DT
, GR.GRADUAND_STATUS
, GR.GRADUAND_APPR_STATUS
, GR.S_GRADUAND_TYPE
, GR.GRADUATION_NAME
, '_LA:GR.PROXY_AWARD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HP2.PARTY_NAME
, HP2.PARTY_NUMBER
, GR.PREVIOUS_QUALIFICATIONS
, '_LA:GR.CONVOCATION_MEMBERSHIP_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GR.SUR_FOR_COURSE_CD
, GR.SUR_FOR_CRS_VERSION_NUMBER
, CRV3.TITLE
, GR.SUR_FOR_AWARD_CD
, AW2.AWARD_TITLE
, GR.COMMENTS
, GR.PERSON_ID
, GR.PROXY_AWARD_PERSON_ID
, GR.CREATED_BY
, GR.CREATION_DATE
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
FROM IGS_GR_GRADUAND_ALL GR
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_PS_VER_ALL CRV1
, IGS_PS_VER_ALL CRV2
, IGS_PS_VER_ALL CRV3
, IGS_CA_INST_ALL CI
, IGS_GR_HONOURS_LEVEL_ALL HL
, IGS_PS_AWD AW1
, IGS_PS_AWD AW2
WHERE GR.PERSON_ID = HP1.PARTY_ID
AND GR.PROXY_AWARD_PERSON_ID = HP2.PARTY_ID (+)
AND GR.PERSON_ID = SCA.PERSON_ID (+)
AND GR.COURSE_CD = SCA.COURSE_CD (+)
AND SCA.COURSE_CD = CRV1.COURSE_CD (+)
AND SCA.VERSION_NUMBER = CRV1.VERSION_NUMBER (+)
AND GR.GRD_CAL_TYPE = CI.CAL_TYPE
AND GR.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND GR.AWARD_COURSE_CD = CRV2.COURSE_CD (+)
AND GR.AWARD_CRS_VERSION_NUMBER = CRV2.VERSION_NUMBER (+)
AND GR.SUR_FOR_COURSE_CD = CRV3.COURSE_CD (+)
AND GR.SUR_FOR_CRS_VERSION_NUMBER = CRV3.VERSION_NUMBER (+)
AND GR.HONOURS_LEVEL = HL.HONOURS_LEVEL (+)
AND GR.AWARD_CD = AW1.AWARD_CD
AND GR.SUR_FOR_AWARD_CD = AW2.AWARD_CD (+) WITH READ ONLY

Columns