Oregon EDPlan Automatic Imports From PowerSchool Setup Guide

Overview

The S_OR_STU_EDPLAN_X table stores EdPlan (special education) data sent from PSSP (PowerSchool Special Programs) to the PowerSchool SIS. This table enables Oregon districts to view EdPlan student data directly within PowerSchool SIS.

Key points:

PSSP is the system of record - data displayed in PowerSchool SIS is read-only.
Data is refreshed (overwritten) daily via automated export from PSSP.
Each student has one record - historical data is not captured.
The table includes Created by/on and Modified by/on timestamps so users can see when data was last refreshed.

Setup Requirements

Before EdPlan can be sent from PowerSchool SIS to the PCG server, districts must complete the following:

Set up a PowerSchool Remote Connection in Plugin Management Configuration.
Configure an automated recurring export in PowerSchool SIS to push EdPlan data to the PCG server.

Note: The state of Oregon has contracted with PCG to collect this data from all OR districts. Refer to the PCG-provided instructions for detailed setup guidance.

The PCG-provided instructions describe how to set up an AutoSend for student files. Use the Data Dictionary list of fields below to populate the ‘Fields to export’ box on the AutoSend setup screen in the following format:

S_OR_STU_EDPLAN_X.StateCode

S_OR_STU_EDPLAN_X.StudentCode

S_OR_STU_EDPLAN_X.FirstName

(All fields in the Data Dictionary should be included.)

Data Dictionary

The table S_OR_STU_EDPLAN_X is an extension of the Students table. All fields are populated by the PSSP import.

Field Name	Data Type	Length	Description
StateCode	String	10	State-assigned Secure Student Identifier (SSID).
StudentCode	String	40	District/local student identifier. Must be consistent at all times.
FirstName	String	100	Student's legal first name.
MiddleName	String	100	Student's legal middle name.
LastName	String	100	Student's legal last name.
Suffix	String	50	Student's generation code (e.g., Jr., III).
PreferredFirstName	String	50	Student's preferred first name.
Gender	String	1	Gender code.
Status	String	1	Record status: Active or Inactive. A value of `I` indicates inactive (student exited district or no longer in SPED). All other values indicate active.
DateOfBirth	Date	—	Student's date of birth.
RaceEthnicity	String	23	Comma-delimited Race/Ethnicity codes. See Race/Ethnicity Codes.
Language	String	4	Primary language code. See Language Codes.
Grade	String	2	Enrolled grade code. See Grade Codes.
SchoolCode	String	40	Attending school institution identifier.
DistrictCode	String	40	Attending district institution identifier.
RespDistCode	String	40	Resident/Responsible district code — the district responsible for providing services.
ServDistCode	String	40	Serving/Operating district code — the district where the student receives services.
PrimaryDisability	String	2	Primary disability code. See Disability Codes.
SecondaryDisability	String	2	Secondary disability code. See Disability Codes.
EnrollmentType	String	1	Special education enrollment setting type code. See Enrollment Type Codes.
Eligibility	String	1	Indicates if the eligibility event is a regular eligibility (`Y`) or non-eligibility (`N`/`No`).
EligibilityMeetingPurpose	String	1	Meeting purpose associated with the eligibility event. See Meeting Purpose Codes.
EligibilityDate	Date	—	Date of the special education eligibility determination.
EligibilityEndDate	Date	—	Date the student is no longer eligible for special education.
LastIEPDate	Date	—	Meeting date of the student's last IEP. Must be within the last 50 years and cannot be a future date.
IEPBeginDate	Date	—	Begin date of the most current IEP.
IEPEndDate	Date	—	End date of the most current IEP.
Placement	String	2	Secondary federal placement type code. See Placement Type Codes.
SPEDBIPMeetingDate	Date	—	Meeting date of the Special Education Behavior Intervention Plan (BIP).
SPEDBIPBeginDate	Date	—	Begin date of the SPED BIP.
SPEDBIPEndDate	Date	—	End date of the SPED BIP.
DateExited	Date	—	Date the student exited special education.
ExitReason	String	2	Exit reason code. See Exit Reason Codes.
EnglishAsSecondLanguage	String	1	Indicates whether the student receives ESL services. `0` = No, `1` = Yes.
FreeReducedLunch	String	1	Free/reduced lunch status. See Free/Reduced Lunch Codes.
ReceivesRISServices	String	1	Indicates whether the student receives Regional Inservice/Support (RIS) services. `Y` = Yes, `N` = No.

Code Tables

Gender Codes

Code	Description
F	Female
M	Male
X	Non-Binary

Grade Codes

Code	Description
PK	Pre-Kindergarten
KG	Kindergarten
01	First Grade
02	Second Grade
03	Third Grade
04	Fourth Grade
05	Fifth Grade
06	Sixth Grade
07	Seventh Grade
08	Eighth Grade
09	Ninth Grade
10	Tenth Grade
11	Eleventh Grade
12	Twelfth Grade

Race/Ethnicity Codes

Multiple codes can be supplied, delimited by commas.

Code	Description
AM7	American Indian or Alaska Native
AS7	Asian
BL7	Black or African American
HI7	Hispanic/Latino
PI7	Native Hawaiian or Other Pacific Islander
MU7	Two or more races
WH7	White

Language Codes

Code	Description
1290	English
4260	Spanish
3830	Russian
4800	Vietnamese
860	Chinese
4050	Sign Language
9999	Other Languages

Disability Codes

Code	Description
0	Not Applicable
10	Intellectual Disability
20	Deaf or Hard of Hearing
40	Visual Impairment Including Blindness
43	Deaf-Blindness
50	Speech/Language Impairment
60	Emotional Behavior Disability
70	Orthopedic Impairment
74	Traumatic Brain Injury
80	Other Health Impairments
82	Autism Spectrum Disorder
90	Specific Learning Disability
96	Developmental Delay 0–2yr
98	Developmental Delay 3–9yr

Enrollment Type Codes

Code	Description
N	Normal District Enrollment
Y	Private or Parochial School – Parent Placed (with Service Plan)
A	Approved Private School – District Placed (with IEP)
H	Home-Schooled
I	Inter-District Agreement/Transfer
C	Charter Schools
J	Jail / ACEP / JDEP / YCEP
O	Other
T	Parent Paid Tuition to Another District
E	Open Enrollment
M	Homeless
R	Recovery School

Meeting Purpose Codes

Code	Description
I	Initial Eligibility
R	Reevaluation

Placement Type Codes

Code	Description
30	80% or more of day – Regular Class
31	40 to 79% of day – Regular Class
32	Hospital
33	Less than 40% of day – Regular Class
34	Public Separate School
35	Private Separate School
36	Public Residential Facility
37	Private Residential Facility
38	Correctional Facility
39	Homebound
40	Parentally Placed in Private School
41	Home Schooled

Exit Reason Codes

Code	Description
30	Graduation with Regular Diploma
31	Received a Modified Diploma
32	Received a Certificate
33	Returned to Regular Education
34	Reached Maximum Age
35	Deceased
36	Moved, Continuing in Education
37	Extended Diploma
39	Dropped Out

Free/Reduced Lunch Codes

Code	Description
Y	Economically Disadvantaged
N	Not Economically Disadvantaged

Notes

Read-only data: The EdPlan data in PowerSchool SIS cannot be edited. PSSP is the system of record. Any corrections must be made in PSSP and will be reflected after the next daily refresh.
Daily refresh: Data is overwritten daily. The WhenModified timestamp on the record indicates when the last refresh occurred.
One record per student: Only the current record is maintained; historical data is not captured.
Status field: A value of I (case-insensitive) marks the student as inactive in EdPlan. Any other value (or blank) leaves the student as active.
Race/Ethnicity format: Multiple race/ethnicity codes are comma-delimited (e.g., BL7,WH7).