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]

VIEW: APPS.IGS_AZ_GROUPS_V

Object Details

Object Name:	IGS_AZ_GROUPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AZ_GROUPS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id of the advising group record
GROUP_NAME	VARCHAR2	(90)	Yes	Group Name
GROUP_DESC	VARCHAR2	(240)	Yes	Description of the group
ADVISING_CODE	VARCHAR2	(30)		Advising category
RESP_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Reponsible organization code
RESP_ORG_UNIT_DESC	VARCHAR2	(360)		Desciption of the organization unit for this group
RESP_PERSON_ID	NUMBER	(15)		Person id of the person responsible for this group
RESP_PERSON_NAME	VARCHAR2	(363)		Person name of the person responsible for this group
LOCATION_CD	VARCHAR2	(10)		Location of this group where advising will be conducted
DELIVERY_METHOD_CODE	VARCHAR2	(30)	Yes	The type of the advising group such as 1-on-1 etc
DELIVERY_METHOD_DESC	VARCHAR2	(80)		The description of the delivery method for this group
ADVISOR_GROUP_ID	NUMBER			Advisor group id
ADVISOR_GROUP_DESC	VARCHAR2	(60)		Description of the person id group of the advisros in this group
STUDENT_GROUP_ID	NUMBER			Student"s Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic
STUDENT_GROUP_DESC	VARCHAR2	(60)		Description of the person id group of the advisros in this group
DEFAULT_ADVISOR_LOAD_NUM	NUMBER			Load for an advisor when he is part of this group
MANDATORY_FLAG	VARCHAR2	(1)	Yes	If student should meet the advisor mandatorily for the specific number of times
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	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)		Flexfield attribute
ATTRIBUTE1	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE2	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE3	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE4	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE5	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE6	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE7	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE8	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE9	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE10	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE11	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE12	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE13	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE14	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE15	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE16	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE17	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE18	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE19	VARCHAR2	(150)		Flexfield number 1 through 20
ATTRIBUTE20	VARCHAR2	(150)		Flexfield number 1 through 20
CREATED_BY	NUMBER	(15)	Yes	WHO Column
CREATION_DATE	DATE		Yes	WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO Column
LAST_UPDATE_DATE	DATE		Yes	WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO Column

Query Text

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


SELECT ROW_ID
,      GROUP_NAME
,      GROUP_DESC
,      ADVISING_CODE
,      RESP_ORG_UNIT_CD
,      RESP_ORG_UNIT_DESC
,      RESP_PERSON_ID
,      RESP_PERSON_NAME
,      LOCATION_CD
,      DELIVERY_METHOD_CODE
,      DELIVERY_METHOD_DESC
,      ADVISOR_GROUP_ID
,      ADVISOR_GROUP_DESC
,      STUDENT_GROUP_ID
,      STUDENT_GROUP_DESC
,      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 APPS.IGS_AZ_GROUPS_V;

Dependencies

[top of page]

APPS.IGS_AZ_GROUPS_V references the following:

APPS: HZ_PARTIES; IGS_AZ_GROUPS; IGS_LOOKUP_VALUES; IGS_PE_HZ_PARTIES; IGS_PE_PERSID_GROUP

APPS.IGS_AZ_GROUPS_V is not referenced by any database object