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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AZ_GROUPS

Object Details

Object Name:	IGS_AZ_GROUPS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_AZ_GROUPS
Subobject Name:
Status:	VALID

Stores advising group definition

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AZ_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_NAME
IGS_AZ_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADVISING_CODE
IGS_AZ_GROUPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESP_ORG_UNIT_CD
IGS_AZ_GROUPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESP_PERSON_ID
IGS_AZ_GROUPS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_METHOD_CODE
IGS_AZ_GROUPS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADVISOR_GROUP_ID
IGS_AZ_GROUPS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STUDENT_GROUP_ID
IGS_AZ_GROUPS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADVISING_HOLD_TYPE
IGS_AZ_GROUPS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_NAME	VARCHAR2	(90)	Yes	Primary KeyName of the Advising Group
GROUP_DESC	VARCHAR2	(240)	Yes	A short description of the Advising Group
ADVISING_CODE	VARCHAR2	(30)		User defined advising category that is used as a means to cluster advising groups e.g. Academic Advising Groups, Administrative Advising Groups, Athletic Advising groups, etc.
RESP_ORG_UNIT_CD	VARCHAR2	(30)	Yes	The organization unit responsible for maintaining the advising group
RESP_PERSON_ID	NUMBER	(15)		The primary contact person to answer any questions / issues pertaining to the advising group
LOCATION_CD	VARCHAR2	(10)		Location of the Advising Center of an advising group
DELIVERY_METHOD_CODE	VARCHAR2	(30)	Yes	Delivery method of advise including: (a) 1-on-1, (b) Self-Advise, and (c) Advising Center
ADVISOR_GROUP_ID	NUMBER			Advisor"s Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic.
STUDENT_GROUP_ID	NUMBER			Student"s Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic
DEFAULT_ADVISOR_LOAD_NUM	NUMBER			The default number of Students an Advisor is expected to counsel in an advising group. This number can be overwritten for each advisor assigned to the group.
MANDATORY_FLAG	VARCHAR2	(1)	Yes	If selected, the system will track to ensure that students meet their respective advisor(s) at least as many times as stated in the "Advising Sessions" field
ADVISING_SESSIONS_NUM	NUMBER			Expected number of times a student is expected to meet an Advisor
ADVISING_HOLD_TYPE	VARCHAR2	(10)		If selected, all students associated with the advising group will be required to be put on a "hold" with the selected Advising Hold Type
CLOSED_FLAG	VARCHAR2	(1)	Yes	If selected the checkbox signifies that the group is "inactive"
COMMENTS_TXT	VARCHAR2	(2000)		Free form text field to allow user enter more specific information about the group definition e.g. the types of students, advisors expected to be part of the advising group, etc.
AUTO_REFRESH_FLAG	VARCHAR2	(1)	Yes	Indicates whether the advising group will be selected for periodic run of the maintenance job. If selected, the advising group will be included in the periodic run of the "Maintain Advising Group" concurrent manager job.
LAST_AUTO_REFRESH_DATE	DATE			The Date on which the "Maintain Advising Group" concurrent manager job last considered the advising group for any updates
AUTO_STDNT_ADD_FLAG	VARCHAR2	(1)	Yes	If selected, the suggested Student Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job
AUTO_STDNT_REMOVE_FLAG	VARCHAR2	(1)	Yes	If selected, the suggested Student Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job
AUTO_ADVISOR_ADD_FLAG	VARCHAR2	(1)	Yes	If selected, the suggested Advisor Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job
AUTO_ADVISOR_REMOVE_FLAG	VARCHAR2	(1)	Yes	If selected, the suggested Advisor Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job
AUTO_MATCH_FLAG	VARCHAR2	(1)	Yes	If selected, the suggested Advisor and Student matches will be automatically confirmed by the "Maintain Advising Group" concurrent manager job
AUTO_APPLY_HOLD_FLAG	VARCHAR2	(1)	Yes	If selected the "Apply Advising Hold" concurrent manager job, during its periodic run, will put all eligible students on an "advising hold"
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category for the flex field usage.
ATTRIBUTE1	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE2	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE3	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE4	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE5	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE6	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE7	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE8	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE9	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE10	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE11	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE12	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE13	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE14	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE15	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE16	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE17	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE18	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE19	VARCHAR2	(150)		Attribute for Flex field
ATTRIBUTE20	VARCHAR2	(150)		Attribute for Flex field
CREATED_BY	NUMBER	(15)	Yes	STANDARD WHO Column
CREATION_DATE	DATE		Yes	STANDARD WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	STANDARD WHO Column
LAST_UPDATE_DATE	DATE		Yes	STANDARD WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		STANDARD WHO Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_NAME
,      GROUP_DESC
,      ADVISING_CODE
,      RESP_ORG_UNIT_CD
,      RESP_PERSON_ID
,      LOCATION_CD
,      DELIVERY_METHOD_CODE
,      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
,      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.IGS_AZ_GROUPS;

Dependencies

[top of page]

IGS.IGS_AZ_GROUPS does not reference any database object

IGS.IGS_AZ_GROUPS is referenced by following:

APPS: IGS_AZ_GROUPS