PowerSchool SIS Wyoming

S_WY_SEN_X (ver 15.8.0)

This table is an extension to the Spenrollments table and contains Special Education program data.

Column Name

Version

Data Type

Description

SpenrollmentsDCID

15.8.0

Number(10,0)

Primary Key

Assessment

15.8.0

Varchar2(2)

Indicates the type of assessment accommodations given to the student. Migrated from [Spenrollments.WY_Assessment].

AssistiveTechnology

15.8.0

Varchar2(1)

Indicates that the student uses Assistive Technology (AT) equipment or receives AT services. Migrated from [Spenrollments.WY_AssistiveTechnology].

DirectServices

15.8.0

Varchar2(5)

The percent of direct special education services received. No longer used by application. Migrated from [Spenrollments.WY_Direct_Services].

Environment

15.8.0

Varchar2(2)

Indicates the environment in which Special Education service is provided to the student. Migrated from [Spenrollments.WY_Environment].

EvaluationComplete

15.8.0

Date

Date when the student is identified as a student with a disability and the educational needs are determined.. Migrated from [Spenrollments.WY_EvaluationComplete].

ExtendedSchoolYear

15.8.0

Varchar2(1)

Indicates that the student eligible for Extended School Year (ESY) services. Migrated from [Spenrollments.WY_ExtendedSchoolYear].

IndirectServices

15.8.0

Varchar2(5)

The percent of direct special education services received. No longer used by application. Migrated from [Spenrollments.WY_Indirect_Services].

InitialConsent

15.8.0

Date

Date when initial consent was received for the student. Migrated from [Spenrollments.WY_InitialConsent].

InitialIEP

15.8.0

Date

Date when an initial IEP meeting was held. Migrated from [Spenrollments.WY_InitialIEP].

PrimaryDisability

15.8.0

Varchar2(2)

Indicates the primary disability of the student. Migrated from [Spenrollments.WY_Primary_Disability].

Related1

15.8.0

Varchar2(2)

Special Education related services received by the student. Migrated from [Spenrollments.WY_Related1].

Related2

15.8.0

Varchar2(2)

Special Education related services received by the student. Migrated from [Spenrollments.WY_Related2].

Related3

15.8.0

Varchar2(2)

Special Education related services received by the student. Migrated from [Spenrollments.WY_Related3].

Related4

15.8.0

Varchar2(2)

Special Education related services received by the student. Migrated from [Spenrollments.WY_Related4].

Related5

15.8.0

Varchar2(2)

Special Education related services received by the student. Migrated from [Spenrollments.WY_Related5].

ResSchoolID

15.8.0

Varchar2(10)

A valid 7-digit school ID of the school responsible for the IEP of the student. Not Migrated from [Spenrollments.WY_Res_SchoolID].

SecondaryDisability

15.8.0

Varchar2(2)

Indicates the secondary disability of the student. No longer used by application. Migrated from [Spenrollments.WY_Secondary_Disability].

ServStartDate

15.8.0

Date

Date when the student started receiving any special education services in the district. No longer used by application. Migrated from [Spenrollments.WY_ServStartDate].

ServSchoolID

15.8.0

Varchar2(10)

A valid 7-digit school ID of the school responsible for providing services listed on the IEP of the student. Migrated from [Spenrollments.WY_Serv_SchoolID].

SpecialEducation1

15.8.0

Varchar2(2)

Type of instruction provided to meet the unique needs of the student with disability. Migrated from [Spenrollments.WY_SpecialEducation1].

SpecialEducation2

15.8.0

Varchar2(2)

Type of instruction provided to meet the unique needs of the student with disability. Migrated from [Spenrollments.WY_SpecialEducation2].

SpecialEducation3

15.8.0

Varchar2(2)

Type of instruction provided to meet the unique needs of the student with disability. Migrated from [Spenrollments.WY_SpecialEducation3].

SpecialEducation4

15.8.0

Varchar2(2)

Type of instruction provided to meet the unique needs of the student with disability. Migrated from [Spenrollments.WY_SpecialEducation4].

OutOfStateTransfer

15.8.0

Varchar2(1)

Indecator for out of state transfer for SPED