VIEW: APPS.IGS_EN_STDNT_PS_ATT_CRV_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))