Preliminary Staff Report

Introduction

This report returns scheduled classes by staff member. The fall semester version of this report includes all classes scheduled from the beginning of the school year (any class scheduled through the end of report period 4). The spring semester version includes all classes scheduled through the end of the school year (active at end of reporting period 5). The report uses the First Reporting Period for Fall and the Fifth Reporting Period for Spring. Reporting periods must be mapped to reporting segments via Start Page > School Setup > Reporting Segments.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Staff Member Selection

The report selects records from the [Teachers] table based on the following criteria:

The staff member must have a Staff Status equal to Current on the Edit Information staff page.
The staff member must not be excluded from state reporting.
The staff member must be associated with a school included in the report and the school must not be excluded from state reporting.
The staff member must have a staff assignment that begins on or before the reporting segment end date and ends after the reporting segment start date. The report uses the First Reporting Period for Fall and the Fifth Reporting Period for Spring.
The staff member must be a supervising principal, teaching principal, assistant principal, classroom teacher, or university teacher, i.e. the staff assignment must have one of the following codes: PE, PM, PS, PP, PV, PO PF, PN, PG, PQ, PW, PR, TE, TM, TS, TP TV, TO TF, TN, TG, TQ, TW, TR, AE, AM, AS AP, AV, AO, LB, LF, RO, GE, GM, GS, SI, IO, LI, MP, CP, VP, HP, or UN.
The staff member must be assigned a Staff Work Status (Full-Time or Part-Time).

Section Selection

The report selects records from the [Sections] table based on the following criteria:

The section must be associated with a teacher included in the report.
The section must not be excluded from state reporting.
The section must be assigned to a term that begins before the reporting segment end date and ends after the reporting segment start date.
The section must be assigned to a course with an alternate course number.

Back to Top

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. 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.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
School Term	Choose Fall or Spring from the pop-up menu. The report uses the First Reporting Period for Fall and the Fifth Reporting Period for Spring. Reporting periods must be mapped to reporting segments via Start Page > School Setup > Reporting Segments.
School Year	Enter the appropriate school year. For example, enter 2010 for the 2010-2011 school year.

Back to Top

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.

Item #	Data Element	Description	[Table]FieldName
1	Report Year	The school year for the report, entered at report runtime.	N/A
2	District	The district name and number.	[Prefs]Value [Prefs]Name=districtnumber [Prefs]Name=districtname
3	School Term	The school term for the report, as chosen at report runtime.	N/A
4	School	School name and number.	[Schools]School_Number [Schools]Name
5	Effective Date	The date the report is run.	N/A
6	Teacher ID	The teacher's ID.	TBD
7	Teacher Number	The staff member's license number.	[S_TN_SSF_PreliminaryStaff_C]tchLicenseNo
8	Last Name	The staff member's last name.	[S_TN_SSF_PreliminaryStaff_C]tchLastName
9	First Name	The staff member's first name.	[S_TN_SSF_PreliminaryStaff_C]tchFirstName
8	#1 Course Code	The SDE course code.	[S_TN_SSF_PreliminaryStaff_C]coursecode_1
9q	#1 Classes	The local course code.	[S_TN_SSF_PreliminaryStaff_C]classes_1
10	#1 Students	The number of students enrolled in the class.	[S_TN_SSF_PreliminaryStaff_C]students_1
11	#2 Course Code	The SDE course code.	[S_TN_SSF_PreliminaryStaff_C]coursecode_2
12	#2 Classes	The local course code.	[S_TN_SSF_PreliminaryStaff_C]classes_2
13	#2 Students	The number of students enrolled in the class.	[S_TN_SSF_PreliminaryStaff_C]students_2
14	#3 Course Code	The SDE course code.	[S_TN_SSF_PreliminaryStaff_C]coursecode_3
15	#3 Classes	The local course code.	[S_TN_SSF_PreliminaryStaff_C]classes_3
16	#3 Students	The number of students enrolled in the class.	[S_TN_SSF_PreliminaryStaff_C]students_3
17	#4 Course Code	The SDE course code.	[S_TN_SSF_PreliminaryStaff_C]coursecode_4
18	#4 Classes	The local course code.	[S_TN_SSF_PreliminaryStaff_C]classes_4
19	#4 Students	The number of students enrolled in the class.	[S_TN_SSF_PreliminaryStaff_C]students_4

Back to Top