Troubleshooting

 

If you are running into issues with the PowerSchool SIS integration, try setting your Administrator account in PowerSchool to be in Security Group 9.

 

 

Table of Contents

 

Mapping

 

Student Mappings

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
external_id student/id Students.DCID
first_name student/name/first_name Students.First_Name
middle_init   
last_name student/name/last_name Students.Last_Name 
suffix   
nickname   
login student/student_username  Students.Student_Web_ID 
password default password set in domain control 
email student/contact_info/email PSM_StudentContact.Email
user_type "S" 
organization_id student/school_enrollment/school/id Schools.DCID 
enabled "1"  
display_id   
google_email_address email if email matches google apps domain  

 

Once a user is set to use Google Apps SSO authentication they can only be removed manually. If they are not automatically set to this authentication via the import, the user can be set manually and following imports will not change this authentication type.

Please note that we will only currently pull Students with an 'Active' enrollment status in PowerSchool SIS, as this is the default in the PowerSchool API.  In PowerSchool SIS, this means that their enroll_status is equal to 0.

We will pull in Teachers who are Active.  They do not necessarily need to have a class attached to their account - if they are Active and in a school you have selected to be brought in via the integration, then they will be imported.

 

 

Users Levels (Students)

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
external_id  student/id Students.DCID 
level_id  student/school_enrollment/grade_level  Students.Grade_Level

 

 

Teacher Mappings 

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
external_id staff/id Teachers.DCID
first_name staff/name/first_name Teachers.First_Name 
middle_init   
last_name staff/name/last_name Teachers.Last_Name
suffix   
nickname   
login staff/teacher_username Teachers.TeacherLoginId 
password default password set in domain control  
email staff/emails/work_email Users.Email_Addr 
user_type "T"
organization_id staff/school_affiliation/school_id Schools.DCID 
enabled "1"
display_id   
google_email_address email if email matches google apps domain 

 

 

Parent Mappings 

PowerSchool Learning Values PowerSchool SIS Database Column
external_id Guardian.GuardianID
first_name Guardian.First_Name 
middle_init   
last_name Guardian.Last_Name
suffix   
nickname   
login Guardian.Username 
password default password set by your School Advisor  
email Guardian.Email
user_type "P"
organization_id Guardian.DCID 
enabled "1"
display_id   
sso_email_address email if email matches Google apps or Office 365 domain 

Parent imports must be enabled in Domain Control under Manage Domain > PowerSchool Config. When a School is selected to be automatically imported, students with associated guardians will be brought into your Learning domain.

 

 

Organizational Mappings

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
organization_id school/id Schools.DCID
name school/name Schools.Name
parent_organization_id   

 

Course Mappings

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
class_id section/id Sections.DCID
name course/course_name (section/section_number) - section/expression Courses.Course_Name (Sections.Section_Number) - Sections.Expression 
shortname  
description  
code course/course_number Courses.Course_Number 
year section/term_id Terms.DCID
teacher_id section/staff_id Teachers.DCID
organization_id section section/school_id Schools.DCID 

PowerSchool courses must be active and have a teacher assigned in order to come over to PowerSchool Learning.

 


Roster

PowerSchool Learning Values Powerschool API Attribute Path PowerSchool Database Column
class_id section_enrollment/section_id Sections.DCID
user_id section_enrollment/student_id Students.DCID 

 

 

Grade Mappings 

Assignments

PowerSchool API Attribute Path PowerSchool Learning Field
section [Class Import ID]
assignment/name [Gradable Title]
assignment/abbreviation [First 15 characters of the Gradable Name + "-HK"
assignment/description [Gradable Description]
assignment/date_assignment_due [Gradable Due Date] or [Today]
assignment/category null*
assignment/extra_credit_points [Gradable Points] if extra credit
assignment/include_final_grades null
assignment/points_possible [Gradable Points] if not extra credit
assignment/publish_scores null
assignment/publish_state "PUBLISH_NEVER"
assignment/publish_days_before_due null
assignment/publish_specific_date null
assignment/scoring_type "POINTS"
assignment/weight null

 *The category is set to 'TEST' by the PowerSchool API, unless there is no 'TEST' category, in which case it is set to 'UNDEFINED'

Assignment Scores

PowerSchool API Attribute Path PowerSchool Learning Field
assignment_score/student_id [Student Import ID]
assignment/id [Gradable ID]
assignment_score/score_entered [Score]

 Table of Contents

 

PowerSchool Gradebook Resources

 

 

Table of Contents 

 

Download the plugin below:

Plugin v1.3 is compatible with PowerSchool SIS versions 9.2 and up. This is the version that will allow for the import of co-Teachers.

 

If you do not have PowerSchool SIS version 9.2 or later, please use Plugin v1.1. v1.1 will not allow the import of co-teachers.