PowerSchool SIS Integration
This guide provides information for data elements written to PowerSchool Student Information System (SIS) from PowerSchool Special Programs (PSSP) to mitigate dual data entry. The intent is to provide special education data so that all state reports can be generated for your SIS.
Data Imports
The SIS owns student demographic data. (such as, student name, gender, etc.). These data fields are imported into PowerSchool Special Programs using the Student Demographics import that can be generated manually or configured to run on a scheduled basis using an API Integration Tool.
To find this and other Import Layouts, navigate to Administration, Configuration, Integration, and then Import Layouts using the data source type: PowerSchool SIS Rest API.
For example, PowerSchool Student Import (model): Import Layout and Field List.
Refer to PowerSchool SIS Michigan Compliance Help.
PowerSchool Special Programs to PowerSchool SIS Fields
This table provides an overview of the fields in PowerSchool Special Programs and the fields they correlate to within PowerSchool SIS.
The Export reports are found under PowerSchool Special Programs. Reporting, Standard Reports, and PowerSchool Export.
PowerSchool - Students - S/P - MI - GC
PowerSchool Alert Export
PowerSchool Special Programs | Data Flow | PowerSchool SIS | ||||||
|---|---|---|---|---|---|---|---|---|
Profile Label | Section Field | Keyword Table | Direction | Many-to-One Predicate | Screen Label | Table | Column | Logic/Notes |
Students | CEPI Birth to 3 | NA | NA | NA | Michigan State Information, Early On | NA | NA | NA |
Eligibility Reasons | EligibilityReasonList | EOEligibilityReason | Export | Location = Student.School | Eligibility Reason | S_MI_STU_GC_X | ELIGIBILITYREASON | NA |
Students, EnrollmentsSecurity | Main | NA | NA | NA | Michigan State Information, General Education FTE | NA | NA | NA |
General ED FTE | GenEdFTE | NA | Export | NA | General Education FTE | S_MI_STU_GC_X | FTE | NA |
Students | CEPI | NA | NA | NA | Michigan State Information, Initial IEP | NA | NA | NA |
Date of Parental Consent | ConsentEvaluate | NA | Export | Location = Student.InitialSchool | Date of Parental Consent | S_MI_STU_GC_X | SECONSENTDATE | Student.InitIEPDataNotSubmit |
Days Beyond Timeline | IEPLateDays | NA | Export | Location = Student.InitialSchool | Days Beyond Timeline | S_MI_STU_GC_X | SEINITIALDAYS | Student.InitIEPDataNotSubmit |
Result of Initial IEP | InitialEligibility | InitialResultsTable | Export | Location = Student.InitialSchool | Result of Initial IEP | S_MI_STU_GC_X | SEINITIALRESULT | Student.InitIEPDataNotSubmit AND (Globals.CurrentCountDate - BirthDate) <= 26 |
Timeliness of Initial IEP | TimelinessResult | IEPExtensionReasons | Export | Location = Student.InitialSchool | Timeliness of Initial IEP | S_MI_STU_GC_X | SEINITIALTIMELY | Student.InitIEPDataNotSubmit |
Part C Transition Timeliness | PartCTransitionTimeliness | PartCTimelinessCodes | Export | Part C Transition Timeliness | S_MI_STU_GC_X | SEINITIALTIMEPC | Student.InitIEPDataNotSubmit | |
Students, EnrollmentsSecurity | Main | NA | NA | NA | Michigan State Information, Initial IEP | NA | NA | NA |
Initial IEP Completion Date | InitialIEPDate | NA | Location = Student.InitialSchool | Initial IEP Completion Date | S_MI_STU_GC_X | SEFAPEDate | Student.InitIEPDataNotSubmit | |
Initial IEP Completion Date | InitialIEPDate | NA | Export | Location = Student.InitialSchool | Determination Date | S_MI_STU_GC_X | SEINITIALRESULTDATE | Student.InitIEPDataNotSubmit |
Students | Section 504 | NA | NA | NA | Michigan State Information, Program Participation | NA | NA | NA |
IS_504 | NA | NA | NA | 9210 - Section 504 | S_MI_STU_GC_X | FLAGSECTION504 | ||
Students | CEPI | NA | NA | NA | Michigan State Information, School Demographics | NA | NA | NA |
Building Pupil Would Otherwise Attend | OtherBuilding | NA | Export | Location = Student.School | Building Pupil Would Otherwise Attend | S_MI_STU_GC_X | BLDGOTHERWISEATTEND | NA |
Students | CEPI | NA | NA | NA | Michigan State Information, Special Education | NA | NA | NA |
IS_SPED | NA | Export | NA | Include SE Data in MSDS Reporting? | S_MI_STU_GC_X | FLAGSPECED | NA | |
Secondary Disability | AddCharacteristic | DisabCharacteristics | Export | FTE > 0 | Secondary Disability | S_MI_STU_GC_X | SEADDDISABILITY | NA |
Type of Plan | PlanType | PlanTypes | Export | FTE > 0 | Type of Plan | S_MI_STU_GC_X | SEPLANTYPE | |
Primary Educational Setting | PrimarySetting | EducationSettings | Export | FTE > 0 | Primary Educational Setting | S_MI_STU_GC_X | SEPRISETTING | NA |
Students, EnrollmentsSecurity | Main | NA | NA | NA | Michigan State Information, Special Education | NA | NA | NA |
Primary Disability | PrimaryDisability | Disabilities | NA | FTE > 0 | Primary Disability | S_MI_STU_GC_X | SEPRIDISABILITY | NA |
Completion Date | CompletionDate | NA | NA | FTE > 0 | Plan Date | S_MI_STU_GC_X | SEIEPDATE | |
Additional Plan Date | AdditionalPlanDate[P1] | NA | NA | FTE > 0 | Additional Plan Date 1 | S_MI_STU_GC_X | SEADDPLANDATE1 | |
Additional Plan Date | AdditionalPlanDate[P2] | NA | Export | FTE > 0 | Additional Plan Date 2 | S_MI_STU_GC_X | SEADDPLANDATE2 | |
Additional Plan Date | AdditionalPlanDate[P3] | NA | Export | FTE > 0 | Additional Plan Date 3 | S_MI_STU_GC_X | SEADDPLANDATE3 | |
Support Service | SupportService[C1] | SupportServiceCodes | Export | NA | Support Service 1 | S_MI_STU_GC_X | SESERVICE1 | SupportService[C1].CEPI |
Support Service | SupportService[C2] | SupportServiceCodes | Export | NA | Support Service 2 | S_MI_STU_GC_X | SESERVICE2 | SupportService[C2].CEPI |
Support Service | SupportService[C3] | SupportServiceCodes | Export | NA | Support Service 3 | S_MI_STU_GC_X | SESERVICE3 | SupportService[C3].CEPI |
Support Service | SupportService[C4] | SupportServiceCodes | Export | NA | Support Service 4 | S_MI_STU_GC_X | SESERVICE4 | SupportService[C4].CEPI |
Support Service | SupportService[C5] | SupportServiceCodes | Export | NA | Support Service 5 | S_MI_STU_GC_X | SESERVICE5 | SupportService[C5].CEPI |
Program Service Code | ProgramServiceCode[C1] | ProgramServiceCodes | Export | NA | Program Service Code 1 | S_MI_STU_GC_X | SEPRGM1 | NA |
Program Service Code | ProgramServiceCode[C2] | ProgramServiceCodes | Export | NA | Program Service Code 2 | S_MI_STU_GC_X | SEPRGM2 | NA |
Program Service Code | ProgramServiceCode[C3] | ProgramServiceCodes | Export | NA | Program Service Code 3 | S_MI_STU_GC_X | SEPRGM3 | NA |
Spec Ed Exit Reason | SpecialEdExitReason | SpEdExitReasons | Export | NA | Special Education Exit Reason | S_MI_STU_GC_X | SEEXITCODE | SpecialEdExitDate IS NOT NULL |
Spec Ed Exit Date | SpecialEdExitDate | NA | Export | NA | Special Education Exit Date | S_MI_STU_GC_X | SEEXITDATE | NA |
Placed By Another Dist IEP | PlacedInDistrict | NA | Export | Location = Student.InitialSchool | Placed by Another District IEP | S_MI_STU_GC_X | SEIEPANOTHERDIST | NA |
FTE | FTE | NA | Export | NA | Section 52 FTE | S_MI_STU_GC_X | FTE52 | Student.Section53 |
FTE | FTE | NA | Export | NA | Section 53 FTE | S_MI_STU_GC_X | FTE53 | NA |