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