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_RELATIONS

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

View Text

SELECT AZR.GROUP_ADVISING_REL_ID
, AZR.GROUP_NAME
, AZR.GROUP_ADVISOR_ID
, AZR.GROUP_STUDENT_ID
, AZR.START_DATE
, AZR.END_DATE
, AZS.STUDENT_PERSON_ID
, PE1.PARTY_NUMBER
, AZA.ADVISOR_PERSON_ID
, PE2.PARTY_NUMBER
, AZG.GROUP_DESC
, AZR.CREATED_BY
, AZR.CREATION_DATE
, AZR.LAST_UPDATED_BY
, AZR.LAST_UPDATE_DATE
FROM IGS_AZ_ADVISING_RELS AZR
, IGS_AZ_GROUPS AZG
, IGS_AZ_STUDENTS AZS
, IGS_AZ_ADVISORS AZA
, HZ_PARTIES PE1
, HZ_PARTIES PE2
WHERE AZR.GROUP_NAME = AZG.GROUP_NAME
AND AZR.GROUP_STUDENT_ID = AZS.GROUP_STUDENT_ID
AND AZR. GROUP_NAME = AZS. GROUP_NAME
AND PE1.PARTY_ID = AZS.STUDENT_PERSON_ID
AND AZR.GROUP_ADVISOR_ID = AZA.GROUP_ADVISOR_ID
AND AZR. GROUP_NAME = AZA. GROUP_NAME
AND PE2.PARTY_ID = AZA.ADVISOR_PERSON_ID WITH READ ONLY

Columns

Name
GROUP_ADVISING_REL_IDENTIFIER
GROUP_NAME
GROUP_ADVISOR_IDENTIFIER
GROUP_STUDENT_IDENTIFIER
START_DATE
END_DATE
STUDENT_PERSON_IDENTIFIER
STUDENT_PERSON_NUMBER
ADVISOR_PERSON_ID
ADVISOR_PERSON_NUMBER
GROUP_DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE