View created to contain the teaching responsibility, which applies to a given unit offering option. This routine will use either the teaching responsibility or teaching responsibility override tables to determine the relevant responsibility
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT UOO.UNIT_CD , UOO.VERSION_NUMBER , UOO.CAL_TYPE , UOO.CI_SEQUENCE_NUMBER , UOO.LOCATION_CD , UOO.UNIT_CLASS , TR.ORG_UNIT_CD , TR.OU_START_DT , UOO.UOO_ID , TR.PERCENTAGE , UOO.CREATED_BY , UOO.CREATION_DATE , UOO.LAST_UPDATED_BY , UOO.LAST_UPDATE_DATE , UOO.LAST_UPDATE_LOGIN FROM IGS_PS_UNIT_OFR_OPT UOO , IGS_PS_TCH_RESP TR WHERE NOT EXISTS ( SELECT UNIT_CD FROM IGS_PS_TCH_RESP_OVRD WHERE UOO_ID = UOO.UOO_ID ) AND TR.UNIT_CD = UOO.UNIT_CD AND TR.VERSION_NUMBER = UOO.VERSION_NUMBER UNION ALL SELECT UOO.UNIT_CD , UOO.VERSION_NUMBER , UOO.CAL_TYPE , UOO.CI_SEQUENCE_NUMBER , UOO.LOCATION_CD , UOO.UNIT_CLASS , TRO.ORG_UNIT_CD , TRO.OU_START_DT , UOO.UOO_ID , TRO.PERCENTAGE , UOO.CREATED_BY , UOO.CREATION_DATE , UOO.LAST_UPDATED_BY , UOO.LAST_UPDATE_DATE , UOO.LAST_UPDATE_LOGIN FROM IGS_PS_UNIT_OFR_OPT UOO , IGS_PS_TCH_RESP_OVRD TRO WHERE TRO.UOO_ID = UOO.UOO_ID