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_UAI_ETISTD_EXAM_V

Product:	IGS - Student System (Obsolete)
Description:	Created to supply the ETI, student exam timetabling interface, system with information it requires to determine that student unit attempt assessment items to timetable.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UECIV.EXAM_CAL_TYPE
, UECIV.EXAM_CI_SEQUENCE_NUMBER
, UECIV.CAL_TYPE
, UECIV.CI_SEQUENCE_NUMBER
, UECIV.ASS_ID
, UECIV.UNIT_CD
, UECIV.REFERENCE
, SUAAI.PERSON_ID
, UV.OWNER_ORG_UNIT_CD
, CRV.RESPONSIBLE_ORG_UNIT_CD
, PE.SURNAME
, PE.GIVEN_NAMES
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SPCL_NEEDS(SUA.PERSON_ID)
, 1
, 1)
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXAM_TP(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UNIT_ATTEMPT_STATUS
, SUA.UOO_ID)
, 1
, 20)
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UECIV.ASS_ID
, SUA.UOO_ID)
, 1
, 10)
, UECIV.CREATED_BY
, UECIV.CREATION_DATE
, UECIV.LAST_UPDATED_BY
, UECIV.LAST_UPDATE_DATE
, UECIV.LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID
FROM IGS_AS_UAI_EXAM_CI_INIT_V UECIV
, IGS_CA_INST TCI
, IGS_CA_STAT TCS
, IGS_AS_ASSESSMNT_ITM AI
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_STAT US
, IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNIT_CLASS UCL
, IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER CRV
, IGS_PE_PERSON PE
WHERE TCI.CAL_TYPE = UECIV.CAL_TYPE
AND TCI.SEQUENCE_NUMBER = UECIV.CI_SEQUENCE_NUMBER
AND TCS.CAL_STATUS = TCI.CAL_STATUS
AND TCS.S_CAL_STATUS = 'ACTIVE'
AND AI.ASS_ID = UECIV.ASS_ID
AND UV.UNIT_CD = UECIV.UNIT_CD
AND UV.VERSION_NUMBER = UECIV.VERSION_NUMBER
AND US.UNIT_STATUS = UV.UNIT_STATUS
AND US.S_UNIT_STATUS = 'ACTIVE'
AND SUAAI.ASS_ID = UECIV.ASS_ID
AND SUAAI.UNIT_CD = UECIV.UNIT_CD
AND SUAAI.CAL_TYPE = UECIV.CAL_TYPE
AND SUAAI.CI_SEQUENCE_NUMBER = UECIV.CI_SEQUENCE_NUMBER
AND SUAAI.LOGICAL_DELETE_DT IS NULL
AND SUA.PERSON_ID = SUAAI.PERSON_ID
AND SUA.COURSE_CD = SUAAI.COURSE_CD
AND SUA.UOO_ID = SUAAI.UOO_ID
AND SUA.UNIT_ATTEMPT_STATUS IN ('ENROLLED'
, 'COMPLETED')
AND SUA.NO_ASSESSMENT_IND = 'N'
AND UCL.UNIT_CLASS = SUA.UNIT_CLASS
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UCL.UNIT_MODE
, UECIV.LOCATION_CD
, UECIV.UNIT_CLASS
, UECIV.UNIT_MODE) = 'TRUE'
AND IGS_AS_GEN_002.ASSP_GET_EXAM_VIEW( UECIV.UAI_EXAM_CAL_TYPE
, UECIV.UAI_EXAM_CI_SEQUENCE_NUMBER
, UECIV.EXAM_CAL_TYPE
, UECIV.EXAM_CI_SEQUENCE_NUMBER
, SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UNIT_ATTEMPT_STATUS
, SUA.LOCATION_CD
, UCL.UNIT_MODE
, SUA.UNIT_CLASS
, UECIV.ASS_ID) = 'Y'
AND SCA.PERSON_ID = SUA.PERSON_ID
AND SCA.COURSE_CD = SUA.COURSE_CD
AND CRV.COURSE_CD = SCA.COURSE_CD
AND CRV.VERSION_NUMBER = SCA.VERSION_NUMBER
AND PE.PERSON_ID = SUAAI.PERSON_ID

Columns

Name
EXAM_CAL_TYPE
EXAM_CI_SEQUENCE_NUMBER
TEACH_CAL_TYPE
TEACH_CI_SEQUENCE_NUMBER
ASS_ID
UNIT_CD
REFERENCE
PERSON_ID
OWNER_ORG_UNIT_CD
RESPONSIBLE_ORG_UNIT_CD
SURNAME
GIVEN_NAMES
SPECIAL_NEEDS_IND
EXAM_LOCATION_CD
EXAMINATION_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DEG_AUD_DETAIL_ID