Florida Association for Institutional Research 2002 Conference

1
Florida Association for Institutional Research
2002 Conference

• Office of Student Financial Assistance(OSFA)
• State Student Financial Aid Database
• (SSFAD)

2
Agenda

• About OSFA
• Database Features Functions
• Database Reports

3
Florida Department of EducationOffice of Student
Financial Assistance

• State Programs
• 2000-2001 - 193,162 students 312,976,008
• 2001-2002 appropriation 365,284,042
• Federal Family Education Loan Program (FFELP)
• 2000-2001 volume 249,673 student/parent loan
  applications processed for a total volume of
  879,989,450
• 2001-2002 volume 316,337 student/parent loan
  applications processed for a total volume of
  1,357,099,474

4
State Scholarship and Grant Program
Administration

• Merit Programs
• - Florida Bright Futures Scholarship Program
• Need Programs
• - Florida Student Assistance Grants
• Special Interest Programs
• - Florida Resident Access Grant
• - State Workforce Shortage Areas

5
Financial Aid Sources Available to Florida
Residents

• Federal
• State
• Institutional
• Private

6
OSFA Partnerships with Postsecondary Education
Institutions
7
Postsecondary Institutions

• Approved for state financial aid participation
• Package all aid types to assist students defray
  the cost of education
• Disburse funds to students
• Report and reconcile on State funds

8
State Student Financial Aid Database

• 1997 - Legislative mandate
• 1998 - Stakeholder studies contract
  bids
• 1999 - Vendor selection/contract
• 2000 - Design and development
• 2001-02 - Implementation
• 2002-03 - Enhancements

9
SSFAD Highlights

• Online Florida Financial Aid Application
• Streamline process and student feedback
• Streamline Postsecondary link to State
• Comprehensive data for annual reports

10
SSFAD Hardware

• Sun Solaris 8 - E-1000
• 6 CPUs
• 4 G Memory
• 350 G Raid 5 Disk
• 2 Web Servers
• Dell Power Edge 4400
• 2 CPUs
• 33 G Raid 5 Disk
• OS - 2000 Advance Server IIS version 5
• currently used as a backup only
• servers are behind 2 (FIRN and DMS) firewalls
• Unlimited Volume Capabilities

11
SSFAD Details

• Oracle Database
• Oracle Developer 2000
• Web access via Internet Explorer or Netscape
• Number of Tables 184
• Number of Student Records 535,910
  (includes current year and previous 5 years)

12
Security Access for Web Users

• 4 User Types applicants, high schools,
  institutions, and other third-party certifiers
• Each user account allows access to screens
  specific to their user type only
• Security Access Levels
• range 0 (no access) through 5 (full access)
• reviewed quarterly by OSFA

13
Password Security

• System generates User ID and Password
  automatically for online applicants
• All other users are created and maintained by
  OSFA staff
• System uses Verisign for security encryption
• Users required to create own password upon first
  use

14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
Administrative Business Cycle Functions on the
State Student Financial Aid Database (SSFAD)

• Applications Jan - Aug
• Academic Year Allocations July - June
• Term Disbursements Aug and Jan
• Program Refunds April
• Collect Student Grade Hours May
• End of Year Reconciliation June
• Year End Reports Aug - Sept

24
Applications Communication

• Applications for 2002-03 Participation
• Over 79,000 applications received
• 77,724 student applications
• 1,538 professional applications
• Communication generated for all applicants

25
79,262 Applications fromDecember 1, 2001 - June
30, 2002
26
96,531 Letters Sent fromDecember 1, 2001 - June
30, 2002
27
Other Application Statistics Captured

• Awarded Applicants
• Ineligible Applications
• Incomplete Applications
• Eligible Applicants Not Awarded due to lack of
  funds
• Renewal Applications
• Breakdown of Applications by Program
• Also track
• Gender
• Race
• Education Level

28
Institution Eligibility Activities

• Track institution details
• type of facility,
• sector,
• term type,
• tuition fees,
• participation status active, inactive, not
  eligible,
• renewal status

29
Institution Demographics Screen
30
Allocations
31
Disbursement Activities

• Track program expenditures by term, month,
  annually, and in summary
• Produce reconciliation reports by program,
  institution, term, sector, annually, and in
  summary
• Late Report Tracking by institution and 5 year
  summaries

32
Disbursement Eligibility Reports
33
Term and EOY Reconciliation
34
Term and EOY Reconciliation(continued)
35
EOY Academic Review
36
End of Year Program Data
37
Interfaces

• Collaboration with multiple entities for
  electronic information
• Florida Standardized Test Score Repository
• Florida Dept of Veteran Affairs
• Financial Lenders
• Florida School Districts
• FASTER
• DOE Teacher Certification
• USDE ISIR
• Postsecondary Institutions

38
Websites

• State Student Financial Aid Database
• www.FloridaStudentFinancialAid.org

• Office of Student Financial Assistance
• www.myFloridaEducation.com/osfa
• Theresa Antworth
• OSFA State Programs Director
• theresa.antworth_at_fldoe.org