Skip to main content
Skip table of contents

Location Marking Period Extract

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 YearChoose one or more terms, defined at the district, from the pop-up menu.

Back to Top

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 ElementDescription[Table]FieldName
1District CodePED assigned three-digit district number.

[Prefs]Name=DistrictNumber

[Prefs]Value

2Location 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

3Period CodeHard coded to "SYBED" to indicate School Year Beginning/End Date.

'SYBED'

4School Year Date

Indicates the PED defined school year date.

This value is automatically extracted as June 30th. 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
5School Year Start Date

Indicates the actual start date of the location.

The value is extracted in the format YYYY-MM-DD.

[Terms]FirstDay
6School Year End Date

Indicates the actual end date of the location.

The value is extracted in the format YYYY-MM-DD.

[Terms]LastDay
7N/ANot collected.N/A
8Term CodeHard coded to "SYBED" to indicate School Year Beginning/End Date.'SYBED'
9N/ANot collected.N/A
10N/ANot collected.N/A
11N/ANot collected.N/A
12N/ANot collected.N/A
13Days 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



JavaScript errors detected

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

If this problem persists, please contact our support.