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_EN_USEC_EXAM_SCH_V

Product:	IGS - Student System (Obsolete)
Description:	This view contains the final exam schedule details.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UOOV.ROW_ID ROW_ID
, UOOV.UNIT_CD
, UOOV.UNIT_CLASS
, UOOV.CALL_NUMBER
, UOOV.TITLE
, UOOV.UOO_ID
, USAS.FINAL_EXAM_DATE
, USAS.EXAM_START_TIME
, USAS.EXAM_END_TIME
, INITCAP(TO_CHAR(USAS.FINAL_EXAM_DATE
, 'DAY') )
, USAS.LOCATION_CD
, USAS.LOCATION_DESC
, USAS.BUILDING_CODE
, USAS.BUILDING_DESC
, USAS.ROOM_CODE
, USAS.ROOM_DESC
, UTR. PERSON_NUMBER
, UTR.SURNAME
, USAS.CREATED_BY
, USAS.CREATION_DATE
, USAS.LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_AS_V USAS
, IGS_PS_UNIT_OFR_OPT_V UOOV
, IGS_PS_USEC_TCH_RESP_V UTR
WHERE USAS.UOO_ID = UOOV.UOO_ID
AND USAS.UOO_ID = UTR.UOO_ID
AND UTR.LEAD_INSTRUCTOR_FLAG = 'Y'

Columns

Name
ROW_ID
UNIT_CD
UNIT_CLASS
CALL_NUMBER
TITLE
UOO_ID
FINAL_EXAM_DATE
EXAM_START_TIME
EXAM_END_TIME
EXAM_DAY
LOCATION_CD
LOCATION_DESC
BUILDING_CODE
BUILDING_DESC
ROOM_CODE
ROOM_DESC
INSTRUCTOR_PERSON_NUMBER
INSTRUCTOR_SURNAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN