Working with ERDC Data

Data Dictionaries 

Data Type Description
Early Learning

Early Learning and Kindergarten (ELK)

K12 Students Washington Public K12 Student Data from CEDARS and OSPI’s Assessment Data*
K12 Teachers Washington Public K12 Teacher Data*


Washington Public Two-year and Four-year Postsecondary Data


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


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
Instructions for using SFTP  Instructions for secure way to exchange data with ERDC (after requests have been approved)


Data Tools

Document Description

SAS Macros


ERDC has developed several SAS macros to assist us in the cleaning and linking of education data. These SAS macros available to the public. 

High School Code Crosswalks 

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.

Business Rules for Standardizing Name Fields

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 October 2021
Data Manual Appendices Workbook  Contains the lookup tables for EPP data submission July 2021
2021 templates for uploading EPP data Most recent templates for uploading EPP data May 2021
2021 PESB COVID-19 Coding Guidance How to code candidates who receive an emergency certification May 2021


PCHEES Database Docs Description Updated
Release Notes Informs users of changes from the prior PCHEES Data Submission Guide.  August 2021
PCHEES Data Submission Guide PCHEES data definitions and submission rules

August 2021

PCHEES Valid Values

Information for working with PCHEES data

August 2021

CIP Codes Classification of Instructional Program (CIP) codes with STEM and High Demand indicators July 2021