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_V

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

View Text

SELECT CR.GAC_ID
, CR.PERSON_ID
, PE.PERSON_NUMBER
, PE.BIRTH_DT
, PE.ENCUMBERED_IND
, PE.DECEASED_IND
, PE.CONTEXT_BLOCK_NAME
, PE.SEX
, PE.SEX_MEANING AS MEANING
, CR.CREATE_DT
, CR.GRD_CAL_TYPE
, CR.GRD_CI_SEQUENCE_NUMBER
, CR.CEREMONY_NUMBER
, CR.AWARD_COURSE_CD
, CR.AWARD_CRS_VERSION_NUMBER
, CR.AWARD_CD
, CR.US_GROUP_NUMBER
, CR.ORDER_IN_PRESENTATION
, CR.GRADUAND_SEAT_NUMBER
, CR.NAME_PRONUNCIATION
, CR.NAME_ANNOUNCED
, CR.ACADEMIC_DRESS_RQRD_IND
, CR.ACADEMIC_GOWN_SIZE
, CR.ACADEMIC_HAT_SIZE
, CR.GUEST_TICKETS_REQUESTED
, CR.GUEST_TICKETS_ALLOCATED
, CR.GUEST_SEATS
, CR.FEES_PAID_IND
, CR.SPECIAL_REQUIREMENTS
, CR.COMMENTS
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, CR.REQUEST_ID
, CR.PROGRAM_APPLICATION_ID
, CR.PROGRAM_ID
, CR.PROGRAM_UPDATE_DATE
FROM IGS_GR_AWD_CRMN CR
, IGS_PE_PERSON_V PE
WHERE CR.PERSON_ID=PE.PERSON_ID

Columns

Name
GAC_ID
PERSON_ID
PERSON_NUMBER
BIRTH_DT
ENCUMBERED_IND
DECEASED_IND
CONTEXT_BLOCK_NAME
SEX
MEANING
CREATE_DT
GRD_CAL_TYPE
GRD_CI_SEQUENCE_NUMBER
CEREMONY_NUMBER
AWARD_COURSE_CD
AWARD_CRS_VERSION_NUMBER
AWARD_CD
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
SPECIAL_REQUIREMENTS
COMMENTS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE