Skip to main content
Skip table of contents

Staff Language Template Report

Introduction

This report allows to track the home language spoken by all staff.

Data Submission Schedule: 40D, 80D, 120D, EOY.

This data is required for all staff, active on the reporting date, with position codes in the following Staff Assignment Template Categories: Educational Assistants. Principals, or Teachers.

Staff that do NOT have a position code in one of the three categories listed above will not be extracted in the report.

Selection Criteria

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

  • The report is at the District level.

Staff Member Selection

The report selects active and inactive (current and exited) staff records from the [Teachers] table based on the following criteria:

  • The staff member must not be excluded from state reporting.
  • The staff member must have a master record at a school included in the report; i.e. the Master Record field on the Staff Master Record/Position Details must equal Yes.
  • The staff member must be active at the school; i.e. the Active checkbox must be selected on the Information staff page.
  • All staff active on the reporting date, with position codes in the following Staff Assignment Template Categories: Educational Assistants. Principals, or Teachers.

For the K5P reporting period:

  • The staff member must be teaching a section with at least one K5P student enrolled during the defined K5P reporting period.

If the report is run to include exited teachers then, the report additionally includes staff records from the [Teachers] table based on the following criteria:

  • The staff member must not be active at the school; i.e. the Active checkbox must NOT be selected on the Information staff page.
  • The staff Exit Date must occur on or after the report start date and on or before the report end date.
  • The staff member must have an FTE value greater than 0 for 1 or more of the following Position Codes: 00, 20, 21, 22, 23, 25, 28, 30, 73, 74, 75, 94, 96, 97, 101, 103, 104, 106, 110, and 110S.

Back to Top

Report Input

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

Field

Description

Select Staffs*

Choose one of the following:

  • Currently Selected Staff Only – Includes all staff member records associated with the current school that meet the selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Staff (default) – Includes all staff member records on the PowerSchool server that meet the selection criteria.

    The report publishes a qualifying staff member only once for their indicated home school rather than for each school with an existing school staff record.

Report Period

Choose a reporting period from the pop-up menu:

  • 40D
  • 80D
  • 120D
  • EOY

Snapshot Date (Only for the Year-Round reporting period)

This field is only visible when the Year Round reporting period is selected. Enter the snapshot date.

Note: If you are scheduling the report to run on a set schedule (for the Year Round reporting period), the Snapshot Date should be left blank. The report will then use the current system date.

Include Exited Teachers

Note: This field is only available for the Staff extract

Select the checkbox to include exited teachers in the extract.

Note: Exited teachers must be included in the EOY submission.

Start Date (Required for Exited Teachers Only)

Note: This field is only available for the Staff extract

If Include Exited Teachers is selected, enter the start date for the report.

End Date (Required for Exited Teachers Only)

Note: This field is only available for the Staff extract

If Include Exited Teachers is selected, enter the end date for the report.


Report Output

Field #Field NameDescription[Table]FieldNameLength

1

District Code

PED defined a three-character district code.

[Prefs]Name=DistrictNumber

[Prefs]Value

8

2

Staff ID

SSN of staff member formatted without dashes.

[Users]SSN

12

3School Year Date

School year date.

Format: YYYY-06-30

[Schools]SchoolYear
4

Language Code

The primary or heritage language that the staff speaks at home.

The staff’s Home Language may be different from the staff’s Native Language.

Valid Values

[Users]Language


5Language UseLanguage used at Home



JavaScript errors detected

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

If this problem persists, please contact our support.