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_ATTEND_ENTRY_V

Product:	IGS - Student System (Obsolete)
Description:	Describes Unit Sections due for Attendance View
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 LOCATION
, 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 TEACH_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER TEACH_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
AND SYSDATE > (SELECT MAX(CDI.ALIAS_VAL) ATTENDANCE_START_DT
FROM IGS_CA_DA_INST_V CDI
, IGS_AS_CAL_CONF CAC
WHERE CDI.DT_ALIAS = CAC.FINAL_MGS_START_DT_ALIAS
AND CDI.CAL_TYPE = UOO.CAL_TYPE
AND CDI.CI_SEQUENCE_NUMBER = UOO.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