[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AS_UNIT_ASS_ITEM_GROUPS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_AS_UNIT_ASS_ITEM_GROUPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Unit Assessment Item Group
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_ASS_ITEM_GROUP_NAME | VARCHAR2 | (30) | Yes | Describes the name of a group of Unit Assessment Items. For example, Quizzes, Homework. |
UNIT_CODE | VARCHAR2 | (10) | Yes | Unit code to which assessment item groups 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 group is linked to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated. |
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 unit assessment item group 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 | (3) | Yes | Calendar instance sequence number for the unit assessment item group. Sequence number is the unique identifier for the calendar instance. |
CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Calendar Description | |
_LA:MIDTERM_FORMULA_CODE | CHAR | (81) | For Midterm Grading Period, allows user to define the derivation formula based on which the student unit attempt outcome marks will be calculated:- Weighted Average- Best N- At least N- Null | |
MIDTERM_FORMULA_QUANTITY | NUMBER | (3) | In case the Formula is 'Best N' or 'At least N', the user is required to define the corresponding number of assessment item to be used to derive student unit attempt outcome marks. | |
MIDTERM_WEIGHT_QUANTITY | NUMBER | (7) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Midterm' grading period. | |
_LA:FINAL_FORMULA_CODE | CHAR | (79) | For Final Grading Period, allows user to define the derivation formula based on which the student unit attempt outcome marks will be calculated:- Weighted Average- Best N- At least N- Null | |
FINAL_FORMULA_QUANTITY | NUMBER | (3) | In case the Formula is 'Best N' or 'At least N', the user is required to define the corresponding number of assessment item that will be used to derive student unit attempt outcome marks. | |
FINAL_WEIGHT_QUANTITY | NUMBER | (7) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period. | |
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. |
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_ASS_ITEM_GROUP_NAME
, UNIT_CODE
, UNIT_VERSION_NUMBER
, UNIT_TITLE
, CALENDAR_TYPE
, CALENDAR_INST_SEQUENCE_NUMBER
, CALENDAR_DESCRIPTION
, _LA:MIDTERM_FORMULA_CODE
, MIDTERM_FORMULA_QUANTITY
, MIDTERM_WEIGHT_QUANTITY
, _LA:FINAL_FORMULA_CODE
, FINAL_FORMULA_QUANTITY
, FINAL_WEIGHT_QUANTITY
, UNIT_ASSESSMENT_ITEM_GROUP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_UNIT_ASS_ITEM_GROUPS;
APPS.IGSFV_AS_UNIT_ASS_ITEM_GROUPS is not referenced by any database object
|
|
|