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_AD_ADM_UT_STA_GD

Object Details

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

IGS_AD_ADM_UT_STA_GD describes the grading schema code grades applicable to an administrative unit status.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_ADM_UT_STA_GD_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADMINISTRATIVE_UNIT_STATUS GRADING_SCHEMA_CD VERSION_NUMBER GRADE
IGS_AD_ADM_UT_STA_GD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADING_SCHEMA_CD VERSION_NUMBER GRADE

Columns

Name	Datatype	Length	Mandatory	Comments
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)	Yes	Describes user-defined administrative statuses. For example, withdrawn early, supplementary exam granted.
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	Code of the grading schema containing the default grade for the specified administrative unit status.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the grading schema code containing the grade associated with the specified administrative unit status.
GRADE	VARCHAR2	(5)	Yes	Default grade for the specified administrative unit status AUS. This grade is created by the system as the student unit attempt outcome when the associated AUS is assigned to the unit attempt. At any point in time, an AUS can be associated with only one grade attached to a current grading schema.
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

Query Text

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


SELECT ADMINISTRATIVE_UNIT_STATUS
,      GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      GRADE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_ADM_UT_STA_GD;

Dependencies

[top of page]

IGS.IGS_AD_ADM_UT_STA_GD does not reference any database object

IGS.IGS_AD_ADM_UT_STA_GD is referenced by following:

APPS: IGS_AD_ADM_UT_STA_GD