[Home] [Help] [Dependency Information]
Object Name: | IGSBV_AS_UNIT_ASSESSMENT_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Describes assessment items allocated to a unit version within nominated teaching calendar instance.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_ASSESSMENT_ITEM_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. | |
UNIT_ASSESSMENT_ITEM_DESC | VARCHAR2 | (180) | Assessment item description defined at the unit level. | |
UNIT_CODE | VARCHAR2 | (10) | Yes | Unit code to which assessment items are linked. Unit code is an institution-defined unique identifier of a unit of study. |
UNIT_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. |
CALENDAR_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. |
CALDENDAR_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar instance sequence number for the unit assessment item. Sequence number is the unique identifier for the calendar instance. |
CALENDAR_START_DATE | DATE | Yes | Start date of the teaching calendar instance that applies to the unit assessment item. Date from which the calendar instance becomes effective. | |
CALENDAR_END_DATE | 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. | |
ASSESSMENT_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. |
UNIT_ASSESSMENT_ITEM_GROUP_ID | NUMBER | (6) | Yes | System generated number is used to uniquely identify group of unit assessment items. Unit Assessment Item group is a group of assessment items that would have certain amount of weight in the unit grade. Formula can be applied to all the assessment items in a group such as Best 3, Atleast 2. |
MIDTERM_MNDRY_TYP_CD | NUMBER | (15) | Yes | For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) |
MIDTERM_WEIGHT_QUANTITY | CHAR | (87) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Midterm' grading period. | |
FINAL_MNDRY_TYP_CODE | NUMBER | (6) | For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
FINAL_WEIGHT_QUANTITY | CHAR | (85) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period. | |
GRADING_SCHEMA_CODE | NUMBER | (6) | The grading schema for the assessment item associated with student assessment item | |
GRADING_SCHEMA_VERSION_NUMBER | VARCHAR2 | (10) | Yes | The version of grading schema for the assessment item associated with student assessment item. |
DUE_DATE | NUMBER | (3) | Yes | Due date for completion or submission of the unit assessment item. |
RELEASE_DATE | DATE | Date on which outcome is released to the student. | ||
EXAM_CALENDAR_TYPE | DATE | Examination calendar type to which the examinable assessment item applies | ||
EXAM_CAL_INST_SEQUENCE_NUMBER | VARCHAR2 | (10) | Sequence number of the examination calendar instance to which the assessment item applies. | |
ACTION_DATE | NUMBER | (6) | Date on which the unit assessment item is added, deleted, or updated | |
_LA:DEFAULT_ITEM_INDICATOR | DATE | Indicates and specifies if the assessment item is a default item for the unit. | ||
LOGICAL_DELETE_DATE | CHAR | (54) | Date on which the assessment item deleted from the unit offering pattern. | |
UNIT_ASSESSMENT_ITEM_ID | DATE | System generated number is used to uniquely identify unit assessment items. | ||
SEQUENCE_NUMBER | NUMBER | (15) | Yes | Sequence number uniquely identifying the relationship. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_ASSESSMENT_ITEM_REFERENCE
, UNIT_ASSESSMENT_ITEM_DESC
, UNIT_CODE
, UNIT_VERSION_NUMBER
, CALENDAR_TYPE
, CALDENDAR_INST_SEQUENCE_NUMBER
, CALENDAR_START_DATE
, CALENDAR_END_DATE
, ASSESSMENT_ID
, UNIT_ASSESSMENT_ITEM_GROUP_ID
, MIDTERM_MNDRY_TYP_CD
, MIDTERM_WEIGHT_QUANTITY
, FINAL_MNDRY_TYP_CODE
, FINAL_WEIGHT_QUANTITY
, GRADING_SCHEMA_CODE
, GRADING_SCHEMA_VERSION_NUMBER
, DUE_DATE
, RELEASE_DATE
, EXAM_CALENDAR_TYPE
, EXAM_CAL_INST_SEQUENCE_NUMBER
, ACTION_DATE
, _LA:DEFAULT_ITEM_INDICATOR
, LOGICAL_DELETE_DATE
, UNIT_ASSESSMENT_ITEM_ID
, SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS;
APPS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS is not referenced by any database object
|
|
|