List Queries

Total Queries

Change Queries


This is a collection of queries related to Attendance that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


Flex Queries:  If a query needs a conversion for Flex Scheduling, it is displayed below the original query in blue.

  

List Queries

EOY 3 Attendance Queries for Reconciling CALPADS Data


See: EOY 3 Attendance Queries


List of Students if Attendance Enrollment Teacher Does Not Match Teacher/Counselor (STU.CU)

To verify the Attendance Enrollment Teacher matches the Student Demographic Teacher


LIST STU ATT STU.ID STU.NM STU.GR STU.CU ATT.TN IF ATT.TN # STU.CU


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/Teacher Name. Ensure that Attendance History configuration process is updated nightly to allow for the most accurate up-to-date data.

LIST STU TCH AHS STU.ID STU.SC STU.NM TCH.TE AHS.SP AHS.EN AHS.AB AHS.PR (( 1.0 * AHS.PR/AHS.EN * 100 )) BY AHS.SCL IF AHS.EN # 0 AND AHS.YR = "20##-20##" AND AHS.SCL = STU.SC AND LOC.U = 0

(Extract to Excel)


Flex: List of Attendance Percentages for Students by Counselor/Teacher and School for a Specific School Year
By Counselor Name
LIST STU AHS STU.ID STU.SC STU.NM STU.CU AHS.SP AHS.EN AHS.AB AHS.PR (( 1.0 * AHS.PR/AHS.EN * 100 )) BY AHS.SCL IF AHS.EN # 0 AND AHS.YR = "20##-20##" AND AHS.SCL = STU.SC AND LOC.U = 0 
  
Primary Class Tracking by Primary Teacher
LIST STU AHS STU.ID STU.SC STU.NM PRIMARYTEACHERNAME AHS.SP AHS.EN AHS.AB AHS.PR (( 1.0 * AHS.PR/AHS.EN * 100 )) BY AHS.SCL PRIMARYTEACHERNAME  IF AHS.EN # 0 AND AHS.YR = "20##-20##" AND AHS.SCL = STU.SC  AND LOC.U = 0 

MST Schedules
LIST STU SEC MST SSE STF FTF AHS STU.ID STU.SC STU.NM STU.CU MST.SE STF.LN FTF.STI AHS.SP AHS.EN AHS.AB AHS.PR SSE.PR (( 1.0 * AHS.PR/AHS.EN * 100 )) BY AHS.SCL MST.SE IF AHS.EN # 0 AND AHS.YR = "20##-20##" AND AHS.SCL = STU.SC AND LOC.U = 0 AND SSE.PR : 1  



List of Attendance Percentages by Student to help determine Absentee Rate.

Ensure that Attendance History configuration process is updated nightly to allow for the most accurate up-to-date data.

LIST STU AHS STU.ID STU.GR STU.NM AHS.EN AHS.PR (( LEFT ( (( 100 * AHS.PR / AHS.EN  )) ,5 ) + "%" )) AHS.AB AHS.AU AHS.TD AHS.YR IF AHS.YR = "202#-202#" AND AHS.EN > 0




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

Attendance History Configuration process must be run for the 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" 


Same for flex


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##


Same for flex


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 = #########


Same for flex


Class List for Elementary Schools by Teacher

Class list for Elementary Schools sorted by Teacher Name


LIST STU TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE


Flex: Class List for Elementary Schools by Teacher

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 = #


Same for flex


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##


Same for flex


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 # " "


Same for flex


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


Same for flex


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 TCH STU.SC STU.ID STU.NM STU.GR TCH.TE ATN.DT ATN.CD? ATN.CO BY TCH.TE IF ATN.DT = ##/##/202#


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

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 TCH STU.SC STU.ID STU.NM STU.GR TCH.TE ATN.DT ATN.CD? ATN.CO BY TCH.TE IF ATN.DT >= ##/##/202# AND ATN.DT <= ##/##/202#


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

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 # " "


Same for flex


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 # " "


Same for flex


Elem w/MST: List of Students if Attendance Teacher Does Not Match the Class Schedule Teacher for the Designated Attendance Period - Elementary with Master Schedule

Verifies that the Student Demographic Teacher matches the Class Schedule Teacher for Attendance Period in Elementary with Master Schedule


LIST STU SEC MST STU.ID STU.NM STU.GR STU.CU MST.TN IF MST.PD = # AND MST.TN # STU.CU


In flex schools, 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.


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 ATT STU.ID STU.NM STU.GR STU.TL STU.MW STU.FW ATT.A0 ATT.A1 ATT.A2 ATT.A3 ATT.A4 ATT.A5 ATT.A6 ATT.A7 ATT.A8 ATT.A9 IF ATT.DT = ##/##/20##


Flex: List of Absence Entries for Specific Date 
LIST STU CAT SEC MST FTF STU.ID STU.NM STU.GR STU.TL STU.MW STU.FW CAT.DT CAT.SE MST.SE FTF.STI CAT.AC IF CAT.DT = ##/##/202# AND CAT.SE = MST.SE

Flex - With Teacher and Course Information

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


LIST STU SEC MST ATT STU.ID STU.NM SEC.SE ATT.DT ATT.A1 IF MST.PD = #  AND ATT.DT > ##/##/202#


Flex: List of Absence Entries for a 1st Period Class on a Specific Date and Section
LIST STU SEC MST CAT FTF STU.ID STU.NM STU.GR SEC.SE CAT.DT FTF.STI IF FTF.STI = 1 AND CAT.DT = ##/##/202# AND ( CAT.SE = MST.SE ) 
  • 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.


Flex: 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 MST.FSQ = ## 


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.D = 0 OR CAR.D2 > 20 )


Same for flex


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#


Flex: List of Attendance Notes for Students by Teacher for Period Attendance for Specific Attendance Notes Date Range
LIST STU ATN SEC MST SSE STF FTF STU.SC STU.ID STU.SN STU.NM STU.GR STF.LN ATN.SE MST.SE ATN.DT ATN.CD? ATN.CO IF ATN.DT >= ##/##/202# AND ATN.DT <= ##/##/202# AND ATN.SE = MST.SE  

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 TCH CRS STU.ID STU.NM STU.NM STU.ETH STU.RC1 STU.LF STU.GR CAR.CN CRS.CO CAR.SE TCH.TE IF CAR.DS < ##/##/202#


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

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 CAR STU.ID STU.NM CAR.PD CAR.CN CAR.SE CAR.DS CAR.DE IF CAR.DS > ##/##/20## OR CAR.DE < ##/##/20##


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

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 ASL SC TN DT P0 P1 P2 P3 P4 P5 P5 P7 P8 P9 (( CAST(T0 AS DATETIME) )) (( CAST(T1 AS DATETIME) )) (( CAST(T2 AS DATETIME) )) (( CAST(T3 AS DATETIME) )) (( CAST(T4 AS DATETIME) )) (( CAST(T5 AS DATETIME) )) (( CAST(T6 AS DATETIME) )) (( CAST(T7 AS DATETIME) )) (( CAST(T8 AS DATETIME) )) (( CAST(T9 AS DATETIME) ))


Flex: List of Period Attendance Submitted with Date and Timestamp from the Attendance Submission Log by Date and Teacher Name

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


Flex: 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#


Total Queries

Total of All Day Absences for a Specific Date Range

Total of All Day Absences for a specific Date Range


TOTAL ATT IF AL # " " AND DT > ##/##/20## AND DT < ##/##/20##


Same for flex


Period ATT:  Total 1st Period Absences for a Specific Date Range

Total of 1st Period Absences (excluding tardies) for a specific Date Range


TOTAL ATT IF A1 # " " AND A1 # T AND DT  > ##/##/20## AND DT < ##/##/20##


Total of ADA Makeup for Each Attendance Month

Total of how many days of ADA was received for each Attendance Month


TOTAL STU ATT DAY.MO BY DAY.MO IF ADA = M


Same for flex



Change Queries

Elem w/MST:  If Attendance was Initialized with the Wrong Period

If the School Type is designated as Elementary w/Master Schedule and Attendance was initialized with the wrong period. 

Run the following Change queries:


1.  Change the Counselor/Teacher Number in Demographics to match the Teacher for a specific Period
     CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = #


2.  Change the Teacher Number in Attendance Enrollment to match the Counselor/Teacher Number
     CHANGE STU ATT ATT.TN TO STU.CU IF ATT.CD > " "


Period ATT:  Absence Code Change

Change to clear Absence Code of "I" (Illness) to a blank for all of the students in a specific class (section) for Attendance Period 1 on a specific date.


CHANGE STU SEC ATT ATT.A1 TO " " IF SEC.SE = #### AND ATT.DT = ##/##/20## AND ATT.A1 = I


Period ATT:  Change the Student's Counselor/Teacher Number to match the Teacher number for a Specific Period for all Grade Levels Excluding a Specific Grade

Change the student's Counselor/Teacher Number to match the Teacher Number for a specific Period for all Grades excluding a specific Grade


CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = 6 AND GR # 6