Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view describes the data pertaining to the student unit attempt waitlist. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SUA.ROW_ID ROW_ID
, SUA.PERSON_ID PERSON_ID
, PE.FULL_NAME TITLE_NAME
, SUA.COURSE_CD COURSE_CD
, PS.TITLE
, SUA.UNIT_CD UNIT_CD
, SUA.VERSION_NUMBER VERSION_NUMBER
, SUA.CAL_TYPE CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, 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
, SUA.ADMINISTRATIVE_PRIORITY ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT WAITLIST_DT
, SUA.WAITLIST_MANUAL_IND
, SUA.DCNT_REASON_CD DCNT_REASON_CD
, 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.REQUEST_ID REQUEST_ID
, SUA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SUA.PROGRAM_ID PROGRAM_ID
, SUA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SUA. GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, PE.PERSON_NUMBER
, SUA.CART
, SUA.RSV_SEAT_EXT_ID
, SUA.ORG_UNIT_CD
, SUA.SESSION_ID
, SUA.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, SUA.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, SUA.ATTRIBUTE_CATEGORY
, SUA.ATTRIBUTE1
, SUA.ATTRIBUTE2
, SUA.ATTRIBUTE3
, SUA.ATTRIBUTE4
, SUA.ATTRIBUTE5
, SUA.ATTRIBUTE6
, SUA.ATTRIBUTE7
, SUA.ATTRIBUTE8
, SUA.ATTRIBUTE9
, SUA.ATTRIBUTE10
, SUA.ATTRIBUTE11
, SUA.ATTRIBUTE12
, SUA.ATTRIBUTE13
, SUA.ATTRIBUTE14
, SUA.ATTRIBUTE15
, SUA.ATTRIBUTE16
, SUA.ATTRIBUTE17
, SUA.ATTRIBUTE18
, SUA.ATTRIBUTE19
, SUA.ATTRIBUTE20
, SUA.SUBTITLE
, SUA.WLST_PRIORITY_WEIGHT_NUM
, SUA.WLST_PREFERENCE_WEIGHT_NUM
, SUA.CORE_INDICATOR_CODE
, SUA.UPD_AUDIT_FLAG
, SUA.SS_SOURCE_IND
FROM IGS_EN_SU_ATTEMPT_SV SUA
, IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER PS
, IGS_PE_PERSON_BASE_V PE
WHERE SUA.PERSON_ID = PE.PERSON_ID
AND SUA.UNIT_ATTEMPT_STATUS = 'WAITLISTED'
AND SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = PS.COURSE_CD
AND SCA.VERSION_NUMBER = PS.VERSION_NUMBER