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_AV_ADV_STANDING_V

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

View Text

SELECT AAS.ROWID
, AAS.PERSON_ID
, PPV.PERSON_NUMBER
, PPV.ENCUMBERED_IND
, PPV.CONTEXT_BLOCK_NAME
, PPV.SEX
, PPV.BIRTH_DT
, PPV.DECEASED_IND
, AAS.COURSE_CD
, AAS.VERSION_NUMBER
, AAS.TOTAL_EXMPTN_APPROVED
, AAS.TOTAL_EXMPTN_GRANTED
, AAS.TOTAL_EXMPTN_PERC_GRNTD
, AAS.EXEMPTION_INSTITUTION_CD
, AAS.CREATED_BY
, AAS.CREATION_DATE
, AAS.LAST_UPDATED_BY
, AAS.LAST_UPDATE_DATE
, AAS.LAST_UPDATE_LOGIN
FROM IGS_AV_ADV_STANDING AAS
, IGS_PE_PERSON_V PPV
WHERE AAS.PERSON_ID = PPV.PERSON_ID

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
ENCUMBERED_IND
CONTEXT_BLOCK_NAME
SEX
BIRTH_DT
DECEASED_IND
COURSE_CD
VERSION_NUMBER
TOTAL_EXMPTN_APPROVED
TOTAL_EXMPTN_GRANTED
TOTAL_EXMPTN_PERC_GRNTD
EXEMPTION_INSTITUTION_CD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN