Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view holds the details of the program context information of a specific student. The information this view holds appears on each form where program units are described. This information is displayed as a context block. |
Implementation/DBA Data: | Not implemented in this database |
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