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_UAP_ITEM_V

Object Details

Object Name:	IGS_AS_UAP_ITEM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AS_UAP_ITEM_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
ROW_ID	ROWID	(10)
UNIT_ASS_ITEM_ID	NUMBER	(15)	Yes	Unique Identifier of the Assessment items attached at the unit level
UNIT_CD	VARCHAR2	(10)	Yes	UNIT_ASSESSMENT_ITEM.UNIT_CD
VERSION_NUMBER	NUMBER	(3)	Yes	UNIT_ASSESSMENT_ITEM.VERSION_NUMBER
CAL_TYPE	VARCHAR2	(10)	Yes	UNIT_ASSESSMENT_ITEM.CAL_TYPE
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	UNIT_ASSESSMENT_ITEM.CI_SEQUENCE_NUMBER
ASS_PATTERN_ID	NUMBER	(10)	Yes	UNIT_ASS_PATTERN_ITEM.ASS_PATTERN_ID
ASS_ID	NUMBER	(10)	Yes	UNIT_ASSESSMENT_ITEM.ASS_ID
UAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	UNIT_ASSESSMENT_ITEM.SEQUENCE_NUMBER
LOCATION_CD	VARCHAR2	(10)		UNIT_ASSESSMENT_ITEM.LOCATION_CD
UNIT_MODE	VARCHAR2	(10)		UNIT_ASSESSMENT_ITEM.UNIT_MODE
UNIT_CLASS	VARCHAR2	(10)		UNIT_ASSESSMENT_ITEM.UNIT_CLASS
DUE_DT	DATE			UNIT_ASSESSMENT_ITEM.DUE_DT
REFERENCE	VARCHAR2	(30)		UNIT_ASSESSMENT_ITEM.REFERENCE
APPORTIONMENT_PERCENTAGE	NUMBER	(3)		UNIT_ASS_PATTERN_ITEM.APPORTIONMENT_PERCENTAGE
DFLT_ITEM_IND	VARCHAR2	(1)	Yes	UNIT_ASSESSMENT_ITEM.DFLT_ITEM_IND
LOGICAL_DELETE_DT	DATE			UNIT_ASSESSMENT_ITEM.LOGICAL_DELETE_DT
ACTION_DT	DATE			UNIT_ASSESSMENT_ITEM.ACTION_DT
EXAM_CAL_TYPE	VARCHAR2	(10)		UNIT_ASSESSMENT_ITEM.EXAM_CAL_TYPE
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)		UNIT_ASSESSMENT_ITEM.EXAM_CI_SEQUENCE_NUMBER
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.
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)
DESCRIPTION	VARCHAR2	(180)		The item description defined at the unit level and if it is not defined then it will display the generic item description.

Query Text

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


SELECT ROW_ID
,      UNIT_ASS_ITEM_ID
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_PATTERN_ID
,      ASS_ID
,      UAI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_MODE
,      UNIT_CLASS
,      DUE_DT
,      REFERENCE
,      APPORTIONMENT_PERCENTAGE
,      DFLT_ITEM_IND
,      LOGICAL_DELETE_DT
,      ACTION_DT
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADING_SCHEMA_DESC
,      RELEASE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
FROM APPS.IGS_AS_UAP_ITEM_V;

Dependencies

[top of page]

APPS.IGS_AS_UAP_ITEM_V references the following:

APPS: IGS_AS_ASSESSMNT_ITM_ALL; IGS_AS_GRD_SCHEMA; IGS_AS_UNITASS_ITEM_ALL; IGS_AS_UNT_PATRN_ITM

APPS.IGS_AS_UAP_ITEM_V is not referenced by any database object