eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGSBV_AS_UNT_SECTION_AI_GROUPS

Object Details

Object Name:	IGSBV_AS_UNT_SECTION_AI_GROUPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_AS_UNT_SECTION_AI_GROUPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Unit Section Assessment Item Group

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SECTION_AI_GROUP_NAME	VARCHAR2	(30)	Yes	Describes the name of a group of Unit Section Assessment Items. For example, Quizzes, Homework.
UNIT_SECTION_ID	NUMBER	(7)	Yes	Unique identifier for a unit section.
_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	(6)		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	(6)		Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period.
UNIT_SECTION_ASS_ITEM_GROUP_ID	NUMBER	(15)	Yes	System generated number is used to uniquely identify group of unit 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.
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_SECTION_AI_GROUP_NAME
,      UNIT_SECTION_ID
,      _LA:MIDTERM_FORMULA_CODE
,      MIDTERM_FORMULA_QUANTITY
,      MIDTERM_WEIGHT_QUANTITY
,      _LA:FINAL_FORMULA_CODE
,      FINAL_FORMULA_QUANTITY
,      FINAL_WEIGHT_QUANTITY
,      UNIT_SECTION_ASS_ITEM_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_AS_UNT_SECTION_AI_GROUPS;

Dependencies

[top of page]

APPS.IGSBV_AS_UNT_SECTION_AI_GROUPS references the following:

APPS: IGS_AS_US_AI_GROUP

APPS.IGSBV_AS_UNT_SECTION_AI_GROUPS is not referenced by any database object