[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes valid unit attempts for a student's attempt studying at a particular unit offered by the university |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SUA.PERSON_ID PERSON_ID
, SUA.COURSE_CD COURSE_CD
, SUA.UNIT_CD UNIT_CD
, SUA.VERSION_NUMBER VERSION_NUMBER
, SUA.CAL_TYPE CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, SUBSTR( IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10) ACAD_ALTERNATE_CODE
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10) TEACH_ALTERNATE_CODE
, SUA.LOCATION_CD LOCATION_CD
, SUA.UNIT_CLASS UNIT_CLASS
, SUA.CI_START_DT CI_START_DT
, SUA.CI_END_DT CI_END_DT
, SUA.UOO_ID UOO_ID
, SUA.ENROLLED_DT ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT DISCONTINUED_DT
, SUA.RULE_WAIVED_DT RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID RULE_WAIVED_PERSON_ID
, SUA.NO_ASSESSMENT_IND NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON OVERRIDE_CREDIT_REASON
, SUAO.OUTCOME_DT OUTCOME_DT
, SUAO.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, SUAO.GRADE GRADE
, SUAO.MARK MARK
, UV1.TITLE TITLE
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV1.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS
, LKUPS.MEANING MEANING
, SUA.CREATED_BY CREATED_BY
, SUA.CREATION_DATE CREATION_DATE
, SUA.LAST_UPDATED_BY LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_USEC_CPS CPS
, IGS_PS_UNIT_VER UV1
, IGS_AS_SU_STMPTOUT SUAO
, IGS_LOOKUPS_VIEW LKUPS
WHERE SUAO.PERSON_ID = SUA.PERSON_ID
AND SUAO.COURSE_CD = SUA.COURSE_CD
AND SUAO.UOO_ID = SUA.UOO_ID
AND UV1.UNIT_CD = SUA.UNIT_CD
AND UV1.VERSION_NUMBER = SUA.VERSION_NUMBER
AND SUA.UOO_ID = UOO.UOO_ID
AND UOO.UOO_ID = CPS.UOO_ID(+) AND LKUPS.LOOKUP_CODE = SUA.UNIT_ATTEMPT_STATUS AND LKUPS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'