Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view describes the change course option of an enrolled student which also takes course code, location and attempt status into consideration. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCA.PERSON_ID
, P.PERSON_NUMBER
, SCA.STUDENT_CONFIRMED_IND
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.COURSE_ATTEMPT_STATUS
, P.FULL_NAME
, P.SEX
, P.SEX_MEANING
, P.BIRTH_DT
, P.API_PERSON_ID
, P.DECEASED_IND
, P.ENCUMBERED_IND
, PV.TITLE COURSE_TITLE
, SCA.COURSE_CD || ' ' || SCA.VERSION_NUMBER COURSE_CD_VERSION
, SCA.COO_ID
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.COMMENCEMENT_DT
, SCA.DISCONTINUATION_REASON_CD
, SCA.CORRESPONDENCE_CAT
, SCA.EXAM_LOCATION_CD
, SCA.FEE_CAT
, SCA.FUNDING_SOURCE
, SCA.RULE_CHECK_IND
, SCA.WAIVE_OPTION_CHECK_IND
, SCA.ADVANCED_STANDING_IND
, SCA.PUBLISH_OUTCOMES_IND
, SCA.PROVISIONAL_IND
, SCA.SELF_HELP_GROUP_IND
, SCA.DISCONTINUED_DT
, SCA.LAPSED_DT
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_PE_PERSON_V P
, IGS_PS_VER PV
WHERE SCA.PERSON_ID = P.PERSON_ID
AND SCA.COURSE_CD = PV.COURSE_CD
AND SCA.VERSION_NUMBER = PV.VERSION_NUMBER