Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, GAC.CREATE_DT
, GAC.GRD_CAL_TYPE
, GAC.GRD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, GAC.CEREMONY_NUMBER
, GAC.AWARD_COURSE_CD
, GAC.AWARD_CRS_VERSION_NUMBER
, CRV.TITLE
, GAC.AWARD_CD
, AW.AWARD_TITLE
, GAC.US_GROUP_NUMBER
, GAC.ORDER_IN_PRESENTATION
, GAC.GRADUAND_SEAT_NUMBER
, GAC.NAME_PRONUNCIATION
, GAC.NAME_ANNOUNCED
, '_LA:GAC.ACADEMIC_DRESS_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GAC.ACADEMIC_GOWN_SIZE
, MSR1.DESCRIPTION
, GAC.ACADEMIC_HAT_SIZE
, MSR2.DESCRIPTION
, GAC.GUEST_TICKETS_REQUESTED
, GAC.GUEST_TICKETS_ALLOCATED
, GAC.GUEST_SEATS
, '_LA:GAC.FEES_PAID_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GAC.SPECIAL_REQUIREMENTS
, GAC.COMMENTS
, GAC.GAC_ID
, GAC.PERSON_ID
, GAC.CREATED_BY
, GAC.CREATION_DATE
, GAC.LAST_UPDATED_BY
, GAC.LAST_UPDATE_DATE
FROM IGS_GR_AWD_CRMN GAC
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
, IGS_CA_INST_ALL CI
, IGS_PS_AWD AW
, IGS_GE_MEASUREMENT MSR1
, IGS_GE_MEASUREMENT MSR2
WHERE GAC.PERSON_ID = HP.PARTY_ID
AND GAC.GRD_CAL_TYPE = CI.CAL_TYPE
AND GAC.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND GAC.AWARD_COURSE_CD = CRV.COURSE_CD (+)
AND GAC.AWARD_CRS_VERSION_NUMBER = CRV.VERSION_NUMBER (+)
AND GAC.AWARD_CD = AW.AWARD_CD
AND GAC.ACADEMIC_GOWN_SIZE = MSR1.MEASUREMENT_CD (+)
AND GAC.ACADEMIC_HAT_SIZE = MSR2.MEASUREMENT_CD (+) WITH READ ONLY