Financial_Aid_Award table

There is 1 record for each type of financial aid a student receives for an aid year (example of an aid year would be 0607 for the 200710, 200720, and 200730 terms). Columns include the type of financial aid, amount awarded for the academic year, and the amount paid for the academic year. For example, a simple selection like ‘select * from Financial_Aid_Award where pidm = 99835 and aidyr = 0405’ returns (not all columns shown):

AIDYRPIDMFUND_CODEAWARD_AMT_ACAD_YRAWARD_AMT_DATEAWARD_PAID_ACAD_YRAWARD_PAID_DATE

040599835BWCE936.00NULL936.00NULL

040599835CALC576.002004-09-22 576.002005-03-10

040599835PELL4050.002004-05-19 4050.002005-04-07

040599835SEOG250.002005-04-06 250.002004-11-04

To see the sums of financial aid per fund type for an aid year, use the vFinancial_Aid_Totals view in SQL Server. Example of a simple selection like ‘select * from vFinancial_Aid_Totals f where aidyr = '0405' order by fund_code’:

AIDYRFUND_CODEawardpaid

0405BGVE36478.0036478.00

0405BWAE4797.004797.00

0405BWBE193788.00193788.00

0405BWCE2802069.002802069.00

0405CALB1484453.001292114.00

0405CALC34056.0030024.00

0405CARE72897.0071097.00

0405CWWS50683.0093142.54

0405CWWSN65588.00111197.28

0405EOPS328325.00322034.00

0405EOPSWS38759.0031890.64

0405FWS303447.00303667.29

0405PELL9787608.008029473.00

0405SEOG283814.00270064.00

Oracle source: ReportsNet. FINANCIAL_AID_RPRAWRD, ReportsNet. FINANCIAL_AID_RPRAWRD_BOGG views

Oracle objects: RPRAWRD– non-BOGG

sfbetrm, stvterm, SPRIDEN, spbpers– BOGG

This table is a union of non-BOGG type financial aid records (from RPRAWRD) and BOGG type financial aid records.

Updated: nightly

Oracle Field/Calc	DW Field	Description or Sample
Non-Bogg: RPRAWRD_AIDY_CODE Bogg: substr(trim(to_char( substr(stvterm.STVTERM_ACYR_CODE,3,2)-1, '09') \|\| substr(stvterm.STVTERM_ACYR_CODE,3,2)),1,4)	AIDYR	2 digit year of Fall term + 2 digit year of academic year (0607 for 2007 academic year)
Non-Bogg: RPRAWRD_PIDM Bogg: sfbetrm.SFBETRM_PIDM	PIDM	Up to 10-digit unique Banner id for student
Spriden.Spriden_id	STUDENTID	Banner Id (@12345678)
Non-Bogg: FUND_CODE Bogg: substr(NVL(f_bogg_code (SFBETRM_PIDM, SFBETRM_TERM_CODE, 'BOGW'),null),1,6)	FUND_CODE	Type of Aid: Non-BOGG (from RFRBASE): ACG1: Academic Competitive Grant 1 ACG2: Academic Competitive Grant 2 ARNETT: Arnett Loan Program BOGW: BOG Waiver CALB: Cal Grant B CALC: Cal Grant C CARE: EOPS CARE CHAFEE: Chafee Grant CHILDG: Child Developmnt Grant CRAIG:Craig Loan Program CWWS: Cal Works Work Study CWWSN: CalWorks Wk-Study NonNeedBased EOPS: Extended Opportunity Grant EOPSWS: Extended Oppor. WorkStudy FWS: Federal Work Study LEPD: Law Enforcement Pers Gnt PELL: Federal Pell Grant SEOG: Supplemental Opp Grant STAF: Subsidized Stafford Loan BOGG (from TBRACCD): BWAE: Bog Waiver A Enrollment BWBE: Bog Waiver B Enrollment Fee BWCE: Bog Waiver C Enrollment BGVE: BOG VA Enrollment Fee
Non-Bogg: RPRAWRD_ACCEPT_AMT Bogg: sum(ABS(f_term_BOGG_payments (SFBETRM_PIDM,SFBETRM_TERM_CODE, f_bogg_code (SFBETRM_PIDM, SFBETRM_TERM_CODE, 'BOGW'))))	AWARD_AMT_ACAD_YR	Aid awarded to student for academic year (3 terms)
RPRAWRD_ACCEPT_DATE	AWARD_AMT_DATE
Non-Bogg: RPRAWRD_PAID_AMT Bogg: sum(ABS(f_term_BOGG_payments (SFBETRM_PIDM,SFBETRM_TERM_CODE, f_bogg_code (SFBETRM_PIDM, SFBETRM_TERM_CODE, 'BOGW'))))	AWARD_PAID_ACAD_YR	Aid paid to student for academic year
RPRAWRD_PAID_DATE	AWARD_PAID_DATE
RORSTAT_PRI_SAR_PGI	EST_FAM_CONTR_AIDYR	Estimated Family Income for the aid year. If null, the application for financial aid was either invalid or rejected. This value Is repeated for each row of the student for each aid year.