Table of Contents


This is a collection of queries related to CALPADS 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

Fall 1 Queries for Reconciling CALPADS Data


See:  Fall 1 Queries and Reports


Fall 2 Queries for Reconciling CALPADS Data


See:  Fall 2 Queries


EOY 1 Queries for Reconciling CALPADS Data


See:  EOY 1 Course and Career Pathway Queries


EOY 2 Program Queries for Reconciling CALPADS Data


See:  EOY 2 Program Queries and Reports


EOY 3 Discipline Queries for Reconciling CALPADS Data


See: EOY 3 Discipline Queries and Reports


EOY 3 Attendance Queries for Reconciling CALPADS Data


See: EOY 3 Attendance Queries


SCSE:  List of English Language Learners enrolled on Information Day with the section information and reported Ed Service:

List of students and their Enrollment Date, Section Number, Course Number, Course Name, Language Fluency, Ed Services reported on the section, student Start Date in class, student End Date in class if a student is designated as an English Language Learner sorted by Section Number 


LIST STU CAR SEC MST CRS  STU.ID STU.NM STU.ED CAR.SE CRS.CN CRS.CO STU.LF MST.ESR CAR.DS CAR.DE BY CAR.SE IF CAR.DS < 10/##/202# AND CAR.DE > 10/##/202# AND STU.LF = L AND CAR.SE = MST.SE

(The first date should be the date after Information Day.  The second date should be the date after Information Day and the Language Fluency should the English Learner code value)


SINF:  List of Students with Birthdate, District Enter Date, Stude


SENR:  List of Students Enrolled in a Specific Course on Information Day

List of students enrolled in a specific course on Information Day sorted by Student Name and Class Period


LIST STU CAR TCH CRS STU.CID STU.NM CAR.CN CRS.CO CAR.PD CAR.SE TCH.TE BY STU.NM CAR.PD IF CAR.DS < ##/##/20## AND CAR.DE > ##/##/20##  AND CRS.CN = ####

(Use Information Date in the date fields)


SINF:  List of Students with Birthdate, District Enter Date, Student Enrollment Data and Initial US School Enrollment

Provides a list with student Birthdate, Enter Dates and US School Enrollment Date to help resolve Student Information (SINF) anomalies


LIST STU LAC STU.CID STU.ID STU.NM STU.GR STU.BD STU.DD STU.ED LAC.USS


SINF:  List of Students with Birth City, Birth State, Birth Country, Language Fluency, Enrolled in US School Less Than Three Years For Students Not Born in the US

Provides a list of student birth information and  to help resolve Student Information (SINF) anomalies for students not born in the US


LIST STU SSD STU.NM STU.BCY STU.BST STU.BCU STU.LF SSD.SUS IF STU.BCU # US


SPRG:  List of students with an Active Special Education Record

Provides a list of Students, Grade, Teacher, Disability, Special Education Entry Date for students with an active IEP


LIST STU IDN CSE TCH STU.ID STU.NM STU.GR TCH.TE CSE.DI CSE.ED CSE.XD IF CSE.DI > 0 AND CSE.XD = NULL


SELA:  List of Students with Language Acquisition Fields for Verifying Student English Language Acquisition (SELA)

List of students with CALPADS Language Acquisition fields to help resolve Student English Language Acquisition (SELA) anomalies


LIST STU LAC STU.SC STU.ID STU.NM STU.GR STU.LF LAC.STS LAC.USS LAC.EAC LAC.EAD STU.DD STU.ED BY STU.SC STU.LF


CRSE:  List of Teachers with a Multiple Teacher Status Code 

Lists Teachers with a Multiple Teacher Status Code and the additional Teacher Numbers


1.  Elementary from Teacher Table (TCH)

     LIST TCH TE MTS ID2 ID3


2.  Secondary from Master Schedule Sections (MST.SE)

     LIST MST SE TN MTS TN2 TN3


CRSE:  List of Teacher Educational Service, Language of Instruction and Instructional Strategy Codes

Lists Teacher Educational Service, Language of Instruction and Instruction Strategy codes


1.  Elementary from Teacher Table (TCH)

     LIST TCH TE ESR LI INS


2.  Secondary from Master Schedule Sections (MST.SE)

     LIST MST TCH MST.SE TCH.TE MST.ESR MST.LI MST.INS


SCSE:  List of Teachers Missing a Staff ID in the Teacher Table

Provides a list to verify that each Teacher record is linked to a Staff ID


LIST TCH TE ID IF ID = " "


SCSE:  List of Teachers Missing a SEID - District Level

Provides a list to very that Teacher in the Staff Table has a SEID


LIST STF LN FN SID IF TG # I AND SID = " "


Change Queries

SENR:  Change Graduation Fields for 12th Grade Students

Mass populates the Completion Status (STU.HSG) and Completion Date (STU.DG) fields for 12th graders


1.  Change students in 12th grade to a Completion Status of 100 - Graduated, Standard HS Diploma if the 

     Completion Status field has not been populated

     CHANGE STU STU.HSG TO 100 IF GR = 12 AND STU.HSG = " "

   

2.  Change students in 12th grade to have a specific Completion Date if the Completion Date has not been populated

     CHANGE STU DG TO MM/DD/20YY IF GR = 12 AND DG = NULL


CRSE:  Change Language of Instruction to Blank if Erroneously Populated with code 00 - English or 37 - Sign Language for a Teacher with an Educational Service Code of 4 - ELD and SDAIE Not Primary Language

Mass removes the erroneously codes because a Language of Instruction is Blank if the Education Service Code is 4 - ELD and SDAIE Not Primary Language.


1.  Elementary from the Teacher Table (TCH)

     CHANGE TCH LI TO " " IF LI = 00 OR LI = 37 AND ESR = 4


2.  Secondary from the Master Schedule Sections (MST.SE)

     CHANGE MST LI TO " " IF LI = 00 OR LI = 37 AND ESR = 4