Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-fsa

education-data-source-fsa

Verified

FSA — 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.

references/90-10-rule.md

View on GitHub
# The 90/10 Rule for Proprietary Institutions

Reference for the federal requirement that for-profit (proprietary) institutions derive a portion of their revenue from non-federal sources.

## Contents

- [Overview](#overview)
- [Rule Requirements](#rule-requirements)
- [Revenue Classification](#revenue-classification)
- [Calculation Methodology](#calculation-methodology)
- [Compliance and Consequences](#compliance-and-consequences)
- [Legislative History](#legislative-history)
- [FSA Data Variables](#fsa-data-variables)

## Overview

The 90/10 rule is a federal requirement that proprietary (for-profit) institutions of higher education must derive at least 10% of their revenue from sources other than Title IV federal student aid. CRS R46773 calls market viability "a key rationale behind enactment of the original 85/15 rule" (see Purpose below).

### Purpose (as described by CRS R46773)

Proponents of the original 85/15 rule believed it would "stem abuse and might restore some healthy market-based incentives", because proprietary institutions "would no longer be able to set prices at a level that might be beyond the reach of students not fully supported by federal financial aid"; they also argued that an institution of sufficient quality should be able to attract a specific percentage of revenues from non-Title IV programs. Market viability was "a key rationale behind enactment of the original 85/15 rule". Other purposes sometimes attributed to it (taxpayer protection, early warning) are not sourced here.

### Applicability

| Institution Type | Subject to 90/10? |
|------------------|-------------------|
| Proprietary (for-profit) | Yes |
| Private nonprofit | No |
| Public institutions | No |

### Regulatory Authority

- Section 487(a)(24) of the Higher Education Act
- 34 CFR 668.28 - Non-Federal revenue (90/10)
- American Rescue Plan Act of 2021 (modified to include military benefits)

## Rule Requirements

### Basic Requirement

Proprietary institutions must derive **at least 10%** of revenue from sources other than Title IV federal student aid.

Stated differently: No more than **90%** of revenue may come from Title IV programs.

### Calculation Period

- Calculated on a fiscal year basis
- Reported annually to the Department of Education
- Based on institutional fiscal year (not award year)

### Current Standard (fiscal years beginning on or after January 1, 2023; no Portal year uses it)

Following the American Rescue Plan Act modifications:

| Revenue Source | Counted As |
|----------------|------------|
| Title IV (Pell, Direct Loans, etc.) | Federal (numerator) |
| VA education benefits (GI Bill) | Federal (numerator) |
| DoD Tuition Assistance | Federal (numerator) |
| Other federal education funds | Federal (numerator) |
| Cash payments from students | Non-federal |
| Private loans | Non-federal |
| Employer tuition reimbursement | Non-federal |
| State grants | Non-federal |
| Institutional scholarships | Non-federal |

### Formula

```
Title IV Percentage = (Title IV Revenue / Total Revenue) × 100
```

**Compliance Threshold**: Title IV Percentage ≤ 90%

## Revenue Classification

### Title IV Revenue (Federal - Counts Toward 90%)

| Program | Classification |
|---------|----------------|
| Federal Pell Grant | Title IV |
| Direct Subsidized Loans | Title IV |
| Direct Unsubsidized Loans | Title IV |
| Parent PLUS Loans | Title IV |
| Graduate PLUS Loans | Title IV |
| FSEOG | Title IV |
| Federal Work-Study | Title IV only if credited to the student's account; FWS wages paid directly to the student are excluded |
| TEACH Grant | Title IV |
| Iraq/Afghanistan Service Grant | Title IV |

### Other Federal Revenue (fiscal years beginning on or after January 1, 2023)

The American Rescue Plan Act of 2021 expanded "federal" to include:

| Program | Classification (FYs beginning on or after Jan 1, 2023) |
|---------|---------------------------|
| Post-9/11 GI Bill (Chapter 33) | Federal |
| Montgomery GI Bill | Federal |
| Vocational Rehabilitation (Chapter 31) | Federal |
| DoD Tuition Assistance | Federal |
| Other federal education assistance | Federal |

### Non-Federal Revenue (Counts Toward 10%)

| Source | Classification |
|--------|----------------|
| Student cash payments | Non-federal |
| Private educational loans | Non-federal |
| Institutional scholarships/grants | Non-federal |
| State grant aid | Non-federal |
| Employer-paid tuition | Non-federal |
| Third-party payments (non-government) | Non-federal |

### Revenue Exclusions

Certain items are excluded from the calculation entirely:

| Exclusion (34 CFR 668.28(a)(6)) |
|---|
| FWS wages paid directly to students |
| LEAP/SLEAP/GAP funds from a State |
| Institutional matching funds for federal aid |
| Federal funds refunded or returned (e.g., R2T4) |
| Books/supplies/equipment charges not billed as institutional charges |
| Proceeds from factoring/sale of receivables or institutional loans |
| Proceeds from sale of income share/financing agreements |
| Funds from third parties related to the institution |

Revenue from non-Title IV-eligible programs **may** count as non-federal revenue if the program meets 668.28(a)(3)(iii).

## Calculation Methodology

### Step-by-Step Process

1. **Identify fiscal year**: Institution's fiscal year end
2. **Calculate total revenue**: All revenue from Title IV-eligible programs
3. **Calculate Title IV revenue**: Federal student aid disbursed
4. **Apply formula**: Title IV / Total = Percentage
5. **Compare to threshold**: Must be ≤ 90%

### Example Calculation

| Revenue Source | Amount | Classification |
|----------------|--------|----------------|
| Pell Grants | $5,000,000 | Title IV |
| Direct Loans (net of refunds) | $8,000,000 | Title IV |
| Student cash payments | $1,500,000 | Non-federal |
| Private loans | $500,000 | Non-federal |
| **Total Revenue** | **$15,000,000** | |
| **Title IV Revenue** | **$13,000,000** | |
| **Title IV Percentage** | **86.7%** | Compliant (< 90%) |

### Adjustments and Timing

- Revenue recognized when educational services provided
- Loan disbursements count when funds received
- R2T4 (Return of Title IV) reduces Title IV revenue
- Multi-location institutions: calculated at institutional level

## Compliance and Consequences

### Monitoring

- Institutions self-report 90/10 percentages annually
- Department reviews as part of program review
- Auditors verify calculations
- Data published in FSA Data Center

### Warning Threshold

| Percentage | Analyst heuristic (not a regulatory category) |
|------------|--------|
| ≤ 85% | Comfortable margin |
| 85-89% | Approaching threshold |
| 89-90% | Minimal margin |
| > 90% | Violation |

### Consequences of Violation

**Single Year Violation (> 90%):**
- Institution provisionally certified for the two fiscal years after the failing year
- Must notify students of the possibility of loss of Title IV eligibility
- Must report the failure to ED within 45 days of fiscal year end

**Two Consecutive Years (> 90%):**
- Loss of Title IV eligibility for at least two fiscal years
- Students can no longer receive federal aid at institution
- Potential closure or major restructuring

### Provisional Certification

When an institution exceeds 90%:

| Requirement (34 CFR 668.28(c)) | Description |
|---|---|
| Provisional certification | For the two fiscal years after the failing year |
| Student notification | Required after any failing year |
| Report to ED | Within 45 days of fiscal year end |
| Two consecutive failures | Loss of eligibility for at least two fiscal years; liable for Title IV funds disbursed after the last day of the fiscal year it becomes ineligible |

## Legislative History

### Original 85/15 Rule (1992, P.L. 102-325)

- Enacted as part of 1992 HEA amendments
- Required 15% non-federal revenue
- Drew on a precedent: the VA's 85/15 rule for GI Bill courses (early 1950s), which barred VA payments for courses where over 85% of enrollees were VA- or institution-funded (CRS R46773)

### Conversion to 90/10 (1998)

- Higher Education Amendments of 1998 (P.L. 105-244) changed the threshold from 85% to 90% Title IV; CRS found no stated rationale in the legislative history

### Higher Education Opportunity Act (2008)

- P.L. 110-315 moved 90/10 out of the definition of a proprietary institution: one failing year now triggers provisional certification for two fiscal years; two consecutive failing years cause loss of eligibility for at least two fiscal years (previously a single failure meant immediate ineligibility)

### American Rescue Plan Act (2021)

**Key Changes:**
- Expanded definition of "federal" revenue
- VA benefits now count as federal
- DoD Tuition Assistance counts as federal
- Effective for institutional fiscal years beginning on or after January 1, 2023 (ARPA, P.L. 117-2, sec. 2013; implemented by ED final rule 87 FR 65426, Oct. 28, 2022, effective July 1, 2023)

**Context (CRS R46773, 2021):** stakeholders argued that counting GI Bill and DoD Tuition Assistance as non-federal revenue (the "90/10 loophole") gave proprietary institutions an incentive to target servicemembers, veterans and their families; ARPA closed it by counting those funds as federal. Market viability was a key rationale for the original 85/15 rule.

### 2025 Interpretive Rule (90 FR 29734, July 7, 2025)

- ED withdrew its 2022 preamble position and now treats revenue from non-Title IV-eligible programs delivered by distance education as countable non-federal revenue if the program meets 668.28(a)(3)(iii)
- Interpretive rules have no effective date; institutions may revise calculations for concluded fiscal years
- Does not affect Portal years (2014-2021) as published

## FSA Data Variables

### Portal Dataset: `fsa/colleges_fsa_90_10_revenue_percentages`

> **Codebook Authority:** The authoritative variable reference is the codebook at `fsa/codebook_colleges_fsa_90-10_revenue_percentages`. Use `get_codebook_url()` from `fetch-patterns.md` to construct the download URL. If the information below contradicts the codebook or observed data, trust the higher-priority source per the Truth Hierarchy in SKILL.md.

| Variable | Description | Values |
|----------|-------------|--------|
| `unitid` | IPEDS institution identifier | 6-digit integer |
| `year` | Award year (fall start year) in which the institution's fiscal year ended, e.g., `year`=2015 covers fiscal years ending 2015-07-01 through 2016-06-30, so a June-2016 fiscal year end is `year`=2015, not 2016 | 2014-2021 |
| `fips` | State FIPS code | Integer |
| `opeid` | Office of Postsecondary Education ID | Integer |
| `inst_name_fsa` | Institution name (FSA) | String |
| `rev_pct_90_10` | 90/10 revenue percentage | **Proportion (0-1)**, NOT percent (0-100) |
| `numerator_90_10` | Title IV revenue (numerator) | Dollars |
| `denominator_90_10` | Total revenue (denominator) | Dollars |

> **CRITICAL: Proportion, not percentage.** `rev_pct_90_10` is stored as a proportion (e.g., 0.87 means 87%). The compliance threshold is `rev_pct_90_10 > 0.90`, NOT `> 90`. Multiply by 100 for display purposes.

### Year Coverage

| Variable | Years Available |
|----------|----------------|
| 90/10 data | 2014-2021 (`year` = award year in which the institution's fiscal year ended; 2021 = FYE 7/1/2021-6/30/2022) |

### Filtering for Compliance Analysis

```python
import polars as pl

# Fetch data
df = fetch_from_mirrors("fsa/colleges_fsa_90_10_revenue_percentages")

# Find institutions above 85% (0.85 as proportion; analyst heuristic, not a regulatory category)
df_high = df.filter(pl.col("rev_pct_90_10") >= 0.85)

# Find institutions at risk (88%+; analyst heuristic, not a regulatory category)
df_at_risk = df.filter(pl.col("rev_pct_90_10") >= 0.88)

# Find apparent violations (>90%)
df_violations = df.filter(pl.col("rev_pct_90_10") > 0.90)
```

```r
library(arrow)
library(dplyr)

# Fetch data (fetch_from_mirrors() is a Python helper; in R, build the URL
# from the mirror root in mirrors.yaml).
# Mirror failover: see `education-data-query/references/fetch-patterns.md` (R pattern).
config <- yaml::read_yaml("mirrors.yaml")
mirror <- config$mirrors[[1]]
# NOTE: illustrative only — mirror parquet files are Polars-written and may
# declare string_view columns, so a plain read can fail under R arrow
# ("cannot handle Array of type <utf8_view>"). Real fetch scripts must use the
# view-safe parquet read from `education-data-query/references/fetch-patterns.md`.
url <- paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/", "fsa/colleges_fsa_90_10_revenue_percentages", ".", mirror$format)
df <- arrow::read_parquet(url)

# Find institutions above 85% (0.85 as proportion; analyst heuristic, not a regulatory category)
df_high <- df |> filter(rev_pct_90_10 >= 0.85)

# Find institutions at risk (88%+; analyst heuristic, not a regulatory category)
df_at_risk <- df |> filter(rev_pct_90_10 >= 0.88)

# Find apparent violations (>90%)
df_violations <- df |> filter(rev_pct_90_10 > 0.90)
```

## Common Analysis Scenarios

### Sector Risk Assessment

Join with IPEDS Directory to identify:
- For-profit sector vulnerability
- Regional patterns
- Program-level variations

### Trend Analysis

Track institutions over multiple years:
- Improving (decreasing percentage)
- Stable
- Worsening (increasing percentage)

### Military Revenue Analysis

Important to consider:
- Every Portal year (2014-2021) predates the ARPA definition; VA/DoD funds were non-federal in all Portal data
- Historical comparisons require methodology adjustment
- Some institutions may show significant changes

## Important Caveats

1. **Only proprietary institutions**: Rule does not apply to public or nonprofit schools
2. **Data lag**: Published data may be 2-4 years old
3. **Methodology changes**: the ARPA definition applies only to fiscal years beginning on or after 2023-01-01, after Portal coverage ends
4. **Self-reported**: Initial data from institutions, subject to audit
5. **Net vs. gross**: Various netting rules affect calculations
6. **Program-level detail**: Institutional totals may mask program variations
7. **Online revenue treatment**: Recent guidance changes may affect comparisons

## Research Considerations

When using 90/10 data:

- **Context**: High percentages may reflect student demographics, not quality
- **Timing**: All Portal years use the pre-ARPA (Title IV-only) methodology
- **Completeness**: Not all proprietary institutions may have data
- **Interpretation**: Near-90% is not the same as above-90% (one year above 90% means provisional certification; two consecutive years mean ineligibility)
- **Complementary data**: Combine with financial responsibility, outcomes, complaints
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall