Skip to main content
Skip table of contents

Increment Staff Years of Service Report

Introduction

This report adds one year to the following staff years of service fields:

  • Total Years in this LEA

  • Total Years of Educational Service

Use this report to automatically update these fields at the end of the school year for all staff members who were employed in the school district. The report can be run for the district or for each school separately, and for all staff members or a selection of staff members, once per year. The report cannot be run concurrently – run only one instance of the report at a time.

Selection Criteria

Staff Selection

Staff records are included in the extract that meets the following criteria:

  • The staff member must not be excluded from state reporting.

  • If the staff member is associated with a school included in the report, then the school must not be excluded from state reporting.

  • The staff member must have a value of Current for the Status field on the Edit Information page.

  • The staff member's Employment End Date on the Edit Information page must be blank or occur after the current server date (usually today's date). This field can also be populated on the CALPADS Staff Demographics page.

  • The staff member must already have a value populated in the Total Years in this LEA field (values of blank will not be incremented).

  • The staff member must already have a value populated in the Years of Educational Service field (values of blank will not be incremented).

Report Input

This report is run at the District and School level.

For help with navigation and running the report, 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.

Records to Include

Indicate which staff members to include in the report by selecting one of the following options:

  • The selected [number] records only – Run the report for staff members in the current selection.

  • All records – Run the report for all staff members in the current school or district that meet the selection criteria.

Note: If running the report for a single staff member, or group of staff members, select the staff members prior to running report.

Report Mode

Choose one of the following from the pop-up menu:

  • 1. See proposed incremented data settings – Choose this option to preview the new values for the staff fields. It is recommended to use this option before writing changes to the database.

  • 2. Write changes to the database – Choose this option to update the values for the staff fields in the database. This option also includes an output file with the updated values.

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.

Note: The report results are ordered by school ID, last name, and first name.

Report Output Format: The report output format for this report is comma delimited.

Data Element

Description

[Table]FieldName

SEID

The unique identifier assigned to each educator in the California public education system by the California Commission on Teacher Credentialing. This number is known as the Statewide Educator Identifier (SEID).

[S_CA_USR_X]SEID

School Name

The name of the school the staff member is associated with.

Note: If the staff member is not associated with a specific school, the word “District” is reported.

[Schools]Name

Last Name

The staff member’s last name.

[Users]Last_Name

First Name

The staff member’s first name.

[Users]First_Name

Old Years in LEA

The field displays one of the following:

  • For the 1st report mode, before changes are written to the database, the report displays the current value for Years in this LEA.

  • For the 2nd report mode, after changes are written to the database, the report displays what is now the old value for Years in this LEA.

[S_CA_USR_X]YearsInDistrict

New Years in LEA

The field displays one of the following:

  • For the 1st report mode, before changes are written to the database, the report displays the preview value for Years in this LEA.

  • For the 2nd report mode, after changes are written to the database, the report displays what is now the current value for Years in this LEA.

[S_CA_USR_X]YearsInDistrict

Old Years of Ed. Service

The field displays one of the following:

  • For the 1st report mode, before changes are written to the database, the report displays the current value for Years of Educational Service.

  • For the 2nd report mode, after changes are written to the database, the report displays what is now the old value for Years of Educational Service.

[S_CA_USR_X]YearsOfService

New Years of Ed. Service

The field displays one of the following:

  • For the 1st report mode, before changes are written to the database, the report displays the preview value for Years of Educational Service.

  • For the 2nd report mode, after changes are written to the database, the report displays what is now the current value for Years of Educational Service.

[S_CA_USR_X]YearsOfService

 

JavaScript errors detected

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

If this problem persists, please contact our support.