[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity describes a student's attempt at studying a particular unit offered by the university. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON
, SUA.ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT
, SUA.DCNT_REASON_CD
, SUA.GRADING_SCHEMA_CODE
, SUA.GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, SUA.CART
, SUA.ORG_UNIT_CD
, SUA.SUBTITLE
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, SUA.CORE_INDICATOR_CODE
, HP.PARTY_NUMBER
, CRV.TITLE
, UV.TITLE
, CA.DESCRIPTION
, '_LA:SUA.UNIT_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:UNIT_ATTEMPT_STATUS:MEANING'
, SUA.RULE_WAIVED_PERSON_ID
, SUA.UOO_ID
, SUA.DEG_AUD_DETAIL_ID
, SUA.RSV_SEAT_EXT_ID
, SUA.SESSION_ID
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
FROM IGS_EN_SU_ATTEMPT_ALL SUA
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CA
WHERE SUA.PERSON_ID = HP.PARTY_ID
AND SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SUA.CAL_TYPE = CA.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER WITH READ ONLY