Product: | IGS - Student System |
---|---|
Description: | Stores advising group definition |
Implementation/DBA Data: | APPS.IGSBV_ADVISING_GROUPS |
SELECT GROUP_NAME
, GROUP_DESC
, ADVISING_CODE
, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING'
, RESP_ORG_UNIT_CD
, RESP_PERSON_ID
, DELIVERY_METHOD_CODE
, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING'
, ADVISOR_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
, LOCATION_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_AZ_GROUPS WITH READ ONLY