PowerSchool SIS¶
| Vendor: | PowerSchool |
|---|---|
| Frequency: | Nightly |
| Method: | Our PowerSchool plugin is installed in your instance surfacing a set of API endpoints. This plugin includes all SQL queries we run against your PowerSchool database. Data is fetched via the API, transformed, and sent to the Ed-Fi ODS via the API. |
Initial setup¶
Airflow connections¶
Our DAGs look for two Airflow connections:
edfi_api
- Login: your Ed-Fi key
- Password: your Ed-Fi secret
powerschool_api
- Conn type: HTTP
- Host: PowerSchool URL
- Login: plugin API key
- Password: plugin API secret
Configuration¶
Data we pull¶
Schools¶
School names for each site, their physical address, and grade levels served
| Table Name | Column Name | Ed-Fi API Element |
|---|---|---|
| SCHOOLS | SCHOOLCITY | schools.addresses.city |
| SCHOOLS | SCHOOLZIP | schools.addresses.postalCode |
| SCHOOLS | SCHOOLSTATE | schools.addresses.stateAbbreviationDescriptor |
| SCHOOLS | SCHOOLADDRESS | schools.addresses.streetNumberName |
| SCHOOLS | LOW_GRADE | schools.gradeLevels |
| SCHOOLS | HIGH_GRADE | schools.gradeLevels |
| PSM_DISTRICT | DISTRICTNUMBER | schools.localEducationAgencyReference.localEducationAgencyId |
| SCHOOLS | NAME | schools.nameOfInstitution |
| SCHOOLS | SCHOOL_NUMBER | schools.schoolId |
Sessions¶
Terms for the school year.
| Table Name | Column Name | Ed-Fi API Element |
|---|---|---|
| TERMS | FIRSTDAY | sessions.beginDate |
| TERMS | LASTDAY | sessions.endDate |
| TERMS | SCHOOLID | sessions.schoolReference.schoolId |
| TERMS | NAME | sessions.sessionName |
| TERMS | NAME | sessions.termDescriptor |
| TERMS | NOOFDAYS | sessions.totalInstructionalDays |
Student Demographics¶
Student demographics, program info, and enrollments.
| Table Name | Column Name | Ed-Fi API Element | Ed-Fi ODS Table |
|---|---|---|---|
| STUDENTS | ethnicity | studentEducationOrganizationAssociations.raceDescriptors | studenteducationorganizationassociationrace |
| STUDENTS | fedethnicity | studentEducationOrganizationAssociations.hispanicLatinoEthnicity | studenteducationorganizationassociatio.hispaniclatinoethnicity |