eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AS_USEC_CLASSLIST_V

Product:	IGS - Student System (Obsolete)
Description:	Describes Unit Sections for Class List
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UOO.UNIT_CD
, UOO.UNIT_CLASS
, UOO.LOCATION_DESCRIPTION
, UOO.CALL_NUMBER
, UOO.TITLE
, HZ.PERSON_LAST_NAME || '
, ' || HZ.PERSON_FIRST_NAME || ' ' || HZ.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, UOO.UOO_ID
, USTR.INSTRUCTOR_ID
, TTL.LOAD_CAL_TYPE
, TTL.LOAD_CI_SEQUENCE_NUMBER
, TTL.LOAD_START_DT
, TTL.LOAD_END_DT
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
FROM IGS_PS_UNIT_OFR_OPT_V UOO
, HZ_PARTIES HZ
, IGS_CA_TEACH_TO_LOAD_V TTL
, IGS_PS_USEC_TCH_RESP USTR
WHERE UOO.UOO_ID=USTR.UOO_ID
AND UOO.UNIT_SECTION_STATUS IN ('OPEN'
, 'CLOSED'
, 'HOLD'
, 'FULLWAITOK')
AND USTR.LEAD_INSTRUCTOR_FLAG ='Y'
AND USTR.INSTRUCTOR_ID = HZ.PARTY_ID
AND UOO.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER

Columns

Name
LOAD_DESCRIPTION
TEACH_DESCRIPTION
UNIT_CD
UNIT_CLASS
LOCATION
CALL_NUMBER
TITLE
INSTRUCTOR_NAME
UOO_ID
INSTRUCTOR_ID
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
LOAD_START_DT
LOAD_END_DT
TEACH_CAL_TYPE
TEACH_CI_SEQUENCE_NUMBER