[Home] [Help]
[Dependency Information]
[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
IGS_AS_UNITASS_ITEM_ALL
APPS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS is not referenced by any database object
|
|
|
|