ERDC: Trusted. Accurate. Objective.
Working with ERDC Data
Data Dictionaries
| Data Type | Description |
|---|---|
| Early Learning | |
| K12 Students |
Washington Public K12 Student Data from CEDARS and OSPI’s Assessment Data* |
| Dual Credit Students | Washington Public Dual Credit Cohort Data |
|
Postsecondary |
Washington Public Two-year and Four-year Postsecondary Data |
| Workforce |
Washington UI Wage and Employment Data* |
*Still in development
Note: ERDC's policies are governed by data-use agreements with data contributors.
Not all data in the ERDC P20W warehouse is available for sharing with data requesters.
Learn more about data requests.
Learn about Data
| Resource | Description | Updated |
|---|---|---|
| ERDC's P20W Longitudinal Data System Research Handbook | Introduces researchers and analysts to the Washington Preschool-to-Grade 20-to-Workforce (P20W) data warehouse and the use of its products for research and analysis purposes. The research handbook summarizes the core source data that goes into the P20W data warehouse. It also contains information about ERDC's data request process and common methodologies used in P20W research. | October 2020 |
| ERDC Employment Data Handbook | A Guide for Incorporating Employment Information from a State Unemployment Insurance (UI) Program into a P-20 Longitudinal Data System | July 2012 |
| ERDC's Identity Matching Process | Presentation describing ERDC's process for matching identities when records come in from more than two sources | September 2013 |
| National Student Clearinghouse Data | Analysis of how the NSC Student Tracker system performs in matching Washington public high school graduates to in-state public 2 year and 4 year postsecondary institution enrollments. | October 2018 |
Access Data
| Resource | Description |
|---|---|
| Make a Data Request | ERDC data request instructions and forms |
| ERDC Data Enclave FAQs | Frequently Asked Questions (FAQs) about the Education Data Enclave |
| Data Enclave Training Guide | Overview of functionality and use of the Education Data Enclave for new users |
| Data Enclave Help Portal Reference Guide | Have enclave questions? The NORC team is here to help- connect with them here! |
| Instructions for using SFTP | Instructions for secure way to exchange data with ERDC (after requests have been approved) |
Data Tools
| Document | Description |
|---|---|
|
|
ERDC has developed several SAS macros to assist us in the cleaning and linking of education data. These SAS macros available to the public. |
| Crosswalks that relate the high school codes from SBCTC, PCHEES and OSPI. The school codes for SBCTC and PCHEES are for the last high school attended. For OSPI, the school codes are for Washington State public high schools. | |
| Technical description for data clean up to standardize names | |
| Geographic Setting |
Geographic Setting of Schools in Washington State: A Classification Based on Urban-Centric Locale
|
Submit Data
| Educator Preparation Program Docs | Description | Updated |
|---|---|---|
| Data Submissions Manual | For reporting student-level data to the ERDC for aggregate reporting to PESB | July 2023 |
| Data Manual Appendices Workbook | Contains the lookup tables for EPP data submission | July 2023 |
| 2023 templates for uploading EPP data | Most recent templates for uploading EPP data | July 2023 |
| 2021 PESB COVID-19 Coding Guidance | How to code candidates who receive an emergency certification | July 2023 |
| Data Cleaning Checklist Workbook | Guidlines for diagnostic data cleanup prior to submission | July 2023 |
| PCHEES Database Docs | Description | Updated |
|---|---|---|
| Release Notes | Informs users of changes from the prior PCHEES Data Submission Guide. | August 2023 |
| PCHEES Data Submission Guide | PCHEES data definitions and submission rules |
August 2023 |
| PCHEES Lookup Table Values |
Information for working with PCHEES data |
July 2023 August 2021 August 2021 |
| CIP Codes | Classification of Instructional Program (CIP) codes with STEM and High Demand indicators | July 2023 |
