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_OR_UNIT_WLST_V

Product:	IGS - Student System (Obsolete)
Description:	This view incorporates the unit wait list priorities and unit wait list preferences.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT OUW.ROWID ROW_ID
, OUW.ORG_UNIT_WLST_ID ORG_UNIT_WLST_ID
, OUW.ORG_UNIT_CD ORG_UNIT_CD
, OUW.START_DT ORG_START_DT
, HP.PARTY_NAME DESCRIPTION
, OUW.CAL_TYPE CAL_TYPE
, NULL SEQUENCE_NUMBER
, CT.DESCRIPTION
, NULL WAITLIST_ALWD
, NULL MAX_WLST_PER_STUD
, OUW.MAX_STUD_PER_WLST MAX_STUD_PER_WLST
, OUW.SMTANUS_WLST_UNIT_ENR_ALWD SMTANUS_WLST_UNIT_ENR_ALWD
, OUW.ASSES_CHRG_FOR_WLST_STUD ASSES_CHRG_FOR_WLST_STUD
, OUW.CREATED_BY CREATED_BY
, OUW.CREATION_DATE CREATION_DATE
, OUW.LAST_UPDATED_BY LAST_UPDATED_BY
, OUW.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OUW.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OUW.CLOSED_FLAG CLOSED_FLAG
FROM IGS_CA_TYPE CT
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_EN_OR_UNIT_WLST OUW
WHERE OUW.CAL_TYPE = CT.CAL_TYPE
AND HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'O'
AND OUW.ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD
AND OUW.START_DT = IHP.OU_START_DT
AND CT.S_CAL_CAT = 'LOAD'

Columns

Name
ROW_ID
ORG_UNIT_WLST_ID
ORG_UNIT_CD
ORG_START_DT
DESCRIPTION
CAL_TYPE
SEQUENCE_NUMBER
CAL_DESC
WAITLIST_ALWD
MAX_WLST_PER_STUD
MAX_STUD_PER_WLST
SMTANUS_WLST_UNIT_ENR_ALWD
ASSES_CHRG_FOR_WLST_STUD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CLOSED_FLAG