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_UNITASS_ITEM_ALL

Object Details

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

IGS_AS_UNITASS_ITEM describes assessment items allocated to a unit version within nominated teaching calendar instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_UNITASS_ITEM_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_ASS_ITEM_ID
IGS_AS_UNITASS_ITEM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_CD VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER ASS_ID SEQUENCE_NUMBER
IGS_AS_UNITASS_ITEM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_AS_UNITASS_ITEM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_MODE
IGS_AS_UNITASS_ITEM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CLASS
IGS_AS_UNITASS_ITEM_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER
IGS_AS_UNITASS_ITEM_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_ASS_ITEM_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_CD	VARCHAR2	(10)	Yes	Unit code to which assessment items are linked. Unit code is an institution-defined unique identifier of a unit of study.
VERSION_NUMBER	NUMBER	(3)	Yes	Version of the unit the unit assessment item is linked to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type of the unit offerings to which the assessment item is linked. A calendar type is an institution-defined code for a calendar, such as ACAD-YR for a standard academic year.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar instance sequence number for the unit assessment item. Sequence number is the unique identifier for the calendar instance.
ASS_ID	NUMBER	(10)	Yes	Identifier term attached to the unit. The assessment identifier is a system generated number that is used to uniquely identify an assessment item.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence number uniquely identifying the relationship. Required due to the possibility of an assessment item being linked to the same unit offering pattern at more than one location or mode or class.
CI_START_DT	DATE		Yes	Start date of the teaching calendar instance that applies to the unit assessment item. Date from which the calendar instance becomes effective.
CI_END_DT	DATE		Yes	End date of the teaching calendar instance that applies to the unit assessment item. Date from which the calendar instance is no longer effective. For example, teaching period semester 1 1996, ends on 30/6/96.
UNIT_CLASS	VARCHAR2	(10)		- Obsolete
UNIT_MODE	VARCHAR2	(10)		- Obsolete
LOCATION_CD	VARCHAR2	(10)		- Obsolete
DUE_DT	DATE			Due date for completion or submission of the unit assessment item. Due dates are typically entered for non-examinable assessment items. Assignment due dates are used in the assignment tracking facility as the default action date for the Received from Student step.
REFERENCE	VARCHAR2	(30)		Reference for the unit assessment item. References are typically used to indicate the number of a unit assignment or examination such as assignment 1 or assignment 2. Reference is used to enable easy identification of an assessment item when more than one of the same type exists for a unit. It is also passed to the exam timetabling facility to assist in the identification of each examination when multiple examinations exist for a unit.
DFLT_ITEM_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the assessment item is a default item for the unit. If set selected, students enrolled in the unit are automatically allocated the assessment item via the processes ASSJ3212 and ASSJ3213. If not selected, the assessment item can be manually allocated to students in the unit.
LOGICAL_DELETE_DT	DATE			Date on which the assessment item deleted from the unit offering pattern. Logical deletion does not cause the unit assessment item to be physically deleted from the database. However, the item is no longer available for use for the unit offering pattern. Logically deleted items are removed from the corresponding student unit attempts when the process ASSJ3213 is running. Prior to the item being removed from student unit attempts, they are tagged as inactive student unit assessment items in ASSF3222.
ACTION_DT	DATE			Date on which the unit assessment item is added, deleted, or updated. If the assessment item is a default item, the existence of an action date is a trigger which determines that the change is applied to students within the unit when the process Apply Unit Assessment Item Modifications to Student Units -ASSJ3213- is run. This action date is set to null once the change is applied.
EXAM_CAL_TYPE	VARCHAR2	(10)		Examination calendar type to which the examinable assessment item applies. This detail is needed only while entering the unit offering pattern teaching period spans multiple examination periods and the unit is examined in more than one examination period. For example, a year long unit can have one examination in the semester one examination period and another examination in the semester two examination period. Each examination must be linked to the appropriate examination period so that the timetabling extraction process can identify the relevant examinations for each examination period.
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)		Sequence number of the examination calendar instance to which the assessment item applies. This detail required only when the teaching period spans more than one instance of the same examination calendar type.
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
ORG_ID	NUMBER	(15)		Operating Unit Identifier
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	The grading schema for the assessment item associated with student assessment item
GS_VERSION_NUMBER	NUMBER	(3)	Yes	he version of grading schema for the assessment item associated with student assessment item.
RELEASE_DATE	DATE			Date on which outcome is released to the student. If the value is null the outcome is not displayed to the student on self service screens.
UNIT_ASS_ITEM_ID	NUMBER	(15)	Yes	Unique Identifier of the Assessment items attached at the unit level.
DESCRIPTION	VARCHAR2	(180)		The item description defined at the unit level.
UNIT_ASS_ITEM_GROUP_ID	NUMBER	(15)	Yes	Unique identifier for a group to which the unit 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.

Query Text

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


SELECT UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_ID
,      SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      UNIT_CLASS
,      UNIT_MODE
,      LOCATION_CD
,      DUE_DT
,      REFERENCE
,      DFLT_ITEM_IND
,      LOGICAL_DELETE_DT
,      ACTION_DT
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      RELEASE_DATE
,      UNIT_ASS_ITEM_ID
,      DESCRIPTION
,      UNIT_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
FROM IGS.IGS_AS_UNITASS_ITEM_ALL;

Dependencies

[top of page]

IGS.IGS_AS_UNITASS_ITEM_ALL does not reference any database object

IGS.IGS_AS_UNITASS_ITEM_ALL is referenced by following:

APPS: IGS_AS_UNITASS_ITEM_ALL