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_ASSITEM_ADI_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

Assessment Item WebADI View

[View Source]

Columns

Name	Datatype	Length	Comments
PARTY_NAME	VARCHAR2	(363)	Person Name
PARTY_NUMBER	VARCHAR2	(30)	Person Number
ANONYMOUS_ID	VARCHAR2	(4000)	Anonymous Identifier
ASSESSMENT_TYPE	VARCHAR2	(10)	Assessment Type
GRADING_SCHEMA_CD	VARCHAR2	(10)	Grading Schema Code
GS_VERSION_NUMBER	NUMBER	(3)	Version Number
OUTCOME_DT	DATE		Outcome Date
MARK	NUMBER	(6)	Mark
GRADE	VARCHAR2	(5)	Grade
COMMENTS	VARCHAR2	(4000)	Outcome Comment
EXAM_LOCATION_CD	VARCHAR2	(10)	Examination Location Code
PERSON_ID	NUMBER	(15)	Person Identifier
COURSE_CD	VARCHAR2	(6)	Course COde
UNIT_CD	VARCHAR2	(10)	Unit Code
TITLE	VARCHAR2	(90)	Title
CAL_TYPE	VARCHAR2	(10)	Calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Calendar Sequence Number
ASSESSMENT_ID	NUMBER	(10)	Assessment Identifier
LOCATION_CD	VARCHAR2	(10)	Location Code
UOO_ID	NUMBER	(7)	Unit Offering Option Identifier
CHK_ANON_GRADED	VARCHAR2	(4000)	Checks whether Anonymously Graded or not
REFERENCE	VARCHAR2	(30)	Reference for the unit assessment item. References are typically used to indicate the number of a unit assignment or examination such as assignment 1 or assignment 2. 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.
DUE_DT	DATE		Due date for completion or submission of the unit assessment item. Due dates are typically entered for non-examinable assessment items. Assignment due dates are used in the assignment tracking facility as the default action date for the Received from Student step.
WAIVED_FLAG	VARCHAR2	(1)	Determines whether or not assessment item is waived. For Ex. Y-Waived, N-Not Waived
OVERRIDE_DUE_DT	DATE		A user-defined date which overrides the default due date of the assessment item.
SUBMITTED_DATE	DATE		Date on which the student submitted the assessment item.
PENALTY_APPLIED_FLAG	VARCHAR2	(1)	Determines whether or not penalty is applied. For Ex. Y-Penalty Applied, N-Penalty Not Applied
UNIT_CLASS	VARCHAR2	(10)	Unit Level

Query Text

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


SELECT PARTY_NAME
,      PARTY_NUMBER
,      ANONYMOUS_ID
,      ASSESSMENT_TYPE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      OUTCOME_DT
,      MARK
,      GRADE
,      COMMENTS
,      EXAM_LOCATION_CD
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      TITLE
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASSESSMENT_ID
,      LOCATION_CD
,      UOO_ID
,      CHK_ANON_GRADED
,      REFERENCE
,      DUE_DT
,      WAIVED_FLAG
,      OVERRIDE_DUE_DT
,      SUBMITTED_DATE
,      PENALTY_APPLIED_FLAG
,      UNIT_CLASS
FROM APPS.IGS_AS_ASSITEM_ADI_V;

Dependencies

[top of page]

APPS.IGS_AS_ASSITEM_ADI_V references the following:

APPS: HZ_PARTIES; IGS_AS_ANON_GRD_PKG - show dependent code; IGS_AS_ASSESSMNT_ITM_ALL; IGS_AS_GRD_SCH_GRADE; IGS_AS_SU_ATMPT_ITM; IGS_AS_UNITASS_ITEM_ALL; IGS_EN_SU_ATTEMPT_SV; IGS_GE_GEN_004 - show dependent code; IGS_PS_UNITASS_ITEM; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL

APPS.IGS_AS_ASSITEM_ADI_V is not referenced by any database object