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.IGSBV_AS_GRADING_SCHEMA_GRADES

Object Details

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

View Type

A Business Intelligence System view

Grading Schema Grades

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	The code that identifies the grading schema
GRADING_SCHEMA_VERSION_NUMBER	NUMBER	(3)	Yes	The system allocated number which identifies the version of the grading schema
GRADING_SCHEMA_DESCRIPTION	VARCHAR2	(60)	Yes	Describes the grading schema
GRADE	VARCHAR2	(5)	Yes	A code representing the grade which indicates the student's level of achievement in the unit attempt
FULL_GRADE_NAME	VARCHAR2	(60)	Yes	The full name of a grade
_LA:RESULT	CHAR	(59)		The system defined result for the grade. Available system result types are pass, fail, incomplete and withdrawn.
_LA:SHOW_ON_NOTICEBOARD_IND	CHAR	(64)		An indicator that specifies whether or not unit attempts with this grading schema grade will be included on notice board lists of results
_LA:SHOW_IN_EARNED_CRDT_IND	CHAR	(68)		Include in Earned Credit Points (Y/N)
_LA:SHOW_ON_OFFICAL_NTCN_IND	CHAR	(67)		An indicator that specifies whether or not unit attempts with the grade will be included on official notifications of results
_LA:INCL_IN_RPT_PROCESS_IND	CHAR	(64)		Include in Repeat Processing (Y/N)
_LA:SHOW_IN_NEWSPAPER_IND	CHAR	(62)		An indicator that specifies whether or not unit attempts with the grade can be published in the newspaper
_LA:SHOW_INTERNALLY_IND	CHAR	(60)		An indicator that specifies whether or not the grade is shown on documents internal to the institution
_LA:ADMIN_ONLY_IND	CHAR	(55)		Administrator only grade (Y/N)
_LA:SYSTEM_ONLY_IND	CHAR	(56)		An indicator that specifies whether or not the grade can only be assigned by system processes
_LA:DFLT_WHERE_OUTSTND_IND	CHAR	(61)		An indicator which specifies whether the grade is the default grade used to replace blank grades by the insert administrative grades process
S_SPECIAL_GRADE_TYPE	VARCHAR2	(20)		The special grade type of the grade
EXTERNAL_GRADE	VARCHAR2	(5)		The name of the external grade that is equivalent to the institution grade schema grade
LOWER_MARK_RANGE	NUMBER	(6)		A numerical value that designates the lowest mark a student can achieve to be awarded a certain grade
UPPER_MARK_RANGE	NUMBER	(6)		A numerical value that designates the highest mark a student can achieve to be awarded a certain grade rank
MIN_PERCENTAGE	NUMBER	(3)		The normal expected minimum percentage of students awarded the grade for a particular unit offering option
MAX_PERCENTAGE	NUMBER	(3)		The normal expected maximum percentage of students awarded the grade for a particular unit offering
GPA_VAL	NUMBER	(5)		The numerical value assigned to the grade for use in calculation of a student's GPA - grade point average
_LA:GRADING_PERIOD_CD	CHAR	(69)		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
REPEAT_GRADE	VARCHAR2	(5)		Repeat grade to report
_LA:CLOSED_IND	CHAR	(51)		Indicates whether the assessment item is closed or not
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

Query Text

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


SELECT GRADING_SCHEMA_CODE
,      GRADING_SCHEMA_VERSION_NUMBER
,      GRADING_SCHEMA_DESCRIPTION
,      GRADE
,      FULL_GRADE_NAME
,      _LA:RESULT
,      _LA:SHOW_ON_NOTICEBOARD_IND
,      _LA:SHOW_IN_EARNED_CRDT_IND
,      _LA:SHOW_ON_OFFICAL_NTCN_IND
,      _LA:INCL_IN_RPT_PROCESS_IND
,      _LA:SHOW_IN_NEWSPAPER_IND
,      _LA:SHOW_INTERNALLY_IND
,      _LA:ADMIN_ONLY_IND
,      _LA:SYSTEM_ONLY_IND
,      _LA:DFLT_WHERE_OUTSTND_IND
,      S_SPECIAL_GRADE_TYPE
,      EXTERNAL_GRADE
,      LOWER_MARK_RANGE
,      UPPER_MARK_RANGE
,      MIN_PERCENTAGE
,      MAX_PERCENTAGE
,      GPA_VAL
,      _LA:GRADING_PERIOD_CD
,      RANK
,      REPEAT_GRADE
,      _LA:CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_AS_GRADING_SCHEMA_GRADES;

Dependencies

[top of page]

APPS.IGSBV_AS_GRADING_SCHEMA_GRADES references the following:

APPS: IGS_AS_GRD_SCHEMA; IGS_AS_GRD_SCH_GRADE

APPS.IGSBV_AS_GRADING_SCHEMA_GRADES is not referenced by any database object