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.


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

LIST STU TCH AHS STU.SC STU.NM TCH.TE AHS.SP AHS.EN AHS.AB AHS.PR (( AHS.PR/CAST(AHS.EN AS DEC(10,3) )*100 )) BY AHS.SCL IF AHS.EN # 0 AND AHS.YR = "201##20##"

(Extract to Excel)


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 TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE


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 = ##/##/##18 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 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 # " "


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


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


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 SEC.SE = ####  AND ATT.DT > ##/##/20##


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


Period ATT:  Student Enrolled in Course Attendance (CAR) on 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 < ##/##/20##


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


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 < 1##/##/20##


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


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