Student Attendance Information

This report produces a list of student absences for JTED sections. Attendance for a JTED student in a qualifying JTED section is not reported to SAIS. The report results are produced in a comma-delimited format. 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 Student Attendance Information Report. The Student Attendance 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, typically the first day of the semester or other current term.
End Date	Enter the end date for the report, typically the current date.
Display Header	Choose one of the following from the pop-up menu: Yes – Choose this option to display the name of each data element in the first line of the report results. No – Choose this option to omit the first line with data element names.
JTED File Format	Choose one of the following from the pop-up menu: Standard Format – Choose this option to output the results using the standard file format Pima County Format – Choose this option if reporting to the Pima County JTED

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.

Standard Format

Item #	Data Element	Description	[Table]FieldName
1	Date of Absence	The date of the attendance record.	[Attendance]Att_Date
2	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
3	Last Name	The student’s last name.	[Students]Last_Name
4	First Name	The student’s first name.	[Students]First_Name
5	Absence Code	The attendance code associated with the attendance record.	[Attendance_Code]Att_Code [Attendance]Attendance_CodeID = [Attendance_Code]ID
6	Period Absent	The period during which the section associated with the absence took place.	[Sections]Expression

Pima County Format

Item #	Data Element	Description	[Table]FieldName
1	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
2	Attended CTDS	The County Code-Type Code-District Code-Site Number (CTDS) of the student’s home school.	[Prefs]Value [Prefs]Name=districtnumber [Students]Schoolid
3	Class Number	The course and section number of the JTED section in which the student is enrolled, reported in the format CourseNumber-SectionNumber. Must match Class ID from the Student Information file.	[Sections]Course_Number [Sections]Section_Number
5	Absence Date	The date of the attendance record.	[Attendance]Att_Date
6	Absence Code	The absence status of the student’s absence for the class. Valid values: E – Excused U - Unexcused If the Absence Code for the class that day is associated with the ‘Excused’ Attendance Code Category, then E will be reported, otherwise U will be reported.	Calculated.