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]

VIEW: APPS.IGS_AD_ADM_UT_STA_GD_V

Object Details

Object Name:	IGS_AD_ADM_UT_STA_GD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_ADM_UT_STA_GD_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Describes the grading schema code grades applicable to an
administrative unit status. This caters for versions of the grading
schema code. At any point in time, there should be only one grading
schema code grade applicable.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier for each row
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	The version number of the grading schema code containing the grade associated with the specified administrative unit status
GRADE	VARCHAR2	(5)	Yes	The 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.
START_DT	DATE		Yes	Start date of the grading schema version
END_DT	DATE			The end date of the grading schema version. If the end date is less than the current date, the schema version is not available to be attached to any unit offering options, program offering patterns or student unit attempts.
FULL_GRADE_NAME	VARCHAR2	(60)	Yes	Full name of a grade. For example, "Distinction", "High Distinction".
S_RESULT_TYPE	VARCHAR2	(30)	Yes	System defined result for the grade. Result types enable the system to identify the nature of a student unit attempt outcome for specific functionality such as progression rules. Available system result types are pass, fail, incomplete and withdrawn.
MEANING	VARCHAR2	(80)	Yes	Meaning associated with the unit attempt status
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 ROW_ID
,      ADMINISTRATIVE_UNIT_STATUS
,      GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      GRADE
,      START_DT
,      END_DT
,      FULL_GRADE_NAME
,      S_RESULT_TYPE
,      MEANING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_ADM_UT_STA_GD_V;

Dependencies

[top of page]

APPS.IGS_AD_ADM_UT_STA_GD_V references the following:

APPS: IGS_AD_ADM_UT_STA_GD; IGS_AS_GRD_SCHEMA; IGS_AS_GRD_SCH_GRADE; IGS_LOOKUPS_VIEW

APPS.IGS_AD_ADM_UT_STA_GD_V is not referenced by any database object