Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USUCL.ROWID ROW_ID
, USUCL.US_UNSCHEDULED_CL_ID US_UNSCHEDULED_CL_ID
, USUCL.UOO_ID UOO_ID
, USUCL.ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID
, USAT.ACTIVITY_TYPE_DESCRIPTION ACTIVITY_TYPE_DESCRIPTION
, USUCL.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, USUCL.BUILDING_ID BUILDING_ID
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, USUCL.ROOM_ID ROOM_ID
, ROM.DESCRIPTION ROOM_DESCRIPTION
, USUCL.NUMBER_OF_STUDENTS NUMBER_OF_STUDENTS
, USUCL.HOURS_PER_STUDENT HOURS_PER_STUDENT
, USUCL.HOURS_PER_FACULTY HOURS_PER_FACULTY
, USUCL.INSTRUCTOR_ID INSTRUCTOR_ID
, HZ.PARTY_NUMBER INSTRUCTOR_NUMBER
, HZ.PARTY_NAME INSTRUCTOR_NAME
, USUCL.CREATED_BY CREATED_BY
, USUCL.CREATION_DATE CREATION_DATE
, USUCL.LAST_UPDATED_BY LAST_UPDATED_BY
, USUCL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USUCL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_US_UNSCHED_CL USUCL
, HZ_PARTIES HZ
, IGS_PS_USEC_ACT_TYPE USAT
, IGS_AD_LOCATION LOC
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
WHERE USUCL.INSTRUCTOR_ID = HZ.PARTY_ID(+)
AND USUCL.ACTIVITY_TYPE_ID = USAT.ACTIVITY_TYPE_ID
AND USUCL.LOCATION_CD = LOC.LOCATION_CD
AND USUCL.BUILDING_ID = BLD.BUILDING_ID
AND USUCL.ROOM_ID = ROM.ROOM_ID