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

VIEW: APPS.IGSFV_HIGHER_EDU_PRG_AWARDS

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

View Type

A Business Intelligence System view


This is the full view which describes the award to students on completion of the program. The allowance has been made for zero to many awards per program.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRAM_CODE VARCHAR2 (6) Yes Describes the program code for which the award is being specified.
VERSION_NUMBER NUMBER (3) Yes Describes the version number of the program for which the award is being specified.
AWARD_CODE VARCHAR2 (10) Yes Unique identifier for the award.
AWARD_TITLE VARCHAR2 (90)
The name of an award offered by the institution. Examples are BACHELOR OF ARTS, GRADUATE DIPLOMA OF EDUCATION.
DEFAULT_INDICATOR VARCHAR2 (1)
Indicates the default award for the program.
PROGRAM_TITLE VARCHAR2 (90) Yes The title or full name of the program.
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 PROGRAM_CODE
,      VERSION_NUMBER
,      AWARD_CODE
,      AWARD_TITLE
,      DEFAULT_INDICATOR
,      PROGRAM_TITLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_HIGHER_EDU_PRG_AWARDS;

Dependencies

[top of page]

APPS.IGSFV_HIGHER_EDU_PRG_AWARDS references the following:

SchemaAPPS
SynonymIGS_PS_AWARD
SynonymIGS_PS_AWD
SynonymIGS_PS_VER_ALL

APPS.IGSFV_HIGHER_EDU_PRG_AWARDS is not referenced by any database object