Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view stores Unit Section Occurrences. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT C.UNIT_SECTION_OCCURRENCE_ID
, C.UOO_ID
, DECODE(C.MONDAY
, 'Y'
, 'MON'
, NULL)|| DECODE(C.TUESDAY
, 'Y'
, 'TUE'
, NULL)|| DECODE(C.WEDNESDAY
, 'Y'
, 'WED'
, NULL)|| DECODE(C.THURSDAY
, 'Y'
, 'THU'
, NULL)|| DECODE(C.FRIDAY
, 'Y'
, 'FRI'
, NULL)|| DECODE(C.SATURDAY
, 'Y'
, 'SAT'
, NULL)|| DECODE(C.SUNDAY
, 'Y'
, 'SUN'
, NULL)
, TO_CHAR(C.START_TIME
, 'HH:MIAM')||'-'||TO_CHAR(C.END_TIME
, 'HH:MIAM')
, D.LOCATION_CD
, B.DESCRIPTION
, C.BUILDING_CODE
, D.BUILDING_CD
, D.DESCRIPTION BUILDING_DESCRIPTION
, C.ROOM_CODE
, E.ROOM_CD
, E.DESCRIPTION ROOM_DESCRIPTION
, C.INSTRUCTOR_ID
, F.PERSON_LAST_NAME
, F.PERSON_FIRST_NAME
, F. PERSON_TITLE
, F.PERSON_LAST_NAME||'
, '||F.PERSON_FIRST_NAME||' '||F.PERSON_MIDDLE_NAME
, C.START_DATE
, C.END_DATE
FROM IGS_PS_USEC_OCCURS C
, IGS_AD_BUILDING D
, IGS_AD_ROOM E
, HZ_PARTIES F
, IGS_AD_LOCATION B
WHERE C.BUILDING_CODE = D.BUILDING_ID(+)
AND C.ROOM_CODE = E.ROOM_ID(+)
AND C.INSTRUCTOR_ID = F.PARTY_ID(+)
AND D.LOCATION_CD = B.LOCATION_CD(+)