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. |
0 Comments