eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGFFV_STUDENT_BASE_RECORDS

Product:	IGF - Financial Aid (Obsolete)
Description:	Full View for the Entity that holds the summarized information of all the financial aid processes for a student for an academic year
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BASE.EFC_F
, BASE.EFC_I
, BASE.NEED_F
, BASE.NEED_I
, '_LA:BASE.VERIFICATION_PROCESS_RUN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, BASE.INST_VERIF_STATUS_DATE
, '_LA:BASE.FED_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_FED_VERIFY_STATUS:MEANING'
, BASE.FED_VERIF_STATUS_DATE
, '_LA:BASE.INST_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_INST_VERIFY_STATUS:MEANING'
, BASE.NSLDS_ELIGIBLE
, BASE.EDE_CORRECTION_BATCH_ID
, BASE.FA_PROCESS_STATUS_DATE
, '_LA:BASE.ISIR_CORR_STATUS:IGF_LOOKUPS_VIEW:IGF_CORR_STATUS:MEANING'
, BASE.ISIR_CORR_STATUS_DATE
, '_LA:BASE.ISIR_STATUS:IGF_LOOKUPS_VIEW:IGF_ISIR_STATUS:MEANING'
, BASE.ISIR_STATUS_DATE
, BASE.PROFILE_STATUS
, BASE.PROFILE_STATUS_DATE
, BASE.PROFILE_FC
, BASE.COA_FIXED
, BASE.COA_F
, BASE.COA_I
, BASE.COA_PELL
, BASE.DISBURSEMENT_HOLD
, '_LA:BASE.FA_PROCESS_STATUS:IGF_LOOKUPS_VIEW:IGF_AAP_PROCESS_STATUS:MEANING'
, '_LA:BASE.NOTIFICATION_STATUS:IGF_LOOKUPS_VIEW:IGF_AW_NOTIFIC_STAT:MEANING'
, BASE.NOTIFICATION_STATUS_DATE
, '_LA:BASE.NSLDS_DATA_OVERRIDE_FLG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:BASE.PACKAGING_STATUS:IGF_LOOKUPS_VIEW:IGF_PACKAGING_STATUS:MEANING'
, BASE.PACKAGING_STATUS_DATE
, BASE.PAYMENT_ISIR_ID
, BASE.TARGET_GROUP
, BASE.TOTAL_PACKAGE_ACCEPTED
, BASE.TOTAL_PACKAGE_OFFERED
, BASE.TOLERANCE_AMOUNT
, '_LA:BASE.MANUAL_DISB_HOLD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, BASE.PELL_ALT_EXPENSE
, BASE.ASSOC_ORG_NUM
, '_LA:BASE.AWARD_FMLY_CONTRIBUTION_TYPE:IGF_LOOKUPS_VIEW: IGF_AP_ENROLLMENT_STATUS_TYPE:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, '_DF:IGF:IGF_AP_FA_BASE_REC_ALL_FLEX:BASE'
, BASE.CI_CAL_TYPE
, BASE.CI_SEQUENCE_NUMBER
, BASE.PERSON_ID
, BASE.BASE_ID
, BASE.CREATED_BY
, BASE.CREATION_DATE
, BASE.LAST_UPDATED_BY
, BASE.LAST_UPDATE_DATE
FROM IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE 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

Columns

Name
FEDERAL_EFC_AMOUNT
INSTITUTIONAL_EFC_AMOUNT
FEDERAL_NEED_AMOUNT
INSTITUTIONAL_NEED_AMOUNT
"_LA:VERIFICATION_PROCESS_RUN"
INST_VERIFICATION_STATUS_DATE
"_LA:FEDERAL_VERIF_STATUS"
FEDERAL_VERIF_STATUS_DATE
"_LA:INSTITUTION_VERIF_STATUS"
NSLDS_ELIGIBLE_FLAG
EDE_CORRECTION_BATCH_ID
FA_PROCESS_STATUS_DATE
"_LA:ISIR_CORRECTION_STATUS"
ISIR_CORRECTION_STATUS_DATE
"_LA:ISIR_STATUS"
ISIR_STATUS_DATE
PROFILE_STATUS
PROFILE_STATUS_DATE
PROFILE_FAMILY_CONTRIBUTION
COA_FIXED_AMOUNT
COA_FEDERAL_AMOUNT
COA_INSTITUTIONAL_AMOUNT
COA_PELL_AMOUNT
DISBURSEMENT_HOLD
"_LA:FA_PROCESS_STATUS"
"_LA:NOTIFICATION_STATUS"
NOTIFICATION_STATUS_DATE
"_LA:NSLDS_DATA_OVERRIDE_FLAG"
"_LA:PACKAGING_STATUS"
PACKAGING_STATUS_DATE
PAYMENT_ISIR_ID
TARGET_GROUP
TOTAL_PACKAGE_ACCEPTED_AMOUNT
TOTAL_PACKAGE_OFFERED_AMOUNT
TOLERANCE_AMOUNT
"_LA:MANUAL_DISBURSEMENT_HOLD"
PELL_ALTERNATE_EXPENSE
ASSOCIATED_ORGANIZATION_UNIT
"_LA:AWARD_FMLY_CONTRIB_TYPE"
PERSON_NUMBER
PERSON_NAME
AWARD_YEAR
AWARD_YEAR_DESCRIPTION
"_DF"
AWARD_YEAR_CALENDAR_TYPE
AWARD_YEAR_CAL_SEQ_NUMBER
PERSON_IDENTIFIER
BASE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE