Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes Graduand |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, GR.CREATE_DT
, GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, GR.COURSE_CD
, GR.AWARD_COURSE_CD
, GR.AWARD_CRS_VERSION_NUMBER
, GR.AWARD_CD
, GR.HONOURS_LEVEL
, 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'
, 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
, GR.SUR_FOR_AWARD_CD
, 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
, HZ_PARTIES HP
WHERE GR.PERSON_ID = HP.PARTY_ID WITH READ ONLY