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_ADVISORS_V

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.ROWID ROW_ID
, AZA.GROUP_ADVISOR_ID
, AZA.GROUP_NAME
, AG.GROUP_DESC
, AZA.ADVISOR_PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
, AZA.START_DATE
, AZA.END_DATE
, AZA.MAX_STUDENTS_NUM
, AZA.NOTIFIED_DATE
, AZA.ACCEPT_ADD_FLAG
, AZA.ACCEPT_DELETE_FLAG
, AG.ADVISOR_GROUP_ID
, PG.GROUP_CD
, PG.DESCRIPTION
, AG.DELIVERY_METHOD_CODE
, AZA.CREATED_BY
, AZA.CREATION_DATE
, AZA.LAST_UPDATED_BY
, AZA.LAST_UPDATE_DATE
, AZA.LAST_UPDATE_LOGIN
FROM IGS_AZ_ADVISORS AZA
, IGS_AZ_GROUPS AG
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PG
WHERE AZA.GROUP_NAME = AG.GROUP_NAME
AND AZA.ADVISOR_PERSON_ID = HZ.PARTY_ID
AND PG.GROUP_ID(+) = AG.ADVISOR_GROUP_ID

Columns

Name
ROW_ID
GROUP_ADVISOR_ID
GROUP_NAME
GROUP_DESC
ADVISOR_PERSON_ID
ADVISOR_PERSON_NUMBER
ADVISOR_FULL_NAME
START_DATE
END_DATE
MAX_STUDENTS_NUM
NOTIFIED_DATE
ACCEPT_ADD_FLAG
ACCEPT_DELETE_FLAG
ADVISOR_GROUP_ID
ADVISOR_GROUP_CD
ADVISOR_GROUP_DESC
DELIVERY_METHOD_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN