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:
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:
| [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 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 |
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 |