SC48 Attendance Validation Report

Contents

Introduction

The SC48 Attendance Validation CSV Report produces a PDF or CSV file which checks for validation issues on student attendance dates where the student is absent more than 50% of the day and state attendance code SC-ETRD, SC-BTRD, SC-UTRD, SC-EDSM, SC-SKIP, SC-UEPN, or SC-LATE is in use.

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.

School Selection

The school must not be excluded from state reporting.
The school must use Daily Attendance as the default attendance preference.

Student Selection

The student must not be excluded from state reporting.

Report Input

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

Field	Description
Select Schools	At the District Level: Use the Run for All Schools option below to run the extract for all schools not excluded from state reporting. Select Multiple Schools allows the user to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract. At the School Level: The currently selected school is the default.
Select Students	Select which students to include in the report: 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.
Sort By	Select one of the following sort options: Student Name – Sorts the report by student name. Field in Error – Sorts the report by erroneous fields.
Include Only Students in Grade Levels:	Select the checkbox next to the grade to include students in that grade level in the report. To include students in all grade levels, leave all checkboxes blank.
Report Output	Select PDF or CSV to indicate which file type to output.
Start Date	Enter the start date for the reporting period.
End Date	Enter the end date for the reporting period.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Back to Top

Report Output - PDF

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.

Position	Field	Description	[Table]Field Name
Header Information
H1	Date	The date the report is run.	N/A
H2	Page Number	The page number of the report.	N/A
H3	School Name	The name of the school.	[Schools]Name
H4	District Name	The name of the district.	[Prefs]Value [Prefs]Name=districtname
Report Information Note: The report includes the school from which the attendance data is derived.
1	Student Name	The student's last and first name.	[Students]LastFirst
2	Student Number	The student's ID number.	[Students]Student_Number
3	Grade	The student's grade level.	[Students]Grade_Level
4	Field in Error	The erroneous attendance field.	[Attendance_Code] Att_Code
5	Error Message	The explanation of the validation error.	Derived

Back to Top

Report Output - CVS

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.

Field	Description	[Table]Field Name
Student Last Name	The student's last name.	[Students]Last_Name
Student First Name	The student's first name.	[Students]First_Name
Student Middle Name	The student's middle name.	[Students]Middle_Name
Student Number	The student's ID number.	[Students]Student_Number
Student Grade	The student's grade level.	[Students]Grade_Level
Attendance Date	The date of the attendance record.	[Attendance]Att_Date
Attendance School	The school the student attends.	[Attendance_Code]SchoolID
Error Field	The validation error for the attendance record.	Derived

Back to Top