Student Course Attendance (EWS)

Contents

Introduction

This template stores course level attendance information for students. It is important to note that only records for student absences, late arrivals, or early departures should be submitted.

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.

Student Selection

The report selects records from the [Student] 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.
Attendance Date must not be greater than the current date.

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. Note: 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
6	STUDENT ID	The unique, 10-digit PAsecureID assigned to the student.	[Students]State_StudentNumber	Numeric	R
7	ATTENDANCE DATE	The date for which the absence is being reported.	[Attendance]Att_Date	Date	R
10	ATTENDANCE CODE LONG	A code representing the student’s absence on the specified date.	[S_PA_ATC_X]State_ATT_Code_Meeting	Numeric	R
11	COURSE CODE LONG	The unique, local, LEA-specific Course Code.	[Courses]Course_Number	AlphaNumeric	R
12	SECTION CODE LONG	Class section number assigned by LEA to identify distinct classes. This field should be the local section number only.	[Sections]Section_Number	AlphaNumeric	R
14	ATTENDANCE COMMENT	Description of the absence on the specified date.	[Attendance]Att_Comment	AlphaNumeric	R