The California Longitudinal Pupil Achievement Data System (CALPADS) is the foundation of California’s K–12 education data system, comprising student demographic, program participation, grade level, enrollment, course enrollment and completion, discipline, and statewide assessment data.
In order to meet the requirements of California Education Code Section 60900, Local Education Agencies (LEAs) shall retain and report to CALPADS individual pupil and staff records, including:
- Statewide Student Identifier (SSID) data
- Student enrollment and exit data
- All necessary data to produce required graduation and dropout rates
- Demographic data
- Data necessary to comply with the No Child Left Behind Act of 2001
- Other data elements deemed necessary by the State Superintendent of Public Instruction
LEA maintenance of individual SSIDs includes the accurate and timely reporting of demographic, program, local student enrollment, and exit data to CALPADS, and the timely resolution of SSID anomalies with other LEAs.
Failure of LEAs to comply with state law by not meeting CALPADS reporting requirements may result in zero enrollment counts on official state and federal reports as well as on official, publicly-accessible web sites. In addition, zero enrollment counts will result in the loss of any funding based on official enrollment.
That's where Level Data comes in!
Complete List of CALPADS Data Validation Rules
Listed below is the complete list of state reporting validation rules we provide for California districts using PowerSchool to make their CALPADS submission as easy and timely as possible and to maximize both state and federal funding.
RealTime Validation Rules
Courses
- CA: Courses: Alternate Course Number
- CA: Courses: CTE Provider Code
- CA: Courses: Language of Instruction Code
Demographics
- CA: Demographics: Date of Birth
- CA: Demographics: Father
- CA: Demographics: First Name
- CA: Demographics: Gender
- CA: Demographics: Last Name
- CA: Demographics: Legal First Name
- CA: Demographics: Legal Last Name
- CA: Demographics: Legal Middle Name
- CA: Demographics: Middle Name
- CA: Demographics: Mother
- CA: Demographics: Race
- CA: Demographics: SSN
Scheduling Setup
- CA: Scheduling Setup: Next Year Grade
Staff
- CA: Staff: Information: Race
State/Province
- CA: State/Province: Career and Technical Education (CTE): Academic Year
- CA: State/Province: English Learners and Immigrant Information: Proficient or Advanced for ELA Code
- CA: State/Province: Program Eligibility: Education Program Membership Start Date
- CA: State/Province: Student Information: AKA First Name
- CA: State/Province: Student Information: AKA Last Name
- CA: State/Province: Student Information: AKA Middle Name
- CA: State/Province: Student Information: Birth City
- CA: State/Province: Student Information: Birth Country
- CA: State/Province: Student Information: Birth State/Province
- CA: State/Province: Student Information: Enrolled in US less than Three Cumulative Years
- CA: State/Province: Student Information: Enrollment Status Code
- CA: State/Province: Student Information: Initial US School Enrollment Date
- CA: State/Province: Student Information: Parent/Guardian Highest Education Level
- CA: State/Province: Student Information: Statewide Student Identifier (SSID)
Transfer Info
- CA: Transfer Info: Current Enrollment: Exit Code
- CA: Transfer Info: Current Enrollment: Full-Time Equivalency
State Validation Rules
Demographics
- CA: Demographics (SINF-CALPADS): Incomplete Apt/Suite
- CA: Demographics (SINF-CALPADS): Invalid Alias Middle Name
- CA: Demographics (SINF-CALPADS): Invalid Middle Name
- CA: Demographics (SINF-CALPADS): Missing Enrolled in US School less than Three Cumulative Years
- CA: Demographics (SINF-CALPADS): Missing Student Initial US School Enrollment Date
- CA: Demographics (SINF-CALPADS): Missing/Invalid Address Information
- CA: Demographics (SINF-CALPADS): Missing/Invalid Alias First Name
- CA: Demographics (SINF-CALPADS): Missing/Invalid Alias Last Name
- CA: Demographics (SINF-CALPADS): Missing/Invalid Birth Country
- CA: Demographics (SINF-CALPADS): Missing/Invalid Date of Birth
- CA: Demographics (SINF-CALPADS): Missing/Invalid Federal Ethnicity
- CA: Demographics (SINF-CALPADS): Missing/Invalid First Name
- CA: Demographics (SINF-CALPADS): Missing/Invalid Gender
- CA: Demographics (SINF-CALPADS): Missing/Invalid Last Name
- CA: Demographics (SINF-CALPADS): Missing/Invalid Parent/Guardian Highest Education Level
- CA: Demographics (SINF-CALPADS): Missing/Invalid Race Code
- CA: Demographics (SINF-CALPADS): Missing/Invalid SSID
- CA: Demographics (SINF-CALPADS): Student Last/Legal Last Name contains Suffix
Enrollment
- CA: Enrollment (SENR): District Entry Date/School Entry Date Mismatch
- CA: Enrollment (SENR): Enrollment from Previous School Year Not Exited
- CA: Enrollment (SENR): Exit Date/Entry Date Mismatch
- CA: Enrollment (SENR): Invalid Enrollment Status - Receiving Specialized Services Only
- CA: Enrollment (SENR): Invalid Enrollment Status Code For Exit Code E170
- CA: Enrollment (SENR): Invalid Entry Date/Exit Date for Exit Code N420 or N470
- CA: Enrollment (SENR): Invalid Exit Code E155
- CA: Enrollment (SENR): Invalid Exit Code N420
- CA: Enrollment (SENR): Invalid Secondary Enrollment Exit Code
- CA: Enrollment (SENR): Invalid Short Term Enrollment - Exceeds 30 Days
- CA: Enrollment (SENR): Mismatch Between School of Attendance and School of Attendance NPS
- CA: Enrollment (SENR): Mismatch on Exit Code and Grade Level
- CA: Enrollment (SENR): Missing School Completion Status for Golden State Seal Merit
- CA: Enrollment (SENR): Missing School Completion Status for Student Seal of Biliteracy Indicator
- CA: Enrollment (SENR): Missing/Invalid District of Geographic Residence Code
- CA: Enrollment (SENR): Missing/Invalid Entry Date
- CA: Enrollment (SENR): Missing/Invalid Exit Code
- CA: Enrollment (SENR): Missing/Invalid Exit Date
- CA: Enrollment (SENR): Missing/Invalid FTE ID
- CA: Enrollment (SENR): Missing/Invalid New Enrollment Line for Exit Code E150
- CA: Enrollment (SENR): Missing/Invalid School Completion Status
- CA: Enrollment (SENR): Missing/Invalid School ID
- CA: Enrollment (SENR): Overlapping School Enrollments
- CA: Enrollment (SENR): UC/CSU Course Requirements/School Completion Status Mismatch
Staff Demographics
- CA: Staff Demographics (SDEM-CALPADS): Invalid Staff Age
- CA: Staff Demographics (SDEM-CALPADS): Invalid Staff Employment End Date
- CA: Staff Demographics (SDEM-CALPADS): Invalid Teacher/Staff First Name
- CA: Staff Demographics (SDEM-CALPADS): Invalid Teacher/Staff Last Name
- CA: Staff Demographics (SDEM-CALPADS): Mismatch between Years in District and Years of Service
- CA: Staff Demographics (SDEM-CALPADS): Missing Staff Total Years of Educational Service
- CA: Staff Demographics (SDEM-CALPADS): Missing Statewide Educator ID (SEID)
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Federal Ethnicity
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Gender
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Race Code
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Staff Date of Birth
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Staff Employment Start Date
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Staff Employment Status Code
- CA: Staff Demographics (SDEM-CALPADS): Missing/Invalid Staff Highest Degree Code
- CA: Staff Demographics (SDEM-CALPADS): Teacher with SEID of 9999999999
If you have any questions or would like to request additional rules, please reach out to helpdesk@leveldata.com
