Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Contains all combinations of student unit attempt clashes. It is used by a unit clash report that aggregates the records into a unit by unit list. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, SUA1.PERSON_ID
, SUA1.UNIT_CD
, SUA1.CAL_TYPE
, SUA1.CI_SEQUENCE_NUMBER
, SUA1.LOCATION_CD
, SUA2.UNIT_CD
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, SUA2.LOCATION_CD
, SUA1.CREATED_BY
, SUA1.CREATION_DATE
, SUA1.LAST_UPDATED_BY
, SUA1.LAST_UPDATE_DATE
, SUA1.LAST_UPDATE_LOGIN
, SUA1.DEG_AUD_DETAIL_ID
FROM IGS_CA_INST ACI
, IGS_CA_INST TCI
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
, IGS_EN_SU_ATTEMPT SUA1
, IGS_EN_SU_ATTEMPT SUA2
WHERE CT.CAL_TYPE = TCI.CAL_TYPE
AND CT.S_CAL_CAT = 'TEACHING'
AND CS.CAL_STATUS = TCI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, TCI.CAL_TYPE
, TCI.SEQUENCE_NUMBER
, 'N') = 'Y'
AND SUA1.CAL_TYPE = TCI.CAL_TYPE
AND SUA1.CI_SEQUENCE_NUMBER = TCI.SEQUENCE_NUMBER
AND SUA1.UNIT_ATTEMPT_STATUS = 'ENROLLED'
AND SUA2.PERSON_ID = SUA1.PERSON_ID
AND SUA2.UNIT_CD != SUA1.UNIT_CD
AND SUA2.LOCATION_CD != SUA1.LOCATION_CD
AND (( SUA2.CAL_TYPE = SUA1.CAL_TYPE
AND SUA2.CI_SEQUENCE_NUMBER = SUA1.CI_SEQUENCE_NUMBER) OR IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, 'N') = 'Y')
AND SUA2.UNIT_ATTEMPT_STATUS = 'ENROLLED'