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_AS_GRD_SCH_GRADE

Object Details

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

IGS_AS_GRD_SCH_GRADE describes characteristics of grade within grading schema.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_GRD_SCH_GRADE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRADING_SCHEMA_CD VERSION_NUMBER GRADE

Columns

Name	Datatype	Length	Mandatory	Comments
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	The code that identifies the grading schema. A grading schema describes the set of available marks and grades which can be used inthe assessment of student unit attempts. There may be multiple grading schemas for any one institution.
VERSION_NUMBER	NUMBER	(3)	Yes	A system generated number used to identify the version of the grading schema.
GRADE	VARCHAR2	(5)	Yes	A code representing the grade which indicates the student's level ofachievement in the unit attempt. For example HD, D, C.
FULL_GRADE_NAME	VARCHAR2	(60)	Yes	The full name of a grade. For example "Distinction", "High Distinction".
S_RESULT_TYPE	VARCHAR2	(30)	Yes	The 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 systemresult types are pass, fail, incomplete and withdrawn.
SHOW_ON_NOTICEBOARD_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether or not unit attempts with this grading schema grade will be included on noticeboard lists of results. Selecting the indicator ticked allows unit attempts with the grade to be included in noticeboard lists.
SHOW_ON_OFFICIAL_NTFCTN_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether or not unit attempts with the grade will be included on official notifications of results. Setting the indicator ticked allows unit attempts with the grade to beincluded on official notifications. For example transcripts, official statements of results.
S_SPECIAL_GRADE_TYPE	VARCHAR2	(20)		The special grade type of the grade. The available special grade types are special-exam, supp-exam, and replaceable. The types special-exam and supp-exam are used by the system to identify students requiring deferred/ special/ supplementary examinations, details of which are passed to the exam timetabling module. The type replaceable identifies a grade that may be overridden during the electronic results upload process.
SHOW_IN_NEWSPAPER_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether or not unit attempts with the grade can be published in the newspaper. Setting the indicator ticked allows the unit attempts with the grad to be published in thenewspaper. For example may elect not to display a fail grade in the newspaper.
SHOW_INTERNALLY_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether or not the grade is shown on documents internal to the institution. Setting the indicator ticked allows the grade to be shown on internal documents. For example, internal transcripts, and academic histories.
SYSTEM_ONLY_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether or not the grade can only be assigned by system processes. Setting the indicator ticked means the grade can only be assigned by the system and cannot be entered.
DFLT_OUTSTANDING_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the grade is the default grade used to replace blank grades by the insert administrative grades process. The default grade is used only if the 'Insert Default From Grading Schema' parameter is set to "Y" when the process is running. Setting the checkbox here ticked identifies the grade as the default administrative grade.
EXTERNAL_GRADE	VARCHAR2	(5)		The name of the external grade that is equivalent to the institution grade schema grade. External grades are typically used when grades are published via external sources such as newspapers. For example, the grade "FF - BAD FAIL" may have an external grade of "F- FAIL".
LOWER_MARK_RANGE	NUMBER	(6)		A numerical value that designates the lowest mark a student can achieve to be awarded a certain grade. The system uses the grade mark range to derive grades and to validate grades against marks. For example, eighty can be the lowest mark for a high distinction.
UPPER_MARK_RANGE	NUMBER	(6)		A numerical value that designates the highest mark a student can achieve to be awarded a certain grade rank. The system uses the grade mark range to derive grades and to validate grades against marks. For example, seventy nine can be the highest mark for a distinction.
MIN_PERCENTAGE	NUMBER	(3)		The normal expected minimum percentage of students awarded the grade for a particular unit offering option. Used for reporting purposes only, there is no system functionality attached to this item.
MAX_PERCENTAGE	NUMBER	(3)		The normal expected maximum percentage of students awarded the grade for a particular unit offering. Used for reporting purposes only there is no system functionality attached to this item.
GPA_VAL	NUMBER	(5)		The numerical value assigned to the grade for use in calculation of a student's GPA - grade point average.
INCL_IN_REPEAT_PROCESS_IND	VARCHAR2	(1)		Include in Repeat Processing (Y/N)
SHOW_IN_EARNED_CRDT_IND	VARCHAR2	(1)		Includes in Earned Credit Points (Y/N)
ADMIN_ONLY_IND	VARCHAR2	(1)		Administrator only grade (Y/N)
GRADING_PERIOD_CD	VARCHAR2	(30)		Grading Period Code for which the grade is valid
RANK	NUMBER	(3)	Yes	The rank of the grade in relation to other grades within the same grading schema. Rank is used for comparison of grades in rules. For example, has a student achieved a grade better than a credit and also in sorted ordering on reports. For example, unit outcome distribution report.
REPEAT_GRADE	VARCHAR2	(5)		Repeat grade to report
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.V
ATTRIBUTE1	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE2	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE3	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE4	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE5	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE6	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE7	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE8	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE9	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE10	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE11	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE12	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE13	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE14	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE15	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE16	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE17	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE18	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE19	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE20	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
CLOSED_IND	VARCHAR2	(1)		Indicates whether the assessment item is closed or not

Query Text

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


SELECT GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      GRADE
,      FULL_GRADE_NAME
,      S_RESULT_TYPE
,      SHOW_ON_NOTICEBOARD_IND
,      SHOW_ON_OFFICIAL_NTFCTN_IND
,      S_SPECIAL_GRADE_TYPE
,      SHOW_IN_NEWSPAPER_IND
,      SHOW_INTERNALLY_IND
,      SYSTEM_ONLY_IND
,      DFLT_OUTSTANDING_IND
,      EXTERNAL_GRADE
,      LOWER_MARK_RANGE
,      UPPER_MARK_RANGE
,      MIN_PERCENTAGE
,      MAX_PERCENTAGE
,      GPA_VAL
,      INCL_IN_REPEAT_PROCESS_IND
,      SHOW_IN_EARNED_CRDT_IND
,      ADMIN_ONLY_IND
,      GRADING_PERIOD_CD
,      RANK
,      REPEAT_GRADE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CLOSED_IND
FROM IGS.IGS_AS_GRD_SCH_GRADE;

Dependencies

[top of page]

IGS.IGS_AS_GRD_SCH_GRADE does not reference any database object

IGS.IGS_AS_GRD_SCH_GRADE is referenced by following:

APPS: IGS_AS_GRD_SCH_GRADE