[Home] [Help]
View: IGSBV_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
, '_LA:EDE.S_ENCMB_EFFECT_TYPE:IGS_LOOKUP_VALUES:ENCMB_EFFECT_TYPE:MEANING'
, 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
WHERE EDE.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE WITH READ ONLY
Columns
Name |
HOLD_TYPE |
SYSTEM_HOLD_EFFECT_TYPE |
NOTES |
HOLD_TYPE_DESCRIPTION |
"_LA:SYS_HOLD_EFFECT_TYP_DESC" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |