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/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
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: 198k | 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 |