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_X_USEC_CLASSLIST_V

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

View Text

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UXG.USEC_X_LISTED_GROUP_NAME
, UOO.LOCATION_DESCRIPTION
, HZ.PERSON_LAST_NAME || '
, ' || HZ.PERSON_FIRST_NAME || ' ' || HZ.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, USTR.INSTRUCTOR_ID
, UXG.USEC_X_LISTED_GROUP_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_USEC_X_GRP UXG
, IGS_PS_USEC_X_GRPMEM UXGM
, IGS_PS_UNIT_OFR_OPT_V UOO
, IGS_PS_USEC_TCH_RESP USTR
, HZ_PARTIES HZ
, IGS_CA_TEACH_TO_LOAD_V TTL
WHERE UXG.USEC_X_LISTED_GROUP_ID = UXGM.USEC_X_LISTED_GROUP_ID
AND UXGM.UOO_ID = UOO.UOO_ID
AND UXGM.PARENT ='Y'
AND UOO.UNIT_SECTION_STATUS IN('OPEN'
, 'HOLD'
, 'CLOSED'
, 'FULLWAITOK')
AND UOO.UOO_ID = USTR.UOO_ID
AND USTR.LEAD_INSTRUCTOR_FLAG ='Y'
AND USTR.INSTRUCTOR_ID = HZ.PARTY_ID
AND UXG.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UXG.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER

Columns

Name
LOAD_DESCRIPTION
TEACH_DESCRIPTION
GROUP_NAME
LOCATION
INSTRUCTOR_NAME
INSTRUCTOR_ID
GROUP_ID
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
LOAD_START_DT
LOAD_END_DT
TEACH_CAL_TYPE
TEACH_CI_SEQUENCE_NUMBER