eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_GR_AWD_CRMN_HIST_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
PERSON_ID
CREATE_DT
GRD_CAL_TYPE
GRD_CI_SEQUENCE_NUMBER
CEREMONY_NUMBER
AWARD_COURSE_CD
AWARD_CRS_VERSION_NUMBER
AWARD_CD
HIST_START_DT
HIST_END_DT
HIST_WHO
US_GROUP_NUMBER
ORDER_IN_PRESENTATION
GRADUAND_SEAT_NUMBER
NAME_PRONUNCIATION
NAME_ANNOUNCED
ACADEMIC_DRESS_RQRD_IND
ACADEMIC_GOWN_SIZE
ACADEMIC_HAT_SIZE
GUEST_TICKETS_REQUESTED
GUEST_TICKETS_ALLOCATED
GUEST_SEATS
FEES_PAID_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SPECIAL_REQUIREMENTS
COMMENTS