VIEW: APPS.IGS_GR_AWD_CRMN_HIST_V

Source

View Text - Preformatted

SELECT gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_start_dt, gach1.hist_end_dt, gach1.hist_who, NVL(gach1.us_group_number, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'US_GROUP_NUMBER', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt)), gac1.us_group_number)) us_group_number, NVL(gach1.order_in_presentation, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ORDER_IN_PRESENTATION', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt)), gac1.order_in_presentation)) order_in_presentation, NVL(gach1.graduand_seat_number, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GRADUAND_SEAT_NUMBER', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,10), gac1.graduand_seat_number)) graduand_seat_number, NVL(gach1.name_pronunciation, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'NAME_PRONUNCIATION', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,60), gac1.name_pronunciation)) name_pronunciation, NVL(gach1.name_announced, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'NAME_ANNOUNCED', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,60), gac1.name_announced)) name_announced, NVL(gach1.academic_dress_rqrd_ind, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_DRESS_RQRD_IND', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,1), gac1.academic_dress_rqrd_ind)) academic_dress_rqrd_ind, NVL(gach1.academic_gown_size, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_GOWN_SIZE', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,10), gac1.academic_gown_size)) academic_gown_size, NVL(gach1.academic_hat_size, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_HAT_SIZE', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,10), gac1.academic_hat_size)) academic_hat_size, NVL(gach1.guest_tickets_requested, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_TICKETS_REQUESTED', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt)), gac1.guest_tickets_requested)) guest_tickets_requested, NVL(gach1.guest_tickets_allocated, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_TICKETS_ALLOCATED', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt)), gac1.guest_tickets_allocated)) guest_tickets_allocated, NVL(gach1.guest_seats, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_SEATS', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,60), gac1.guest_seats)) guest_seats, NVL(gach1.fees_paid_ind, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'FEES_PAID_IND', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,1), gac1.fees_paid_ind)) fees_paid_ind, gach1.created_by, gach1.creation_date, gach1.last_updated_by, gach1.last_update_date, gach1.last_update_login, NVL(gach1.special_requirements, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'SPECIAL_REQUIREMENTS', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,2000), gac1.special_requirements)) special_requirements, NVL(gach1.comments, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'COMMENTS', gach1.person_id, gach1.create_dt, gach1.grd_cal_type, gach1.grd_ci_sequence_number, gach1.ceremony_number, gach1.award_course_cd, gach1.award_crs_version_number, gach1.award_cd, gach1.hist_end_dt),1,2000), gac1.comments)) comments FROM IGS_GR_AWD_CRMN gac1, IGS_GR_AWD_CRMN_HIST gach1 WHERE gac1.person_id = gach1.person_id AND gac1.create_dt = gach1.create_dt AND gac1.grd_cal_type = gach1.grd_cal_type AND gac1.grd_ci_sequence_number = gach1.grd_ci_sequence_number AND gac1.ceremony_number = gach1.ceremony_number AND gac1.award_course_cd = gach1.award_course_cd AND gac1.award_crs_version_number = gach1.award_crs_version_number AND gac1.award_cd = gach1.award_cd UNION ALL SELECT gac2.person_id, gac2.create_dt, gac2.grd_cal_type, gac2.grd_ci_sequence_number, gac2.ceremony_number, gac2.award_course_cd, gac2.award_crs_version_number, gac2.award_cd, NVL(MAX(gach2.hist_end_dt),gac2.last_update_date), TO_DATE(NULL), gac2.last_updated_by, gac2.us_group_number, gac2.order_in_presentation, gac2.graduand_seat_number, gac2.name_pronunciation, gac2.name_announced, gac2.academic_dress_rqrd_ind, gac2.academic_gown_size, gac2.academic_hat_size, gac2.guest_tickets_requested, gac2.guest_tickets_allocated, gac2.guest_seats, gac2.fees_paid_ind, gac2.created_by, gac2.creation_date, gac2.last_updated_by, gac2.last_update_date, gac2.last_update_login, gac2.special_requirements, gac2.comments FROM IGS_GR_AWD_CRMN gac2, IGS_GR_AWD_CRMN_HIST gach2 WHERE gac2.person_id = gach2.person_id (+) AND gac2.create_dt = gach2.create_dt (+) AND gac2.grd_cal_type = gach2.grd_cal_type (+) AND gac2.grd_ci_sequence_number = gach2.grd_ci_sequence_number (+) AND gac2.ceremony_number = gach2.ceremony_number (+) AND gac2.award_course_cd = gach2.award_course_cd (+) AND gac2.award_crs_version_number = gach2.award_crs_version_number (+) AND gac2.award_cd = gach2.award_cd (+) GROUP BY gac2.person_id, gac2.create_dt, gac2.grd_cal_type, gac2.grd_ci_sequence_number, gac2.ceremony_number, gac2.award_course_cd, gac2.award_crs_version_number, gac2.award_cd, gac2.us_group_number, gac2.order_in_presentation, gac2.graduand_seat_number, gac2.name_pronunciation, gac2.name_announced, gac2.academic_dress_rqrd_ind, gac2.academic_gown_size, gac2.academic_hat_size, gac2.guest_tickets_requested, gac2.guest_tickets_allocated, gac2.guest_seats, gac2.fees_paid_ind, gac2.created_by, gac2.creation_date, gac2.last_updated_by, gac2.last_update_date, gac2.last_update_login, gac2.special_requirements, gac2.comments

View Text - HTML Formatted

SELECT GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_START_DT
, GACH1.HIST_END_DT
, GACH1.HIST_WHO
, NVL(GACH1.US_GROUP_NUMBER
, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'US_GROUP_NUMBER'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT))
, GAC1.US_GROUP_NUMBER)) US_GROUP_NUMBER
, NVL(GACH1.ORDER_IN_PRESENTATION
, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ORDER_IN_PRESENTATION'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT))
, GAC1.ORDER_IN_PRESENTATION)) ORDER_IN_PRESENTATION
, NVL(GACH1.GRADUAND_SEAT_NUMBER
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GRADUAND_SEAT_NUMBER'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 10)
, GAC1.GRADUAND_SEAT_NUMBER)) GRADUAND_SEAT_NUMBER
, NVL(GACH1.NAME_PRONUNCIATION
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'NAME_PRONUNCIATION'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 60)
, GAC1.NAME_PRONUNCIATION)) NAME_PRONUNCIATION
, NVL(GACH1.NAME_ANNOUNCED
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'NAME_ANNOUNCED'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 60)
, GAC1.NAME_ANNOUNCED)) NAME_ANNOUNCED
, NVL(GACH1.ACADEMIC_DRESS_RQRD_IND
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_DRESS_RQRD_IND'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 1)
, GAC1.ACADEMIC_DRESS_RQRD_IND)) ACADEMIC_DRESS_RQRD_IND
, NVL(GACH1.ACADEMIC_GOWN_SIZE
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_GOWN_SIZE'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 10)
, GAC1.ACADEMIC_GOWN_SIZE)) ACADEMIC_GOWN_SIZE
, NVL(GACH1.ACADEMIC_HAT_SIZE
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'ACADEMIC_HAT_SIZE'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 10)
, GAC1.ACADEMIC_HAT_SIZE)) ACADEMIC_HAT_SIZE
, NVL(GACH1.GUEST_TICKETS_REQUESTED
, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_TICKETS_REQUESTED'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT))
, GAC1.GUEST_TICKETS_REQUESTED)) GUEST_TICKETS_REQUESTED
, NVL(GACH1.GUEST_TICKETS_ALLOCATED
, NVL( TO_NUMBER ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_TICKETS_ALLOCATED'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT))
, GAC1.GUEST_TICKETS_ALLOCATED)) GUEST_TICKETS_ALLOCATED
, NVL(GACH1.GUEST_SEATS
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'GUEST_SEATS'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 60)
, GAC1.GUEST_SEATS)) GUEST_SEATS
, NVL(GACH1.FEES_PAID_IND
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'FEES_PAID_IND'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 1)
, GAC1.FEES_PAID_IND)) FEES_PAID_IND
, GACH1.CREATED_BY
, GACH1.CREATION_DATE
, GACH1.LAST_UPDATED_BY
, GACH1.LAST_UPDATE_DATE
, GACH1.LAST_UPDATE_LOGIN
, NVL(GACH1.SPECIAL_REQUIREMENTS
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'SPECIAL_REQUIREMENTS'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 2000)
, GAC1.SPECIAL_REQUIREMENTS)) SPECIAL_REQUIREMENTS
, NVL(GACH1.COMMENTS
, NVL( SUBSTR ( IGS_AU_GEN_003.AUDP_GET_GACH_COL( 'COMMENTS'
, GACH1.PERSON_ID
, GACH1.CREATE_DT
, GACH1.GRD_CAL_TYPE
, GACH1.GRD_CI_SEQUENCE_NUMBER
, GACH1.CEREMONY_NUMBER
, GACH1.AWARD_COURSE_CD
, GACH1.AWARD_CRS_VERSION_NUMBER
, GACH1.AWARD_CD
, GACH1.HIST_END_DT)
, 1
, 2000)
, GAC1.COMMENTS)) COMMENTS
FROM IGS_GR_AWD_CRMN GAC1
, IGS_GR_AWD_CRMN_HIST GACH1
WHERE GAC1.PERSON_ID = GACH1.PERSON_ID
AND GAC1.CREATE_DT = GACH1.CREATE_DT
AND GAC1.GRD_CAL_TYPE = GACH1.GRD_CAL_TYPE
AND GAC1.GRD_CI_SEQUENCE_NUMBER = GACH1.GRD_CI_SEQUENCE_NUMBER
AND GAC1.CEREMONY_NUMBER = GACH1.CEREMONY_NUMBER
AND GAC1.AWARD_COURSE_CD = GACH1.AWARD_COURSE_CD
AND GAC1.AWARD_CRS_VERSION_NUMBER = GACH1.AWARD_CRS_VERSION_NUMBER
AND GAC1.AWARD_CD = GACH1.AWARD_CD UNION ALL SELECT GAC2.PERSON_ID
, GAC2.CREATE_DT
, GAC2.GRD_CAL_TYPE
, GAC2.GRD_CI_SEQUENCE_NUMBER
, GAC2.CEREMONY_NUMBER
, GAC2.AWARD_COURSE_CD
, GAC2.AWARD_CRS_VERSION_NUMBER
, GAC2.AWARD_CD
, NVL(MAX(GACH2.HIST_END_DT)
, GAC2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, GAC2.LAST_UPDATED_BY
, GAC2.US_GROUP_NUMBER
, GAC2.ORDER_IN_PRESENTATION
, GAC2.GRADUAND_SEAT_NUMBER
, GAC2.NAME_PRONUNCIATION
, GAC2.NAME_ANNOUNCED
, GAC2.ACADEMIC_DRESS_RQRD_IND
, GAC2.ACADEMIC_GOWN_SIZE
, GAC2.ACADEMIC_HAT_SIZE
, GAC2.GUEST_TICKETS_REQUESTED
, GAC2.GUEST_TICKETS_ALLOCATED
, GAC2.GUEST_SEATS
, GAC2.FEES_PAID_IND
, GAC2.CREATED_BY
, GAC2.CREATION_DATE
, GAC2.LAST_UPDATED_BY
, GAC2.LAST_UPDATE_DATE
, GAC2.LAST_UPDATE_LOGIN
, GAC2.SPECIAL_REQUIREMENTS
, GAC2.COMMENTS
FROM IGS_GR_AWD_CRMN GAC2
, IGS_GR_AWD_CRMN_HIST GACH2
WHERE GAC2.PERSON_ID = GACH2.PERSON_ID (+)
AND GAC2.CREATE_DT = GACH2.CREATE_DT (+)
AND GAC2.GRD_CAL_TYPE = GACH2.GRD_CAL_TYPE (+)
AND GAC2.GRD_CI_SEQUENCE_NUMBER = GACH2.GRD_CI_SEQUENCE_NUMBER (+)
AND GAC2.CEREMONY_NUMBER = GACH2.CEREMONY_NUMBER (+)
AND GAC2.AWARD_COURSE_CD = GACH2.AWARD_COURSE_CD (+)
AND GAC2.AWARD_CRS_VERSION_NUMBER = GACH2.AWARD_CRS_VERSION_NUMBER (+)
AND GAC2.AWARD_CD = GACH2.AWARD_CD (+) GROUP BY GAC2.PERSON_ID
, GAC2.CREATE_DT
, GAC2.GRD_CAL_TYPE
, GAC2.GRD_CI_SEQUENCE_NUMBER
, GAC2.CEREMONY_NUMBER
, GAC2.AWARD_COURSE_CD
, GAC2.AWARD_CRS_VERSION_NUMBER
, GAC2.AWARD_CD
, GAC2.US_GROUP_NUMBER
, GAC2.ORDER_IN_PRESENTATION
, GAC2.GRADUAND_SEAT_NUMBER
, GAC2.NAME_PRONUNCIATION
, GAC2.NAME_ANNOUNCED
, GAC2.ACADEMIC_DRESS_RQRD_IND
, GAC2.ACADEMIC_GOWN_SIZE
, GAC2.ACADEMIC_HAT_SIZE
, GAC2.GUEST_TICKETS_REQUESTED
, GAC2.GUEST_TICKETS_ALLOCATED
, GAC2.GUEST_SEATS
, GAC2.FEES_PAID_IND
, GAC2.CREATED_BY
, GAC2.CREATION_DATE
, GAC2.LAST_UPDATED_BY
, GAC2.LAST_UPDATE_DATE
, GAC2.LAST_UPDATE_LOGIN
, GAC2.SPECIAL_REQUIREMENTS
, GAC2.COMMENTS