Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view describes and maintains the student course version of a specific program structure. |
Implementation/DBA Data: | Not implemented in this database |
SELECT IGS.ROWID ROW_ID
, IGS.PERSON_ID
, IGS.COURSE_CD
, IGS.VERSION_NUMBER
, IGS.CAL_TYPE
, IGS.LOCATION_CD
, IGS.ATTENDANCE_MODE
, IGS.ATTENDANCE_TYPE
, IGS.COO_ID
, IGS.STUDENT_CONFIRMED_IND
, IGS.COMMENCEMENT_DT
, IGS.COURSE_ATTEMPT_STATUS
, IGS.PROGRESSION_STATUS
, IGS.DERIVED_ATT_TYPE
, IGS.DERIVED_ATT_MODE
, IGS.PROVISIONAL_IND
, IGS.DISCONTINUED_DT
, IGS.DISCONTINUATION_REASON_CD
, IGS.LAPSED_DT
, IGS.FUNDING_SOURCE
, IGS.EXAM_LOCATION_CD
, IGS.DERIVED_COMPLETION_YR
, IGS.DERIVED_COMPLETION_PERD
, IGS.NOMINATED_COMPLETION_YR
, IGS.NOMINATED_COMPLETION_PERD
, IGS.RULE_CHECK_IND
, IGS.WAIVE_OPTION_CHECK_IND
, IGS.LAST_RULE_CHECK_DT
, IGS.PUBLISH_OUTCOMES_IND
, IGS.COURSE_RQRMNT_COMPLETE_IND
, IGS.COURSE_RQRMNTS_COMPLETE_DT
, IGS.S_COMPLETED_SOURCE_TYPE
, IGS.OVERRIDE_TIME_LIMITATION
, IGS.ADVANCED_STANDING_IND
, IGS.FEE_CAT
, IGS.CORRESPONDENCE_CAT
, IGS.SELF_HELP_GROUP_IND
, IGS.LOGICAL_DELETE_DT
, IGS.ADM_ADMISSION_APPL_NUMBER
, IGS.ADM_NOMINATED_COURSE_CD
, IGS.ADM_SEQUENCE_NUMBER
, IGS.CREATED_BY
, IGS.CREATION_DATE
, IGS.LAST_UPDATED_BY
, IGS.LAST_UPDATE_DATE
, IGS.LAST_UPDATE_LOGIN
, IGS.REQUEST_ID
, IGS.PROGRAM_APPLICATION_ID
, IGS.PROGRAM_ID
, IGS.PROGRAM_UPDATE_DATE
, LKUP.FEE_ASS_IND
, LKUP.MEANING
, CRV.SHORT_TITLE
FROM IGS_EN_STDNT_PS_ATT IGS
, IGS_LOOKUPS_VIEW LKUP
, IGS_PS_VER CRV
WHERE IGS.COURSE_ATTEMPT_STATUS = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS'
AND (CRV.COURSE_CD = IGS.COURSE_CD OR (CRV.COURSE_CD IS NULL
AND IGS.COURSE_CD IS NULL))
AND (CRV.VERSION_NUMBER = IGS.VERSION_NUMBER OR (IGS.VERSION_NUMBER IS NULL
AND CRV.VERSION_NUMBER IS NULL))