Student Summary Attendance Extract

Contents

Introduction

The Student Summary Attendance extract is a summary report of the total days present, total days absent, and days enrolled for a student. The extract is generated in a comma-delimited format.

Note: The report calculates all students as full-time, regardless of PowerSchool attendance setup. The state will calculate part-time students after the file is submitted.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The Student Summary Attendance extract includes attendance records from the [Attendance] table that are related to student records from the [Students] or [ReEnrollments] table that meet the following criteria:

Students who are not excluded from state reporting.
Students who are enrolled in a school that is not excluded from state reporting.
Students whose school enrollment Exit Date is after the report start date.
Students whose school enrollment Entry Date is on or before the report end date.
Students whose school enrollment Exit Date is after the Entry Date.

Report Input

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

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Attendance Period Start Date	Enter the first in session day of the school year.
Attendance Period End Date	Enter the last in session day of the school year.

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.

Element #	Data Element	Description	[Table]FieldName
1	District Code	NDE Number for the district.	[Prefs]Name=districtnumber [Prefs]Value
2	Location Code	The report extracts the value for the Alternate School Number field, if populated on the Edit School page. Otherwise, the report extracts the School Number.	[Schools]Alternate_School_Number [Schools]School_Number
3	School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. Extracted in the format YYYY-MM-DD.	[Terms]LastDay
4	Student ID	State assigned ID number.	[Students]State_StudentNumber
5	Period Start Date	The date must occur before the current date. Extracted in the format YYYY-MM-DD.	[Students]EntryDate [ReEnrollments]EntryDate
6	Period End Date	The date must occur on or after the Period Start Date. Extracted in the format YYYY-MM-DD. Note: Period Start Date and Period End date must occur within the same school year.	[Students]ExitDate [ReEnrollments]ExitDate
7	Total Days Present	Calculated using the PowerSchool ADA calculation. The report totals the number of days that the student was either marked present, or not marked absent, depending on your attendance setup, between the report start and end dates. Note: PowerSchool identifies attendance codes as present if the code is associated with a Presence Status of Present. See Knowledgebase article 6182 on PowerSource for troubleshooting assistance.	N/A
8	Total Days Absent	Not collected as of 2011-2012 School Year.	N/A
9	Days Enrolled	Not collected.	N/A
10	Days Truant	Not Collected	N/A
11	FTE Percent	The value is multiplied by 100. For example, if the FTE is 1, the report extracts 100. If the FTE is 0.5, the report extracts 50.	[Students]MembershipShare
12	Days Tardy	Not Collected.	N/A
13	Grade Level	If the field Kindergarten Student receiving less than 1,032 instructional program hours is set to Yes, then the report extracts HK. Otherwise, the report extracts the grade level.	[Students]Grade_Level [S_NE_STU_X]Kdg_Grade_HK

Back to Top