brycewang-stanford/Auto-Empirical-Research-Skills / skills/17-DAAF-Contribution-Community-daaf/dot-claude/skills/education-data-source-ipeds
education-data-source-ipeds
VerifiedIPEDS — primary federal postsecondary data (~6,500 institutions, 1980-present): 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 | 23.7 KB |
| references/completions-data.md | markdown | 12.7 KB |
| references/data-quality.md | markdown | 13.4 KB |
| references/enrollment-data.md | markdown | 11.8 KB |
| references/finance-data.md | markdown | 15.1 KB |
| references/financial-aid.md | markdown | 18.2 KB |
| references/graduation-rates.md | markdown | 17.6 KB |
| references/institution-identifiers.md | markdown | 11.5 KB |
| references/survey-components.md | markdown | 25.6 KB |
references/survey-components.md
View on GitHub# IPEDS Survey Components
Complete reference for all IPEDS survey components, their collection periods, data content, and key variables.
> **IMPORTANT: NCES vs Portal Variable Names.** Many variable names in this file are from NCES survey documentation (e.g., `instnm`, `stabbr`, `applcn`, `eftotlt`). The Portal uses different, descriptive lowercase names (e.g., `inst_name`, `state_abbr`, `number_applied`, `enrollment_fall`). Always verify actual column names by inspecting the downloaded data or consulting the codebook. See `SKILL.md` for common NCES-to-Portal mappings, and use `get_codebook_url()` from `fetch-patterns.md` to download codebooks.
## Contents
- [Collection Schedule](#collection-schedule)
- [Fall Collection](#fall-collection)
- [Winter Collection](#winter-collection)
- [Spring Collection](#spring-collection)
- [Data Release Schedule](#data-release-schedule)
## Collection Schedule
IPEDS collects data in three periods annually. Each collection opens ~2 months before the due date.
| Collection | Opens | Closes | Data Release |
|------------|-------|--------|--------------|
| Fall | August | October | Following September |
| Winter | December | February | Following December |
| Spring | December | April | Following January |
## Fall Collection
### Institutional Characteristics (IC)
The foundational survey that must be completed first. Establishes institution identity.
**Collection Period**: August-October
**Data Collected**:
- Institution name, address, website
- Control (public/private nonprofit/private for-profit)
- Highest degree offered
- Carnegie classification
- Calendar system (semester/quarter/trimester)
- Student services offered
- Special institutional characteristics (HBCU, tribal, women's, religious)
- Open admission policy
- Tuition and fees
- Room and board charges
**Key Variables** (NCES names shown; Portal uses different names — see note at top):
| NCES Variable | Portal Variable | Description | Values |
|---------------|-----------------|-------------|--------|
| `unitid` | `unitid` | Unique institution ID | 6-digit integer |
| `instnm` | `inst_name` | Institution name | Text |
| `addr` | `address` | Street address | Text |
| `city` | `city` | City | Text |
| `stabbr` | `state_abbr` | State abbreviation | 2-letter |
| `fips` | `fips` | State FIPS code | Integer |
| `zip` | `zip` | ZIP code | Text |
| `control` | `inst_control` | Institutional control | 1=Public, 2=Private NP, 3=Private FP |
| `iclevel` | `institution_level` | Level of institution | 1=<2-yr, 2=2-yr, 4=4-yr+ |
| `hloffer` | `offering_highest_level` | Highest level of offering | Integer |
| `ugoffer` | `offering_undergrad` | Undergraduate offering | 1=Yes, 0=No |
| `groffer` | `offering_grad` | Graduate offering | 1=Yes, 0=No |
| `hdegofr1` | `offering_highest_degree` | Highest degree offered | Integer |
| `deggrant` | `degree_granting` | Degree-granting status | 1=Yes, 0=No |
| `hbcu` | `hbcu` | HBCU indicator | 1=Yes, 0=No |
| `hospital` | `hospital` | Has hospital | 1=Yes |
| `medical` | `medical_degree` | Grants medical degree | 1=Yes |
| `tribal` | `tribal_college` | Tribal college | 1=Yes, 0=No |
| `locale` | `urban_centric_locale` | Urban-centric locale code | 11-43 |
| `openpubl` | `open_public` | Open to general public | Integer |
| `obereg` | `region` | Bureau of Economic Analysis region | 0-8 |
| `ccbasic` | `cc_basic_2021` | Carnegie basic classification (2021) | See codebook |
> **Note on `institution_level`:** The Portal uses codes 1, 2, 4 (NOT 1, 2, 3). There is no code 3. This differs from the `iclevel` NCES values where 1=4-yr, 2=2-yr, 3=<2-yr.
> **Note on `hbcu` and `tribal_college`:** The Portal uses 0=No, 1=Yes (not 2=No as in some NCES documentation). Both also have -1=Missing.
### 12-Month Enrollment (E12)
Provides unduplicated headcount for the full academic year.
**Collection Period**: August-October (for prior academic year)
**Data Collected**:
- Unduplicated headcount by level, race/ethnicity, gender
- Instructional activity (credit/contact hours)
- Full-time equivalent (FTE) enrollment
**Portal Dataset**: `enrollment-fte` (path: `ipeds/colleges_ipeds_enrollment-fte`)
> **Structural Note:** The Portal transforms E12 data from the NCES wide format (one column per demographic group, e.g., `efytotlt`, `efyug`) into a **long/tidy format** with dimension columns + measure columns. There are no separate columns for race/ethnicity breakdowns; instead, those are available in the `headcount` dataset which uses `race` and `sex` dimension columns.
**Portal Variables** (`enrollment-fte` dataset, 9 columns):
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Academic year | 1997-2021 |
| `fips` | Int64 | State FIPS code | Integer |
| `level_of_study` | Int64 | Level of study | 1=Undergraduate, 2=Graduate, 3=First Professional |
| `acttype` | Int64 | Instructional activity type | 1=Credit hours, 2=Contact hours, 3=Both; -2=Not applicable |
| `credit_hours` | Int64 | Total credit hours | Integer |
| `contact_hours` | Int64 | Total contact hours | Integer |
| `est_fte` | Int64 | Estimated FTE enrollment | Integer |
| `rep_fte` | Int64 | Reported FTE enrollment | Integer |
> **NCES-to-Portal mapping:** The NCES variables `efytotlt`, `efyug`, `efygr`, `fteug`, `ftegr`, `fte` (wide-format totals/subtotals) do not exist as separate columns. To get undergraduate FTE, filter `level_of_study == 1` and read `est_fte` or `rep_fte`. For 12-month enrollment headcounts by race/ethnicity and sex, use the separate `headcount` dataset (`ipeds/colleges_ipeds_headcount`), which has `headcount`, `level_of_study`, `race`, and `sex` dimension columns.
**FTE Calculation Methods**:
Credit hour institutions:
- Undergrad FTE = (FT undergrad) + (PT undergrad credit hours / 30)
- Graduate FTE = (FT grad) + (PT grad credit hours / 24)
Clock hour institutions:
- FTE = Total contact hours / 900
### Completions (C)
Degrees and certificates awarded during the academic year.
**Collection Period**: August-October
**Data Collected**:
- Completions by CIP code, award level, race/ethnicity, gender
- Completers (unduplicated count of individuals)
- Distance education program indicator
**Award Levels**:
| Code | Award Level |
|------|-------------|
| 1 | Postsecondary certificate (<1 year) |
| 2 | Postsecondary certificate (1-2 years) |
| 3 | Associate's degree |
| 4 | Postsecondary certificate (2-4 years) |
| 5 | Bachelor's degree |
| 6 | Postbaccalaureate certificate |
| 7 | Master's degree |
| 8 | Post-master's certificate |
| 17 | Doctor's degree - research/scholarship |
| 18 | Doctor's degree - professional practice |
| 19 | Doctor's degree - other |
**CIP Code Structure**:
- 2-digit: General field (e.g., 52 = Business)
- 4-digit: More specific (e.g., 52.02 = Business Administration)
- 6-digit: Most specific (e.g., 52.0201 = Business Administration and Management)
### Cost (CST)
New component (2024-25) - Cost of attendance and net price data.
**Collection Period**: Fall and Winter
**Data Collected**:
- Published cost of attendance
- Net price by income level
- Books and supplies estimates
- Other expenses
## Winter Collection
### Admissions (ADM)
Application and admissions data for degree-granting institutions.
**Collection Period**: December-February
**Data Collected**:
- Applications received (men/women)
- Applicants admitted (men/women)
- Admitted students who enrolled (men/women)
- SAT/ACT score ranges (25th-75th percentile)
- Admission considerations (test scores, GPA, etc.)
**Key Variables** (Portal `admissions-enrollment` dataset):
| Portal Variable | NCES Name | Description |
|-----------------|-----------|-------------|
| `number_applied` | `APPLCN` | Total applicants |
| `number_admitted` | `ADMSSN` | Total admitted |
| `number_enrolled_total` | `ENRLT` | Total enrolled |
| `number_enrolled_ft` | `ENRLFT` | Enrolled full-time |
| `number_enrolled_pt` | `ENRLPT` | Enrolled part-time |
| `sex` | — | Sex (1=Male, 2=Female, 3=Nonbinary, 9=Unknown, 99=Total) |
> **Note:** The Portal `admissions-enrollment` dataset has only 9 columns: `unitid`, `year`, `fips`, `sex`, `number_applied`, `number_admitted`, `number_enrolled_ft`, `number_enrolled_pt`, `number_enrolled_total`. SAT/ACT scores are in the separate `admissions-requirements` dataset.
**Admission Rate Calculation**:
```python
# Filter to totals first (sex == 99)
admit_rate = number_admitted / number_applied
yield_rate = number_enrolled_total / number_admitted
```
### Student Financial Aid (SFA)
Financial aid awarded to students.
**Collection Period**: December-February
**Data Collected**:
- Number receiving aid by type
- Total amount awarded by type
- Military education benefits recipients
**Key Populations**:
| Population | Description |
|------------|-------------|
| All undergraduates | All enrolled undergrads |
| Full-time first-time | FTFT degree-seeking |
| All degree/certificate-seeking | Excludes non-degree |
**Aid Categories**:
| Category | Description |
|----------|-------------|
| Any aid | Any type of financial aid |
| Grant/scholarship | Gift aid (no repayment) |
| Federal grants | Pell, SEOG, other federal |
| State/local grants | State need-based, merit |
| Institutional grants | Institution-funded |
| Federal loans | Direct subsidized, unsubsidized, PLUS |
### Graduation Rates (GR)
See `graduation-rates.md` for complete details.
**Collection Period**: December-February
**Key Data**:
- 150% time completion rates
- Cohort counts by race/ethnicity, gender
- Pell/Stafford loan recipient rates
- Transfer-out counts
### Graduation Rates 200% (GR200)
Extended completion tracking.
**Collection Period**: December-February
**Data Collected**:
- 200% time completion rates
- Additional completers beyond 150% window
**Time Windows**:
| Institution Type | 150% Time | 200% Time |
|-----------------|-----------|-----------|
| 4-year | 6 years | 8 years |
| 2-year | 3 years | 4 years |
| Less-than-2-year | Varies | Varies |
### Outcome Measures (OM)
Expanded success metrics including part-time and transfer students.
**Collection Period**: December-February
**Cohort Groups** (unlike GR, includes more students):
1. First-time, full-time entering
2. First-time, part-time entering
3. Non-first-time, full-time entering (transfers)
4. Non-first-time, part-time entering
**Outcomes Tracked at 8 years**:
- Award at reporting institution
- Award at another institution
- Still enrolled at reporting institution
- Still enrolled elsewhere
- No longer enrolled anywhere
**Key Advantage**: Tracks students IPEDS graduation rates miss.
## Spring Collection
### Fall Enrollment (EF)
Point-in-time enrollment snapshot.
**Collection Period**: December-April (for previous fall)
**Data Collected**:
- Enrollment by level, attendance status, race/ethnicity, gender
- First-time student residence (even years)
- Enrollment by age (odd years)
- Retention rates
- Student-to-faculty ratio
- Distance education enrollment
> **Structural Note:** The Portal splits the NCES Fall Enrollment survey into **six separate datasets**, each in long/tidy format with dimension columns + a single measure column. The NCES wide-format variables (e.g., `effall`, `efft`, `efug`) do not exist as separate columns. Instead, filter on dimension columns (`ftpt`, `level_of_study`, `sex`, `race`, etc.) to get the desired subpopulation counts.
**Portal Datasets** (all Spring Collection, reported for previous fall):
| Portal Dataset | Path | Rows | Cols | Key Measure | Dimensions |
|----------------|------|------|------|-------------|------------|
| Fall Enrollment (Race) | `ipeds/colleges_ipeds_fall-enrollment-race_{year}` | ~3.5M/yr | 10 | `enrollment_fall` | `sex`, `race`, `ftpt`, `level_of_study`, `degree_seeking`, `class_level` |
| Fall Enrollment (Age) | `ipeds/colleges_ipeds_fall-enrollment-age_{year}` | ~1.2M/yr | 9 | `enrollment_fall` | `sex`, `age`, `ftpt`, `level_of_study`, `degree_seeking` |
| Fall Enrollment (Residence) | `ipeds/colleges_ipeds_fall-res` | 3.1M total | 6 | `enrollment_fall` | `state_of_residence`, `type_of_freshman` |
| Enrollment Headcount | `ipeds/colleges_ipeds_headcount` | 9.6M total | 7 | `headcount` | `level_of_study`, `race`, `sex` |
| Fall Retention | `ipeds/colleges_ipeds_fall-retention` | 325K total | 9 | `retention_rate` | `ftpt` |
| Student-Faculty Ratio | `ipeds/colleges_ipeds_student-faculty-ratio` | 80K total | 4 | `student_faculty_ratio` | (none — one row per institution-year) |
**Fall Enrollment (Race) Variables** (yearly dataset, 10 columns):
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Fall term year | 1986-2022 |
| `fips` | Int64 | State FIPS code | Integer |
| `sex` | Int64 | Sex | 1=Male, 2=Female, 99=Total |
| `race` | Int64 | Race/ethnicity | 1-9=Individual groups, 99=Total |
| `ftpt` | Int64 | Full-time/part-time | 1=Full-time, 2=Part-time, 99=Total |
| `level_of_study` | Int64 | Level of study | 1=Undergraduate, 2=Graduate, 99=Total |
| `degree_seeking` | Int64 | Degree-seeking status | 0=Non-degree, 1=Degree-seeking, 99=Total |
| `class_level` | Int64 | Class level | 1=First-year, 2=Second-year, 3=Third-year, 4=Fourth-year+, 99=Total |
| `enrollment_fall` | Int64 | Fall enrollment count | Integer |
**Fall Retention Variables** (single-file, 9 columns):
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Year | 2003-2020 |
| `fips` | Int64 | State FIPS code | Integer |
| `ftpt` | Int64 | Full-time/part-time | 1=Full-time, 2=Part-time, 99=Total |
| `retention_rate` | Float64 | Retention rate | Percentage |
| `returning_students` | String | Number returning | String (may contain suppression markers) |
| `prev_cohort` | String | Previous year cohort size | String |
| `prev_exclusions` | String | Exclusions from cohort | String |
| `prev_cohort_adj` | String | Adjusted cohort | String |
**NCES-to-Portal Mapping:**
| NCES Variable | Portal Equivalent | How to Derive |
|---------------|-------------------|---------------|
| `effall` (total fall enrollment) | `enrollment_fall` | Filter `fall-enrollment-race`: `sex==99`, `race==99`, `ftpt==99`, `level_of_study==99` |
| `efft` (full-time enrollment) | `enrollment_fall` | Filter: `ftpt==1`, `sex==99`, `race==99`, `level_of_study==99` |
| `efpt` (part-time enrollment) | `enrollment_fall` | Filter: `ftpt==2`, `sex==99`, `race==99`, `level_of_study==99` |
| `efug` (undergrad enrollment) | `enrollment_fall` | Filter: `level_of_study==1`, `sex==99`, `race==99`, `ftpt==99` |
| `efgr` (graduate enrollment) | `enrollment_fall` | Filter: `level_of_study==2`, `sex==99`, `race==99`, `ftpt==99` |
| `ret_pcf` (FT retention rate) | `retention_rate` | Filter `fall-retention`: `ftpt==1` |
| `ret_pcp` (PT retention rate) | `retention_rate` | Filter `fall-retention`: `ftpt==2` |
| `stufacr` (student-faculty ratio) | `student_faculty_ratio` | Direct column in `student-faculty-ratio` dataset |
| `efdeexc` (distance ed exclusively) | — | Not available as a separate Portal dataset column |
| `efdesom` (distance ed some) | — | Not available as a separate Portal dataset column |
| `efdenom` (not distance ed) | — | Not available as a separate Portal dataset column |
> **Note:** Distance education enrollment variables (`efdeexc`, `efdesom`, `efdenom`) are not in the Portal mirror datasets. These are available in the NCES IPEDS Data Center directly.
**Enrollment Categories**:
| Category | Definition |
|----------|------------|
| First-time | Never attended college before |
| Transfer | Previously attended another institution |
| Continuing | Enrolled previous year at same institution |
| Graduate | Master's, doctoral, professional |
| Non-degree | Not in a degree program |
### Finance (F)
Institutional finances - see `finance-data.md` for GASB/FASB details.
**Collection Period**: December-April
**Data Collected**:
- Revenues by source
- Expenses by function and natural classification
- Assets and liabilities
- Scholarships and fellowships
- Endowment and investments
**Portal Dataset**: `finance` (path: `ipeds/colleges_ipeds_finance`)
> **Structural Note:** Unlike E12 and EF, the Portal finance dataset keeps a **wide format** with 141 descriptive column names. The Portal replaces NCES form-field codes (e.g., `f1a01`, `f2a01`) with readable names (e.g., `rev_tuition_fees_gross`, `exp_instruc_total`). All finance forms (GASB F1, FASB F2, for-profit F3) are merged into a single dataset with `form_type` and `reporting_form` columns to distinguish them.
**Key Portal Variables** (selected from 141 columns; see `finance-data.md` for complete GASB/FASB treatment):
*Identification & Classification:*
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Fiscal year | 1979-2021 |
| `fips` | Int64 | State FIPS code | Integer |
| `form_type` | Int64 | Finance reporting form | 1-5 (see below) |
| `reporting_form` | Int64 | Detailed reporting form | -2=Not applicable, -1=Missing, 1-6 |
| `gasb_alternative_accounting` | Int64 | GASB alternative model | -2=N/A, -1=Missing, 1-4 |
| `parent_child_flag` | Int64 | Parent/child institution | -2=N/A, -1=Missing, 1-6 |
| `parent_unitid` | Int64 | Parent institution unitid | Integer |
*Revenue Variables (selected):*
| Portal Variable | Type | Description |
|-----------------|------|-------------|
| `rev_tuition_fees_gross` | Float64 | Gross tuition and fees |
| `rev_tuition_fees_net` | Float64 | Net tuition and fees (after allowances) |
| `rev_appropriations_state` | Float64 | State appropriations |
| `rev_appropriations_local` | Float64 | Local appropriations |
| `rev_appropriations_fed` | Float64 | Federal appropriations |
| `rev_grants_contracts_federal` | Float64 | Federal grants and contracts |
| `rev_grants_contracts_state` | Float64 | State grants and contracts |
| `rev_grants_contracts_local` | Float64 | Local grants and contracts |
| `rev_auxiliary_enterprises_gross` | Float64 | Auxiliary enterprises (gross) |
| `rev_hospital` | Float64 | Hospital revenue |
| `rev_investment_return` | Float64 | Investment return |
| `rev_endowment_income` | Float64 | Endowment income |
| `rev_total_current` | Float64 | Total current revenues |
*Expense Variables (selected):*
| Portal Variable | Type | Description |
|-----------------|------|-------------|
| `exp_instruc_total` | Float64 | Instruction total expenses |
| `exp_instruc_salaries` | Float64 | Instruction salaries |
| `exp_research_total` | Float64 | Research total expenses |
| `exp_pub_serv_total` | Float64 | Public service total |
| `exp_acad_supp_total` | Float64 | Academic support total |
| `exp_student_serv_total` | Float64 | Student services total |
| `exp_inst_supp_total` | Float64 | Institutional support total |
| `exp_aux_ent_total` | Float64 | Auxiliary enterprises total |
| `exp_hospital_total` | Float64 | Hospital expenses total |
| `exp_total_current` | Float64 | Total current expenses |
| `exp_total_salaries` | Float64 | Total salary outlays |
| `exp_total_benefits` | Float64 | Total benefit expenses |
*Scholarship & Aid Variables:*
| Portal Variable | Type | Description |
|-----------------|------|-------------|
| `sch_pell_grant` | Float64 | Pell Grant expenditures |
| `sch_grants_state` | Float64 | State grant aid |
| `sch_grants_institutional` | Float64 | Institutional grant aid |
| `sch_total_student_aid` | Float64 | Total student aid |
*Balance Sheet Variables (selected):*
| Portal Variable | Type | Description |
|-----------------|------|-------------|
| `assets` | Float64 | Total assets |
| `liabilities` | Float64 | Total liabilities |
| `endowment_beg` | Float64 | Endowment beginning of year |
| `endowment_end` | Float64 | Endowment end of year |
| `equity_total` | Float64 | Total equity |
| `est_fte` | Int64 | Estimated FTE (for per-FTE calculations) |
| `rep_fte` | Int64 | Reported FTE |
| `calc_fte` | Float64 | Calculated FTE |
*Cost Adjustment Indices:*
| Portal Variable | Type | Description |
|-----------------|------|-------------|
| `cpi` | Float64 | Consumer Price Index |
| `heca` | Float64 | Higher Education Cost Adjustment |
| `hepi` | Float64 | Higher Education Price Index |
> **`form_type` values:** 1=Public GASB, 2=Private nonprofit FASB, 3=Private for-profit, 4=Public FASB (rare, ~20 institutions), 5=Other. Not all columns are populated for all form types; see `finance-data.md` for which revenue/expense categories apply to which form.
> **NCES form-field codes** (e.g., `f1a01`=GASB total current assets, `f2a01`=FASB total current assets) do not appear in the Portal. The Portal uses the descriptive names listed above. See the codebook (`ipeds/codebook_colleges_ipeds_finance`) for complete column documentation.
### Human Resources (HR)
Employees and compensation.
**Collection Period**: December-April
**Data Collected**:
- Employees by occupational category
- Full-time and part-time counts
- Faculty counts by rank and tenure status
- Salaries for full-time instructional staff
- New hires
- Employees by race/ethnicity and gender
**Portal Datasets**: The Portal splits HR into two separate datasets, both in **long/tidy format** with dimension columns:
| Portal Dataset | Path | Rows | Cols | Years |
|----------------|------|------|------|-------|
| Instructional Staff Salaries | `ipeds/colleges_ipeds_salaries_is` | 7.2M | 11 | 1980-2022 |
| Noninstructional Staff Salaries | `ipeds/colleges_ipeds_salaries_nis` | 680K | 6 | 2012-2022 |
**Instructional Staff Salaries Variables** (11 columns):
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Year | 1980-2022 |
| `fips` | Int64 | State FIPS code | Integer |
| `academic_rank` | Int64 | Faculty rank | 1=Professor, 2=Associate Professor, 3=Assistant Professor, 4=Instructor, 5=Lecturer, 6=No Academic Rank, 99=Total |
| `contract_length` | Int64 | Contract length (months) | 5-13=Month count, 99=Total |
| `sex` | Int64 | Sex | 1=Male, 2=Female, 99=Total |
| `instruc_staff_count` | Float64 | Number of instructional staff | Float (may have fractional FTE) |
| `salary_outlays` | Float64 | Total salary outlays ($) | Float |
| `average_salary` | Float64 | Average salary ($) | Float; -1=Not applicable |
| `total_months` | Float64 | Total months of contract | Float |
| `avg_wgtd_mon_salary` | Float64 | Average weighted monthly salary ($) | Float |
**Noninstructional Staff Salaries Variables** (6 columns):
| Portal Variable | Type | Description | Values |
|-----------------|------|-------------|--------|
| `unitid` | Int64 | Unique institution ID | 6-digit integer |
| `year` | Int64 | Year | 2012-2022 |
| `fips` | Int64 | State FIPS code | Integer |
| `staff_category` | Int64 | Occupational category | 2-14, 99=Total (see below) |
| `noninstruc_staff_count` | Float64 | Number of noninstructional staff | Float |
| `salary_outlays` | Float64 | Total salary outlays ($) | Float |
**`staff_category` Values** (noninstructional staff):
| Code | Occupational Category |
|------|-----------------------|
| 2 | Research |
| 3 | Public service |
| 4 | Librarians, curators, archivists |
| 5 | Student and academic affairs |
| 6 | Management |
| 7 | Business and financial operations |
| 8 | Computer, engineering, and science |
| 9 | Community service, legal, arts, and media |
| 10 | Healthcare practitioners |
| 11 | Service occupations |
| 12 | Sales and office |
| 13 | Natural resources, construction, and maintenance |
| 14 | Production, transportation, and material moving |
| 99 | Total |
> **Structural Note:** NCES HR data uses wide-format variables for each occupation/rank/gender combination. The Portal transforms this into long format: one row per institution-year-dimension combination. To get total instructional staff salary, filter `salaries_is` with `academic_rank==99`, `contract_length==99`, `sex==99`. For occupational breakdowns, filter `salaries_nis` by `staff_category`.
**Occupational Categories** (NCES reference):
- Instruction (faculty) -- in `salaries_is` dataset
- Research through Production/transportation -- in `salaries_nis` dataset (codes 2-14)
### Academic Libraries (AL)
Library resources and services. **Collected biennially**.
**Collection Period**: December-April (odd years)
**Data Collected**:
- Library expenditures
- Collections (physical and digital)
- Circulation
- Interlibrary loans
## Data Release Schedule
Data releases occur in three types:
| Release Type | Timing | Use Case |
|--------------|--------|----------|
| Provisional | Shortly after collection closes | Initial analysis |
| Final | ~6 months after provisional | Most analysis |
| Revised | As needed | Corrections |
**Typical Release Calendar**:
| Collection | Provisional | Final |
|------------|-------------|-------|
| Fall 2024 | September 2025 | March 2026 |
| Winter 2024-25 | December 2025 | June 2026 |
| Spring 2025 | January 2026 | July 2026 |
## Title IV Requirement
All institutions participating in Title IV federal student financial aid programs are required to report IPEDS data. This includes:
- Pell Grant program
- Federal Direct Loans
- Federal Work-Study
- Federal Supplemental Educational Opportunity Grant (SEOG)
- Federal Perkins Loan (discontinued)
- TEACH Grant
**Non-Title IV institutions** are not in IPEDS (e.g., some religious institutions, purely non-credit vocational schools).
## Survey Response Rates
IPEDS achieves ~99% response rate because:
1. Reporting is mandatory for Title IV participation
2. Non-response can result in fine and loss of Title IV eligibility
3. Extensive follow-up by NCES
Imputation is used for remaining missing data.
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 |