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_TIMESLOT_REVW_V

Product:	IGS - Student System (Obsolete)
Description:	Review Timeslot Allocation
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TSR.ROWID ROW_ID
, TSR.PERSON_ID
, TSR.START_DT_TIME
, TSR.END_DT_TIME
, TSP.CAL_TYPE
, CT.DESCRIPTION CAL_TYPE_DESC
, TSP.TIMESLOT_CALENDAR
, TSP.TS_MODE
, LKUP.MEANING
FROM IGS_EN_TIMESLOT_RSLT TSR
, IGS_CA_TYPE CT
, IGS_EN_TIMESLOT_PARA TSP
, IGS_LOOKUPS_VIEW LKUP
WHERE TSP.IGS_EN_TIMESLOT_PARA_ID = TSR.IGS_EN_TIMESLOT_PARA_ID
AND TSP.CAL_TYPE = CT.CAL_TYPE
AND (TSP.TS_MODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'TIMESLOT_MODE')

Columns

Name
ROW_ID
PERSON_ID
START_DT_TIME
END_DT_TIME
CAL_TYPE
CAL_TYPE_DESC
TIMESLOT_CALENDAR
TS_MODE
MEANING