[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | It will display the exam schedule for the sections for the students |
| Implementation/DBA Data: | Not implemented in this database |
SELECT UOOV.ROW_ID ROW_ID
, UOOV.UOO_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.PERSON_ID
, SUA.UNIT_ATTEMPT_STATUS
, UOOV.UNIT_CD
, UOOV.UNIT_CLASS
, UOOV.CALL_NUMBER
, IGS_SS_ENR_DETAILS.GET_TITLE_SECTION(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD) TITLE
, USAS.FINAL_EXAM_DATE ||'
' || TO_CHAR(USAS.EXAM_START_TIME
, 'HH:MIAM')||' - ' || TO_CHAR(USAS.EXAM_END_TIME
, 'HH:MIAM') EXAM_DATE_TIME
, INITCAP(TO_CHAR(USAS.FINAL_EXAM_DATE
, 'DAY') )
, USAS.LOCATION_CD
, USAS.LOCATION_DESC
, USAS.BUILDING_DESC ||'
'|| USAS.ROOM_DESC
, PE.PARTY_NUMBER
, DECODE(PE.PARTY_NUMBER
, NULL
, NULL
, PE.PERSON_LAST_NAME||'
, '||PE.PERSON_FIRST_NAME||' '||PE.PERSON_MIDDLE_NAME)
, USAS.CREATED_BY
, USAS.CREATION_DATE
, USAS.LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN
, UOOV.LOCATION_CD SUA_LOCATION_CD
, SUA.CORE_INDICATOR_CODE
, USAS.FINAL_EXAM_DATE ||' ' || TO_CHAR(USAS.EXAM_START_TIME
, 'HH:MIAM')||' - ' || TO_CHAR(USAS.EXAM_END_TIME
, 'HH:MIAM') EXAM_TIMETABLE
, NVL(USAS.LOCATION_CD
, '-') || '/' || NVL(USAS.BUILDING_DESC
, '-') ||'/'|| NVL(USAS.ROOM_DESC
, '-')
FROM IGS_PS_USEC_AS_V USAS
, IGS_PS_UNIT_OFR_OPT UOOV
, IGS_PS_USEC_TCH_RESP UTR
, HZ_PARTIES PE
, IGS_EN_SU_ATTEMPT SUA
, IGS_EN_STDNT_PS_ATT SCA
WHERE USAS.UOO_ID (+)= UOOV.UOO_ID
AND USAS.UOO_ID = UTR.UOO_ID(+)
AND UTR.LEAD_INSTRUCTOR_FLAG(+) = 'Y'
AND UTR.INSTRUCTOR_ID = PE.PARTY_ID(+)
AND SCA.PERSON_ID = SUA.PERSON_ID
AND SCA.COURSE_CD = SUA.COURSE_CD
AND UOOV.UOO_ID =SUA.UOO_ID
AND SUA.UNIT_ATTEMPT_STATUS NOT IN ('UNCONFIRM')