[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View to display the student information for advising on the SS page. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AZS.ROWID ROW_ID
, AZS.GROUP_STUDENT_ID
, AZS.GROUP_NAME
, AG.GROUP_DESC
, AZS.STUDENT_PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
, AZS.START_DATE
, AZS.END_DATE
, AZS.ADVISING_HOLD_TYPE
, AZS.HOLD_START_DATE
, (SELECT PE.EXPIRY_DT
FROM IGS_PE_PERS_ENCUMB PE
WHERE PE.PERSON_ID = AZS.STUDENT_PERSON_ID
AND PE.ENCUMBRANCE_TYPE = AZS.ADVISING_HOLD_TYPE
AND PE.START_DT = AZS.HOLD_START_DATE) HOLD_END_DATE
, AZS.NOTIFIED_DATE
, AZS.ACCEPT_ADD_FLAG
, AZS.ACCEPT_DELETE_FLAG
, AZS.CREATED_BY
, AZS.CREATION_DATE
, AZS.LAST_UPDATED_BY
, AZS.LAST_UPDATE_DATE
, AZS.LAST_UPDATE_LOGIN
, AG.STUDENT_GROUP_ID
, PG.GROUP_CD STUDENT_GROUP_CD
, PG.DESCRIPTION STUDENT_GROUP_DESC
, AG.DELIVERY_METHOD_CODE
FROM IGS_AZ_STUDENTS AZS
, IGS_AZ_GROUPS AG
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PG
WHERE AZS.GROUP_NAME = AG.GROUP_NAME
AND AZS.STUDENT_PERSON_ID = HZ.PARTY_ID
AND PG.GROUP_ID(+) = AG.STUDENT_GROUP_ID