[Home] [Help] [Dependency Information]
Object Name: | IGSBV_AS_UNT_SECTION_ASS_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_AS_UNT_SECTION_ASS_ITEMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Describes all the assessment items for a unit section
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_SECTION_AI_DESCRIPTION | NUMBER | Yes | Reference for the unit section assessment item. References are typically used to indicate the number of a unit section assignment or examination such as assignment 1 or assignment 2. | |
UNIT_SECTION_AI_REFERENCE | VARCHAR2 | (180) | Assessment item description defined at the unit section level. | |
UNIT_SECTION_ID | VARCHAR2 | (30) | Identifier for unit offering option. | |
ASSESSMENT_ID | NUMBER | (7) | Yes | Identifier term attached to the unit section. The assessment identifier is a system generated number that is used to uniquely identify an assessment item. |
CALENDAR_START_DATE | NUMBER | (10) | Yes | Start date of the teaching calendar instance that applies to the unit section assessment item. Date from which the calendar instance becomes effective. |
CALENDAR_END_DATE | NUMBER | (6) | Yes | End date of the teaching calendar instance that applies to the unit section 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_SECTION_AI_GROUP_ID | NUMBER | (15) | System generated number is used to uniquely identify group of unit section assessment items. Unit section 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 | DATE | Yes | For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
MIDTERM_WEIGHT_QUANTITY | DATE | Yes | 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 | (88) | 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_CODE | CHAR | (86) | The grading schema for the assessment item associated with student assessment item | |
GRADING_SCHEMA_VERSION_NUMBER | NUMBER | (6) | The version of grading schema for the assessment item associated with student assessment item. | |
DUE_DATE | VARCHAR2 | (10) | Yes | Due date for completion or submission of the unit assessment item. |
RELEASE_DATE | NUMBER | (3) | Yes | Date on which outcome is released to the student. |
EXAM_CALENDAR_TYPE | DATE | Examination calendar type to which the examinable assessment item applies. | ||
EXAM_CALENDAR_SEQUENCE_NUMBER | DATE | Sequence number of the examination calendar instance to which the assessment item applies. | ||
ACTION_DATE | VARCHAR2 | (10) | Date on which the unit section assessment item is added, deleted, or updated. | |
_LA:DEFAULT_ITEM_INDICATOR | NUMBER | (6) | 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_SECTION_ASS_ITEM_ID | CHAR | (55) | Unique identifier for assessment unit for the unit section. | |
SEQUENCE_NUMBER | DATE | 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_SECTION_AI_DESCRIPTION
, UNIT_SECTION_AI_REFERENCE
, UNIT_SECTION_ID
, ASSESSMENT_ID
, CALENDAR_START_DATE
, CALENDAR_END_DATE
, UNIT_SECTION_AI_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_CALENDAR_SEQUENCE_NUMBER
, ACTION_DATE
, _LA:DEFAULT_ITEM_INDICATOR
, LOGICAL_DELETE_DATE
, UNIT_SECTION_ASS_ITEM_ID
, SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_AS_UNT_SECTION_ASS_ITEMS;
APPS.IGSBV_AS_UNT_SECTION_ASS_ITEMS is not referenced by any database object
|
|
|