PowerSchool to Hapara Integration column names
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFG
1
PowerSchool API Attribute PathPowerSchool description of attributePowerSchool Database ColumnHapara Sync Config Column NameHapara Extracted Spreadsheet Column NameNotes
2
course/idSequential number generated by the application, guaranteed to be unique.Courses.DCIDraw_course_id
3
course/course_nameName of the course.Courses.Course_NameCourseNameraw_course_name
4
course/course_numberNumber that is used to identify the course.Courses.Course_NumberCourseNumberraw_course_number
5
section/expressionThe schedule expression for the section, which is a representation of the day and period it is offered. It may be multiple if offered over several days, such as 2 (A) = 2nd period A days.Sections.ExpressionPeriodraw_expression
6
section/idSequential number generated by the application, guaranteed to be unique.Sections.DCIDSISIdraw_id
7
school/alternate_school_numberThe alternate school number for this school.Schools.Alternate_School_Numberraw_school_alternate_school_numberPossibly only in newer PS instances?
8
school/high_gradeThe highest grade level that will be attending this school.Schools.High_Graderaw_school_high_grade
9
school/idSequential number generated by the application, guaranteed to be unique.Schools.DCIDraw_school_id
10
school/low_gradeThe lowest grade level that will be attending this school.Schools.Low_Graderaw_school_low_grade
11
school/nameThe school's name.Schools.Nameraw_school_name
12
school/school_numberThe school number of the school.Schools.School_Numberraw_school_number
13
school/state_province_idSIF specific identifier.Schools.SIF_StatePrIdraw_school_state_province_idPossibly only in newer PS instances?
14
section/section_numberThe number for this section. While it is an alpha field, it is strongly recommended that numbers are used for this field.Sections.Section_NumberSectionraw_section_number
15
section/staff_idThe ID of the Staff.Teachers.DCIDraw_staff_id
16
staff/admin_usernameThe administrator's user name for signing in to PowerSchool.Teachers.LoginIdraw_teacher_admin_username
17
staff/teacher_usernameThe teacher's user name for signing in to PowerTeacher.Teachers.TeacherLoginIdraw_teacher_emailCalculated, but standard PS configuration resolves to teacher_username
18
raw_teacher_first_nameCopied from raw_teacher_name_first_name
19
staff/idSequential number generated by the application, guaranteed to be unique.Teachers.DCIDraw_teacher_id
20
raw_teacher_last_nameCopied from raw_teacher_name_last_name
21
staff/local_idThe staff number assigned by the school.Teachers.TeacherNumberraw_teacher_local_id
22
raw_teacher_middle_nameCopied from raw_teacher_name_middle_name
23
staff/name/first_nameThe staff's first name.Teachers.First_Nameraw_teacher_name_first_name
24
staff/name/last_nameThe staff's last name.Teachers.Last_Nameraw_teacher_name_last_name
25
staff/name/middle_nameThe staff's middle name.Teachers.Middle_Nameraw_teacher_name_middle_name
26
staff/teacher_usernameThe teacher's user name for signing in to PowerTeacher.Teachers.TeacherLoginIdraw_teacher_username
27
section/term_idThe ID of the Term.Terms.DCIDraw_term_id
28
raw_year_suffixFrom Teacher Dashboard configuration, copied in for convenience
29
Loading...