[Home] [Help] [Dependency Information]
Object Name: | IGSBV_AWARDS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_AWARDS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the base view which describes the awards offered by the university.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AWARD_CODE | VARCHAR2 | (10) | Yes | The code for an award offered by the institution. |
AWARD_TITLE | VARCHAR2 | (90) | Yes | The name of an award offered by the institution. Examples are BACHELOR OF ARTS, GRADUATE DIPLOMA OF EDUCATION. |
SYSTEM_AWARD_TYPE | VARCHAR2 | (10) | Yes | The system defined award type. i.e., program, honorary, prize, medal. |
TESTAMUR_DEGREE_TYPE | VARCHAR2 | (10) | Institution-defined degree type to that the award is mapped. This enables student system to produce the correct degree type for each graduate. Examples: University, Entrepreneurial. | |
CLOSED_INDICATOR | VARCHAR2 | (1) | Yes | An indicator, which specifies if the award is open or closed. Setting the checkbox to 'Closed' (ticked) prevents use of the award in new or modified records in other parts of the system, such as program awards and special awards. |
NOTES | VARCHAR2 | (2000) | Enables the recording of any additional information or details about the award. | |
GRADING_SCHEMA_CODE | VARCHAR2 | (10) | The grading schema for the award. | |
GRADING_SCHEMA_VERSION_NUMBER | NUMBER | (3) | The grading schema version number for the award. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
CREATED_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
LAST_UPDATED_DATE | DATE | Yes | Standard Who Column. |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_CODE
, AWARD_TITLE
, SYSTEM_AWARD_TYPE
, TESTAMUR_DEGREE_TYPE
, CLOSED_INDICATOR
, NOTES
, GRADING_SCHEMA_CODE
, GRADING_SCHEMA_VERSION_NUMBER
, CREATED_BY
, CREATED_DATE
, LAST_UPDATED_BY
, LAST_UPDATED_DATE
FROM APPS.IGSBV_AWARDS;
APPS.IGSBV_AWARDS is not referenced by any database object
|
|
|