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_UNT_SECTION_ASS_ITEMS

Object Details

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

View Type

A Business Intelligence System view

Describes all the assessment items for a unit section

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SECTION_AI_REFERENCE	VARCHAR2	(30)		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_DESCRIPTION	VARCHAR2	(180)		Assessment item description defined at the unit section level.
UNIT_CD	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.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Title of the identified unit code.
CALENDAR_INST_SEQUENCE_NUMBER	NUMBER	(6)	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_DESCRIPTION	VARCHAR2	(30)		Unique identifier for the calendar instance.
LOCATION_CODE	VARCHAR2	(10)	Yes	Calendar Description
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	The description of a physical location owned or used by an institution.
UNIT_CLASS_DESCRIPTION	VARCHAR2	(60)	Yes	Institution-defined code that identifies a unit class.
UNIT_SECTION_AI_GROUP_NAME	VARCHAR2	(30)	Yes	Describes the name of a group of Unit Section Assessment Items. For example, Quizzes, Homework.
CALENDAR_START_DATE	DATE		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	DATE		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.
MIDTERM_MNDRY_TYP_CD	CHAR	(88)		For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
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.
FINAL_MNDRY_TYP_CODE	CHAR	(86)		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_DESC	VARCHAR2	(60)		Describes the grading schema.
DUE_DATE	DATE			Due date for completion or submission of the unit assessment item.
RELEASE_DATE	DATE			Date on which outcome is released to the student. If the value is null the outcome is not displayed to the student on self service screens.
EXAM_CALENDAR_TYPE	VARCHAR2	(10)		Examination calendar type to which the examinable assessment item applies.
EXAM_CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)		Sequence number of the examination calendar instance to which the assessment item applies. This detail required only when the teaching period spans more than one instance of the same examination calendar type.
EXAM_CALENDAR_DESCRIPTION	VARCHAR2	(30)		Exam calendar description
ACTION_DATE	DATE			Date on which the unit section assessment item is added, deleted, or updated.
_LA:DEFAULT_ITEM_INDICATOR	CHAR	(55)		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	NUMBER		Yes	Unique identifier for assessment unit for the unit section.
UNIT_SECTION_ID	NUMBER	(7)	Yes	Identifier for unit offering option.
ASSESSMENT_ID	NUMBER	(10)	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.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence number uniquely identifying the relationship.
UNIT_SECTION_ASS_ITEM_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.
GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	The grading schema for the assessment item associated with student assessment item
GRADING_SCHEMA_VERSION_NUMBER	NUMBER	(3)	Yes	The version of grading schema for the assessment item associated with student assessment item.
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_REFERENCE
,      UNIT_SECTION_AI_DESCRIPTION
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      CALENDAR_TYPE
,      CALENDAR_INST_SEQUENCE_NUMBER
,      CALENDAR_DESCRIPTION
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      UNIT_CLASS
,      UNIT_CLASS_DESCRIPTION
,      UNIT_SECTION_AI_GROUP_NAME
,      CALENDAR_START_DATE
,      CALENDAR_END_DATE
,      MIDTERM_MNDRY_TYP_CD
,      MIDTERM_WEIGHT_QUANTITY
,      FINAL_MNDRY_TYP_CODE
,      FINAL_WEIGHT_QUANTITY
,      GRADING_SCHEMA_DESC
,      DUE_DATE
,      RELEASE_DATE
,      EXAM_CALENDAR_TYPE
,      EXAM_CAL_INST_SEQUENCE_NUMBER
,      EXAM_CALENDAR_DESCRIPTION
,      ACTION_DATE
,      _LA:DEFAULT_ITEM_INDICATOR
,      LOGICAL_DELETE_DATE
,      UNIT_SECTION_ASS_ITEM_ID
,      UNIT_SECTION_ID
,      ASSESSMENT_ID
,      SEQUENCE_NUMBER
,      UNIT_SECTION_ASS_ITEM_GROUP_ID
,      GRADING_SCHEMA_CODE
,      GRADING_SCHEMA_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_UNT_SECTION_ASS_ITEMS;

Dependencies

[top of page]

APPS.IGSFV_AS_UNT_SECTION_ASS_ITEMS references the following:

APPS: IGS_AD_LOCATION_ALL; IGS_AS_GRD_SCHEMA; IGS_AS_UNIT_CLASS_ALL; IGS_AS_US_AI_GROUP; IGS_CA_INST_ALL; IGS_PS_UNITASS_ITEM; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL

APPS.IGSFV_AS_UNT_SECTION_ASS_ITEMS is not referenced by any database object