Skip to main content
Skip table of contents

PowerSchool SIS Integration

This guide provides information for data elements that are written between PowerSchool SIS and PowerSchool Special Programs to mitigate dual data entry. The intent is to provide special education data so that all state reports can be generated for PowerSchool SIS. PowerSchool SIS can autofill information into the special education forms (such as student’s address information).

Data Exchanged between PowerSchool SIS and PowerSchool Special Programs

PowerSchool - Student Import Data

PowerSchool SIS owns student demographic data (e.g., student name, gender, GTID). This data is imported into Special Programs using the Student Demographics import that can be generated manually or configured to run on a scheduled basis using the Data Connectivity Tool. This and other Import Layouts can be found by navigating to Administration, Configuration, Integration, Import Layouts using the data source type: PowerSchool SIS Rest API.

Reports

A scheduled task is run to upload data to PowerSchool SIS, comparing the data in PowerSchool SIS to the data in the export reports (PowerSchool Special Programs). If the data does not exist, the data will be added to PowerSchool SIS. If the data exists, the data will be updated.

The following reports are available in Reporting, Standard Reports, and PowerSchool Export Reports.

Resources

Understanding the Mapping Table

Each setup table may include some or all of the following elements. Reports will not display elements that are not pertinent to that report.

  • Breadcrumbs and Navigation – The navigation aid shows the path to the data entry page as listed on the page in PowerSchool Special Programs. Each “>” indicates a new page or link. Example: Student > Profile.

  • Data Element – The name of the field as it appears in the state report.

  • Field Name – The name of the field where the data is stored./ {PrimaryDisability}

  • Reports – The name of each report that uses the data element. This field may be populated with “Required Setup” or “Not Required” to indicate whether the data element should be configured for Utah state reporting not specific to a report.

Student Import Layout

Student Import Layout (model) and Student Change Notification (model)

The following data elements will process field information from PowerSchool SIS to PowerSchool Special Programs. The Student Import Layout (Model) and Student Change Notification (model) can be found in Administration > Integration. Data will flow from the Contact and Student Information and Parent Guardian Information screen into the student’s profile record, contacts 1-4, and disability records.

PowerSchool Special Programs

PowerSchool SIS

Data Element - PowerSchool Special Programs

Information

ID

{student_local_id}

{ID}

Profile > Student Information

FirstName

{student_name_first_name}

{FirstName}


LastName

{student_name_last_name}

{LastName}


BirthDate

{student_demographics_birth_date:6,2}/{student_demographics_birth_date:9,2}/{student_demographics_birth_date:1,4}

{BirthDate}


Student Address

{student_addresses_physical_street}


Student City

{student_addresses_physical_city}



StudentState

{student_addresses_physical_state_province}

{City}{Province}


StudentZipCode

{student_addresses_physical_postal_code}

{PostalCode}


StudentHomePhone

{student_phones_main_number}

{HomePhone}


Grade

{student_school_enrollment_grade_level:1,2<0}

{Grade}


EnrollmentStartDate

{student_school_enrollment_entry_date:6,2}/{student_school_enrollment_entry_date:9,2}/{student_school_enrollment_entry_date:1,4}

{DistEnrollStartDate}


EnrollmentEndDate

{student_school_enrollment_exit_date:6,2}/{student_school_enrollment_exit_date:9,2}/{student_school_enrollment_exit_date:1,4}

{DistEnrollEndDate}


Race[Black]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Black]}


Race[Asian]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Asian]}


Race[Hispanic]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Hispanic]}


Race[White]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[White]}


Race[Pacific]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Pacific]}


Race{Native]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Native]}


MiddleName

{student_name_middle_name}

{MiddleName}


IntegrationIDT

{__DS__?InstanceID}:{student_id}



Gender

{student_demographics_gender}

{Gender}


Parent2FirstName

{student_contact_mother/1}

{Parent2FirstName}

Profile > Parent Guardian Information

Parent2LastName

{student_contact_mother/2}

{Parent2LastName}


Parent1FirstName

{student_contact_father/1}

{Parent1FirstName} 


Parent1LastName

{student_contact_father/2}

{Parent1LastName}


Parent1Email

{student_contact_guardian_email}

{Parent1Email}


Race[None]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[None]}


School

{__DS__?InstanceID}:{student_school_enrollment_school_id}

{School}


Student Contact Import Layout (Future Unlimited Contact layout)

The following data fields will be imported from PowerSchool SIS to PowerSchool Special Programs, Profile Contact and Student Guardian for student and contact information. This layout can be found in Administration > Integration > PowerSchool – Student Contact Import.

PowerSchool Special Programs

PowerSchool SIS

Data Element - PowerSchool Special Programs


Student

{__DS__?InstanceID}:{student_id}

{ID}


FirstName

{first_name}

{FirstName}


LastName

{last_name}

{LastName}


MiddleName

{middle_name}

{MiddleName}


Prefix

{prefix}



Suffix

{suffix}



Address

{[{[{street} {unit} {linetwo}]-< > }]@<*>" "*>>" "}

{Street}        

{Address2}


City

{city}



State

{state}

{City}{Province}


PostalCode

{postal_code}

{PostalCode}


AddressType

{address_type<A1>}



Phone1

{phone1}

{Parent1HomePhone}


Phone1Ext

{phone1_ext}



Phone1Type

{phone1_type<A1>}

Home Phone Label


Phone2

{phone2}

{Parent1WorkPhone}


Phone2Ext

{phone2_ext}



Phone2Type

{phone2_type<A1>}

Work Phone Label


Phone3

{phone3}

{Parent1CellPhone}


Phone3Ext

{phone3_ext}



Phone3Type

{phone3_type<A1>}

Cell Phone Label


Email1

{email1}

{Parent1Email}


Email1Type

{email1_type<A1>}



Email2

{email2}

{Parent2Email}


Email2Type

{email2_type<A1>}



RelationshipType

{relationship_type<A1>}

{Parent1Relationship}

1-4

IsCustodial

{is_custodial}

{@IFELSE(Parent1JointCust, "Yes", "No")}

Relabel Has Custody

IsEmergency

{is_emergency}



LivesWith

{lives_with}



ReceivesMail

{receives_mail}

{Parent1GetLetters}


SchoolPickup

{school_pickup}



Gender

{gender}

{Gender}

Allow Override With Empty, Set as Empty When Not Valid

Sequence

{Sequence}


Allow Override With Empty, Set as Empty When Not Valid

#DeleteFlag

{student_contact_rel_id~<*>""?"true":"false"}



IntegrationIDT

{__DS__?InstanceID}:{student_contact_rel_id}



PowerSchool Exports

See also: Export List Report Settings.

PowerSchool State Reporting Export (S_UT_SEN_X)

The following data fields are exported from PowerSchool Special Programs to PowerSchool SIS. This information can be found in Reporting > Standard Reports > PowerSchool SIS Export > PowerSchool State Reporting Export (S_UT_SEN_X). Student data comes from PowerSchool Special Programs, Student Profile called Reporting.

PowerSchool Special Programs

PowerSchool SIS

Data Element - PowerSchool Special Programs


Integration IDT




SPEnrollmentSDCID

spenrollmentsdcid



RegulareducationPortion

RegularEducationPortion

RegPercent.Code


EducationalSetting

EducationalSetting

Environment.Code


isonepercent

IsOnePercent


{AltAssessment}


extschoolyear

ExtSchoolYear


{ESY}


PowerSchool State Reporting Export (SPEnrollment)

State Field Name

PowerSchool Special Programs

PowerSchool SIS


Data Element

Notes

Integrationidt




S4=

Student Number

{ID}


·          

S1 & S4 records required

StudEntID

{StateID}


·          


Code 1

{PrimaryDisability:F"InUse"}


·          

Primary Disability

Code 2

{TimePerDay:F"InUse"}


·          

TimePerDay

ExitCode

{SpecialEdExitReason:F"Special_Education"}


·          

Special Ed Exit Reason

ProgramID

{Environment:F"InUse"}


·          


EnterDate

{InitEligibilityDate}


·          

Special Ed Start Date

ExitDate

{SpecialEdExitDate}


·          

Special Ed Exit Date

PowerSchool 504 SIS Export – S4

The following data fields will be exported from PowerSchool Special Programs to PowerSchool SIS. This information can be found in Reporting > Standard Reports > PowerSchool SIS Export, S_UT_SEN_X. Student data comes from PowerSchool Special Programs, Student Profile called Section 504. 

At least one disability is required for each Section 504 student.

State Field Name

PowerSchool Special Programs

PowerSchool SIS

S_UT_SEN_X

This is an extension of the SpEnrollments table.

Data Element

Notes

Record ID




S4=

Student Number

{ID}


·          

S1 & S4 records required

Section 504 Entry Date

{Section504EntryDate}

[SpEnrollments]Enter_Date



Section 504 Exit Date

{Section504ExitDate}

[SpEnrollments]Exit_Date



Section 504 Exit Reason

{ExitReason} {ExitReason_Other}{-ExitReason_Other}

[SpEnrollments]ExitCode



Code

Meaning

A

Returned to regular placement

P

Promoted to the next grade level; expected to return to LEA

S

Service change

X

Exited school

Blank

If YIC Exit Date is blank


LEA Number

{ThisDistrict} ID

LEA Number would be the PS district so:

[Prefs]Value where [Prefs]name = districtnumber



School Number

{=School.ID}

[SpEnrollments]SchoolID



Autism

Y/Blank

Autism


Disabilities entered in 1-3 will indicate Y/N in the appropriate fields below..

{Disability1}

{Disability2}

{Disability3}

Brain Injury or Concussion Impairment

Y/Blank

BraininjConcussionImpmnt



Hearing Impairment

Y/Blank

Hearingimpmnt



Learning Impairment

Y/Blank

Learningimpmnt



Major Bodily Function Impairment

Y/Blank

MajorBodilyFunctionImprmnt



Medical Impairment

Y/Blank

MedicalImprmnt



Mental Health Impairment

Y/Blank

MentalHealthImprmnt



Orthopedic Impairment

Y/Blank

OrthopedicImprmnt



Other Impairment

Y/Blank

OtherImprmnt





JavaScript errors detected

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

If this problem persists, please contact our support.