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.
![](../../__attachments/770345743/image2020-3-20_18-11-44.png?inst-v=414df02a-56c2-487a-a448-70251fa07e77)
Resources
Help Guides and Support are located under the question tag icon in the application header.
Data Connectivity Tool (DCT) resources are located under Administration > Configuration > Integration > Select the More drop-down.
Data Connectivity Guide – provides step-by-step instructions for setting up integration using the data connectivity tool and managing settings.
Data Connectivity Tool – plug-in required for integration.
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} | Profile > Student Information | |
FirstName | {student_name_first_name} | ||
LastName | {student_name_last_name} | ||
BirthDate | {student_demographics_birth_date:6,2}/{student_demographics_birth_date:9,2}/{student_demographics_birth_date:1,4} | ||
Student Address | {student_addresses_physical_street} | ||
Student City | {student_addresses_physical_city} | ||
StudentState | {student_addresses_physical_state_province} | ||
StudentZipCode | {student_addresses_physical_postal_code} | {PostalCode} | |
StudentHomePhone | {student_phones_main_number} | {HomePhone} | |
Grade | {student_school_enrollment_grade_level:1,2<0} | ||
EnrollmentStartDate | {student_school_enrollment_entry_date:6,2}/{student_school_enrollment_entry_date:9,2}/{student_school_enrollment_entry_date:1,4} | ||
EnrollmentEndDate | {student_school_enrollment_exit_date:6,2}/{student_school_enrollment_exit_date:9,2}/{student_school_enrollment_exit_date:1,4} | ||
Race[Black] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
Race[Asian] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
Race[Hispanic] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
Race[White] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
Race[Pacific] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
Race{Native] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
MiddleName | {student_name_middle_name} | ||
IntegrationIDT | {__DS__?InstanceID}:{student_id} | ||
Gender | {student_demographics_gender} | ||
Parent2FirstName | {student_contact_mother/1} | Profile > Parent Guardian Information | |
Parent2LastName | {student_contact_mother/2} | ||
Parent1FirstName | {student_contact_father/1} | ||
Parent1LastName | {student_contact_father/2} | ||
Parent1Email | {student_contact_guardian_email} | ||
Race[None] | {student_ethnicity_race_scheduling_reporting_ethnicity} | ||
School | {__DS__?InstanceID}:{student_school_enrollment_school_id} |
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} | ||
FirstName | {first_name} | ||
LastName | {last_name} | ||
MiddleName | {middle_name} | ||
Prefix | {prefix} | ||
Suffix | {suffix} | ||
Address | {[{[{street} {unit} {linetwo}]-< > }]@<*>" "*>>" "} | ||
City | {city} | ||
State | {state} | ||
PostalCode | {postal_code} | ||
AddressType | {address_type<A1>} | ||
Phone1 | {phone1} | ||
Phone1Ext | {phone1_ext} | ||
Phone1Type | {phone1_type<A1>} | Home Phone Label | |
Phone2 | {phone2} | ||
Phone2Ext | {phone2_ext} | ||
Phone2Type | {phone2_type<A1>} | Work Phone Label | |
Phone3 | {phone3} | ||
Phone3Ext | {phone3_ext} | ||
Phone3Type | {phone3_type<A1>} | Cell Phone Label | |
Email1 | {email1} | ||
Email1Type | {email1_type<A1>} | ||
Email2 | {email2} | ||
Email2Type | {email2_type<A1>} | ||
RelationshipType | {relationship_type<A1>} | 1-4 | |
IsCustodial | {is_custodial} | {@IFELSE(Parent1JointCust, "Yes", "No")} | Relabel Has Custody |
IsEmergency | {is_emergency} | ||
LivesWith | {lives_with} | ||
ReceivesMail | {receives_mail} | ||
SchoolPickup | {school_pickup} | ||
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 |
| |
extschoolyear | ExtSchoolYear |
|
PowerSchool State Reporting Export (SPEnrollment)
State Field Name | PowerSchool Special Programs | PowerSchool SIS | Data Element | Notes |
---|---|---|---|---|
Integrationidt | S4= | |||
Student Number | · | S1 & S4 records required | ||
StudEntID | · | |||
Code 1 | {PrimaryDisability:F"InUse"} | · | Primary Disability | |
Code 2 | {TimePerDay:F"InUse"} | · | TimePerDay | |
ExitCode | · | Special Ed Exit Reason | ||
ProgramID | {Environment:F"InUse"} | · | ||
EnterDate | · | 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 | · | S1 & S4 records required | ||||||||||||||
Section 504 Entry Date | [SpEnrollments]Enter_Date | |||||||||||||||
Section 504 Exit Date | [SpEnrollments]Exit_Date | |||||||||||||||
Section 504 Exit Reason | {ExitReason} {ExitReason_Other}{-ExitReason_Other} | [SpEnrollments]ExitCode |
| |||||||||||||
LEA Number | 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.. | |||||||||||||
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 |