DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-scorecard
education-data-source-scorecard
VerifiedCollege Scorecard — post-enrollment outcomes linking aid records to IRS/Treasury earnings. Earnings, loan repayment, debt via six Portal sub-datasets. Use when tax-record-based earnings needed. Tracks only Title IV aid recipients, not all students.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 22.3 KB |
| references/completion-rates.md | markdown | 10.5 KB |
| references/data-quality.md | markdown | 11.5 KB |
| references/debt-repayment.md | markdown | 11.6 KB |
| references/earnings-data.md | markdown | 11.6 KB |
| references/field-of-study.md | markdown | 12.4 KB |
| references/population-coverage.md | markdown | 9.5 KB |
| references/variable-definitions.md | markdown | 25.3 KB |
references/earnings-data.md
View on GitHub# Earnings Data
College Scorecard's earnings data come from Treasury/IRS tax records — W-2 wages plus Schedule SE self-employment earnings — making it uniquely valuable for understanding labor market outcomes.
> **Portal dataset:** `scorecard/colleges_scorecard_earnings` (203,066 rows x 33 columns)
>
> **Portal uses lowercase LONG format.** Original Scorecard names like `MD_EARN_WNE_P6` become `earnings_med` filtered by `years_after_entry == 6`. See `variable-definitions.md` for the full mapping.
>
> **Suppression:** Earnings columns use `-3` integer code (NOT null) for suppressed values.
## Data Source: IRS/Treasury
Earnings come from Treasury (IRS) administrative tax records linked to NSLDS records of federally aided students:
| Aspect | Detail |
|--------|--------|
| Source | W-2 wages and deferred compensation (Box 1 + Box 12) plus positive self-employment earnings from Schedule SE |
| Matching | NSLDS records of Title IV recipients linked to tax records |
| Reporting | Aggregated; counts and medians perturbed with differential-privacy noise; suppressed (`PS`) when cells are too small |
| Coverage | Federally aided students who are working (W-2 or Schedule SE earnings) and not enrolled |
### What the earnings measure includes
- Wages, salaries, tips and deferred compensation on W-2 forms (full- and part-time jobs)
- Positive self-employment earnings reported on Schedule SE
### What it excludes
| Excluded Income | Impact on Analysis |
|-----------------|-------------------|
| Investment and other non-labor income | Passive income not counted |
| Unreported (cash-economy) income | Not captured |
| Earnings not reported on U.S. tax forms | Not captured |
## Cohort Definitions
### Entry Cohort vs Completion Cohort
Scorecard primarily uses **entry cohorts** - students grouped by when they first enrolled:
```
Entry Cohort Example:
- Students who entered in Fall 2008
- 6-year earnings measured in 2014
- 10-year earnings measured in 2018
```
**Important:** Earnings are measured from entry, NOT graduation. This means:
- A student who took 4 years to graduate has earnings measured 2 years post-graduation at the "6-year" mark
- A student who took 6 years to graduate has earnings measured AT graduation at the "6-year" mark
### Entry Cohort Construction
Students included in entry cohorts:
- Title IV recipients (Pell Grant or undergraduate federal loan) assigned to an entry year from their first aid receipt at the institution, back-dated by up to two years using the FAFSA grade level (not restricted to first-time students)
- Includes full-time AND part-time students
- Includes students who transferred in (at receiving institution)
- Includes students who did not complete
### Pooled Cohorts
Many metrics use "pooled" cohorts combining multiple years:
- Increases sample size
- Reduces suppression
- Typical pooling: 2-4 entry years combined
Variable naming convention: `*_POOLED` or `*_POOLED_SUPP`
## Time Horizons
### Available Measurement Points
| Metric | Years After Entry | What It Captures |
|--------|------------------|------------------|
| 6-year earnings | 6 years | Early career, ~2 years post-graduation for 4-year completers |
| 8-year earnings | 8 years | Early-mid career |
| 10-year earnings | 10 years | Mid-career, ~6 years post-graduation for 4-year completers |
### Interpreting Time Horizons
**6-Year Earnings:**
- Most commonly reported metric
- Captures early career earnings
- For 4-year completers: ~2 years post-graduation
- For 2-year completers: ~4 years post-graduation
- For non-completers: earnings regardless of completion status
**10-Year Earnings:**
- Better reflection of career trajectory
- More stable earnings picture
- Fewer students still in graduate school
- But: cohorts are even older (11+ years old when data released)
### Data Vintage and Lag
Earnings data has significant lag:
```
Example for 2024 data release:
├─ 10-year earnings
│ ├─ Entry cohort: ~2014
│ ├─ Measured in: ~2024
│ ├─ Reflects: Students who entered 10+ years ago
│ └─ Labor market: 2024 conditions applied to old cohort
└─ 6-year earnings
├─ Entry cohort: ~2018
├─ Measured in: ~2024
└─ Reflects: Students who entered 6+ years ago
```
**Implication:** Earnings data reflects students and programs from years ago. Rapid changes in:
- Program quality
- Curriculum
- Labor market conditions
- Industry demand
...may not be reflected in current data.
## Earnings Metrics
### Median Earnings (Primary Metric)
> **Portal column names are lowercase.** Filter by `years_after_entry` to select time horizon.
| Portal Column | Description | Original Scorecard |
|---------------|-------------|-------------------|
| `earnings_med` | Median earnings (filter by `years_after_entry`) | `MD_EARN_WNE_P6/P8/P10` |
| `earnings_mean` | Mean earnings | `MN_EARN_WNE_P*` |
"WNE" (Working and Not Enrolled) is implicit in the Portal data — these columns only include workers.
Available `years_after_entry` values: **6, 7, 8, 9, 10**
### Percentile Earnings
| Portal Column | Description | Original Scorecard |
|---------------|-------------|-------------------|
| `earnings_pct10` | 10th percentile earnings | `PCT10_EARN_WNE_P*` |
| `earnings_pct25` | 25th percentile earnings | `PCT25_EARN_WNE_P*` |
| `earnings_pct75` | 75th percentile earnings | `PCT75_EARN_WNE_P*` |
| `earnings_pct90` | 90th percentile earnings | `PCT90_EARN_WNE_P*` |
### Earnings by Family Income
Disaggregated by FAFSA-reported family income tercile:
| Portal Column | Family Income Level | Original Scorecard |
|---------------|--------------------|--------------------|
| `earnings_lowinc_mean` | Lowest third ($0-$30,000) | `MN_EARN_WNE_INC1_P*` |
| `earnings_midinc_mean` | Middle third ($30,001-$75,000) | `MN_EARN_WNE_INC2_P*` |
| `earnings_highinc_mean` | Highest third ($75,001+) | `MN_EARN_WNE_INC3_P*` |
### Additional Disaggregations
| Portal Column | Description |
|---------------|-------------|
| `earnings_dep_mean` | Mean earnings, dependent students |
| `earnings_dep_lowinc_mean` | Mean earnings, dependent low-income |
| `earnings_ind_mean` | Mean earnings, independent students |
| `earnings_female_mean` | Mean earnings, female |
| `earnings_male_mean` | Mean earnings, male |
### Working and Enrollment Status
| Portal Column | Description | Original Scorecard |
|---------------|-------------|-------------------|
| `count_working` | Number working and not enrolled | `COUNT_WNE_P*` |
| `count_not_working` | Number not working and not enrolled | `COUNT_NWNE_P*` |
| `earnings_greater_than_25k_pct` | Share earning > $25K | `GT_25K_P*` |
## Working Population Filter
**Critical:** Earnings are only calculated for students who are:
1. Working (have positive W-2 or Schedule SE earnings)
2. Not enrolled in postsecondary education
### Who Is Excluded from Earnings Calculations
| Excluded Group | Reason | Impact |
|----------------|--------|--------|
| Students enrolled in school (e.g., graduate school) | In-school deferment status for at least 30 days of the measurement year, whether or not working | Where many students are still enrolled, the earnings cohort is a selected subset; the technical documentation states the exclusion but not the direction of the bias |
| Non-employed | No W-2 or Schedule SE earnings | Unemployed, stay-at-home parents, disabled excluded |
| Deceased | No tax-record earnings | Small effect |
| Living abroad | No U.S. tax-record earnings | May affect certain fields |
### Implications for Analysis
- Fields or institutions with high graduate-school attendance have a selected earnings cohort (enrolled students are excluded); the direction of the bias is not documented
- Institutions/programs with higher unemployment rates are NOT penalized in earnings metrics
## Earnings Suppression
Earnings are suppressed when privacy thresholds are not met:
### Suppression Rules
Scorecard suppresses NSLDS and Treasury elements (shown as `PS`) when cell sizes do not meet privacy standards, and adds differential-privacy noise to earnings counts and medians (small differences of 1–3 in counts are expected). For consumer-site elements, separate `*_SUPP` versions suppress institutions with fewer than 30 students in the denominator (e.g., `C150_4_POOLED_SUPP`, `RPY_3YR_RT_SUPP`). The base-element cell-size thresholds are not stated in the October 2026 technical documentation.
### Variables Indicating Suppression
> **Portal Encoding:** In the Portal earnings dataset, **`-3` is the primary suppression indicator** for earnings and count columns (NOT null). This was verified empirically — ~24,000 rows have `-3` in `earnings_mean` alone.
| Data Pattern | Meaning | Notes |
|--------------|---------|-------|
| `-3` | Suppressed for privacy | Primary suppression indicator in earnings columns |
| `null` | Missing data | Null count is 0 for `unitid`, `year`, etc. but ~109K for disaggregated columns |
| Positive value | Valid earnings | Actual data |
```python
import polars as pl
# CORRECT: Filter both -3 and null for earnings
valid = df.filter(
pl.col("earnings_med").is_not_null() &
(pl.col("earnings_med") != -3) &
(pl.col("earnings_med") > 0)
)
```
```r
# CORRECT: Filter both -3 and NA for earnings
valid <- df |> filter(!is.na(earnings_med), earnings_med != -3, earnings_med > 0)
```
### High Suppression Rates Affect
- Small institutions
- Small programs (by CIP code)
- Disaggregations (by income, race, gender)
- Newer programs without enough cohorts
## Cohort Year Mapping
Understanding which cohort corresponds to which measurement year:
### Institution-Level Earnings
For annual data files (e.g., `merged_2022_23`):
| Variable | Entry Cohort Years (Approx) | Measurement Year |
|----------|---------------------------|------------------|
| 6-year earnings | 2015-16, 2016-17 | 2021, 2022 |
| 8-year earnings | 2013-14, 2014-15 | 2021, 2022 |
| 10-year earnings | 2011-12, 2012-13 | 2021, 2022 |
**Note:** Specific cohort years vary by data release. Always check documentation.
### Data Errata
The October 2026 technical documentation notes that previously published entry-cohort earnings differ from the current methodology, as described in the Scorecard data errata document; check the errata for affected files and variables.
## Recommended Practices
### Before Earnings Analysis
1. **Identify cohort timing** - Know which entry years are reflected
2. **Check suppression rates** - How many institutions/programs have data?
3. **Note WNE filter** - Earnings exclude non-workers and enrolled students
4. **Understand coverage** - Title IV recipients only
### Reporting Earnings
1. **State population clearly**: "Title IV aid recipients who were working and not enrolled"
2. **Note time context**: "Earnings measured 6 years after enrollment"
3. **Acknowledge lag**: "Reflects students who entered in [year]"
4. **Report suppression**: "X% of programs had suppressed earnings data"
### Comparing Earnings
**Valid comparisons:**
- Same institution type, similar aid populations
- Same field across similar institution types
- Same institution over time (with cohort caveats)
**Invalid comparisons:**
- Scorecard earnings vs BLS occupational wages
- Scorecard earnings vs Census income
- Scorecard vs alumni survey earnings
- Institutions with very different Title IV coverage rates
## Example: Interpreting 6-Year Earnings
```
Institution A: Median 6-year earnings = $45,000
What this means:
- Half of Title IV aid recipients earned more, half less
- Measured 6 years after the estimated entry year at the institution
- Only includes those working and not enrolled
- Excludes the non-working and those still enrolled
- Reflects cohort that entered ~6 years ago
- May not reflect current program quality or labor market
```
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 |