Product: | IGF - Financial Aid |
---|---|
Description: | Full View for Entity that holds the cost of attendance amount, Pell amount, alternative Pell amount for each item, student in an award year |
Implementation/DBA Data: | APPS.IGFFV_STUDENT_COA |
SELECT COAI.ITEM_CODE
, COAI.AMOUNT
, COAI.PELL_COA_AMOUNT
, COAI.ALT_PELL_AMOUNT
, '_LA:COAI.FIXED_COST:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:COAI.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, AWITEM.DESCRIPTION
, COAI.BASE_ID
, COAI.CREATED_BY
, COAI.CREATION_DATE
, COAI.LAST_UPDATED_BY
, COAI.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AW_COA_ITEMS COAI
, IGF_AW_ITEM AWITEM
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE AWITEM.ITEM_CODE = COAI.ITEM_CODE
AND COAI.BASE_ID = BASE.BASE_ID
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY