Location Marking Period Template (EWS)

Contents

Introduction

This template defines the start and end dates for marking periods and terms during a school year at a specific location.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

The report selects records from following tables: Terms, School, Calendar_Day, TermBins, Terms extension table [TRM], and TermBins ExtensionTable [TRB] based on the following criteria:

Grain: One record per District Code / Location Code / School Year / Marking Period

Or:

Grain: One record per District Code / Location Code / School Year / Term

The mapping of Years/Terms defined to the EWS Terms Codes is required.
The mapping of the EWS Marking Period Codes in Final Grade Setup
Calendar Membership Types must be setup and applied to the Calendar

Back to Top

Report Input

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

Field	Description
Schools to Include*	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select School Year*	Select the school year for which you wish to run the report.
Field Delimiter	Choose the field delimiter for the extract file from the pop-up menu.
Include Header Labels in output file?	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.
Scheduling	Select when to run the report. Run Now – Execute the report immediately. Schedule - Execute the report on the date and time specified. Start Date - Enter a start date to run the report. Start Time – Enter a start time to run the report. Select Run Once or Repeat to schedule how often the report is run.

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Req'd
1	DISTRICT CODE	The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Note: All LEA and School codes can be found at https://www.education.pa.gov/Pages/Education-Directory-and-Maps.aspx	[Prefs]District_Number If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Numeric	R
2	LOCATION CODE	The PDE-defined, 4-digit code identifying the school. Note: All LEA and School codes can be found at https://www.education.pa.gov/Pages/Education-Directory-and-Maps.aspx	[Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID	Numeric	R
3	MARKING PERIOD CODE	A code specifying a marking period during the school year. Use N/A when defining start/end dates for a term. Otherwise, see the Appendix for valid values.	[S_PA_TRB_X]State_Marking_Period	AlphaNumeric	R
4	SCHOOL YEAR DATE	A single date indicating the whole school year. June 30, at the end of the standard school year, is used to designate a school year. Thus, the 2017-2018 school year would be indicated by 2018-06-30.	Calculated [Terms]LastDay	Date	R
5	MARKING PERIOD START DATE	The date on which the marking period begins at the specified school.	Derived from TERMSBINS Table (33)	Date
6	MARKING PERIOD END DATE	The date on which the marking period ends at the specified school.	Derived from TERMSBINS Table (33)	Date	R
8	TERM CODE	The type of the session during the school year. Use N/A when defining start and end dates for Marking Period. Otherwise, see the Appendix for valid values.	[S_PA_TRM_X]State_Term_Code	AlphaNumeric	R
	INSTRUCTIONAL DAYS	The number of instructional days offered during the specified marking period.	Derived from the date of the marking periods or the terms.	Numeric	R
11	LOCATION TERM CATEGORY	The local identifying name for the marking period or term, for example, Fall 2017-2018, 2017 Summer.	[TERMS]Name	AlphaNumeric	R

Back to Top