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_SUA_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGS_AS_UAP_SUA_V describes the assessment patterns that make up the assessment requirement for a student's unit attempt.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier
COURSE_CD	VARCHAR2	(6)	Yes	Program code
UNIT_CD	VARCHAR2	(10)	Yes	Unit code
VERSION_NUMBER	NUMBER	(3)	Yes	Unit version number
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar instance sequence number
ASS_PATTERN_ID	NUMBER	(10)	Yes	Assessment pattern identifier
ASS_PATTERN_CD	VARCHAR2	(10)	Yes	Assessment pattern code
DESCRIPTION	VARCHAR2	(60)	Yes	Assessment pattern description
UAP_LOCATION_CD	VARCHAR2	(10)		Unit assessment pattern location code
UAP_UNIT_CLASS	VARCHAR2	(10)		Unit assessment pattern unit class
UAP_UNIT_MODE	VARCHAR2	(10)		Unit assessment pattern unit mode
UAP_DFLT_PATTERN_IND	VARCHAR2	(1)	Yes	Unit assessment pattern default indicator
UAP_LOGICAL_DELETE_DT	DATE			Unit assessment pattern logical deletion date
SUA_LOCATION_CD	VARCHAR2	(10)	Yes	Student unit attempt location code
SUA_UNIT_CLASS	VARCHAR2	(10)	Yes	Student unit attempt unit class
SUA_UNIT_MODE	VARCHAR2	(10)	Yes	Student unit attempt unit mode
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Detail Id
UOO_ID	NUMBER	(7)	Yes	Unit Section Identifier

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_PATTERN_ID
,      ASS_PATTERN_CD
,      DESCRIPTION
,      UAP_LOCATION_CD
,      UAP_UNIT_CLASS
,      UAP_UNIT_MODE
,      UAP_DFLT_PATTERN_IND
,      UAP_LOGICAL_DELETE_DT
,      SUA_LOCATION_CD
,      SUA_UNIT_CLASS
,      SUA_UNIT_MODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEG_AUD_DETAIL_ID
,      UOO_ID
FROM APPS.IGS_AS_UAP_SUA_V;

Dependencies

[top of page]

APPS.IGS_AS_UAP_SUA_V references the following:

APPS: IGS_AS_UNIT_CLASS; IGS_AS_UNTAS_PATTERN; IGS_AS_VAL_UAP - show dependent code; IGS_EN_SU_ATTEMPT

APPS.IGS_AS_UAP_SUA_V is not referenced by any database object