PowerSchool SIS Integration Management

warning_2.pngWarning: This document contains instructions for adjusting app synchronization settings that can adversely affect your device data, user data, and/or user mapping settings in Incident IQ. As such, only qualified personnel should proceed with making adjustments to the settings outlined in this document.


Guide Overview

The PowerSchool App allows administrators to seamlessly integrate PowerSchool with Incident IQ by automating most aspects of your data upload. This provides administrators the ability to easily manage email translation settings, as well as the sync and mapping options for users, groups, and locations between the two programs in one convenient location. The following guide provides an in-depth overview of managing this application in Incident IQ.

Not what you were looking for? Perhaps one of these other guides will help:


Guide Index

You can use the following links below to quickly navigate to a specific section in this document. To quickly return to this index simply use the Return to Index link located at the end of any section.

  1. Accessing the PowerSchool App Management
  2. Overview Tab
  3. Settings Tab
  4. Location Mappings Tab
  5. Sync History Tab
  6. User History Tab
  7. Models Tab
  8. Using the PowerSchool Widget
  9. Filter by SIS User Status


Accessing the PowerSchool App Management

You can edit all information entered during installation using the management options. To do so go to the Apps Management page by selecting Incident IQ Apps > Manage on the left navigation bar. On the Installed Apps tab on the Apps Management page select Options on the PowerSchool app.


This will take you to the PowerSchool App management page where you will be able to select the following tabs:

  • Overview tab where you to view basic user and group data, as well as run manual syncs with PowerSchool.
  • Settings tab where you to view and update your authentication (API Url, consumer key, and consumer secret) as well as your field mappings.
  • Location Mappings tab where you can change your location mappings between PowerSchool and Incident IQ.
  • Sync History tab where you view the sync data for each sync including users updated, skipped, created, and deactivated.
  • User History tab where you can view the user revision history in Incident IQ, as well as the current groups this user belongs to.
  • Models tab where you can set whether PowerSchool is available for use in ticket submission within Incident IQ.

[Return to Index]


Overview Tab

This tab provides you with a brief summary of your current users, groups, and changes made to users in Incident IQ during the last sync with PowerSchool.


If necessary, the Authentication section allows you to view and manage the following PowerSchool API settings:

  • Url
  • Consumer Key
  • Consumer Secret


You can also start manual syncs at any time by selecting the Start Sync button near the bottom of the page.


[Return to Index]


Settings Tab

This tab allows you to change or validate your PowerSchool API data, as well as make changes to your user data options.

The Authentication section allows you to view and manage the following PowerSchool API settings:

  • Url
  • Consumer Key
  • Consumer Secret


The User Mapping section contains two key features that are managed by iiQ Administrators. Changes to settings here can only be made upon request to a member of the Incident IQ support team. These settings will only affect account information stored in iiQ. Data stored in PowerSchool will not be affected by these features.

The Translate Email feature allows iiQ to translate the domain name of your district's PowerSchool email addresses to another domain name inside of iiQ. This is used in cases when the email domains of your AD/SSO accounts and PowerSchool do not match. When set, the email translation can make your PowerSchool emails appear exactly the same as your AD/SSO emails, ensuring user data between the two systems matches correctly in iiQ.

Alternatively, the Append to Username for Email lookup feature allows iiQ to append an email domain to a user's username. This is used in cases where a user does not have an email address attached to their PowerSchool account. When set, the appended information will make the username appear the same as the AD/SSO account format, ensuring user data between the two systems matches correctly in iiQ.


The Import Options section controls when iiQ imports, skips or deactivates accounts or calendars based on PowerSchool data. You have access to the following options:

  • Add Rooms to Users: Assign the user with their homeroom. 
  • Skip import of calendars: Do not import the SIS calendars.

The next following options can only be made upon request to a member of the Incident IQ support team. This includes the ability to do the following:

Please note, we do not import users from your SIS integration. This would create duplicates within iiQ when using your SSO integration to create users. 

  • Import students: Allows the creation of accounts based on PowerSchool users of type: student.
  • Import teachers: Allows the creation of accounts based on PowerSchool users of type: teachers.
  • Import administrators: Allows the creation of accounts based on PowerSchool users of type: administrator.
  • Import other users: Allows the creation of accounts based on PowerSchool users such as parents or guardians.
  • Include inactive users: Allows the creation of iiQ accounts based on users marked as inactive in PowerSchool.
  • Deactivate users: Automatically removes user accounts authenticated by PowerSchool from iiQ when they are deactivated in Aeries.
  • Allow Non-Agent Role Downgrades: Allows iiQ to automatically downgrade agent or admin users to a requestor level account if their account is downgraded in PowerSchool.
  • Skip import of user relationships: Do not import relationships for user (e.g. parents, guardians)


The Field Mapping section allows you to control what fields get updated and what priority the PowerSchool has when updating user accounts during syncs. The left-hand column of checkboxes allows you to enable and disable user data fields for use in data syncs.

Please note that unchecking a box will prevent any app from syncing data into the deselected field. For instance, if you uncheck the Phone option, no app will be able to write data into this field, not just PowerSchool.


You can also set the app priority in the right-hand column. Selecting Allow app to Update will prioritize other applications over the PowerSchool sync if another system is already pulling in the selected system. Alternatively, selecting Always Update places no prioritization on which app will update this field.


Make sure to select Save after making any changes before you navigate away from this tab. Otherwise, your new settings will not update in Incident IQ.

[Return to Index]


Location Mappings Tab

This tab allows you to select or modify your current location mappings between PowerSchool and Incident IQ. You can set or modify your current default location as well as match locations in PowerSchool to the locations in Incident IQ.


[Return to Index]


Sync History Tab

This tab allows you to look up the data for any sync between Powerschool and Incident IQ. Every sync, whether it completed successfully or not, is logged for reference purposes and available for review.

Clicking on View Details will display the number of factors that have been added, updated, no change, skipped, or deleted during the course of that particular sync.


When viewing the syncs details, you also have access to Download SIS Data. This is the raw data that Powerschool integration is sending over to iiQ.  You can download the raw data to help troubleshoot any issues or concerns with any syncs. 


[Return to Index]


User History Tab

This tab allows you to look up the PowerSchool data that Incident IQ is able to view from the selected user. The information displayed includes what type of user they are, their username, first and last names, organization groups they belong to, as well as their sync/change history.


[Return to Index]


Models Tab

The Models tab allows you to set whether PowerSchool is available for ticket submission. By default, PowerSchool is enabled, but if you do not wish to utilize the ticketing functionality you can simply uncheck the model activation box.


[Return to Index]


The PowerSchool Widget

Administrators in districts with a PowerSchool integration can access basic PowerSchool data on a user directly from their user page using the PowerSchool Widget. This tool allows you to immediately view their PowerSchool Id, Identifier, Role, Status, Grade, Location, and Homeroom information.

tips.pngTip: Homeroom and grade-level data are also available as filters for user views. For more information on applying filters to user views check out the Filtering the Users View section of this document. Additionally, you can find out more about Custom Views by clicking here.


They can also access the courses a user is enrolled in as well as the Incident IQ and PowerSchool sync history of the user.


Additionally, should you need to make any changes to a user's account, you can access the following features using the Options button:

  • Sync User: This option allows you to sync this individual user's data without the need for a full sync between Incident IQ and PowerSchool.
  • Remove link to SIS User: This option allows you to unassociate the PowerSchool account that is tied to this Incident IQ account.
  • Change SIS User: This option allows you to change the PowerSchool account that is tied to this Incident IQ account.


[Return to Index]


Filter by SIS User Status

Filter any user view by your SIS user status (Active, Not Active, Not Linked). On the filtering window select the filter SIS User Status


[Return to Index]

Was this article helpful?
2 out of 3 found this helpful