Student Daily Attendance (EWS)

Contents

Description

This template is used to store daily student absence. It is important to note that only records for student absences, late arrivals, or early departures should be submitted. Records should NOT be included for students who are in attendance.

Selection Criteria

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

Student Selection

The report selects student from the [Students] and [Attendance] table based on the following criteria:

The school must not be excluded from state reporting.
The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student must not be a no-show; i.e., there school Exit Date must be after their Entry Date.
The schools local attendance codes must be mapped to the EWS attendance codes.

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.
Students to Include*	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report.
Report Start Date*	Enter the start date using the format mm/dd/yyyy for the first day of the reporting period.
Report End Date*	Enter the end date using the format mm/dd/yyyy for the last day of the reporting period.
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.

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. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite.	[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. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite.	[Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID	Numeric	R
3	STUDENT ID	The unique, 10-digit PAsecureID assigned to the student.	[Students]State_StudentNumber	Numeric	R
4	ATTENDANCE DATE	The date for which the absence is being reported.	[Attendance]Att_Date	Date	R
6	ATTENDANCE COMMENT	Description of the absence on the specified date.	[Attendance]Att_Comment	AlphaNumeric	O
8	ATTENDANCE CODE LONG	A code representing the reason for the student’s absence on the specified date.	[S_PA_ATC_X]State_ATT_Code	AlphaNumeric	R
9	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
10	MARKING PERIOD CODE	The report will default to a value of N/A per the state requirements.	Static Value of N/A	AlphaNumeric	R
11	TERM CODE	The term in which the student attendance event occurred. Submit the smallest term in which a student is enrolled in course sections.	Derived	AlphaNumeric	R