[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | IGS_AS_UAI_EXAM_CI_V describes the examination calendar instances that a unit assessment item record is examined. This is determined based on the relationships between the teaching and examination calendar instances and the override uai.exa |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.CI_START_DT
, UAI.CI_END_DT
, UAI.UNIT_CLASS
, UAI.UNIT_MODE
, UAI.LOCATION_CD
, UAI.DUE_DT
, UAI.REFERENCE
, UAI.DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT
, UAI.ACTION_DT
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
FROM IGS_AS_UNITASS_ITEM UAI
, IGS_AS_ASSESSMNT_ITM AI
, IGS_AS_ASSESSMNT_TYP AT
, IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE UAI.LOGICAL_DELETE_DT IS NULL
AND AI.ASS_ID = UAI.ASS_ID
AND AI.EXAM_SCHEDULED_IND = 'Y'
AND AT.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE
AND AT.EXAMINABLE_IND = 'Y'
AND CAT.CAL_TYPE = CI.CAL_TYPE
AND CAT.S_CAL_CAT = 'EXAM'
AND CS.CAL_STATUS = CI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND (UAI.EXAM_CAL_TYPE IS NULL OR CI.CAL_TYPE = UAI.EXAM_CAL_TYPE)
AND (UAI.EXAM_CI_SEQUENCE_NUMBER IS NULL OR CI.SEQUENCE_NUMBER = UAI.EXAM_CI_SEQUENCE_NUMBER)
AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, 'N') = 'Y'