DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS

Object Details
Object Name: IGSFV_AS_UNIT_ASSESSMENT_ITEMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS references the following:

SchemaAPPS
SynonymIGS_AS_ASSESSMNT_ITM_ALL
SynonymIGS_AS_GRD_SCHEMA
SynonymIGS_AS_UNITASS_ITEM_ALL
SynonymIGS_AS_UNIT_AI_GRP
SynonymIGS_CA_INST_ALL
SynonymIGS_PS_UNIT_VER_ALL

APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS is not referenced by any database object