VIEW: APPS.IGS_EN_SUA_WLST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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