Skip to main content
Skip table of contents

Export Staff Assignments Report

Introduction

This extract includes a record for each staff assignment. Use this report to verify that staff members are assigned the correct assignments. Staff assignments are set up via Start Page > Staff > Edit Information > Click HERE to Create/Edit Staff Assignments.

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 Assignments Selection

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

  • The staff assignment must be associated with the current school.
  • The staff assignment begin date must occur before the last day of school.
  • The staff assignment must end after the first day of school.

Note: The first and last days of school are determined based on the term selected at the top of the page when the report is run.

Report Input

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

Field

Description

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/yyyy or mm-dd-yyyy in 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.

Extract 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

foreignKey

The staff member's internal PowerSchool ID.

[S_TN_USR_StaffAssignments_C]foreignKey

2

LastFirst

The staff member's first and last name.

[Users]LastFirst

3

TN_StaffAssignment

The staff member's current assignment.

[S_TN_USR_StaffAssignments_C]TStaffAssignment

4

TN_AssignmentBeginDate

The date that the assignment began.

[S_TN_USR_StaffAssignments_C]AssignmentBeginDate

5

TN_AssignmentEndDate

The date that the assignment ended.

[S_TN_USR_StaffAssignments_C]AssignmentEndDate

6

SchoolID

The school ID.

[S_TN_USR_StaffAssignments_C]SchoolID

JavaScript errors detected

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

If this problem persists, please contact our support.