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.

[Home] [Help]

View: IGS_AS_UAP_SUA_V

Product:	IGS - Student System (Obsolete)
Description:	Describes the assessment patterns that make up the assessment requirement for a student's unit attempt
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, UAP.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UAP.ASS_PATTERN_ID
, UAP.ASS_PATTERN_CD
, UAP.DESCRIPTION
, UAP.LOCATION_CD
, UAP.UNIT_CLASS
, UAP.UNIT_MODE
, UAP.DFLT_PATTERN_IND
, UAP.LOGICAL_DELETE_DT
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, UAP.CREATED_BY
, UAP.CREATION_DATE
, UAP.LAST_UPDATED_BY
, UAP.LAST_UPDATE_DATE
, UAP.LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNTAS_PATTERN UAP
, IGS_AS_UNIT_CLASS UC
WHERE SUA.UNIT_CD = UAP.UNIT_CD
AND SUA.VERSION_NUMBER = UAP.VERSION_NUMBER
AND SUA.CAL_TYPE = UAP.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = UAP.CI_SEQUENCE_NUMBER
AND SUA.UNIT_CLASS = UC.UNIT_CLASS
AND IGS_AS_VAL_UAP.ASSP_VAL_SUA_UAP(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, UAP.LOCATION_CD
, UAP.UNIT_CLASS
, UAP.UNIT_MODE) = 'TRUE'

Columns

Name
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