Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains the history of instructors teaching details at the institution such as units taught, unit location, calendar details and teaching responsibilities of the instructor. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UTR.INSTRUCTOR_ID INSTRUCTOR_ID
, UOF.UOO_ID UOO_ID
, UOF.CAL_TYPE CAL_TYPE
, UOF.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOF.UNIT_CD UNIT_CD
, UOF.VERSION_NUMBER VERSION_NUMBER
, UOF.UNIT_CLASS UNIT_CLASS
, AL.DESCRIPTION LOCATION_DESCRIPTION
, UV.TITLE UNIT_TITLE
, UTR.INSTRUCTIONAL_LOAD_LECTURE INSTRUCTIONAL_LOAD_LECTURE
, UTR.INSTRUCTIONAL_LOAD_LAB INSTRUCTIONAL_LOAD_LAB
, UTR.INSTRUCTIONAL_LOAD INSTRUCTIONAL_LOAD
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS
, IGS_PS_FAC_CREDT_WRKLOAD.PRGP_GET_LEAD_INSTRUCTOR(UOF.UOO_ID) LEAD_INSTRUCTOR
, UTR.CREATED_BY CREATED_BY
, UTR.CREATION_DATE CREATION_DATE
, UTR.LAST_UPDATED_BY LAST_UPDATED_BY
, UTR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOF
, IGS_PS_USEC_TCH_RESP UTR
, IGS_PS_UNIT_VER UV
, IGS_AD_LOCATION AL
, IGS_PS_USEC_CPS CPS
WHERE UOF.UOO_ID = UTR.UOO_ID
AND UOF.UNIT_CD = UV.UNIT_CD
AND UOF.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOF.LOCATION_CD=AL.LOCATION_CD
AND UOF.UOO_ID = CPS.UOO_ID(+)