[Home] [Help]
View: IGS_PE_FUND_EXCL_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Person Hold Effect Fund Exclusion Details. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT E.ROWID ROW_ID
, E.FUND_EXCL_ID
, E.PERSON_ID
, E.ENCUMBRANCE_TYPE
, E.PEN_START_DT
, E.S_ENCMB_EFFECT_TYPE
, E.PEE_START_DT
, E.PEE_SEQUENCE_NUMBER
, E.FUND_CODE
, L.DESCRIPTION FUND_DESCRIPTION
, E.PFE_START_DT
, E.EXPIRY_DT
, E.CREATED_BY
, E.CREATION_DATE
, E.LAST_UPDATED_BY
, E.LAST_UPDATE_DATE
, E.LAST_UPDATE_LOGIN
FROM IGS_PE_FUND_EXCL E
, IGF_AW_FUND_CAT L
WHERE E.FUND_CODE = L.FUND_CODE
Columns
| Name |
| ROW_ID |
| 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 |