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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_CD	VARCHAR2	(10)	Yes	The unit code to which assessment items are linked. Unit code is an Institution-defined identifier of a unit of study.
VERSION_NUMBER	NUMBER	(3)	Yes	A number used to uniqely identify the version of a unit.
CAL_TYPE	VARCHAR2	(10)	Yes	The institution defined name of a type of calendar used within the organisation. Units can only be offered in instances of calendar types that are catergorised as TEACHING calendars. For Example SEM-1 -Semester 1 teaching period-.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	UNIT_ASSESSMENT_ITEM.CI_SEQUENCE_NUMBER
ASS_ID	NUMBER	(10)	Yes	A number that uniquely identifies an assessment item.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	UNIT_ASSESSMENT_ITEM.SEQUENCE_NUMBER
REFERENCE	VARCHAR2	(30)		The reference for the unit assessment item. References are typically used to indicate the number of a unit assignment or examination. Eg assignment '1', assignment '2' and so on. The reference is used to enable easy identification of an assessment item when more than one of the same type exists for a unit. It is also passed to the exam timetabling facility to assist in the identification of each examination when multiple examinations exist for a unit.
CI_START_DT	DATE		Yes	The date from which a calendar instance beomes effective.
CI_END_DT	DATE		Yes	The date from which a calendar instance is no longer effective.
LOCATION_CD	VARCHAR2	(0)		The location at which the unit assessment item is available in the specified teaching period. If a location is not specified, it is considered to be available at all locations in the context of the specified mode or class. Eg a unit assessment item may only be available for all location 'Location-A' offerings of the unit within the specified teaching period. --Obsolete
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	The grading schema for the assessment item associated with student assessment item
GS_VERSION_NUMBER	NUMBER	(3)	Yes	The version of grading schema for the assessment item associated with student assessment item.
GRADING_SCHEMA_DESC	VARCHAR2	(60)	Yes	Description for Grading Schema.
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.
UNIT_MODE	VARCHAR2	(0)		The mode in which the unit assessment item is available in thespecified teaching period. If a mode is not specified the assessmentitem is considered available in all modes. Eg. A unit assessment itemmay only be available in mode ON offerings of the unit within thespecified teaching period. That is, in all classes mapped to the modeON. --Obsolete
UNIT_CLASS	VARCHAR2	(0)		The class in which the assessment item is available in the specified teaching period. If a class is not specified, the assessment item is considered to be available for all classes. Eg a unit assessment item may only be available for all DAY class offerings of the unit within the specified teaching period. --Obsolete
DFLT_ITEM_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the assessment item is a default item for the unit. If set -ticked-, students enrolled in the unit will automatically be allocated the assessment item via the processes ASSJ3212 and ASSJ3213. If not set -not ticked-, the assessment item may be manually allocated to students in the unit.
LOGICAL_DELETE_DT	DATE			The date on which the assessment item was deleted from the unit offering pattern. Logical deletion does not cause the unit assessment item to be physically deleted from the database, however the item is no longer available for use for the unit offering pattern. Logically deleted items are removed from the corresponding student unit attempts when the process ASSJ3213 is run. Prior to the item being removed from student unit attempts, they are tagged as INACTIVE student unit assessment items in ASSF3222.
ASSESSMENT_TYPE	VARCHAR2	(10)	Yes	The name of the assessment type. An assessment type is assigned to an assessment item in order to classify the item. Eg. EXAM-CTL -Centrally managed examination-, ASSIGNMENT. Assessment types can be either examinable or non-examinable
DESCRIPTION	VARCHAR2	(180)		The description of the assessment item.
EXAM_SCHEDULED_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether or not the examinable assessment item is to be included in the exam timetable. The process which extracts data and exports it to the timetabling facility uses this indicator to determine which assessment items to include. Setting the indicator -ticked- causes the assessment item to be included in timetabling processing.
EXAM_SHORT_PAPER_NAME	VARCHAR2	(50)		The short name of the examination paper.
EXAM_PAPER_NAME	VARCHAR2	(90)		The long name of the examination paper, which is normally printed on the cover sheet of a theory examination.
EXAM_WORKING_TIME	DATE			The amount of time a student has to complete the examination. Eg 3.00 hours.
EXAM_PERUSAL_TIME	DATE			The amount of perusal/reading time permitted for the examination.
QUESTION_OR_TITLE	VARCHAR2	(180)		The question or title associated with the non-examinable assessment item.
ASS_LENGTH_OR_DURATION	VARCHAR2	(30)		The length or duration of a non-examinable assessment item. Examples- an essay with a length of 2000 words- a seminar with a duration of 15 min.
EXAMINABLE_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether the assessment item is examinable or non-examinable. This value is inherited from the assessment type assigned to the assessment item. When the checkbox is ticked, the item is examinable and is available for timetabling if its 'scheduled' indicator is also ticked. The setting of this indicator also determines which fields are displayed in ASSF2100 when assessment items are created / modified.
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
UNIT_ASS_ITEM_GROUP_ID	NUMBER	(15)	Yes	Unique identifier for a group to which the unit assessment item is attached.
MIDTERM_MANDATORY_TYPE_CODE	VARCHAR2	(30)		For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
MIDTERM_WEIGHT_QTY	NUMBER	(6)		Allows user to define the weight of the assessment item relative to other assessment items for Midterm grading period.
FINAL_MANDATORY_TYPE_CODE	VARCHAR2	(30)		For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
FINAL_WEIGHT_QTY	NUMBER	(6)		Allows user to define the weight of the assessment item relative to other assessment items for Final grading period.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_ID
,      SEQUENCE_NUMBER
,      REFERENCE
,      CI_START_DT
,      CI_END_DT
,      LOCATION_CD
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADING_SCHEMA_DESC
,      RELEASE_DATE
,      UNIT_MODE
,      UNIT_CLASS
,      DFLT_ITEM_IND
,      LOGICAL_DELETE_DT
,      ASSESSMENT_TYPE
,      DESCRIPTION
,      EXAM_SCHEDULED_IND
,      EXAM_SHORT_PAPER_NAME
,      EXAM_PAPER_NAME
,      EXAM_WORKING_TIME
,      EXAM_PERUSAL_TIME
,      QUESTION_OR_TITLE
,      ASS_LENGTH_OR_DURATION
,      EXAMINABLE_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UNIT_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
FROM APPS.IGS_AS_UAI_FIND_V;

Dependencies

[top of page]

APPS.IGS_AS_UAI_FIND_V references the following:

APPS: IGS_AS_ASSESSMNT_ITM_ALL; IGS_AS_ASSESSMNT_TYP; IGS_AS_GRD_SCHEMA; IGS_AS_UNITASS_ITEM_ALL

APPS.IGS_AS_UAI_FIND_V is not referenced by any database object