[Home] [Help]
View: IGSFV_PERSON_FUND_EXCL
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Person Hold Effect Fund Exclusion Details Full Business View |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FE.FUND_EXCL_ID
, FE.PERSON_ID
, FE.ENCUMBRANCE_TYPE
, FE.PEN_START_DT
, FE.S_ENCMB_EFFECT_TYPE
, FE.PEE_START_DT
, FE.PEE_SEQUENCE_NUMBER
, FE.FUND_CODE
, L.DESCRIPTION FUND_DESCRIPTION
, FE.PFE_START_DT
, FE.EXPIRY_DT
, FE.CREATED_BY
, FE.CREATION_DATE
, FE.LAST_UPDATED_BY
, FE.LAST_UPDATE_DATE
, FE.LAST_UPDATE_LOGIN
FROM IGS_PE_FUND_EXCL FE
, IGF_AW_FUND_CAT L
WHERE FE.FUND_CODE = L.FUND_CODE WITH READ ONLY
Columns
| Name |
| FUND_EXCL_ID |
| PERSON_ID |
| ENCUMBRANCE_TYPE |
| PEN_START_DT |
| S_ENCMB_EFFECT_TYPE |
| PEE_START_DT |
| PEE_SEQUENCE_NUMBER |
| FUND_CODE |
| FUND_DESCRIPTION |
| PFE_START_DT |
| EXPIRY_DT |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |