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
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 C
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
SPRG: Mega Migrant Ed Dashboard Information
Provides a list of Students and Mailing Addresses, Parent/Guardian information on Demographics, Telephone, Birth State, if a student has a Migrant ID and the student is Active.
LIST STU SSD STU.HL? STU.SC? STU.CID STU.NM STU.AD STU.CY STU.ST STU.ZC STU.PG STU.TL STU.BST IF SSD.MID # " " AND STU.TG = " "
SPRG: Mega Migrant Ed Dashboard Information
Provides a list of Student Home Language, School, SSID, Student Name, Student Address, Parent/Guardian information on Demographics, Telephone, Birth State, if a student has a Migrant ID and the student is Active.
LIST STU SSD STU.HL? STU.SC? STU.CID STU.NM STU.AD STU.CY STU.ST STU.ZC STU.PG STU.TL STU.BST IF SSD.MID # " " AND STU.TG = " "
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