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_CHN_GRD_REQ

Object Details

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

Stores the Change Grade Requests History of a student .

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_CHN_GRD_REQ_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID REQUEST_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Student Id
COURSE_CD	VARCHAR2	(6)	Yes	Course Code
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code
UNIT_CLASS	VARCHAR2	(10)	Yes	Section
LOCATION_CD	VARCHAR2	(10)	Yes	Location Of Section
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load Calender Type
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	LoadCalendar Sequence Number
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Teaching Calendar Type
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching Calendar Sequence Number
REQUEST_DATE	DATE		Yes	Date Of Request
REQUESTER_ID	NUMBER	(15)	Yes	Person Id, requesting for change of grade
CURRENT_MARK	NUMBER	(6)		Current Marks of the Student
CURRENT_GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	Grading Schema Code
CURRENT_GS_VERSION_NUMBER	NUMBER	(6)	Yes	Grading Schema Version Number
CURRENT_GRADE	VARCHAR2	(5)	Yes	Current Grades of the Student
CHANGE_MARK	NUMBER	(6)		Requested Marks to replace current marks
CHANGE_GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	Change Grading Schema Code
CHANGE_GS_VERSION_NUMBER	NUMBER	(6)	Yes	Change Grading Schema Version Number
CHANGE_GRADE	VARCHAR2	(5)	Yes	Requested Grades to replace current Grades
REQUESTER_COMMENTS	VARCHAR2	(360)	Yes	Justification for change of grade request
APPROVER_ID	NUMBER	(15)		Person Id, approving requested change of grade
APPROVER_DATE	DATE			Date of approval
APPROVER_COMMENTS	VARCHAR2	(360)		Approver Comments
CURRENT_STATUS	VARCHAR2	(15)	Yes	The status are 'IN PROGRESS''REJECTED''APPROVED'
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
MARK_CAPPED_FLAG	VARCHAR2	(1)		Allows user to indicate whether marks have been capped for a student unit attempt outcome
SHOW_ON_ACADEMIC_HISTRY_FLAG	VARCHAR2	(1)		Allows user to define whether the changed grade be displayed on the Academic History self-service page.

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      UNIT_CLASS
,      LOCATION_CD
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      REQUEST_DATE
,      REQUESTER_ID
,      CURRENT_MARK
,      CURRENT_GRADING_SCHEMA_CD
,      CURRENT_GS_VERSION_NUMBER
,      CURRENT_GRADE
,      CHANGE_MARK
,      CHANGE_GRADING_SCHEMA_CD
,      CHANGE_GS_VERSION_NUMBER
,      CHANGE_GRADE
,      REQUESTER_COMMENTS
,      APPROVER_ID
,      APPROVER_DATE
,      APPROVER_COMMENTS
,      CURRENT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UOO_ID
,      MARK_CAPPED_FLAG
,      SHOW_ON_ACADEMIC_HISTRY_FLAG
FROM IGS.IGS_AS_CHN_GRD_REQ;

Dependencies

[top of page]

IGS.IGS_AS_CHN_GRD_REQ does not reference any database object

IGS.IGS_AS_CHN_GRD_REQ is referenced by following:

APPS: IGS_AS_CHN_GRD_REQ