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.IGSFV_AS_SUA_ASS_ITEM_GROUPS

Object Details

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

View Type

A Business Intelligence System view

Student Unit Attempt Assessment Item Group

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Describes the person name.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Describes the student's course code.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the identified program code.
UNIT_CODE	VARCHAR2	(10)	Yes	Title of the identified unit code.
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the unit being offered. Students are normally enrolled in the current version of a unit. 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 in that the unit is offered. Units can only be offered in instances of calendar types that are categorized as teaching calendars.
CALENDAR_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance.
CALENDAR_DESCRIPTION	VARCHAR2	(30)		Calendar Description
LOCATION_CODE	VARCHAR2	(10)	Yes	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	The description of a physical location owned or used by an institution.
UNIT_CLASS	VARCHAR2	(10)	Yes	Institution-defined code that identifies a unit class.
UNIT_CLASS_DESCRIPTION	VARCHAR2	(60)	Yes	Unit class description.
SUA_ASS_ITEM_GROUP_NAME	VARCHAR2	(30)	Yes	Describes the name of a group of Student Unit Assessment Items. For example, Quizzes, Homework.
_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_ASS_ITEM_GROUP_NAME	VARCHAR2	(30)	Yes	Describes the name of a group of Unit Assessment Items. For example, Quizzes, Homework.
UNIT_SECTION_AI_GROUP_NAME	VARCHAR2	(30)	Yes	Describes the name of a group of Unit Section Assessment Items. For example, Quizzes, Homework.
SUA_ASSESSMENT_ITEM_GROUP_ID	NUMBER	(15)		System generated number is used to uniquely identify group of student unit assessment items. Student 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.
PERSON_ID	NUMBER	(15)	Yes	Describes the person ID of the student to whom the assessment item group is linked.
UNIT_SECTION_ID	NUMBER	(7)	Yes	Identifier for unit offering option.
UNIT_ASSESSMENT_ITEM_GROUP_ID	NUMBER	(15)		Reference to the original source from where the student unit attempt assessment items were inherited - Unit Level
UNIT_SECTION_ASS_ITEM_GROUP_ID	NUMBER	(15)		Reference to the original source from where the student unit attempt assessment items were inherited - Unit Section Level
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 PERSON_NAME
,      PERSON_NUMBER
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      UNIT_CODE
,      UNIT_VERSION_NUMBER
,      UNIT_TITLE
,      CALENDAR_TYPE
,      CALENDAR_INST_SEQUENCE_NUMBER
,      CALENDAR_DESCRIPTION
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      UNIT_CLASS
,      UNIT_CLASS_DESCRIPTION
,      SUA_ASS_ITEM_GROUP_NAME
,      _LA:MIDTERM_FORMULA_CODE
,      MIDTERM_FORMULA_QUANTITY
,      MIDTERM_WEIGHT_QUANTITY
,      _LA:FINAL_FORMULA_CODE
,      FINAL_FORMULA_QUANTITY
,      FINAL_WEIGHT_QUANTITY
,      UNIT_ASS_ITEM_GROUP_NAME
,      UNIT_SECTION_AI_GROUP_NAME
,      SUA_ASSESSMENT_ITEM_GROUP_ID
,      PERSON_ID
,      UNIT_SECTION_ID
,      UNIT_ASSESSMENT_ITEM_GROUP_ID
,      UNIT_SECTION_ASS_ITEM_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_SUA_ASS_ITEM_GROUPS;

Dependencies

[top of page]

APPS.IGSFV_AS_SUA_ASS_ITEM_GROUPS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_AS_SUA_AI_GROUP; IGS_AS_UNIT_AI_GRP; IGS_AS_UNIT_CLASS_ALL; IGS_AS_US_AI_GROUP; IGS_CA_INST_ALL; IGS_EN_STDNT_PS_ATT_ALL; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER_ALL

APPS.IGSFV_AS_SUA_ASS_ITEM_GROUPS is not referenced by any database object