[Home] [Help]
View: IGSBV_ADVISING_GROUPS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Stores advising group definition |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
Columns
| Name |
| ADVISING_GROUP_NAME |
| GROUP_DESCRIPTION |
| ADVISING_CATEGORY |
| "_LA:ADVISING_CATEGORY_DESC" |
| RESP_ORG_UNIT_CODE |
| RESP_PERSON_IDENTIFIER |
| DELIVERY_METHOD_CODE |
| "_LA:DELIVERY_METHOD_CD_DESC" |
| ADVISOR_GROUP_ID |
| STUDENT_GROUP_ID |
| DEFAULT_ADVISOR_LOAD |
| MANDATORY_FLAG |
| ADVISING_SESSIONS |
| ADVISING_HOLD_TYPE |
| CLOSED_FLAG |
| COMMENTS |
| 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_CODE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |