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.IGSFV_ADVISING_RELATIONS

Object Details

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

View Type

A Business Intelligence System view

View to display the advisor student relationship information for the advising functionality.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ADVISING_REL_IDENTIFIER	NUMBER		Yes	Primary key of the table. Indicates the relationship ID between the student and an advisor for the group. Its sequence generated.
GROUP_NAME	VARCHAR2	(90)	Yes	Group name for which the relationship is being created.
GROUP_ADVISOR_IDENTIFIER	NUMBER		Yes	The Primary Key ID of the table of Advisor table
GROUP_STUDENT_IDENTIFIER	NUMBER		Yes	The sequence generated ID of the Advising student table.
START_DATE	DATE			Start date of the relationship between the student and the advisor for a group.
END_DATE	DATE			Date on which the relationship between the student and the advisor for a group terminated.
STUDENT_PERSON_IDENTIFIER	NUMBER	(15)	Yes	Person ID of the Student
STUDENT_PERSON_NUMBER	VARCHAR2	(30)	Yes	Student Person Number
ADVISOR_PERSON_ID	NUMBER	(15)	Yes	Person ID of the Advisor
ADVISOR_PERSON_NUMBER	VARCHAR2	(30)	Yes	Advisor Person Number
GROUP_DESCRIPTION	VARCHAR2	(240)	Yes	Description of the person id group of the advisors in this group
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

Query Text

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


SELECT GROUP_ADVISING_REL_IDENTIFIER
,      GROUP_NAME
,      GROUP_ADVISOR_IDENTIFIER
,      GROUP_STUDENT_IDENTIFIER
,      START_DATE
,      END_DATE
,      STUDENT_PERSON_IDENTIFIER
,      STUDENT_PERSON_NUMBER
,      ADVISOR_PERSON_ID
,      ADVISOR_PERSON_NUMBER
,      GROUP_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ADVISING_RELATIONS;

Dependencies

[top of page]

APPS.IGSFV_ADVISING_RELATIONS references the following:

APPS: HZ_PARTIES; IGS_AZ_ADVISING_RELS; IGS_AZ_ADVISORS; IGS_AZ_GROUPS; IGS_AZ_STUDENTS

APPS.IGSFV_ADVISING_RELATIONS is not referenced by any database object