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: IGSBV_GR_CRMN_STDNT_PRG

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

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, GAC.CREATE_DT
, GAC.GRD_CAL_TYPE
, GAC.GRD_CI_SEQUENCE_NUMBER
, GAC.CEREMONY_NUMBER
, GAC.AWARD_COURSE_CD
, GAC.AWARD_CRS_VERSION_NUMBER
, GAC.AWARD_CD
, 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
, GAC.ACADEMIC_HAT_SIZE
, 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
WHERE GAC.PERSON_ID = HP.PARTY_ID WITH READ ONLY

Columns

Name
PERSON_NAME
PERSON_NUMBER
CREATE_DT
GRD_CAL_TYPE
GRD_CI_SEQUENCE_NUMBER
CEREMONY_NUMBER
AWARD_PROGRAM_CODE
AWARD_PROGRAM_VERSION_NUMBER
AWARD_CD
US_GROUP_NUMBER
ORDER_IN_PRESENTATION
GRADUAND_SEAT_NUMBER
NAME_PRONUNCIATION
NAME_ANNOUNCED
"_LA:ACADEMIC_DRESS_RQRD_IND"
ACADEMIC_GOWN_SIZE
ACADEMIC_HAT_SIZE
GUEST_TICKETS_REQUESTED
GUEST_TICKETS_ALLOCATED
GUEST_SEATS
"_LA:FEES_PAID_IND"
SPECIAL_REQUIREMENTS
COMMENTS
GAC_ID
PERSON_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE