View: IGSFV_USEC_TEACH_INSTRUCTORS

Product:	IGS - Student System
Description:	This is the full view, which describes the teaching responsibilities for a unit section.
Implementation/DBA Data:	APPS.IGSFV_USEC_TEACH_INSTRUCTORS

View Text

SELECT US.UNIT_SECTION_TEACH_RESP_ID
, US.UOO_ID UNIT_SECTION_ID
, US.INSTRUCTOR_ID
, US.CONFIRMED_FLAG
, US.PERCENTAGE_ALLOCATION
, US.INSTRUCTIONAL_LOAD
, US.LEAD_INSTRUCTOR_FLAG
, US.INSTRUCTIONAL_LOAD_LAB
, US.INSTRUCTIONAL_LOAD_LECTURE
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_TCH_RESP US
, HZ_PARTIES HZ
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE UN.UOO_ID = US.UOO_ID
AND US.INSTRUCTOR_ID = HZ.PARTY_ID
AND HZ.STATUS = 'A' WITH READ ONLY

Columns