Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View to display the advising group definition in the self-service page. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID
, GROUP_NAME
, GROUP_DESC
, ADVISING_CODE
, RESP_ORG_UNIT_CD
, (SELECT PARTY_NAME
FROM HZ_PARTIES HZ
, IGS_PE_HZ_PARTIES IPZ
WHERE IPZ.OSS_ORG_UNIT_CD = RESP_ORG_UNIT_CD
AND IPZ.PARTY_ID = HZ.PARTY_ID)
, RESP_PERSON_ID
, (SELECT HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
FROM HZ_PARTIES HZ
WHERE HZ.PARTY_ID = RESP_PERSON_ID)
, LOCATION_CD
, DELIVERY_METHOD_CODE
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'IGS_AZ_DELIV_METHOD'
AND LOOKUP_CODE = DELIVERY_METHOD_CODE)
, ADVISOR_GROUP_ID
, (SELECT DESCRIPTION
FROM IGS_PE_PERSID_GROUP
WHERE GROUP_ID = ADVISOR_GROUP_ID)
, STUDENT_GROUP_ID
, (SELECT DESCRIPTION
FROM IGS_PE_PERSID_GROUP
WHERE GROUP_ID = STUDENT_GROUP_ID)
, DEFAULT_ADVISOR_LOAD_NUM
, MANDATORY_FLAG
, ADVISING_SESSIONS_NUM
, ADVISING_HOLD_TYPE
, CLOSED_FLAG
, COMMENTS_TXT
, AUTO_REFRESH_FLAG
, LAST_AUTO_REFRESH_DATE
, AUTO_STDNT_ADD_FLAG
, AUTO_STDNT_REMOVE_FLAG
, AUTO_ADVISOR_ADD_FLAG
, AUTO_ADVISOR_REMOVE_FLAG
, AUTO_MATCH_FLAG
, AUTO_APPLY_HOLD_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_AZ_GROUPS