Overview

In flex schools where primary class tracking is enabled, the primary class is the attendance class and the primary teacher of this section is stored in the PRIMARYTEACHERNAME field which can be queried with any table.

List Queries

List of Attendance Percentages for Students by Counselor/Teacher and School for a Specific School Year

Provides Attendance History information with calculated percentages for student enrollment for a specific school year sorted by School and Counselor or Primary Teacher Name

List of Attendance Percentages for Independent Study Students to help determine Absentee Rate.

Attendance History Configuration must be run for desired date range prior to running this query. For details, see Attendance History Configuration.

LIST STU AHS STU.NM STU.GR AHS.ID AHS.SP AHS.EN AHS.ISC AHS.ISI (( 1.0 * AHS.ISI/AHS.EN * 100 )) IF AHS.YR = "202#-202#" AND AHS.SP : "I" 

Absence Code List for a Specific Date Range

List of students with Absence Codes for each day of absence within a specific period of time sorted by Absence Code

LIST STU ATT STU.ID STU.NM STU.GR ATT.AL ATT.DT BY ATT.AL IF ATT.AL # " " AND ATT.DT > ##/##/20## AND ATT.DT < ##/##/20##

List of Absence Dates, Calendar Day#, Enter/Leave Codes and All Day Code in Attendance for a Specific Student

List of student Absence Dates, Calendar Day#, Enter/Leave Codes, and Absence All Day Codes for a specific student

LIST STU ATT STU.ID STU.TG STU.NM ATT.DT ATT.DY ATT.CD ATT.AL IF STU.ID = #########

Class List for Elementary Schools by Teacher

Class list for Elementary Schools sorted by Teacher Name

LIST STU STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW PRIMARYTEACHERNAME BY PRIMARYTEACHERNAME  

List of Students Who Were Absent Within the First 20 School Days by a Grade Level

List of students in a specific grade level who were absent within the first 20 days of the school calendar with their Absence Codes and any Special Program designation sorted by the Special Program code, Attendance Day and Attendance Code

LIST STU ATT STU.ID STU.NM STU.SP STU.GR ATT.DY ATT.AL BY STU.SP ATT.DY ATT.AL IF ATT.DY < 21 AND ATT.AL # " " AND STU.GR = #

List of Students who Enrolled or Changed Attendance in a Specific Calendar Month

Lists the enrollment changes in Attendance Enrollment for student who were newly enrolled or changed Student Program

LIST STU ATT STU.ID STU.NM STU.GR ATT.DT ATT.CD IF ATT.CD = E AND ATT.DT.MONTH = # AND ATT.DT.YEAR = 20##

List of Students with an All Day Code

List of students with an all day absence code on a specific date sorted by grade

LIST STU ATT STU.NM STU.GR ATT.DT ATT.AL BY STU.GR IF ATT.DT = ##/##/20## AND ATT.AL # " "

List of Students Who Are Reported as Entering and Leaving on the Same Date

List to find students who show as entering and leaving on the same day

LIST STU ATT STU.ID STU.NM STU.TG ATT.DT ATT.CD IF ATT.CD = B

List of Attendance Notes for Students by Teacher for Daily Attendance for a Specific Attendance Notes Date

List of Attendance Notes for students on a specific Attendance Note date includes:  Attendance Notes Date, Attendance Notes Code and Attendance Notes Comment sorted by teacher

LIST STU ATN STU.SC STU.ID STU.NM STU.GR PRIMARYTEACHERNAME ATN.DT ATN.CD? ATN.CO BY PRIMARYTEACHERNAME IF ATN.DT = ##/##/202#

List of Attendance Notes for Students by Teacher for Daily Attendance for Specific Attendance Notes Date Range

List of Attendance Notes for students during a specific Attendance Note range of dates includes:  Attendance Notes Date, Attendance Notes Code and Attendance Notes Comment sorted by teacher

LIST STU ATN STU.SC STU.ID STU.NM STU.GR PRIMARYTEACHERNAME ATN.DT ATN.CD? ATN.CO BY PRIMARYTEACHERNAME IF ATN.DT > ##/##/202# AND ATN.DT < ##/##/202#

List of Attendance Information for Students with an ADA Make-up Code 

Provides a list of students with Grade, Attendance All Day Code, Attendance Make-up Code, Attendance Make-up Date and Attendance Make-up Comment

LIST STU ATT STU.ID STU.NM STU.GR ATT.AL ATT.ADA ATT.ADT ATT.ACO IF ATT.ADA # " "

List of Student Absences and ADA Make-up Code

Provides a list to identify students with absences and if they received an ADA Make-Up Code for the absence

LIST STU ATT STU.ID STU.NM STU.GR ATT.AL ATT.ADA ATT.ADT ATT.ACO IF ATT.AL # " "

Period ATT:  List of Absence Entries for Specific Date

List of student's attendance entries for every period on a specific date and the student's Home Telephone Number and Parent's Work Numbers

LIST STU CAT SEC MST SSE STF CRS FTF STU.ID STU.NM STU.GR STU.TL STU.MW STU.FW CAT.DT STF.LN CRS.CO FTF.STI CAT.AC IF CAT.DT = ##/##/202# AND CAT.SE = MST.SE      

Period ATT:  List of Absence Entries for a 1st Period Class on a Specific Date and Section

List of student Absence Codes for a 1st period section with Attendance Date and Section Number on a Specific Date

• FTF.STI must equal Flex Period's short title for Period 1 equivalent. For example, if the FTF.STI = 1, then use 1, if the FTF.STI = AM, use AM.

List of Absence Entries by Teacher for a Specific Period 

LIST STU SEC MST FTF SSE STF IDN CAT STF.LN STU.ID STU.NM STU.GR FTF.STI CAT.DT CAT.AC IF FTF.STI = '##'

Enter the flex period short title

Period ATT:  Course Attendance Enrollment (CAR) Data for First 20 Days of School

List sorted by Student Number of students enrolled in a specific section with their start date and end date for a specific period of time (in this query for the first 20 days of school)

LIST STU CAR STU.ID CAR.CN CAR.DS CAR.DE CAR.D1 CAR.D2 CAR.SE IF CAR.SE = #### AND ( CAR.D2 = 0 OR CAR.D2 > 20 )

Period ATT:  List of Attendance Notes for Students by Teacher for Period Attendance for Specific Attendance Notes Date Range

List of Attendance Notes for students during a specific Attendance Note range of dates includes: Attendance Notes Period, Attendance Notes Date, Attendance Notes Code and Attendance Notes Comment sorted by teacher

LIST STU ATN TCH STU.SC STU.ID STU.NM STU.GR TCH.TE ATN.PD ATN.DT ATN.CD? ATN.CO BY TCH.TE IF ATN.DT >= ##/##/202# AND ATN.DT <= ##/##/202#

Period ATT:  Student Enrolled in Course Attendance (CAR) Prior to a Specific Date

List students who were enrolled in classes with Course information prior to a specific data

LIST STU CAR MST SSE STF CRS STU.ID STU.NM STU.NM STU.ETH STU.RC1 STU.LF STU.GR CAR.CN STF.LN CRS.CO CAR.SE CAR.DS CAR.DE IF CAR.DS < 11/01/2021 AND MST.SE = CAR.SE AND SSE.PR = 1    

Period ATT:  Course Attendance (CAR) List with Student ID, Student Name, Section Number and Start and End Date Course Changes During a Specific Date Range

List from CAR of Student ID and Name with Course changes during a specific Date Range including from CAR:  Period, Course Number, Section Number and the CAR Start and End Dates

LIST STU SEC MST SSE STF FTF CAR STU.ID STU.NM MST.SE CAR.SE FTF.STI STF.LN CAR.DS CAR.DE IF CAR.DS > ##/##/202# AND CAR.DE < ##/##/202#    

Period ATT:  List of Period Attendance Submitted with Date and Timestamp from the Attendance Submission Log

Provides a list from the Attendance Submission Log of School, Teacher Number, Date and each Period with submitted attendance and the corresponding Date and Timestamp.

LIST MST SSE FTF CAS CAS.SC STF.LN STF.FN CAS.SE CAS.DT CAS.FT CAS.DTS BY CAS.DT STF.LN STF.FN BY CAS.DT STF.LN STF.FN

List of Period Attendance Submitted with Date and Timestamp from the Attendance Submission Log for a specific date

LIST MST SSE FTF CAS CAS.SC STF.LN STF.FN CAS.SE CAS.DT CAS.FT CAS.DTS BY CAS.DT STF.LN STF.FN IF CAS.DT = ##/##/202#