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_SU_ATMPT_ITM

Object Details

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

IGS_AS_SU_ATMPT_ITM describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_SU_ATMPT_ITM_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID ASS_ID CREATION_DT
IGS_AS_SU_ATMPT_ITM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASS_ID
IGS_AS_SU_ATMPT_ITM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRACKING_ID
IGS_AS_SU_ATMPT_ITM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UOO_ID
IGS_AS_SU_ATMPT_ITM_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUA_ASS_ITEM_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the person ID of the student to whom the assessment item is linked
COURSE_CD	VARCHAR2	(6)	Yes	Describes the students course code
UNIT_CD	VARCHAR2	(10)	Yes	Describes the students enrolled unit code
CAL_TYPE	VARCHAR2	(10)	Yes	Describes the students enrolled teaching calendar type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the teaching calendar sequence number
ASS_ID	NUMBER	(10)	Yes	The assessment item ID of an assessment item which has been linked to the student. An assessment item ID is a system generated number which is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unitofferings before it can be assigned to student unit attempts.
CREATION_DT	DATE		Yes	Indicates the date on which an assessment item was created against the student. This is used partially to allow for uniqueness.
ATTEMPT_NUMBER	NUMBER	(2)	Yes	The attempt number of the assessment. This exists to enable multiple of attempt of a particular assessment item within a single student unit attempt.
OUTCOME_DT	DATE			The date on which an outcome was decided for the students attempt at the assessment item.
OVERRIDE_DUE_DT	DATE			A user-defined date which overrides the default due date of the assessment item.
PERFORMANCE	VARCHAR2	(10)		The outcome of a student unit attempt assessment item. This is not governed by a restricted set it is user-definable.
TRACKING_ID	NUMBER	(9)		The tracking ID of the tracking item which has been created to track the students assessment item. A tracking is a system-generated identification number used to uniquely identify a tracking item.
LOGICAL_DELETE_DT	DATE			Describes the date on that the record was logically deleted. Logical deletion is used here as a method of retaining the history of decisions made regarding a students assessment.
S_DEFAULT_IND	VARCHAR2	(1)	Yes	Indicates if the assessment item has been assigned manually or by the system
ASS_PATTERN_ID	NUMBER	(10)		- Obsolete
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
GRADING_SCHEMA_CD	VARCHAR2	(10)		The grading schema for the assessment item associated with student assessment item
GS_VERSION_NUMBER	NUMBER	(3)		The version of grading schema for the assessment item associated with student assessment item.vv
GRADE	VARCHAR2	(5)		The grade for the assessment item for the student.
OUTCOME_COMMENT_CODE	VARCHAR2	(30)		The reason for changing the grade or marks. This would be a required column whenever the marks or the grade are changed.
MARK	NUMBER	(6)		The mark for the assessment item for the student.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
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.
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
UNIT_SECTION_ASS_ITEM_ID	NUMBER	(15)		Unique Identifier of the Assessment items attached at the unit section level
UNIT_ASS_ITEM_ID	NUMBER	(15)		Unique Identifier of the Assessment items attached at the unit level
SUA_ASS_ITEM_GROUP_ID	NUMBER	(15)	Yes	Unique identifier of a group to which the student unit attempt assessment item is attached.
MIDTERM_MANDATORY_TYPE_CODE	VARCHAR2	(30)		For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
MIDTERM_WEIGHT_QTY	NUMBER	(6)		Allows user to define the weight of the assessment item relative to other assessment items for 'Midterm' grading period.
FINAL_MANDATORY_TYPE_CODE	VARCHAR2	(30)		For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
FINAL_WEIGHT_QTY	NUMBER	(6)		Allows user to define the weight of the assessment item relative to other assessment items for 'Final' grading period.
SUBMITTED_DATE	DATE			Date on which the student submitted the assessment item for grading
WAIVED_FLAG	VARCHAR2	(1)		Allows the user to indicate that the assessment item is being waived for a particular student.
PENALTY_APPLIED_FLAG	VARCHAR2	(1)		Allows the user to indicate that the captured mark/grade have been subjected to a penalty.

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_ID
,      CREATION_DT
,      ATTEMPT_NUMBER
,      OUTCOME_DT
,      OVERRIDE_DUE_DT
,      PERFORMANCE
,      TRACKING_ID
,      LOGICAL_DELETE_DT
,      S_DEFAULT_IND
,      ASS_PATTERN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADE
,      OUTCOME_COMMENT_CODE
,      MARK
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      UOO_ID
,      UNIT_SECTION_ASS_ITEM_ID
,      UNIT_ASS_ITEM_ID
,      SUA_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
,      SUBMITTED_DATE
,      WAIVED_FLAG
,      PENALTY_APPLIED_FLAG
FROM IGS.IGS_AS_SU_ATMPT_ITM;

Dependencies

[top of page]

IGS.IGS_AS_SU_ATMPT_ITM does not reference any database object

IGS.IGS_AS_SU_ATMPT_ITM is referenced by following:

APPS: IGS_AS_SU_ATMPT_ITM