[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AS_UNIT_ASSESSMENT_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_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. |
UNIT_TITLE | VARCHAR2 | (90) | Yes | Title of the identified unit code. |
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. |
CALENDAR_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_DESCRIPTION | VARCHAR2 | (30) | Calendar Description | |
ASSESSMENT_ITEM_DESCRIPTION | VARCHAR2 | (180) | Yes | Assessment item description |
UNIT_ASS_ITEM_GROUP_NAME | VARCHAR2 | (30) | Yes | Describes the name of a group of Unit Assessment Items. For example, Quizzes, Homework. |
CALENDAR_START_DATE | DATE | Yes | Start date of the teaching calendar instance that applies to the unit assessment item.. | |
CALENDAR_END_DATE | DATE | Yes | End date of the teaching calendar instance that applies to the unit assessment item. | |
MIDTERM_MNDRY_TYP_CD | CHAR | (87) | For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
MIDTERM_WEIGHT_QUANTITY | NUMBER | (6) | 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 | CHAR | (85) | For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
FINAL_WEIGHT_QUANTITY | NUMBER | (6) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period. | |
GRADING_SCHEMA_DESC | VARCHAR2 | (60) | Yes | Describes the grading schema. |
DUE_DATE | DATE | 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 | VARCHAR2 | (10) | Examination calendar type to which the examinable assessment item applies | |
EXAM_CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Sequence number of the examination calendar instance to which the assessment item applies. | |
EXAM_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Exam calendar description | |
ACTION_DATE | DATE | Date on which the unit assessment item is added, deleted, or updated | ||
_LA:DEFAULT_ITEM_INDICATOR | CHAR | (54) | Indicates and specifies if the assessment item is a default item for the unit. | |
LOGICAL_DELETE_DATE | DATE | Date on which the assessment item deleted from the unit offering pattern. | ||
UNIT_ASSESSMENT_ITEM_ID | NUMBER | (15) | Yes | System generated number is used to uniquely identify unit assessment items. |
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. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence number uniquely identifying the relationship. |
UNIT_ASSESSMENT_ITEM_GROUP_ID | NUMBER | (15) | 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. |
GRADING_SCHEMA_CODE | VARCHAR2 | (10) | Yes | The grading schema for the assessment item associated with student assessment item |
GRADING_SCHEMA_VERSION_NUMBER | NUMBER | (3) | Yes | The version of grading schema for the assessment item associated with student assessment item. |
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
, UNIT_TITLE
, CALENDAR_TYPE
, CALENDAR_INST_SEQUENCE_NUMBER
, CALENDAR_DESCRIPTION
, ASSESSMENT_ITEM_DESCRIPTION
, UNIT_ASS_ITEM_GROUP_NAME
, CALENDAR_START_DATE
, CALENDAR_END_DATE
, MIDTERM_MNDRY_TYP_CD
, MIDTERM_WEIGHT_QUANTITY
, FINAL_MNDRY_TYP_CODE
, FINAL_WEIGHT_QUANTITY
, GRADING_SCHEMA_DESC
, DUE_DATE
, RELEASE_DATE
, EXAM_CALENDAR_TYPE
, EXAM_CAL_INST_SEQUENCE_NUMBER
, EXAM_CALENDAR_DESCRIPTION
, ACTION_DATE
, _LA:DEFAULT_ITEM_INDICATOR
, LOGICAL_DELETE_DATE
, UNIT_ASSESSMENT_ITEM_ID
, ASSESSMENT_ID
, SEQUENCE_NUMBER
, UNIT_ASSESSMENT_ITEM_GROUP_ID
, GRADING_SCHEMA_CODE
, GRADING_SCHEMA_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS;
APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS is not referenced by any database object
|
|
|