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: IGSFV_HOLD_TYPE_DFLT_EFFECTS

Product:	IGS - Student System (Obsolete)
Description:	Describes the default effects that are applied to the associated hold type.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT EDE.ENCUMBRANCE_TYPE HOLD_TYPE
, EDE.S_ENCMB_EFFECT_TYPE SYSTEM_HOLD_EFFECT_TYPE
, EDE.COMMENTS NOTES
, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION
, ENT.S_ENCUMBRANCE_CAT SYSTEM_HOLD_CATEGORY
, '_LA:EDE.S_ENCMB_EFFECT_TYPE:IGS_LOOKUP_VALUES:ENCMB_EFFECT_TYPE:MEANING'
, ENE.APPLY_TO_COURSE_IND APPLY_TO_PROGRAM_INDICATOR
, EDE.CREATED_BY
, EDE.CREATION_DATE
, EDE.LAST_UPDATED_BY
, EDE.LAST_UPDATE_DATE
FROM IGS_FI_ENC_DFLT_EFT EDE
, IGS_FI_ENCMB_TYPE_ALL ENT
, IGS_EN_ENCMB_EFCTTYP ENE
WHERE EDE.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE
AND EDE.S_ENCMB_EFFECT_TYPE = ENE.S_ENCMB_EFFECT_TYPE WITH READ ONLY

Columns

Name
HOLD_TYPE
SYSTEM_HOLD_EFFECT_TYPE
NOTES
HOLD_TYPE_DESCRIPTION
SYSTEM_HOLD_CATEGORY
"_LA:SYS_HOLD_EFFECT_TYP_DESC"
APPLY_TO_PROGRAM_INDICATOR
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE