WY Prepare Student Attendance Summary Report

Contents

Introduction

The WY Prepare Student Attendance Summary provides aggregate data on attendance and membership information for all students enrolled during the reporting period. One record is created for each school and enrollment for a student. This information is published using the Student Attendance Summary object by the SIF agent. This is required for WDE600 submission via SIF.

The SAS data can be prepared at the district level. There can be only one instance of SAS data for a school in the district.

Note: Whenever the Student Attendance Summary table in PowerSchool is updated, all the previous records for that school year are deleted and new records are created.

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 [Students] and [ReEnrollments] tables based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Exit Date must occur after the report start date.
The student’s school enrollment Entry Date must occur on or before the report end date.
The school enrollment Exit Date must occur after the Entry Date.

Back to Top

Report Input

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

Field	Description
The report start date	Enter a date using the format mm/dd/yyyy for the first day of the report date range.
The report end date	Enter a date using the format mm/dd/yyyy for the last day of the report date range.

Back to Top

View the Student Attendance Summary Data

View the Student Attendance Summary (SAS) data through Direct Database Export (DDE):

Click System on the Start page. The System Administrator page appears.
Click Direct Database Export. The Direct Database Export page appears.
Choose the StudentAttendanceSummary (200) table from the Current Table pop-up menu.
Select all records in this table.
Click either List View or Table View to view the records.

Back to Top

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	SAS Table Data Element	Description	[Table]FieldName
1	DCID	The Record ID for SIF.	Calculated
2	ID	The Record ID.	Calculated
3	StudentDCID	The Student Identification Number for SIF.	[Students]DCID
4	SchoolDCID	The School Identification Number for SIF.	[Schools]DCID
5	SchoolYear	The school year for which the information is applicable.	[Terms]
6	StartDate	The starting date for this attendance reporting period.	[Students]EntryDate [ReEnrollments]EntryDate
7	StartDay	The number of the school days represented in StartDate.	N/A
8	EndDate	The ending date for this attendance reporting period.	[Students]ExitDate [ReEnrollments]ExitDate
9	EndDay	The number of the school days represented in EndDate.	N/A
10	Resident	Indicates if the student's legal residence was within the boundaries of the school during the time between the StartDate and EndDate, inclusive.	[Students]State_StudentNumber (WISER ID)
11	DaysAttended	The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive.	Calculated: Membership Value – (Excused Absences + Unexcused Absences)
12	Excused	The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive.	Calculated
13	Unexcused	The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive.	Calculated
14	Membership	The number of days the student was enrolled when school was in session during the period between the StartDate and EndDate, inclusive.	Calculated
15	DaysTransportedEligibleStateAid	The days transported and eligible for state aid to be paid.	[Students]Student_Number

Back to Top