Location Marking Period Extract | PowerSchool SIS Compliance

Introduction

This extract generates a comma-delimited file containing all start and end dates for all public and charter locations. Off-sites locations are optional.

Selection Criteria

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

School Selection Criteria

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

The building has at least a full year term defined in the reporting year.
The building is not flagged as a summer school.
The building is not excluded from state reporting.

Report Input

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

Field

Description

Select Schools

Choose one of the following:

Current School Only – Includes all student records associated with the current school that meet 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 Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

School Year

Choose one or more terms, defined at the district, from the pop-up menu.

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.

File name: [DistrictNumber] +_ + LOCATION_MARKING_PERIOD+_+[YYYYMMDDHHMM].csv

e.g. 100_LOCATION_MARKING_PERIOD_201807181046.csv

Item #	Data Element	Description	[Table]FieldName
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value
2	Location Code	The PED assigned three-digit school number. The alternate school number is used if specified in the report input. Notes: Off-site locations that have instructional programs are optional. The following Location Codes should not be reported: 992 = Off-Site Early Childhood Program 993 = Students who are hospitalized 997 = Students who are enrolled in a private school 998 = Students who are homebound 999 = Students who are home schooled	[Sections]SchoolID [Schools]Alternate_School_Number
3	Period Code	Hard coded to "SYBED" to indicate School Year Beginning/End Date.	'SYBED'
4	School Year Date	Indicates the PED defined school year date. This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay
5	School Year Start Date	Indicates the actual start date of the location. The value is extracted in the format YYYY-MM-DD.	[Terms]FirstDay
6	School Year End Date	Indicates the actual end date of the location. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay
7	N/A	Not collected.	N/A
8	Term Code	Hard coded to "SYBED" to indicate School Year Beginning/End Date.	'SYBED'
9	N/A	Not collected.	N/A
10	N/A	Not collected.	N/A
11	N/A	Not collected.	N/A
12	N/A	Not collected.	N/A
13	Days In Session	Indicates the number of days that the location is in session.	Calculated School: Sum of Calendar_Day records where InSession = 1 and Date >= [Terms]FirstDay and Date <= [Terms]LastDay For the District Office record: [Prefs]Value where [Prefs]Name = DaysInSes Else: 180