CA Weekly Attendance Summary (Daily)

Introduction

The Weekly Attendance Summary (Daily) report returns a weekly attendance summary by the teacher.

Use the Weekly Attendance Summary Daily (D) report to display attendance codes by day. Only daily attendance codes will be displayed on this report. Present codes are not displayed. If the student is not enrolled on the attendance day, the report will export N/E for that student’s attendance for that day.

The report will only return teachers who have students currently enrolled in a section. Additionally, the teacher must have a Staff Status equal to Teacher and a Status equal to Current to display in the list on the report run page.

Students who are not enrolled in the section during the date range selected will not show up on the report. Teachers who have sections having no section enrollments will not show up on the report. The report will return an error page if the search criteria is invalid.

Note: This report includes weekends and out-of-session days so that unexpected closures can be audited.

Selection Criteria

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

Student Selection

The report selects student records based on the following criteria:

The student must be enrolled in the school included in the report during the report date range.
The student’s school enrollment must not be excluded from California ADA reporting.
Students Ever Enrolled in Section:
- The student must have been enrolled in the section at some point during the term dates associated with the section, but may no longer be enrolled in the section.
Students Current Enrolled in Section:
- The student’s entry date in the section must occur on or before the report's end date.
- The student’s exit date from the section must occur after the report start date.

Teacher Selection

The report selects staff member records based on the following criteria:

The staff member must have a Staff Status equal to Teacher on the Edit Information staff page.
The staff member must have a Status equal to Current on the Edit Information staff page.

Section Selection

The report selects sections based on the following criteria:

The section must be associated with the appropriate school and teacher.
The section must have at least one student enrolled.
The section must be set to use for daily attendance. For more information, see Create Bell Schedules.

Report Input

This report is run at the School level only.

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

Field	Description
Teachers	Select one or more teachers from the list. If a teacher is missing from the list, verify that he or she has Teacher chosen for Staff Status and Current chosen for Status on the Edit Information staff page.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
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.
Weeks	Choose the date range for the report from the pop-up menu.
Implement the "Exclude from ADA" flag to exclude such enrollment records from this report	Choose Yes or No from the pop-up menu. Choosing Yes excludes the student from the report if the student has a school enrollment marked to be excluded from ADA during the report date range.
Attendance Codes – Absent	List Absent attendance codes to include in the report. Separate multiple codes with a comma and no space, such as: A,S,I. Note: Attendance codes are considered absent if listed; the report ignores Presence Status.
Attendance Codes – Unexcused	List Unexcused attendance codes to include in the report. Separate multiple codes with a comma and no space, such as: P,E,T. Note: Attendance codes are considered absent if listed; the report ignores Presence Status.
Attendance Codes – Tardy	List Tardy attendance codes to include in the report. Separate multiple codes with a comma and no space, such as: T,L. Note: Attendance codes are considered present if listed; the report ignores Presence Status.
Report Student Name as	Choose the appropriate option from the pop-up menu: Preferred Name – The report will pull the student's preferred name. Legal Name – The report will pull the student's legal name. Note: This field is set up based on security preferences and may not be visible. For more information, see Entering Security Information.
Include Student Number	Check the box to include the locally assigned student identification number for each student.
Include Verification Line	Check the box to include the signature and date verification line in the report.

Report Output

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

See PowerSource for assistance with troubleshooting ADA and ADM calculations.

Report Output Format: The report output format for this report is pdf.

Data Element	Description	[Table]FieldName
Report Name	The name of the report.	N/A
School Name	The name of the school.	[Schools]Name
Date Range	The date range of the report, chosen at report runtime.	N/A
Teacher Name	The teacher’s name.	[Users]LastFirst
Student Name	The student’s first and last name. Note: This field reports the student's name based on whether the Preferred Name or Legal Name was chosen in the report parameters or in the security settings for Report Parameter Authorizations. Refer to Entering Security Information for more information. If the legal Name is selected and populated, the legal name is reported. Otherwise, the student's preferred name is reported.	[Students]LastFirst [StudentCoreFields]PSCore_Legal_Last_Name [StudentCoreFields]PSCore_Legal_First_Name
Student Number	The locally assigned student number.	[Students]Student_Number
Student Grade Level	The student’s grade level. The Translated Text value from the appropriate Grade Level Mapping is used, if present. Otherwise, the numeric value from the Grade Level field is extracted in a 2-character format. EX: 1 = 01	[Students]Grade_Level
Weekday	The report extracts the attendance code recorded for each day if the code matches one of those listed at report runtime. If the student is not enrolled in the section on the attendance day and Ever Enrolled is chosen at report runtime, the report will export -NOT ENR- for that day. Students who are not enrolled in the section during the date range selected will not show up on the report. Note: The report includes weekends and out-of-session days so that unexpected closures can be audited. Days that are not in session are labeled –HOLIDAY-.	[Attendance]Att_Date => Report Start Date [Attendance]Att_Date <= Report End Date [Attendance]SchoolID [Attendance]StudentID [Attendance]Attendance_CodeID [Attendance_Code]Att_Code=[user entered code(s)]
TotalExc	The total number of Excused attendance codes for the student recorded during the report date range. The report counts the number of attendance codes for the week identified as Present at report runtime. Note: The report does not consider attendance records or the Presence status of the attendance code.	N/A
TotalUnex	The total number of Unexcused attendance codes per student recorded during the report date range. The report counts the number of attendance codes for the week identified as Absent at report runtime. Note: The report does not consider attendance records or the Presence status of the attendance code.	N/A
TotalTardy	The total number of Tardy attendance codes per student recorded during the report date range. The report counts the number of attendance codes for the week identified as Tardy at report runtime. Note: The report does not consider attendance records or the Presence status of the attendance code.	N/A
Totals	The total number of Present, Absent, and Tardy attendance codes recorded for the date range. The report sums the values in the Total Present, Total Absent, and Total Tardy columns.	N/A
Signature and Date Line	The report includes a verification line if Include Verification Line is selected at report runtime.	N/A