[Home] [Help]
View: IGSBV_PR_STDNT_PRG_FUNDS
| Product: | IGS - Student System |
| Description: | Describes the financial aid fund the student will be excluded from when a student progression outcome is applied. |
| Implementation/DBA Data: |
APPS.IGSBV_PR_STDNT_PRG_FUNDS
|
View Text
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, FC.DESCRIPTION
, SPF.FUND_CODE
, SPF.PERSON_ID
, SPF.COURSE_CD
, SPF.SPO_SEQUENCE_NUMBER
, SPF.CREATED_BY
, SPF.CREATION_DATE
, SPF.LAST_UPDATED_BY
, SPF.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_FND SPF
, HZ_PARTIES HP
, IGF_AW_FUND_CAT_ALL FC
WHERE SPF.PERSON_ID = HP.PARTY_ID
AND SPF.FUND_CODE = FC.FUND_CODE WITH READ ONLY
Columns
| Name |
| PERSON_NAME |
| PERSON_NUMBER |
| FUND_DESCRIPTION |
| FUND_CODE |
| PERSON_ID |
| SPO_PROGRAM_CODE |
| SPO_SEQUENCE_NUMBER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |