Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view describes the detailed information about students attempt for a specific program structure, including the student information, the attendance type information and the course attempt status. |
Implementation/DBA Data: | Not implemented in this database |
SELECT IGS.ROWID ROW_ID
, IGS.PERSON_ID
, PEV.PERSON_NUMBER
, IGS.COURSE_CD
, IGS.VERSION_NUMBER
, IGS.CAL_TYPE
, IGS.LOCATION_CD
, IGS.ATTENDANCE_MODE
, IGS.ATTENDANCE_TYPE
, IGS.COURSE_ATTEMPT_STATUS
, IGS.CREATED_BY
, IGS.CREATION_DATE
, IGS.LAST_UPDATED_BY
, IGS.LAST_UPDATE_DATE
, IGS.LAST_UPDATE_LOGIN
, LKUP.FEE_ASS_IND
, IGS.FEE_CAT
, FCAT.CURRENCY_CD CURRENCY_CD
FROM IGS_EN_STDNT_PS_ATT IGS
, IGS_PE_PERSON_BASE_V PEV
, IGS_LOOKUPS_VIEW LKUP
, IGS_FI_FEE_CAT FCAT
WHERE (IGS.COURSE_ATTEMPT_STATUS = LKUP.LOOKUP_CODE OR IGS.COURSE_ATTEMPT_STATUS IS NULL)
AND LKUP.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS'
AND IGS.FEE_CAT = FCAT.FEE_CAT(+)
AND IGS.PERSON_ID = PEV.PERSON_ID