FA_GROUP_BY_AIDY column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Group by Aidy table

(dwngss_pf.fa_group_by_aidy)

Explanation

Grouping of financial aid and student data for a given financial aid applicant per aid year.

Source

The warehouse Financial Aid Group by Aidy (dwngss_pf.fa_group_by_aidy) table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are FAISMGR_RORSTAT, FAISMGR_RTVAPRD, FAISMGR_ROBUSDF, FAISMGR_RRRAREQ, SATURN_SGBSTDN, SATURN_STVTERM, SATURN_SARAPPD, and SATURN_SARADAP.

Common Uses

• Understanding the different types of students/financial aid applicants are particiating in a given aid year. This table allows for grouping be specific characteristics ranging from curriculum information, enrollment information, document information, financial aid characteristics etc.

Cautions and notes

• This table is based on aid year. If you join to another table that is based on periods or term codes, you may end up dupilicating some of your results. Make sure to check how the other tables are set up and how you may need to group things in your query.

FA_GROUP_BY_AIDY column definitions . Pennant Financial Aid Home . Data Warehouse Home