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_ADVISORS

Product:	IGS - Student System (Obsolete)
Description:	View to display the advisor information for the advising functionality.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AZA.GROUP_ADVISOR_ID
, AZA.GROUP_NAME
, AZA.ADVISOR_PERSON_ID
, AZA.START_DATE
, AZA.END_DATE
, AZA.MAX_STUDENTS_NUM
, AZA.NOTIFIED_DATE
, AZA.ACCEPT_ADD_FLAG
, '_LA:ACCEPT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZA.ACCEPT_DELETE_FLAG
, '_LA:ACCEPT_DELETE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZG.GROUP_DESC
, PE.PARTY_NUMBER
, AZA.CREATED_BY
, AZA.CREATION_DATE
, AZA.LAST_UPDATED_BY
, AZA.LAST_UPDATE_DATE
FROM IGS_AZ_ADVISORS AZA
, IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
WHERE AZA.GROUP_NAME = AZG.GROUP_NAME
AND AZA.ADVISOR_PERSON_ID = PE.PARTY_ID WITH READ ONLY

Columns

Name
GROUP_ADVISOR_IDENTIFIER
GROUP_NAME
ADVISOR_PERSON_IDENTIFIER
START_DATE
END_DATE
MAX_STUDENTS_NUM
NOTIFIED_DATE
ACCEPT_ADD_FLAG
"_LA:ACCEPT_ADD_FLAG_DESC"
ACCEPT_DELETE_FLAG
"_LA:ACCEPT_DELETE_FLAG_DESC"
GROUP_DESCRIPTION
ADVISOR_PERSON_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE