[Home] [Help] [Dependency Information]
Object Name: | IGSBV_HIGHER_EDU_PRG_AWARDS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_HIGHER_EDU_PRG_AWARDS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the base view which describes the award to students on completion of the program. The allowance has been made for zero to many awards per program.
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. |
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.IGSBV_HIGHER_EDU_PRG_AWARDS;
APPS.IGSBV_HIGHER_EDU_PRG_AWARDS is not referenced by any database object
|
|
|