Attendance Audit Information

This report produces a list of student absences for JTED sections. As required by the JTED, the Attendance Audit report results must be signed by a teacher and kept on file for auditing purposes. The report results are broken down by teacher and should be viewed in an internet browser window. The report runs for the current school only and cannot be run district-wide.

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] table based on the following criteria:

The student must be enrolled in a section taught by a teacher selected at report runtime. The section must be marked “Yes” for “JTED Section Led by a CTE Instructor.”
The student must have “Yes” selected for “JTED Student Indicator” on the Transfer Info page for a school enrollment that occurs during the report dates.

Attendance Selection

The report selects records from the [Attendance] table based on the following criteria:

The attendance record must be associated with a student included in the report.
The attendance record must occur during the report dates.
The attendance record must be associated with an attendance code that is marked “absence” for Presence Status.

Report Input

To generate the report, do the following:

On the Start Page, click Special Functions. The Special Functions page appears.
Click Interfaces to other systems. The Interfaces to Other Systems page appears.
Click JTED. The JTED – Arizona’s Joint Technical Education District Ranking and Reporting page appears.
Click AZ Attendance Audit Information Report. The Attendance Audit Information Report page appears.
Enter information in all of the required fields.
Click Submit to generate the report.

Field	Description
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 report.
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.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.
Teachers	Choose the teachers to include in the report. Hold the Function or Apple key to select multiple teachers. The teachers in the list appear based on whether “Yes” is selected for the “JTED Section Led by a CTE Instructor” for sections assigned to the teacher.

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.

Note: Open the result file in a browser window.

Item #	Data Element	Description	[Table]FieldName
1	School Name	The name of the current school.	[Schools]Name
2	CTD Number	The district number.	[Prefs]Value [Prefs]Name=districtnumber
3	Teacher Name	The name of the teacher assigned to the section.	[Teachers]First_Name [Teachers]Last_Name [Sections]Teacher = [Teachers]ID
4	Teacher ID	The teacher number entered in the ID field on the Edit Staff Information page.	[Teachers]TeacherNumber
5	From	The dates of the report, as entered at report runtime.	N/A
6	Course – Section	The course and section number, separated by a dash.	[Courses]Course_Number [Sections]Section_Number
7	Course Title	The name of the course.	[Courses]Course_Name
8	Period	The period during which the section is taught.	[Sections]Expression
9	Student Name	The name of the student.	[Students]First_Name [Students]Last_Name
10	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
11	Date	The date of the absence record.	[Attendance]Att_Date
12	Absence Code	The attendance code associated with the absence record.	[Attendance_Code]Att_Code [Attendance]Attendance_CodeID = [Attendance_Code]ID
13	Signature Line	A line provided for the teacher to authorize that the attendance information is correct.	N/A