Skip to main content
Skip table of contents

Student Special Education Events

studentSpecialEducationAssociationEvents

This view captures student Special Education Program event data as published in the StudentSpecialEducationAssociationEvent resource within the Student Program category. The layout includes the Student’s Unique ID, School reference, Event Type Code, Event Date, Event Reason, Non-Compliance Reason, Last Publish Date, and Publishing ID.

Note: In order for a student’s Special Education event data to publish, they must have a published StudentSpecialEducationProgramAssociation record.

Primary PowerSchool Source Data

  • [Students]

  • [ReEnrollments]

  • [S_NM_STU_X]

  • [S_NM_STU_SPEDEVENTS_C]

Selection Criteria

Records are published if the following criteria are met:

  • StudentUniqueId must be populated in PowerSchool.

  • The student must not be excluded from state reporting.

  • The school must not be excluded from state reporting.

  • The student must be identified as a Special Education student.

    • [S_NM_STU_X]SpEd38_YN = Y (for a current special education student) or N (for a student that has exited special education).

    • The date range between the following fields must span some part of the reporting year.

      • [S_NM_STU_X]SpedEntryDate

      • [S_NM_STU_X]SpEdExitDate

  • The Special Education Event Date is within 365 days of the first day of school.

Publish Special Education Event Record for Specific Scenarios

Functionality available to publish Special Education Event records for the following specific scenarios:

  • Students that were evaluated for Special Ed but did not qualify for whatever reason (DNQ students).

  • Students that exited Special Education prior to the current school year and therefore don’t have a parent Special Education record in the current year.

  • Students are currently in Special Education, but PED is reporting a certain event is missing on their side that is outside of the normal PowerSchool publishing logic (Sped Event record took place more than 365 days from the start of the current school year).

For the scenarios outlined above, this functionality allows end users to select a year value, for a given Sped Event record (the year should reflect the school year in which the Sped Event record must publish), in the Force this record to publish? field. Once a year is selected, the next time a Publish All is done, a Special Education parent program record will be generated, and the Sped Event record (or records) will be published.

Note: Due to Special Education Events being dependent on a Special Education parent program record, if the student’s Special Ed data is unable to get a parent Sped record (students that exited Special Education in a previous school year or DNQ students), this functionality will generate a parent Sped program record to enable to the selected Sped Event to publish.

The generated Sped program record will have the following fields:

  • beginDate

    • The event date of the event record that needs to be sent.

  • programReference

    • Existing logic

  • studentReference

    • Existing logic

  • endDate

    • The event date of the event record that needs to be sent.

  • specialEducationLevelOfIntegrationDescriptor

    • Required field in the ODS. A valid value will be published that will not be stored in the PowerSchool database.

  • primaryAreaOfExceptionalityDescriptor

    • Required field in the ODS. A valid value will be published that will not be stored in the PowerSchool database.

  • alternateInstruction

    • Required field in the ODS. A valid value will be published that will not be stored in the PowerSchool database.

Resource Output

  • A separate record is published for each enrollment period the student was in Special Education.

  • The StudentSpecialEducationProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssocation.

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).

Data Element

Description

Data Type

Stored in [Table]Field

Req’d

eventDate

The date of the event.

Datetime

[S_NM_STU_SPEDEVENTS_C]EventDate

M

specialEducationEventTypeDescriptor

The special education event type.

Special Education Event Type Descriptor Set

String

[S_NM_STU_SPEDEVENTS_C]EventType


M

studentSpecialEducationProgramAssociationReference

/beginDate

The earliest date the student is involved with the special education program. This will be the student's latest school entry date.

Datetime

[S_NM_STU_SPEDEVENTS_C]EventDate

M

/educationOrganizationId

The school associated with this student. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number -

[Students]LocationCode

[Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

M

/programEducationOrganizationId

The LEA associated with this student and program. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+000

Integer

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

The last 3 digits will be 000

M

/programName

The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.

String

Always Special Education

M

/programTypeDescriptor

Program Type - The type of program.

Type

Always Special Education

M

/studentUniqueId

A unique number assigned to the student by the state. 

String

[Students]State_StudentNumber

M

specialEducationEventReasonDescriptor

The special education event reason.

Special Education Event Reason Descriptor Set

Note: Use the Event Reason of 13 - Did Not Qualify for any students that ultimately did not qualify for Special Education.

Functionality to publish these events is being worked on and, until that is released, these events will not be published to NOVA.

String

[S_NM_STU_SPEDEVENTS_C]EventReason


specialEducationNonComplianceReasonDescriptor

The special education non compliance reason.

Special Education Non Compliance Reason Descriptor Set

String

[S_NM_STU_SPEDEVENTS_C]SPEDNonComplianceReason




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.