PowerSchool SIS Oregon

PSSP EdPlan Data

Introduction

The PSSP EdPlan Data page in PowerSchool SIS provides a centralized, read-only view of Special Education and EdPlan information transmitted from PowerSchool Special Programs (PSSP).

Data Flow

  • System of Record: PSSP serves as the authoritative system of record for all special education and EdPlan data.

  • Automated Data Transmission: Data is refreshed daily via an automated recurring export/scheduled job pushing data from PSSP to PowerSchool SIS.

  • Single Student Record: Each student record is maintained as a single active snapshot linked directly to Students.dcid in the S_OR_STU_EDPLAN_X database extension table (historical revisions are maintained within PSSP).

  • Read-Only Display: Because PSSP is the system of record, data cannot be modified directly within PowerSchool SIS on this screen. Any necessary corrections or updates must be entered in PSSP and synchronized during the next export cycle. Navigation & Security Access

Start Page > Student Selection > Oregon State Information > More > PSSP EdPlan Data

  1. On the PowerSchool SIS Start Page, search for and select the student.

  2. Under the student navigation menu on the left, navigate to State/Province - OR (or Compliance / State Information).

  3. In the Oregon State Information page tabs, click the More dropdown or tab group.

  4. Select PSSP EdPlan Data.

Security & Permissions

  • Default Access: By default, access to this screen is granted to staff roles/users who hold permissions to view the Oregon Student SSID page (/state/usa_or/stateOR-SSID.html).

  • Custom Security: District administrators can adjust or customize page permissions for individual security groups or roles under System > Security > Page Permissions as needed.

Data View

  • This page provides an overview of PSSP EdPlan Data, showing the EdPlan information sent from PSSP (PowerSchool Special Programs) to the PowerSchool SIS through the nightly scheduled job. It also displays the latest database refresh timestamp in the upper-right corner so users can confirm when the student record was last updated from PSSP

Column Name

Description

Field

The database column identifier in the S_OR_STU_EDPLAN_X extension table.

Name

The official Oregon state / PSSP export field label.

Description

A business explanation of the field.

Value

The read-only value populated for the selected student.

Note: If no EdPlan record exists in PSSP for the student, the page displays blank/empty values.

4. Table & Field Mapping (S_OR_STU_EDPLAN_X)

Below is the complete field mapping between the PowerSchool database extension table, the state/PSSP export field name, and the UI field descriptions:

State / Export Field Name

PowerSchool Field (S_OR_STU_EDPLAN_X)

Description / Business Rule

Data Type / Format

StateCode

StateCode

Two-letter state identifier (OR).

VARCHAR(10)

StudentCode

StudentCode

Unique state student identification code (SSID).

VARCHAR(40)

FirstName

FirstName

Student legal first name.

VARCHAR(100)

MiddleName

MiddleName

Student legal middle name.

VARCHAR(100)

Suffix

Suffix

Student name suffix (e.g., Jr., III).

VARCHAR(50)

PreferredFirstName

PreferredFirstName

Student preferred first name.

VARCHAR(50)

Gender

Gender

Gender code of the student.

VARCHAR(1)

Status

Status

Active or Inactive student.

VARCHAR(1)

DateOfBirth

DateOfBirth

Student date of birth.

DATE (YYYY-MM-DD)

Race/Ethnicity

Race/Ethnicity

Race and Ethnicity Code(s).

VARCHAR(23)

Language

Language

Primary or native language code.

VARCHAR(4)

Grade

Grade

Student current grade level code.

VARCHAR(2)

SchoolCode

SchoolCode

State school institution code.

VARCHAR(40)

DistrictCode

DistrictCode

State district institution code.

VARCHAR(40)

RespDistCode

RespDistCode

Resident/Responsible District code.

VARCHAR(40)

ServDistCode

ServDistCode

Serving/Operating District code.

VARCHAR(40)

PrimaryDisability

PrimaryDisability

Primary IDEA special education disability code.

VARCHAR(2)

SecondaryDisability

SecondaryDisability

Secondary IDEA special education disability code.

VARCHAR(2)

EnrollmentType

EnrollmentType

Student enrollment classification type code.

VARCHAR(1)

Eligibility

Eligibility

Eligibility status for special education services.

VARCHAR(1)

EligibilityMeetingPurpose

EligibilityMeetingPurpose

The Meeting Purpose of the Eligibility event.

VARCHAR(1)

EligibilityDate

EligibilityDate

Date initial or re-evaluated eligibility was determined.

DATE (YYYY-MM-DD)

EligibilityEndDate

EligibilityEndDate

Date the student is no longer eligible for Special Education.

DATE (YYYY-MM-DD)

LastIEPDate

LastIEPDate

Meeting date of the last IEP event in the system for the student.

DATE (YYYY-MM-DD)

IEPBeginDate

IEPBeginDate

Effective start date of the current Individualized Education Program (IEP).

DATE (YYYY-MM-DD)

IEPEndDate

IEPEndDate

Projected end/review date of the current IEP.

DATE (YYYY-MM-DD)

Placement

Placement

Educational environment / federal placement setting code.

VARCHAR(2)

SPEDBIPMeetingDate

SPEDBIPMeetingDate

The meeting date for the SPED BIP event being imported.

DATE (YYYY-MM-DD)

SPEDBIPBeginDate

SPEDBIPBeginDate

The Begin Date of the SPED BIP event being imported.

DATE (YYYY-MM-DD)

SPEDBIPEndDate

SPEDBIPEndDate

The End Date of the SPED BIP event being imported.

DATE (YYYY-MM-DD)

DateExited

DateExited

Date the student exited special education services.

DATE (YYYY-MM-DD)

ExitReason

ExitReason

State reason code indicating why the student exited special education.

VARCHAR(2)

EnglishAsSecondLanguage

EnglishAsSecondLanguage

Student receives English as a second language services (Y/N).

VARCHAR(1)

FreeReducedLunch

FreeReducedLunch

Student free or reduced lunch status.

VARCHAR(1)

ReceivesRISServices

ReceivesRISServices

Student receives Regional Inclusive Services (RIS) (Y/N).

VARCHAR(1)

Note

  • Editing Data: To correct or update any of the values displayed on this screen, update the student's records directly in PowerSchool Special Programs (PSSP). The changes will populate in PowerSchool SIS after the next scheduled nightly sync.

  • Economically Disadvantaged / Lunch Status: The FreeReducedLunch field displayed on this screen reflects the lunch status stored in PSSP. It complements the Economically Disadvantaged Flag maintained on the Oregon SSID screen.