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