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_FIELDS_OF_STUDY

Object Details

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

View Type

A Business Intelligence System view

This is the full view which describes university set of fields of study.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FIELD_OF_STUDY	VARCHAR2	(10)	Yes	The unique identifier for the institution-defined field of study. Field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program. Each field of study must be mapped to a Government field of study. Examples are ARCHAEOLOGY, MUSIC.
FIELD_OF_STUDY_DESCRIPTION	VARCHAR2	(80)	Yes	The description of an institution-defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
GOVT_FIELD_OF_STUDY	VARCHAR2	(10)		The unique identifier for the Government-defined field of study. Each institution-defined field of study is mapped to a Government field of study.
CLOSED_INDICATOR	VARCHAR2	(1)	Yes	An indicator, which specifies if the field of study is open or closed. Setting the checkbox to 'closed' (ticked) prevents use of the field of study in new or modified field of study records.
GOVT_FIELD_OF_STUDY_DESC	VARCHAR2	(60)	Yes	A description of the government field of study.
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 FIELD_OF_STUDY
,      FIELD_OF_STUDY_DESCRIPTION
,      GOVT_FIELD_OF_STUDY
,      CLOSED_INDICATOR
,      GOVT_FIELD_OF_STUDY_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_FIELDS_OF_STUDY;

Dependencies

[top of page]

APPS.IGSFV_FIELDS_OF_STUDY references the following:

APPS: IGS_PS_FLD_OF_STUDY_ALL; IGS_RE_GV_FLD_OF_SDY

APPS.IGSFV_FIELDS_OF_STUDY is not referenced by any database object