Quick Reference Guide DM - STU Financial Aid Term

AITS – Decision Support

University Administration

Financial Aid Data Marts

Quick Reference Guide
DM - STU – Financial Aid Term

DM - STU – Financial Aid Year

Who should use this Universe?

Functional Offices, Academic Colleges and Departments interested in analyzing student financial aid awards by term or year for awards to students or by fund with dollar amounts.

What types of questions can I answer in this universe?

How much aid was distributed to students?
What types of aid were distributed to students?
How many students received Federal vs. State aid?
Who received a tuition waiver?

Universe Description

The Financial Aid TERM and YEAR Data Marts contains information related to Student Financial Aids including funds, awards, and SAP (Satisfactory Academic Progress). In addition this offers limited general student information and registration information for each student who has applied for aid by term or year.

The level of detail (i.e. grain) included in these data marts is that each individual award to each student per year (or term) has a separate record in the data mart. These separate data sets are provided to allow for reporting at either the year or term level.

With the three campus FAOs approval the Year and Term data marts are now loaded weekly on Monday’s. The first weekly load occurred on Monday, January 2011.

Data included in this Universe

This universe includes information on aid recipients by student name, UIN, address, curriclula (campus, college, department, program), registered hours, Satisfactory Academic Progress (SAP), fund characteristics and awards by fund and student.
Specific data elements include: Student Residency/Type/Level/Program, SAP, Fund Code/Type, Amounts by student and fund (i.e., Offered, Accepted, Declined, Paid).
Security can be applied to only allow users to access information on aid recipients from their own Campus, College, or Department. In addition, selected users can be given access that includes all Campuses.
Student Needs Analysis is granted at different levels depending upon your access (i.e. No Needs Analysis information, Only Y/N indicators for Gross/Unmet need, Actual dollar amounts for Gross/Unmet need, Budget/Resource/Contribution dollar amounts)

Report Creation Tips

You must always specify a Term or Academic Year in your reports or you will receive “extra” data that you may not need in your report.