VIEW: APPS.IGS_EN_PE_PRG_CTXT_V

Source

View Text - Preformatted

SELECT SPA.PERSON_ID, P.PERSON_NUMBER, SPA.COURSE_CD, SPA.VERSION_NUMBER, SPA.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, SPA.COURSE_CD || ' ' || SPA.VERSION_NUMBER COURSE_CD_VERSION, SPA.CAL_TYPE, SPA.LOCATION_CD, SPA.ATTENDANCE_MODE, SPA.ATTENDANCE_TYPE, SPA.COMMENCEMENT_DT, SPA.DISCONTINUATION_REASON_CD , SPA.CORRESPONDENCE_CAT , SPA.EXAM_LOCATION_CD , SPA.FEE_CAT , SPA.FUNDING_SOURCE , SPA.PUBLISH_OUTCOMES_IND , SPA.PROVISIONAL_IND , SPA.SELF_HELP_GROUP_IND , SPA.DISCONTINUED_DT , SPA.LAPSED_DT , SPA.CREATED_BY, SPA.CREATION_DATE, SPA.LAST_UPDATED_BY, SPA.LAST_UPDATE_DATE, SPA.LAST_UPDATE_LOGIN FROM IGS_EN_STDNT_PS_ATT_SV SPA, IGS_PE_PERSON_V P, IGS_PS_VER PV WHERE SPA.PERSON_ID = P.PERSON_ID AND SPA.COURSE_CD = PV.COURSE_CD AND SPA.VERSION_NUMBER = PV.VERSION_NUMBER

View Text - HTML Formatted

SELECT SPA.PERSON_ID
, P.PERSON_NUMBER
, SPA.COURSE_CD
, SPA.VERSION_NUMBER
, SPA.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
, SPA.COURSE_CD || ' ' || SPA.VERSION_NUMBER COURSE_CD_VERSION
, SPA.CAL_TYPE
, SPA.LOCATION_CD
, SPA.ATTENDANCE_MODE
, SPA.ATTENDANCE_TYPE
, SPA.COMMENCEMENT_DT
, SPA.DISCONTINUATION_REASON_CD
, SPA.CORRESPONDENCE_CAT
, SPA.EXAM_LOCATION_CD
, SPA.FEE_CAT
, SPA.FUNDING_SOURCE
, SPA.PUBLISH_OUTCOMES_IND
, SPA.PROVISIONAL_IND
, SPA.SELF_HELP_GROUP_IND
, SPA.DISCONTINUED_DT
, SPA.LAPSED_DT
, SPA.CREATED_BY
, SPA.CREATION_DATE
, SPA.LAST_UPDATED_BY
, SPA.LAST_UPDATE_DATE
, SPA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT_SV SPA
, IGS_PE_PERSON_V P
, IGS_PS_VER PV
WHERE SPA.PERSON_ID = P.PERSON_ID
AND SPA.COURSE_CD = PV.COURSE_CD
AND SPA.VERSION_NUMBER = PV.VERSION_NUMBER