Skip to main content
Skip table of contents

Classlink Extract


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

Selection criteria determine which database records are used in the report.

Staff Selection

  • 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.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.



Select Schools

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report

  • All Schools – Run the report for the entire district.

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 to save the results to a location on the server. The File Name will be in the format: ps_[DistrictName]_[DistrictNumber||SchoolNumber] followed by the provided file suffix. The concatenated value of the district ID and school ID must be a minimum of 7 digits. If the concatenated value is not 7 digits, then zeros will be added after the district Id.

For example, if the district name is District_100, the district ID is 575, and the school ID is 475, then the file name will be as follows:


If the report is run from the district office, then after the district ID, zeros will be added to ensure that the filename contains 7 digits.

If the concatenated value is more than 7 digits, the filename contains the actual number of digits. For example, if the district name is District_100, the district Id is 5751, and the school ID is 4751, then the file name will be as follows:


SFTP Connections

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to Setting Up an SFTP Connection for details on how to create an SFTP connection.

Report Output

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.


Data Element





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 the staff member.






The role of the staff member for example, District Administrator, School Administrator, Teacher, and so on. The job role data is accessed from Security Settings, Admin Access, and Roles page 1.

The report output includes a separate row per staff, per role, and school.

Note: Only job roles where the GA LDS Token field is populated are included in the report. The GA LDS Token information is obtained from System Setup, Roles Administration, and User Access.




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.

Note: If the staff is assigned to the district office, then the school ID will be reported as null.




For staff, this is the last four digits of their SSN.





Individual Unique ID for that district.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.