The Classlink report extracts staff demographic data for the current school year, with one record per staff member per school. A staff may have multiple records, but must not have more than one at the same school. An active district staff not assigned to a school will be included in the extract when run from the district level.
Selection criteria determine which database records are used in the report.
The staff must be assigned to the school chosen at report runtime. Staff who are enrolled in multiple schools during the reporting period, will have separate records for each school if the report is run at the district level.
When run at the district level, staff who are not assigned to a school but identified as Active will be included in the extract.
The staff must be active for the current school year ([SchoolStaff]Status = 1)
The staff member must not be excluded from state reporting.
For help with navigation and running the report, see How to Find and Generate a Report.
If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Staff
Run the report for the current selection of staff or all staff.
File Path and File Suffix
The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix.
For example, a report run at district 999 on August 1, 2017, at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201708010915_AAA.txt in the provided location. If no path is specified, or if PowerSchool is unable to write to the specified folder, the report will run but will not be saved to the server.
Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.
Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection.
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
The name of the school district.
The school district code. This is the district number in PowerSchool.
First name of staff member.
Last name of staff member.
This field will report blank currently.
Staff member’s email address.
School name for the school_id reported, matching on alternate_school_number if > 0, or school_ID
The school code the staff is assigned to.
For staff, this is the last four digits of their SSN.
Individual Unique ID for that district.