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_AZ_ADVISING_RELS_V

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 AZREL.ROWID
, AZREL.GROUP_NAME
, HP1.PERSON_LAST_NAME ||'
, '||HP1.PERSON_FIRST_NAME||' '||HP1.PERSON_MIDDLE_NAME
, HP1.PARTY_NUMBER
, HP2.PERSON_LAST_NAME ||'
, '||HP2.PERSON_FIRST_NAME||' '||HP2.PERSON_MIDDLE_NAME
, HP2.PARTY_NUMBER
, AZREL.START_DATE
, AZREL.END_DATE
, AZREL.GROUP_ADVISING_REL_ID
, AZREL.GROUP_ADVISOR_ID
, AZREL.GROUP_STUDENT_ID
, AZSTU.STUDENT_PERSON_ID
, AZADV.ADVISOR_PERSON_ID
, AZREL.CREATED_BY
, AZREL.CREATION_DATE
, AZREL.LAST_UPDATED_BY
, AZREL.LAST_UPDATE_DATE
, AZREL.LAST_UPDATE_LOGIN
FROM IGS_AZ_ADVISING_RELS AZREL
, IGS_AZ_STUDENTS AZSTU
, IGS_AZ_ADVISORS AZADV
, HZ_PARTIES HP1
, HZ_PARTIES HP2
WHERE AZREL.GROUP_STUDENT_ID = AZSTU.GROUP_STUDENT_ID
AND AZREL.GROUP_NAME = AZSTU.GROUP_NAME
AND AZREL.GROUP_ADVISOR_ID = AZADV.GROUP_ADVISOR_ID
AND AZREL.GROUP_NAME = AZADV.GROUP_NAME
AND AZSTU.STUDENT_PERSON_ID = HP1.PARTY_ID
AND AZADV.ADVISOR_PERSON_ID = HP2.PARTY_ID

Columns

Name
ROW_ID
GROUP_NAME
STUDENT_NAME
STUDENT_NUMBER
ADVISOR_NAME
ADVISOR_NUMBER
RELATION_START_DATE
RELATION_END_DATE
ADVISING_REL_ID
GROUP_ADVISOR_ID
GROUP_STUDENT_ID
STUDENT_PERSON_ID
ADVISOR_PERSON_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN