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*

High School Outcomes Cohort Data

Dual Credit Students Washington Public Dual Credit Cohort 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
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

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 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