Location MP Calendar Date Template (EWS)
Contents
Introduction
This template specifies the day type for days in a school's academic calendar; it defines the start and end dates for marking periods and terms during a school year at a specific location. This template is used in conjunction with the attendance domain to determine the percentage of instructional days a student was absent/present within a given period.
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 the Terms and Calendar Day table based on the following criteria:
- One record per District Code / Location Code / School Year / Calendar Date
- Calendar Membership types must be setup and applied to the Calendar
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:
If sub-districts are enabled:
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.
|
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. | [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 | Use N/A. | Derived - N/A | AlphaNumeric | R |
4 | TERM CODE | Use YR | Derived - YR | AlphaNumeric | R |
5 | 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 2014-2015 school year would be indicated by 2015-06-30. | Derived | Date | R |
6 | CALENDAR DATE | A date within the specified school year, marking period, and term. | Derived [Terms] | Date | R |
7 | DAY TYPE | The type of scheduled or unscheduled event for the specified calendar date. | [Calendar_Day]Type | AlphaNumeric | R |