DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-fsa
education-data-source-fsa
VerifiedFSA — Title IV aid at institution level (~5,500 institutions, 1999-2021). Pell Grants, Direct/PLUS loans, campus-based aid, financial responsibility scores, 90/10 metrics. Use for aid distribution, loan volume, or for-profit analysis. By unitid.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 19.7 KB |
| references/90-10-rule.md | markdown | 14.4 KB |
| references/data-quality.md | markdown | 15.4 KB |
| references/financial-responsibility.md | markdown | 15.8 KB |
| references/title-iv-programs.md | markdown | 14.6 KB |
| references/variable-definitions.md | markdown | 24.2 KB |
references/title-iv-programs.md
View on GitHub# Title IV Federal Student Aid Programs
Comprehensive reference for federal student aid programs authorized under Title IV of the Higher Education Act (HEA) of 1965, as amended.
## Contents
- [Overview](#overview)
- [Federal Pell Grant Program](#federal-pell-grant-program)
- [William D. Ford Federal Direct Loan Program](#william-d-ford-federal-direct-loan-program)
- [Campus-Based Programs](#campus-based-programs)
- [Program Comparison](#program-comparison)
- [Eligibility Requirements](#eligibility-requirements)
## Overview
Title IV programs are the largest source of federal student aid, providing grants, loans, and work-study funds to eligible students attending participating postsecondary institutions. The Department of Education's Office of Federal Student Aid (FSA) administers these programs.
### Title IV Program Categories
| Category | Programs | Funding Mechanism |
|----------|----------|-------------------|
| Grant Programs | Pell Grant, FSEOG, TEACH Grant, Iraq/Afghanistan Service Grant | Direct appropriation |
| Loan Programs | Direct Subsidized, Direct Unsubsidized, Parent PLUS, Grad PLUS | Federal lending |
| Campus-Based | Federal Work-Study, FSEOG, Perkins (discontinued) | Institutional allocation |
### Key Legislative Authority
- Higher Education Act of 1965 (HEA), Title IV
- FAFSA Simplification Act (part of Consolidated Appropriations Act, 2021)
- Student Aid Index (SAI) replaced Expected Family Contribution (EFC) in 2024-25
- One Big Beautiful Bill Act (P.L. 119-21, July 4, 2025): loan-limit and Grad PLUS changes effective July 1, 2026
## Federal Pell Grant Program
The largest federal grant program providing need-based aid to undergraduate students.
### Program Characteristics
| Attribute | Description |
|-----------|-------------|
| **Type** | Need-based grant (does not require repayment) |
| **Eligibility** | Undergraduate students with demonstrated financial need |
| **Maximum Award (2025-26 and 2026-27)** | $7,395 (2026-27 per GEN-26-01, updated Feb. 18, 2026; minimum $740; Pell barred at SAI ≥ $14,790 except under the Special Rule) |
| **Minimum Award (2025-26)** | $740 (10% of maximum, rounded to nearest $5) |
| **Lifetime Eligibility** | 12 full-time semesters (600% Lifetime Eligibility Used) |
| **Portability** | Follows student to any Title IV institution |
### Pell Grant Calculation
The Pell Grant Scheduled Award depends on:
1. **Student Aid Index (SAI)**: Measure of family financial strength
2. **Cost of Attendance (COA)**: Institutional cost for full academic year
3. **Enrollment Intensity**: Full-time, 3/4-time, half-time, or less-than-half-time
4. **Academic Year Structure**: Semesters, quarters, clock hours
**SAI ceiling for an SAI-calculated Pell (2025-26)**: about $6,655 (derived: $7,395 max − $740 min; ED does not publish this as a fixed cutoff, and students may still qualify for Min Pell)
### Pell Grant Award Calculation Table
| Enrollment Status | Percentage of Scheduled Award |
|-------------------|-------------------------------|
| Full-time (12+ credits) | 100% |
| Three-quarter time (9-11 credits) | 75% |
| Half-time (6-8 credits) | 50% |
| Less than half-time (<6 credits) | 25-50% (varies) |
### Special Pell Provisions
- **Year-Round Pell**: Students may receive up to 150% of scheduled award in one award year
- **Maximum Pell eligibility**: determined from tax-filing status, family size and composition, federal poverty guidelines, and state of residence; SAI is not used
- **Minimum Pell eligibility**: also determined from tax-filing status, family size and composition, federal poverty guidelines, and state of residence (GEN-25-02); a student ineligible for an SAI-calculated Pell may still receive Min Pell
### FSA Data Variables for Pell Grants
In the Portal dataset `fsa/colleges_fsa_grants`, Pell Grant data is accessed by filtering `grant_type == 4`:
| Variable | Description |
|----------|-------------|
| `grant_type` | Set to `4` for Federal Pell Grant |
| `grant_recipients_unitid` | Number of grant recipients (by unit ID) |
| `value_grants_disbursed_unitid` | Total grant disbursements ($, by unit ID) |
| `grant_recipients_opeid` | Number of grant recipients (by OPEID) |
| `value_grants_disbursed_opeid` | Total grant disbursements ($, by OPEID) |
> **Note:** The Portal uses generic column names with a `grant_type` code to differentiate programs. There are no Pell-specific column names like `pell_recipients`.
## William D. Ford Federal Direct Loan Program
The federal government is the direct lender for all loans in this program.
### Direct Subsidized Loans
| Attribute | Description |
|-----------|-------------|
| **Type** | Need-based loan with interest subsidy |
| **Eligibility** | Undergraduate students with financial need |
| **Interest Subsidy** | Government pays interest while in school, grace period, and deferment |
| **Interest Rate (2025-26)** | 6.39% (fixed) |
| **Origination Fee** | 1.057% (loans made on or after Oct. 1, 2020; statutory 1% plus sequestration, CRS IF13147) |
**Annual Limits by Grade Level:**
| Grade Level | Annual Limit |
|-------------|--------------|
| Freshman (0-29 credits) | $3,500 |
| Sophomore (30-59 credits) | $4,500 |
| Junior/Senior (60+ credits) | $5,500 |
**Aggregate Limit**: $23,000 (subsidized only)
### Direct Unsubsidized Loans
| Attribute | Description |
|-----------|-------------|
| **Type** | Non-need-based loan |
| **Eligibility** | All enrolled students (undergrad, grad, professional) |
| **Interest Subsidy** | None - interest accrues from disbursement |
| **Interest Rate - Undergrad (2025-26)** | 6.39% (fixed) |
| **Interest Rate - Graduate (2025-26)** | 7.94% (fixed) |
| **Origination Fee** | 1.057% (loans made on or after Oct. 1, 2020; statutory 1% plus sequestration, CRS IF13147) |
**Annual Limits (Dependent Undergraduates):**
| Grade Level | Subsidized | Unsubsidized | Total |
|-------------|------------|--------------|-------|
| Freshman | $3,500 | $2,000 | $5,500 |
| Sophomore | $4,500 | $2,000 | $6,500 |
| Junior/Senior | $5,500 | $2,000 | $7,500 |
**Annual Limits (Independent Undergraduates):**
| Grade Level | Subsidized | Additional Unsub | Total |
|-------------|------------|------------------|-------|
| Freshman | $3,500 | $6,000 | $9,500 |
| Sophomore | $4,500 | $6,000 | $10,500 |
| Junior/Senior | $5,500 | $7,000 | $12,500 |
**Graduate/Professional Student Limits:**
- Annual: $20,500 (all unsubsidized)
- Aggregate: $138,500 (includes undergraduate borrowing)
### Direct PLUS Loans
| Attribute | Parent PLUS | Graduate/Professional PLUS |
|-----------|-------------|---------------------------|
| **Borrower** | Parent of dependent undergraduate | Graduate/professional student |
| **Credit Check** | Required | Required |
| **Interest Rate (2025-26)** | 8.94% (fixed) | 8.94% (fixed) |
| **Origination Fee** | 4.228% (loans made on or after Oct. 1, 2020; statutory 4% plus sequestration, CRS IF13147) | 4.228% (same basis) |
| **Annual Limit** | Cost of attendance minus other aid | Cost of attendance minus other aid |
| **Aggregate Limit** | None | None |
> **Changed July 1, 2026 (P.L. 119-21):** New Grad PLUS loans ended for periods of enrollment beginning on or after July 1, 2026 (grandfathering for students enrolled in a program as of June 30, 2026 who had a Direct Loan for it). Parent PLUS is capped at $20,000/year and $65,000 aggregate per dependent student. Graduate Unsubsidized annual limit is $20,500 ($50,000 for professional programs). The $138,500 aggregate applies only to enrollment periods beginning before July 1, 2026. Values above describe 2025-26 and earlier.
**Credit Requirements:**
- No adverse credit history (90+ day delinquency, bankruptcy, foreclosure, etc.)
- Endorser option if borrower has adverse credit
- Credit counseling required if approved despite adverse credit
### FSA Data Variables for Loans
In the Portal dataset `fsa/colleges_fsa_loans`, loan data is accessed by filtering `loan_type`:
| `loan_type` Code | Loan Type | Key Columns |
|------------------|-----------|-------------|
| `1` | Subsidized Direct Loan - Undergraduate | `loan_recipients_unitid`, `value_loan_disbursements_unitid` |
| `4` | Unsubsidized Direct Loan - Undergraduate | Same generic columns |
| `7` | Direct Loan, Parent PLUS | Same generic columns |
| `8` | Direct Loan, Grad PLUS | Same generic columns |
> **Note:** The Portal uses generic column names with a `loan_type` code to differentiate programs. There are no loan-specific column names like `dl_sub_recipients`. See `variable-definitions.md` for all 14 loan type codes.
## Campus-Based Programs
These programs provide funds directly to institutions, which then award aid to eligible students.
### Federal Supplemental Educational Opportunity Grant (FSEOG)
| Attribute | Description |
|-----------|-------------|
| **Type** | Need-based grant |
| **Eligibility** | Undergraduates with exceptional financial need (Pell-first priority) |
| **Award Range** | $100 to $4,000 per full academic year ($4,400 for credit-approved study abroad whose reasonable costs exceed the home institution's cost of attendance; 34 CFR 676.20(c)) |
| **Funding** | Limited institutional allocation |
| **Matching** | Non-federal share of at least 25% (federal share ≤ 75%); 100% federal share on request for institutions designated eligible under the Developing Hispanic-Serving Institutions, Strengthening Institutions, American Indian Tribally Controlled Colleges and Universities, Alaska Native and Native Hawaiian-Serving Institutions, or Strengthening Historically Black Colleges and Universities programs (34 CFR 676.21(b)) |
**Priority**: Schools must award FSEOG first to students with lowest SAI who are Pell-eligible.
### Federal Work-Study (FWS)
| Attribute | Description |
|-----------|-------------|
| **Type** | Employment program |
| **Eligibility** | Students with financial need |
| **Earnings** | At least federal minimum wage |
| **Hours** | Vary; cannot exceed student's financial need |
| **Matching** | 25% employer match (some exceptions) |
**Employment Types:**
- On-campus employment
- Off-campus community service positions
- Off-campus employment with federal, state, or local agencies
- Literacy tutoring
- America Reads/America Counts
**Special Requirements:**
- At least 7% of the FWS federal allocation must pay students in community service jobs, including at least one student employed as a reading tutor or in a family literacy project (34 CFR 675.18(g))
### Federal Perkins Loan (Discontinued)
| Attribute | Description |
|-----------|-------------|
| **Type** | Need-based, campus-based loan |
| **Status** | No new loans after September 30, 2017; final disbursements permitted through June 30, 2018, so Portal campus-based `year`=2017 (2017-18) can still contain Perkins disbursements |
| **Interest Rate** | 5% (fixed) |
| **Annual Limit (was)** | $5,500 undergrad / $8,000 grad |
| **Current Status** | Wind-down and servicing only |
**Note**: While no new Perkins Loans can be made, institutions continue to collect on outstanding loans and FSA data may include historical Perkins data.
### FSA Data Variables for Campus-Based Programs
In the Portal dataset `fsa/colleges_fsa_campus_based_volume`, campus-based data is accessed by filtering `award_type`:
| `award_type` Code | Award Type | Key Columns |
|-------------------|------------|-------------|
| `1` | FSEOG | `campus_award_recipients_unitid`, `value_campus_disbursed_unitid`, `campus_award_fed_contr_unitid` |
| `2` | Federal Work-Study | Same generic columns |
| `3` | Perkins Loans (discontinued) | Same generic columns |
> **Note:** The Portal uses generic column names with an `award_type` code to differentiate programs. There are no program-specific column names like `fws_recipients`. See `variable-definitions.md` for the complete column list.
## Program Comparison
### Grant Programs
| Program | Need-Based | Max Amount | Repayment |
|---------|------------|------------|-----------|
| Federal Pell Grant | Yes | $7,395 | No |
| FSEOG | Yes (exceptional) | $4,000 | No |
| TEACH Grant | Service-based | $4,000 | Converts to loan if service not completed |
### Loan Programs
| Program | Need-Based | Interest Rate (2025-26) | Interest Subsidy |
|---------|------------|------------------------|------------------|
| Direct Subsidized | Yes | 6.39% | Yes (in school/grace/deferment) |
| Direct Unsubsidized | No | 6.39% (UG) / 7.94% (Grad) | No |
| Parent PLUS | No (credit-based) | 8.94% | No |
| Grad PLUS | No (credit-based) | 8.94% | No |
### Historical Loan Interest Rates
| Loan Type | 2020-21 | 2021-22 | 2022-23 | 2023-24 | 2024-25 | 2025-26 |
|-----------|---------|---------|---------|---------|---------|---------|
| Direct Subsidized/Unsub (UG) | 2.75% | 3.73% | 4.99% | 5.50% | 6.53% | 6.39% |
| Direct Unsubsidized (Grad) | 4.30% | 5.28% | 6.54% | 7.05% | 8.08% | 7.94% |
| PLUS (Parent/Grad) | 5.30% | 6.28% | 7.54% | 8.05% | 9.08% | 8.94% |
2026-27 (first disbursed 7/1/2026-6/30/2027): 6.52% UG, 8.07% Grad Unsub, 9.07% PLUS (FSA EA, June 4, 2026).
## Eligibility Requirements
### General Title IV Eligibility (Students)
All Title IV programs require students to:
1. Be a U.S. citizen, national, or eligible noncitizen
2. Have a valid Social Security number
3. Be enrolled in an eligible program at a participating school
4. Maintain satisfactory academic progress (SAP)
5. Not be in default on federal student loans
6. Not owe a refund on federal grants
7. Complete the FAFSA annually
(Selective Service registration is no longer required; removed by the FAFSA Simplification Act, effective 2021-22)
### Institutional Participation Requirements
To participate in Title IV programs, institutions must:
1. Be accredited by a recognized accrediting agency
2. Be authorized to operate by the state
3. Sign a Program Participation Agreement (PPA) with ED
4. Demonstrate administrative capability
5. Demonstrate financial responsibility
6. Meet program-specific requirements
### Program-Specific Eligibility
| Program | Additional Requirements |
|---------|------------------------|
| Pell Grant | Undergraduate only; no prior bachelor's degree; Max/Min Pell eligibility (tax filing, family size, poverty guidelines, state) or an SAI-calculated award at least the minimum (GEN-25-02) |
| Direct Subsidized | Undergraduate only; demonstrated financial need |
| Direct Unsubsidized | No additional need requirement |
| Parent PLUS | Parent of dependent undergrad; no adverse credit history |
| Grad PLUS | Graduate/professional student; no adverse credit history; no new loans for enrollment periods beginning on or after July 1, 2026, except grandfathered students (P.L. 119-21) |
| FSEOG | Exceptional financial need; Pell-eligible priority |
| FWS | Demonstrated financial need; U.S. citizen/eligible noncitizen |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |