Student Check-in and Check-out Log

The Arizona Student Check-in/Check-out Log pulls student Meeting Attendance Check-in/Check-out information for a date range. The report includes all Meeting Attendance Clock-in/Clock-out records at the school for the selection of students for a given date range. It includes meeting period attendance codes and all Comments for the day.

Selection Criteria

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

Student Selection

The report selects records from the [Students] and [ReEnrollments] and [S_AZ_STU_CONENR_C ] tables based on the following criteria:

The student must be enrolled in a school included in the report.
The student must not be excluded from state reporting.
The student’s school entry date must occur on or before the report end date.
The student’s school exit date must occur on or after the report start date.
The student’s school exit date must occur after their school entry date.

Report Input

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

Field	Description
School or District Wide	Select whether to include results from a single school or the whole district. Default is School.
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.
Begin Date	Choose a date to begin the reporting period.
End Date	Choose a date to end the reporting period.
Sort By	Choose one of the following by which to sort the report output: Student Name – Sorts by the student names alphabetically. Date/Time – Sorts by the date and time.
Attendance Codes	Choose the appropriate attendance codes from the pop-up menu. Leave blank to select all codes for that school. Selecting one or more attendance code categories will cause the report to only include those codes Note: To select multiple values, hold the Command (Mac) or Control (Windows) key as you click the values.
Output Type	Choose either PDF or Text-Tab from the pop-up menu to indicate the output file type.

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.

Item #	Data Element	Description	[Table]FieldName
Report Header
H1	Date	The date the report was run.	N/A
H2	Time	The time the report was run.	N/A
H3	School Name	The the school name reported.	[Schools]Name
H4	Page Number	The page number of the report.	N/A
H5	Report Name	The report name.	N/A
H6	Begin/End Date	The begin and end date of the reporting period, selected in the report parameters.	N/A
H7	Sequence	The sort by option, selected in the report parameters.	N/A
H8	Attendance Codes	The attendance codes, selected in the report parameters.	N/A
Report Body
1	Student Name	The name of the student included in the report.	[Students]LastFirst
2	Student Number	The student's assigned identifier.	[Students]Student_Number
3	Grade	The student’s grade level at the time of the reporting period. Note: PS = PK4, PK3, PK2 KG = KG UE = Grade KG with the Ungraded Elementary field box checked.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_AZ_STU_CONENR_C]Grade_Level [Students]UngradedElementary [Reenrollments]UngradedElementary [S_AZ_STU_CONENR_C]UngradedElementary
4	Date	The date of the clock-in/clock-out record.	If the Enable Clock In/Out option is selected on the Attendance Preferences page: [Attendance]Att_Date Otherwise: [S_STU_Attendance_MeetingTime_C]Att_Date
5	Departed	The time the student left school (clocked-out).	If the Enable Clock In/Out option is selected on the Attendance Preferences page: [AttendanceTime]Time_Out Otherwise: [S_STU_Attendance_MeetingTime_C]Start_Time
6	Arrived	The time the student arrived at school (clocked-in).	If the Enable Clock In/Out option is selected on the Attendance Preferences page: [AttendanceTime]Time_In Otherwise: [S_STU_Attendance_MeetingTime_C]End_Time
7	Attendance Codes	The list of all the attendances codes for the day. The field displays dots for classes with no marks and dashes for periods not scheduled.	[Attendance_Code]Att_Code
8	Comment(s)	Any comments on the record.	[S_STU_Attendance_MeetingTime_C]ClockInComment [S_STU_Attendance_MeetingTime_C]ClockOutComment