VIEW: APPS.IGS_EN_PS_ATT_CH_OPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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