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 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: ps_District_100_5750475.csv 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: ps_District_100_57514751.csv
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.

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 the staff member.	[S_GA_SEC_X]Teacher_LastName_Override [S_GA_USR_X]Last_Name [Users]Last_Name
5	Role	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.	[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. Note: If the staff is assigned to the district office, then the school ID will be reported as null.	[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