Skip to main content
Skip table of contents

Classlink Extract

Introduction

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.

Field

Description

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

SFTP Connections

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.

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.

Column

Data Element

Description

[Table]FieldName

1

District_Name

The name of the school district.

[Prefs]Name=districtname

2

District_ID

The school district code. This is the district number in PowerSchool.

[Prefs]Name=districtnumber

3

First_Name

First name of staff member.

[S_GA_SEC_X]Teacher_FirstName_Override

[S_GA_USR_X]First_Name

[Users]First_Name

4

Last_Name

Last name of staff member.

[S_GA_SEC_X]Teacher_LastName_Override

[S_GA_USR_X]Last_Name

[Users]Last_Name

5

Role

This field will report blank currently.

[S_GA_USR_X]Staff_Role

6

Email

Staff member’s email address.

[S_GA_USR_X]Email_Addr

[Users]Email_Addr

7

School_Name

School name for the school_id reported, matching on alternate_school_number if > 0, or school_ID

[Schools]Name

8

School_ID

The school code the staff is assigned to.

[Staff_School]School_ID

9

Claiming_ID

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

[S_GA_SEC_X]Teacher_SSN_Override

[Users]SSN

10

SIS_ID

Individual Unique ID for that district.

[Users]TeacherNumber

[Users]DCID

JavaScript errors detected

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

If this problem persists, please contact our support.