[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 |