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

VIEW: APPS.IGSFV_UNIT_FIELD_OF_STUDIES

Object Details
Object Name: IGSFV_UNIT_FIELD_OF_STUDIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_UNIT_FIELD_OF_STUDIES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This is the full view, which describes the Field of Study with details unit code, version number, unit title, field of study and field of study description


[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_FIELD_OF_STUDY_ID NUMBER (10) Yes Unique Identifier for Unit Field of Study
UNIT_CODE VARCHAR2 (10) Yes The unique identifier of the unit.
VERSION_NUMBER NUMBER (3) Yes The version number of the unit.
FIELD_OF_STUDY VARCHAR2 (10) Yes The area or field to which the unit belongs.
UNIT_TITLE VARCHAR2 (90) Yes The title of the unit.
FIELD_OF_STUDY_DESCRIPTION VARCHAR2 (80) Yes The description of an institution-defined field of study. A field of study is a classification of courses based on similarity in terms of the vocational field of specialisation or the principal subject matter of the course.
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 UNIT_FIELD_OF_STUDY_ID
,      UNIT_CODE
,      VERSION_NUMBER
,      FIELD_OF_STUDY
,      UNIT_TITLE
,      FIELD_OF_STUDY_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UNIT_FIELD_OF_STUDIES;

Dependencies

[top of page]

APPS.IGSFV_UNIT_FIELD_OF_STUDIES references the following:

SchemaAPPS
SynonymIGS_PS_FLD_OF_STUDY_ALL
SynonymIGS_PS_UNIT_FLD_STDY
SynonymIGS_PS_UNIT_VER_ALL

APPS.IGSFV_UNIT_FIELD_OF_STUDIES is not referenced by any database object