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: IGSFV_ADVISING_GROUPS

Product:	IGS - Student System (Obsolete)
Description:	Stores advising group definition
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AZG.GROUP_NAME
, AZG.GROUP_DESC
, AZG.ADVISING_CODE
, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING'
, AZG.RESP_ORG_UNIT_CD
, AZG.RESP_PERSON_ID
, AZG.DELIVERY_METHOD_CODE
, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING'
, AZG.ADVISOR_GROUP_ID
, AZG.STUDENT_GROUP_ID
, AZG.DEFAULT_ADVISOR_LOAD_NUM
, AZG.MANDATORY_FLAG
, AZG.ADVISING_SESSIONS_NUM
, AZG.ADVISING_HOLD_TYPE
, AZG.CLOSED_FLAG
, AZG.COMMENTS_TXT
, AZG.AUTO_REFRESH_FLAG
, AZG.LAST_AUTO_REFRESH_DATE
, AZG.AUTO_STDNT_ADD_FLAG
, AZG.AUTO_STDNT_REMOVE_FLAG
, AZG.AUTO_ADVISOR_ADD_FLAG
, AZG.AUTO_ADVISOR_REMOVE_FLAG
, AZG.AUTO_MATCH_FLAG
, AZG.AUTO_APPLY_HOLD_FLAG
, AZG.LOCATION_CD
, '_DF:IGS:IGS_AZ_GROUPS_FLEX:AZG'
, AZG.CREATED_BY
, AZG.CREATION_DATE
, AZG.LAST_UPDATED_BY
, AZG.LAST_UPDATE_DATE
, PE.PARTY_NUMBER
, OU.PARTY_NAME
, LOC.DESCRIPTION
, '_LA:MANDATORY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:CLOSED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_REFRESH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_STDNT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_STDNT_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_ADVISOR_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_ADVISOR_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_MATCH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_APPLY_HOLD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ENC.DESCRIPTION
, GR1.DESCRIPTION
, GR2.DESCRIPTION
FROM IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
, HZ_PARTIES OU
, IGS_AD_LOCATION_ALL LOC
, IGS_FI_ENCMB_TYPE_ALL ENC
, IGS_PE_PERSID_GROUP_ALL GR1
, IGS_PE_PERSID_GROUP_ALL GR2
, IGS_PE_HZ_PARTIES IPZ
WHERE AZG.RESP_PERSON_ID = PE.PARTY_ID(+)
AND AZG.RESP_ORG_UNIT_CD = IPZ.OSS_ORG_UNIT_CD
AND AZG.LOCATION_CD = LOC.LOCATION_CD(+)
AND AZG.ADVISING_HOLD_TYPE = ENC.ENCUMBRANCE_TYPE(+)
AND GR1.GROUP_ID(+) = AZG.STUDENT_GROUP_ID
AND GR2.GROUP_ID(+) = AZG.ADVISOR_GROUP_ID
AND IPZ.PARTY_ID = OU.PARTY_ID 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_MTH_CODE_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
_DF
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
RESP_PERSON_NUMBER
RESP_ORGANIZATION
LOCATION_DESC
"_LA:MANDATORY_FLAG_DESC"
"_LA:CLOSED_FLAG_DESC"
"_LA:AUTO_REFRESH_FLAG_DESC"
"_LA:AUTO_STDNT_ADD_FLAG_DESC"
"_LA:AUTO_STDNT_RMV_FLAG_DESC"
"_LA:AUTO_ADVSOR_ADD_FLG_DESC"
"_LA:AUTO_ADVSR_RMV_FLAG_DESC"
"_LA:AUTO_MATCH_FLAG_DESC"
"_LA:AUTO_APPLY_HLD_FLAG_DESC"
HOLD_DESC
STUDENT_GROUP_DESCRIPTION
ADVISOR_GROUP_DESCRIPTION