DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-ipeds
education-data-source-ipeds
VerifiedIPEDS — primary federal postsecondary data (~5,800 Title IV institutions, administrative offices, and U.S. service academies, 5,829 in the 2024-25 collection; 1979-present in the mirror; IPEDS replaced its predecessor HEGIS in 1986, so the earliest mirror years predate IPEDS): enrollment, completions, graduation rates, finance, aid, admissions, HR. For college/university analysis. Grad rates = first-time full-time; finance needs GASB/FASB care.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 30.4 KB |
| references/completions-data.md | markdown | 24.8 KB |
| references/data-quality.md | markdown | 18.5 KB |
| references/enrollment-data.md | markdown | 12.8 KB |
| references/finance-data.md | markdown | 16.9 KB |
| references/financial-aid.md | markdown | 23.1 KB |
| references/graduation-rates.md | markdown | 23.8 KB |
| references/institution-identifiers.md | markdown | 17.1 KB |
| references/survey-components.md | markdown | 28.4 KB |
references/finance-data.md
View on GitHub# IPEDS Finance Data: GASB vs FASB
Understanding the critical differences between accounting standards used by public and private institutions.
## Contents
- [The Core Problem](#the-core-problem)
- [Accounting Standards Overview](#accounting-standards-overview)
- [History of Finance Forms](#history-of-finance-forms)
- [GASB (Public Institutions)](#gasb-public-institutions)
- [FASB (Private Institutions)](#fasb-private-institutions)
- [Revenue Comparisons](#revenue-comparisons)
- [Expense Comparisons](#expense-comparisons)
- [Cross-Sector Analysis](#cross-sector-analysis)
- [Finance Data Quality Issues](#finance-data-quality-issues)
- [Common Finance Metrics](#common-finance-metrics)
## The Core Problem
**Public and private institutions use different accounting standards that are NOT directly comparable.**
| Standard | Institution Type | Governing Body |
|----------|-----------------|----------------|
| GASB | Public | Governmental Accounting Standards Board |
| FASB | Private nonprofit | Financial Accounting Standards Board |
| FASB | Private for-profit | Financial Accounting Standards Board |
**Critical Rule**: Do NOT compare finance data across sectors without understanding these differences.
## Accounting Standards Overview
### Why Different Standards?
- **Public institutions** are part of state/local government systems
- **Private institutions** are independent nonprofit or for-profit entities
- Different accounting rules for government vs business entities
### IPEDS Finance Forms
| Form | Institution Type | Standard |
|------|-----------------|----------|
| F1 | Public | GASB |
| F2 | Private nonprofit | FASB |
| F2 | Public using FASB (count unsourced) | FASB |
| F3 | Private for-profit | FASB |
### Key Structural Differences
| Aspect | GASB (Public) | FASB (Private) |
|--------|--------------|----------------|
| Revenue classification | Operating vs non-operating | By restriction level |
| State appropriations | Major category | Reported when received (some private institutions receive state appropriations) |
| Net assets | Net position | Net assets by restriction |
| Pell Grant treatment | Federal non-operating revenue | May be passthrough |
## History of Finance Forms
### Timeline
| Period | Public Institutions | Private Institutions |
|--------|--------------------|--------------------|
| 1987-1996 | Common Form | Common Form |
| 1997-2001 | Common Form | FASB |
| 2002-2003 | GASB (phased in) | FASB |
| 2004-2009 | GASB | FASB |
| 2010-present | GASB Aligned | FASB Aligned |
| 2014-15+ | GASB Aligned | FASB Aligned (F3 revised) |
**Implication**: Pre-2004 data for public institutions uses different format; trend analysis must account for this.
## GASB (Public Institutions)
### Revenue Categories
#### Operating Revenues
Generated from institution's principal activities.
| Category | Examples |
|----------|----------|
| Tuition and fees (net) | After scholarship discounts |
| Federal grants and contracts | Sponsored research, etc. |
| State grants and contracts | State-funded research |
| Local grants and contracts | Local government funding |
| Private grants and contracts | Foundation research grants |
| Sales and services of educational activities | Testing services, clinics |
| Auxiliary enterprises | Housing, dining, bookstore |
| Hospital revenue | If institution has hospital |
| Independent operations | Related but separate entities |
#### Non-Operating Revenues
Not from principal activities.
| Category | Examples |
|----------|----------|
| Federal appropriations | Rarely used |
| State appropriations | PRIMARY public funding source |
| Local appropriations | Local tax support |
| Federal non-operating grants | Pell Grants, SEOG |
| State non-operating grants | State financial aid |
| Gifts | Private donations |
| Investment income | Endowment returns, interest |
| Other non-operating | Miscellaneous |
#### Other Revenues and Additions
Capital and endowment related.
| Category | Examples |
|----------|----------|
| Capital appropriations | State funding for buildings |
| Capital grants and gifts | Donations for construction |
| Additions to permanent endowments | Endowment contributions |
| Other | Miscellaneous |
### Expense Categories (Functional)
| Function | Description |
|----------|-------------|
| Instruction | Teaching and instructional support |
| Research | Sponsored and institutional research |
| Public service | Community service, extension |
| Academic support | Libraries, academic computing |
| Student services | Admissions, counseling, career services |
| Institutional support | Administration, legal, HR |
| Operation and maintenance of plant | Facilities, grounds |
| Scholarships and fellowships | Aid NOT applied to charges |
| Auxiliary enterprises | Housing, dining, bookstore expenses |
| Hospital services | Hospital operations |
| Independent operations | Related but separate entities |
| Other | Miscellaneous |
### Net Position
| Category | Definition |
|----------|------------|
| Net investment in capital assets | Property minus related debt |
| Restricted expendable | Can be spent but with restrictions |
| Restricted nonexpendable | Cannot be spent (endowment principal) |
| Unrestricted | No donor/grantor restrictions |
## FASB (Private Institutions)
### Revenue Categories (F2 - Nonprofit)
| Category | Description |
|----------|-------------|
| Tuition and fees (net) | After discounts and allowances |
| Federal appropriations/grants/contracts | All federal revenue |
| State appropriations/grants/contracts | All state revenue |
| Local appropriations/grants/contracts | All local revenue |
| Private gifts, grants, contracts | Donations and private grants |
| Contributions from affiliated entities | Related organizations |
| Investment return | Endowment and other investments |
| Sales and services of educational activities | Non-auxiliary revenue |
| Sales and services of auxiliary enterprises | Housing, dining, etc. |
| Hospital revenue | If applicable |
| Independent operations | Related but separate |
| Other | Miscellaneous |
### Revenue by Restriction Level (F2 Only)
| Level | Definition |
|-------|------------|
| Unrestricted | No donor restrictions |
| Temporarily restricted | Time or purpose restrictions |
| Permanently restricted | Cannot be spent (endowment) |
### Expense Categories (Functional)
Same functional categories as GASB but:
- "Net grant aid to students" instead of "Scholarships and fellowships"
- May have different allocation methods
### For-Profit Differences (F3)
| Aspect | F3 Treatment |
|--------|--------------|
| Restrictions | Not applicable |
| Revenue categories | Simplified |
| Owner's equity | Reported instead of net assets |
| Tax status | Different financial structure |
## Revenue Comparisons
### What's Comparable
| Category | GASB | FASB | Comparable? |
|----------|------|------|-------------|
| Tuition and fees | Yes | Yes | Yes (net) |
| Federal research | Operating + non-operating | Single category | Requires sum |
| State support | Appropriations | Grants/contracts | Partially |
| Private gifts | Gifts | Gifts, grants, contracts | Requires mapping |
| Investment income | Investment income | Investment return | Similar |
| Auxiliary | Yes | Yes | Yes |
### State Appropriations Issue
| Sector | Treatment |
|--------|-----------|
| Public (GASB) | Major revenue source, clearly reported |
| Private (FASB) | Usually small or zero, but some private nonprofits report state appropriations (e.g., Cornell, unitid 190415: $370M in Portal `year` 2017) |
**Impact**: "Government support" is not comparable across sectors without examining each institution's reported appropriations.
### Pell Grant Treatment
| Standard | Treatment |
|----------|-----------|
| GASB | Federal non-operating revenue, net of discounts |
| FASB (some) | Federal grant revenue |
| FASB (others) | Passthrough transaction (not revenue) |
**Problem**: If a FASB institution treats Pell as passthrough:
- Not counted as federal revenue
- Not counted as discount/allowance to tuition
- Revenue totals may be lower than comparable GASB institution
## Expense Comparisons
### More Comparable Than Revenues
Functional expense categories are more standardized:
| Function | GASB | FASB | Comparable? |
|----------|------|------|-------------|
| Instruction | Yes | Yes | Yes |
| Research | Yes | Yes | Yes |
| Public service | Yes | Yes | Yes |
| Academic support | Yes | Yes | Yes |
| Student services | Yes | Yes | Yes |
| Institutional support | Yes | Yes | Yes |
| Scholarships (net) | Yes | Yes | Terminology differs |
| Auxiliary | Yes | Yes | Yes |
### Natural Classification
Both report by natural classification:
- Salaries and wages
- Benefits
- Operations and maintenance
- Depreciation
- Interest
This is more comparable across sectors than functional classification.
### Depreciation Differences
| Issue | Impact |
|-------|--------|
| Historical vs current cost | Different base values |
| Useful life estimates | May differ |
| Asset categories | May be classified differently |
## Cross-Sector Analysis
### When It's Acceptable
| Scenario | Approach |
|----------|----------|
| Within-sector comparison | Safe |
| Public to public | Safe |
| Private NP to private NP | Safe |
| Cross-sector with caution | Note limitations |
### Harmonization Approaches
#### Delta Cost Project
The Delta Cost Project, managed by American Institutes for Research (AIR), built a harmonized longitudinal database from IPEDS finance, enrollment, staffing, completions and aid data for academic years 1986-87 through 2011-12 (not updated past 2011-12). NCES distributes it as "IPEDS Analytics: Delta Cost Project Database" (https://nces.ed.gov/ipeds/use-the-data/delta-cost-project-finance-data).
#### Manual Harmonization
```python
# Example: Total education and general expenses
# Must sum functional categories consistently
# GASB
e_and_g_gasb = (
instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
scholarships_fellowships
)
# FASB (similar but verify category names)
e_and_g_fasb = (
instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
net_grant_aid
)
```
```r
# Total education and general expenses
# Must sum functional categories consistently
# GASB
e_and_g_gasb <- instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
scholarships_fellowships
# FASB (similar but verify category names)
e_and_g_fasb <- instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
net_grant_aid
```
### Metrics That Cross Sectors
| Metric | Cross-Sector? | Notes |
|--------|--------------|-------|
| Tuition revenue per FTE | Caution | Net vs gross |
| Instruction expense per FTE | Yes | Functional is comparable |
| Admin expense per FTE | Yes | Institutional support |
| Total expense per FTE | Caution | Different inclusions |
| Endowment per FTE | Limited | Different reporting |
## Finance Data Quality Issues
### Data Lag
Finance data typically has a 1-2 year lag:
- FY 2024 data available in early 2026
- Institutions report after fiscal year close
- Audited figures may be delayed
### Affiliated Entities
| Issue | Impact |
|-------|--------|
| Hospital finances | May be separate or included |
| Foundations | May not be consolidated |
| Research parks | Variable inclusion |
### System vs Campus
For multi-campus systems:
- Each campus may report separately
- System office may report separately
- Some consolidated reporting
### Restatements
Institutions may restate prior years:
- Accounting changes
- Error corrections
- Audit findings
Check for unusual year-over-year changes.
## Common Finance Metrics
### Expense Per FTE
```python
# Most common metric
instruction_per_fte = instruction_expenses / total_fte
total_exp_per_fte = total_expenses / total_fte
```
```r
# Most common metric
instruction_per_fte <- instruction_expenses / total_fte
total_exp_per_fte <- total_expenses / total_fte
```
### Revenue Composition
```python
# What share comes from each source
tuition_share = tuition_revenue / total_revenue * 100
state_share = state_appropriations / total_revenue * 100
```
```r
# What share comes from each source
tuition_share <- tuition_revenue / total_revenue * 100
state_share <- state_appropriations / total_revenue * 100
```
### Net Tuition Revenue
```python
# Tuition after discounts
net_tuition = gross_tuition - tuition_discounts_allowances
```
```r
# Tuition after discounts
net_tuition <- gross_tuition - tuition_discounts_allowances
```
### Education and General Spending
```python
# Core education spending (excludes auxiliary, hospital)
e_and_g = (instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
scholarships_fellowships)
```
```r
# Core education spending (excludes auxiliary, hospital)
e_and_g <- instruction + research + public_service +
academic_support + student_services +
institutional_support +
operation_maintenance +
scholarships_fellowships
```
### Instruction Share
```python
# Share of spending on instruction
instruction_share = instruction / total_core_expenses * 100
```
```r
# Share of spending on instruction
instruction_share <- instruction / total_core_expenses * 100
```
## Variable Reference
> Verify these variable names against the live codebook. Use `get_codebook_url()` from `fetch-patterns.md`:
> ```python
> url = get_codebook_url("ipeds/codebook_colleges_ipeds_finance")
> ```
>
> ```r
> # get_codebook_url() is a Python helper; in R, construct the URL directly
> # or use the codebook path from datasets-reference.md
> ```
> **CRITICAL: Portal vs NCES Variable Names.** The Portal `finance` dataset uses descriptive variable names (e.g., `rev_appropriations_state`, `exp_instruc_total`), NOT the NCES form-field codes (`f1a01`, `f2a01`). The NCES codes are shown below for cross-reference with source documentation only.
### Portal Revenue Variables (Selected)
| Portal Variable | Description | NCES Form Field |
|-----------------|-------------|-----------------|
| `rev_tuition` | Tuition and fees (net) | F1A01 / F2A01 |
| `rev_appropriations_fed` | Federal appropriations | F1A02 |
| `rev_appropriations_state` | State appropriations | F1A03 |
| `rev_appropriations_local` | Local appropriations | F1A04 |
| `rev_grants_contracts_federal` | Federal grants and contracts | F1A05 |
| `rev_grants_contracts_state` | State grants and contracts | F1A06 |
| `rev_grants_contracts_local` | Local grants and contracts | F1A07 |
| `rev_gifts_grants_contracts` | Private gifts, grants, contracts | F1A08 / F2A05 |
| `rev_investment_return` | Investment income/return | F1A09 / F2A07 |
| `rev_edu_services_sales` | Sales/services educational activities | F1A10 / F2A08 |
| `rev_auxiliary_enterprises_net` | Auxiliary enterprises (net) | F1A11 / F2A09 |
| `rev_hospital` | Hospital revenue | F1A12 |
| `rev_affiliated_entities` | Contributions from affiliated entities | F2A06 |
| `rev_operating` | Total operating revenue | — |
| `rev_nonoperating` | Total non-operating revenue | — |
### Portal Expense Variables (Selected)
| Portal Variable | Description | NCES Form Field |
|-----------------|-------------|-----------------|
| `exp_instruc_total` | Instruction (total) | F*B01 |
| `exp_research_total` | Research (total) | F*B02 |
| `exp_pub_serv_total` | Public service (total) | F*B03 |
| `exp_acad_supp_total` | Academic support (total) | F*B04 |
| `exp_student_serv_total` | Student services (total) | F*B05 |
| `exp_inst_supp_total` | Institutional support (total) | F*B06 |
| `exp_net_grant_aid_total` | Scholarships/fellowships (net) | F*B08 |
| `exp_aux_ent_total` | Auxiliary enterprises (total) | F*B09 |
| `exp_hospital_total` | Hospital services (total) | F*B10 |
| `exp_total_current` | Total current expenses | — |
### Other Key Finance Variables
| Portal Variable | Description |
|-----------------|-------------|
| `endowment_beg` | Endowment value at beginning of year |
| `endowment_end` | Endowment value at end of year |
| `form_type` | Reporting form (codebook labels: 1=Common form, 2=Form 1, 3=Form 1A, 4=Form 2, 5=Form 3); private nonprofits Harvard and Cornell carry 4. For the accounting standard (GASB vs FASB) use `reporting_form` |
| `assets` | Total assets |
| `liabilities` | Total liabilities |
| `calc_fte` | Calculated FTE enrollment |
| `est_fte` | Estimated FTE enrollment |
| `rep_fte` | Reported FTE enrollment |
### NCES Form Field Codes (for reference only)
The variable names below are from NCES finance survey forms and are NOT used as column names in the Portal:
| NCES Code | Description | Used In |
|-----------|-------------|---------|
| `f1a01`-`f1a12` | GASB revenue items | Form F1 (public) |
| `f2a01`-`f2a09` | FASB revenue items | Form F2 (private NP) |
| `f*b01`-`f*b11` | Expense items (both forms) | Form F1, F2, F3 |
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 |