Skip to main content
Skip table of contents

Staff Digital Resources Template Report (Retired)

Introduction

This report is retired starting school year 2022-2023.


This report allows PED to track the digital devices a staff uses and their internet connectivity at home.

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.

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

2Location Code

The school number (or alt school number of the staff member’s home school)


[Schools]School_Number
3School Year Date

School year date.

Format: YYYY-06-30

[Schools]SchoolYear
4

Staff ID

SSN of staff member formatted without dashes.

[Users]SSN

12

5Reporting Date

Valid values:

YYYY-10-01 = 40D

YYYY-12-15 = 80D

YYYY-03-01 = 120D

YYYY-06-01 = EOY

YYYY-06-29=Summer

ReportingDate
6Primary Teaching Device Type CodeThe Primary Teaching Device Type Code

[S_USR_X]PrimaryTeachingDevice


7School Provided DeviceThe device provided by the school

[S_USR_X]SchoolProvidedDevice


8Not collectedN/AN/AN/A
9Primary Teaching Device Access CodeThe Primary Teaching Device[S_USR_X]PrimaryDeviceAccess
10Not collectedN/AN/AN/A
11Internet Access In ResidenceThe Internet Access In Residence[S_USR_X]nternetAccessinRes
12Not CollectedN/AN/A
13Internet Access Type CodeThe Internet Access Type Code[S_USR_X.]InternetAccessType.
14Internet Performance Code

The internet Performance Code

[S_USR_X.]InternetPerformance
15Not CollectedN/AN/AN/A
JavaScript errors detected

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

If this problem persists, please contact our support.