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

Product:	IGS - Student System (Obsolete)
Description:	Student details associated with the various Advising Groups in the system
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AZS.GROUP_STUDENT_ID
, AZS.GROUP_NAME
, AZS.STUDENT_PERSON_ID
, AZS.START_DATE
, AZS.END_DATE
, AZS.ADVISING_HOLD_TYPE
, AZS.HOLD_START_DATE
, AZS.NOTIFIED_DATE
, AZS.ACCEPT_ADD_FLAG
, '_LA:ACCEPT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZS.ACCEPT_DELETE_FLAG
, '_LA:ACCEPT_DELETE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZG.GROUP_DESC
, PE.PARTY_NUMBER
, ENC.DESCRIPTION
, AZS.CREATED_BY
, AZS.CREATION_DATE
, AZS.LAST_UPDATED_BY
, AZS.LAST_UPDATE_DATE
FROM IGS_AZ_STUDENTS AZS
, IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
, IGS_FI_ENCMB_TYPE_ALL ENC
WHERE AZS.GROUP_NAME = AZG.GROUP_NAME
AND AZS.STUDENT_PERSON_ID = PE.PARTY_ID
AND ENC.ENCUMBRANCE_TYPE = AZS.ADVISING_HOLD_TYPE WITH READ ONLY

Columns

Name
GROUP_STUDENT_IDENTIFIER
GROUP_NAME
STUDENT_PERSON_IDENTIFIER
START_DATE
END_DATE
ADVISING_HOLD_TYPE
HOLD_START_DATE
NOTIFIED_DATE
ACCEPT_ADD_FLAG
"_LA:ACCEPT_ADD_FLAG_DESC"
ACCEPT_DELETE_FLAG
"_LA:ACCEPT_DELETE_FLAG_DESC"
GROUP_DESCRIPTION
STUDENT_PERSON_NUMBER
ADVISING_HOLD_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE