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_UG_INTERFACE

Object Details

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

Grade Unit Interface Table primarily using to import details entered in Web ADI for Final Grades.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_UG_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_DATE USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)	Yes	User Identification Number.
BATCH_DATE	DATE		Yes	The batch date .
PERSON_NUMBER	VARCHAR2	(30)		Student Number.
ANONYMOUS_ID	VARCHAR2	(30)		Anonymous Number.
COURSE_CD	VARCHAR2	(6)	Yes	Course Code.
UNIT_CD	VARCHAR2	(10)	Yes	Unit code.
CAL_TYPE	VARCHAR2	(10)		Calendar Type.
CI_SEQUENCE_NUMBER	NUMBER	(6)		Calendar Instance Sequence Number.
ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code.
GRADE	VARCHAR2	(5)		Grade.
MARK	NUMBER	(6)		Mark.
GRADING_PERIOD_CD	VARCHAR2	(30)	Yes	Grading Period Code.
INCOMP_DEFAULT_GRADE	VARCHAR2	(5)		For Incomplete Grade default grade
INCOMP_DEFAULT_MARK	NUMBER	(6)		For Incomplete Grade default Mark.
INCOMP_DEADLINE_DATE	DATE			For Incomplete Grade deadline date.
COMMENTS	VARCHAR2	(240)		Comments.
ERROR_CODE	VARCHAR2	(30)		Error code to be replaced by import process.
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
LOCATION_CD	VARCHAR2	(10)		Unit Section Location code
UNIT_CLASS	VARCHAR2	(10)		Unit Section Unit Class
MARK_CAPPED_FLAG	VARCHAR2	(1)		Allows user to indicate whether marks have been capped for a student unit attempt outcome
MANUAL_OVERRIDE_FLAG	VARCHAR2	(1)		The user should select this checkbox to keep the system from replacing the manually assigned marks with the system calculated ones.
RELEASE_DATE	DATE			Date on which the student unit attempt outcome will be released to the student for viewing
UOO_ID	NUMBER	(7)		Unique identifier for a unit offering option.

Query Text

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


SELECT USER_ID
,      BATCH_DATE
,      PERSON_NUMBER
,      ANONYMOUS_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ALTERNATE_CODE
,      GRADE
,      MARK
,      GRADING_PERIOD_CD
,      INCOMP_DEFAULT_GRADE
,      INCOMP_DEFAULT_MARK
,      INCOMP_DEADLINE_DATE
,      COMMENTS
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOCATION_CD
,      UNIT_CLASS
,      MARK_CAPPED_FLAG
,      MANUAL_OVERRIDE_FLAG
,      RELEASE_DATE
,      UOO_ID
FROM IGS.IGS_AS_UG_INTERFACE;

Dependencies

[top of page]

IGS.IGS_AS_UG_INTERFACE does not reference any database object

IGS.IGS_AS_UG_INTERFACE is referenced by following:

APPS: IGS_AS_UG_INTERFACE