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_INS_GRD_ENTRY

Object Details

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

IGS_AS_INS_GRD_ENTRY contains temporary information about grade entries.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_INS_GRD_ENTRY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	KEYING_TIME KEYING_WHO STUDENT_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
KEYING_WHO	VARCHAR2	(30)	Yes	The Oracle username of the person who entered the result.
KEYING_TIME	DATE		Yes	The number of times that the grade has been entered.
STUDENT_SEQUENCE	NUMBER	(4)	Yes	Student sequence in the grade entry
PERSON_ID	NUMBER	(15)	Yes	The person ID of the student for whom results are being entered.
NAME	VARCHAR2	(40)	Yes	The name of the student.
COURSE_CD	VARCHAR2	(6)	Yes	The code of the course in which the student is enrolled.
UNIT_CD	VARCHAR2	(10)	Yes	A code that uniquely identifies the unit in which the student is enrolled.
VERSION_NUMBER	NUMBER		Yes	A number that uniquely identifies the version of a unit.
CAL_TYPE	VARCHAR2	(10)	Yes	The calendar type in which the student unit attempt is enrolled. For example, SEM-1.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The calendar sequence number.
LOCATION_CD	VARCHAR2	(10)	Yes	The code identifying the location, which is typically a campus, in which the unit attempt was enrolled.
UNIT_CLASS	VARCHAR2	(10)	Yes	The code of the class associated with the unit in which the student is enrolled.
UNIT_ATTEMPT_STATUS	VARCHAR2	(10)		The status of the student unit attempt. For example, enrolled, discontin.
MARK	NUMBER	(3)		A numeric value which represents the student's level of achievement in the unit attempt.
GRADING_SCHEMA_CD	VARCHAR2	(10)		A code identifying the grading schema which describes the set of available marks and grades which can be used in the assessment of student unit attempts.
GS_VERSION_NUMBER	NUMBER	(3)		A system generated number used to identify the version of a grading schema.
GRADE	VARCHAR2	(5)		A grade which represents the student's level of achievement for the unit attempt. The grade entered must exist in the grading schema being used.
SPECIFIED_GRADE_IND	VARCHAR2	(1)	Yes	Specified grade indicator
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 KEYING_WHO
,      KEYING_TIME
,      STUDENT_SEQUENCE
,      PERSON_ID
,      NAME
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_ATTEMPT_STATUS
,      MARK
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADE
,      SPECIFIED_GRADE_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_INS_GRD_ENTRY;

Dependencies

[top of page]

IGS.IGS_AS_INS_GRD_ENTRY does not reference any database object

IGS.IGS_AS_INS_GRD_ENTRY is referenced by following:

APPS: IGS_AS_INS_GRD_ENTRY