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_INST_WLST_OPT_V

Product:	IGS - Student System (Obsolete)
Description:	This view incorporates the waitlist options based on the calendar type, institution wait list allowed indicator so that appropriate wait list options are applied to a calendar instance.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT IWO.ROWID ROW_ID
, IWO.INST_WAITLIST_ID INST_WAITLIST_ID
, IWO.CAL_TYPE CAL_TYPE
, NULL SEQUENCE_NUMBER
, CT.DESCRIPTION
, NULL
, NULL
, NULL
, IWO.WAITLIST_ALWD WAITLIST_ALWD
, IWO.SMLNES_WAITLIST_ALWD SMLNES_WAITLIST_ALWD
, IWO.CREATED_BY CREATED_BY
, IWO.CREATION_DATE CREATION_DATE
, IWO.LAST_UPDATED_BY LAST_UPDATED_BY
, IWO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IWO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CT
, IGS_EN_INST_WLST_OPT IWO
WHERE IWO.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'

Columns

Name
ROW_ID
INST_WAITLIST_ID
CAL_TYPE
SEQUENCE_NUMBER
CAL_DESC
ALTERNATE_CD
START_DT
END_DT
WAITLIST_ALWD
SMLNES_WAITLIST_ALWD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN