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]

TABLE: IGS.IGS_GR_HONOURS_LEVEL_ALL

Object Details

Object Name:	IGS_GR_HONOURS_LEVEL_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_GR_HONOURS_LEVEL_ALL
Subobject Name:
Status:	VALID

IGS_GR_HONOURS_LEVEL_ALL describes the user-defined level of honors granted to a student as part of graduation. These will map back onto the DEET level of honors.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_HONOURS_LEVEL_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HONOURS_LEVEL
IGS_GR_HONOURS_LEVEL_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_HONOURS_LEVEL

Columns

Name	Datatype	Length	Mandatory	Comments
HONOURS_LEVEL	VARCHAR2	(3)	Yes	An institution-defined code that defines the honours level granted to a graduating student. For example, 'H1' - first class honors. Honors level can also be used to indicate other windows of achievement by graduating students such as 'pass with merit' or 'pass with distinction'.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes honors level code. The honors level code is an institution-defined code that defines the honors level granted to a graduating student. For example, 'H1' - first class honors.
GOVT_HONOURS_LEVEL	VARCHAR2	(1)		The government-defined honors level code that the institution defined honors level is mapped. Used for reporting purposes. It indicates the level of bachelor honors award which has been granted to a student.
RANK	NUMBER	(3)	Yes	The rank of the honors level in relation to other honors levels. Rank is used for comparison of honors level in sort ordering on reports and for ordering of graduands in conferral ceremonies
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the honors level is open or closed. Selecting the indicator to 'closed' prevents use of the code in new or modified graduand records.
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HONOURS_LEVEL
,      DESCRIPTION
,      GOVT_HONOURS_LEVEL
,      RANK
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_GR_HONOURS_LEVEL_ALL;

Dependencies

[top of page]

IGS.IGS_GR_HONOURS_LEVEL_ALL does not reference any database object

IGS.IGS_GR_HONOURS_LEVEL_ALL is referenced by following:

APPS: IGS_GR_HONOURS_LEVEL_ALL