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 Name	Description	[Table]FieldName	Length
1	District Code	PED defined a three-character district code.	[Prefs]Name=DistrictNumber [Prefs]Value	8
2	Location Code	The school number (or alt school number of the staff member’s home school)	[Schools]School_Number
3	School Year Date	School year date. Format: YYYY-06-30	[Schools]SchoolYear
4	Staff ID	SSN of staff member formatted without dashes.	[Users]SSN	12
5	Reporting Date	Valid values: YYYY-10-01 = 40D YYYY-12-15 = 80D YYYY-03-01 = 120D YYYY-06-01 = EOY YYYY-06-29=Summer	ReportingDate
6	Primary Teaching Device Type Code	The Primary Teaching Device Type Code	[S_USR_X]PrimaryTeachingDevice
7	School Provided Device	The device provided by the school	[S_USR_X]SchoolProvidedDevice
8	Not collected	N/A	N/A	N/A
9	Primary Teaching Device Access Code	The Primary Teaching Device	[S_USR_X]PrimaryDeviceAccess
10	Not collected	N/A	N/A	N/A
11	Internet Access In Residence	The Internet Access In Residence	[S_USR_X]nternetAccessinRes
12	Not Collected	N/A	N/A
13	Internet Access Type Code	The Internet Access Type Code	[S_USR_X.]InternetAccessType.
14	Internet Performance Code	The internet Performance Code	[S_USR_X.]InternetPerformance
15	Not Collected	N/A	N/A	N/A