The Comprehensive Education Data and Research System (CEDARS) is a longitudinal data warehouse of educational data. Districts report data on courses, students, and teachers. Course data includes standardized state course codes.
Student data includes Demographics, Enrollment information, Schedules, Grades, and Program participation.
Teacher data includes Demographics, Certifications, and Schedules.
That's where Level Data comes in!
Student Information Systems Supported
- PowerSchool - Schedule a demo
- Skyward - Become a pilot
- Synergy - Become a pilot
- eSchoolPlus - Become a pilot
Complete List of CEDARS Data Validation Rules
Listed below is the complete list of state reporting validation rules we provide for Washington districts using PowerSchool to make their CEDARS submission as easy and timely as possible and to maximize both state and federal funding.
RealTime Validation Rules
Courses
- WA: Courses: Advanced Placement Course Code
- WA: Courses: ALE Course Type
- WA: Courses: CIP Code
- WA: Courses: Course Designation Codes: Course Designation Code Advanced Placement
- WA: Courses: Course Designation Codes: Course Designation Code International Baccalaureate
- WA: Courses: Course Designation Codes: Course Designation Code Online
- WA: Courses: Course Designation Codes: Course Designation Code Tech Prep
- WA: Courses: CTE Course Equivalency Identification
- WA: Courses: CTE Equivalency
- WA: Courses: International Baccalaureate Course Code
- WA: Courses: State Course Code
Demographics
- WA: Demographics: Ethnicity Collection Method
- WA: Demographics: Legal First Name
- WA: Demographics: Legal Gender
- WA: Demographics: Legal Last Name
- WA: Demographics: Military Family Indicator
- WA: Demographics: Number Months Non US Attendance in School
- WA: Demographics: Race Collection Method
- WA: Demographics: Scheduling Ethnicity
Historical Grades
- WA: Historical Grades: Location ID
Staff
- WA: Staff: Information: DOB
- WA: Staff: Information: First Name
- WA: Staff: Information: Last Name
- WA: Staff: Information: Middle Name
- WA: Staff: Information: Staff Type Code
- WA: Staff: Information: Teacher Credential ID
State/Province
- WA: State/Province: English Learners (Limited English Proficiency) Information: Exit Reason Code
- WA: State/Province: English Learners (Limited English Proficiency) Information: Grade Level at Placement
- WA: State/Province: English Learners (Limited English Proficiency) Information: Instructional Model Code
- WA: State/Province: English Learners (Limited English Proficiency) Information: Placement Status
- WA: State/Province: English Learners (Limited English Proficiency) Information: Placement Test Code
- WA: State/Province: English Learners (Limited English Proficiency) Information: Placement Test Date
- WA: State/Province: English Learners (Limited English Proficiency) Information: Placement Test Score
- WA: State/Province: English Learners (Limited English Proficiency) Information: Program End Date
- WA: State/Province: English Learners (Limited English Proficiency) Information: Program Status Start Date
- WA: State/Province: English Learners (Limited English Proficiency) Information: Program/Eligibility Designation
- WA: State/Province: General Information: Birth Country
- WA: State/Province: Home County District Code
- WA: State/Province: Initial USA School Enrollment
- WA: State/Province: Kindergarten Program Enrollment
- WA: State/Province: Kindergarten Program State Funding
- WA: State/Province: Language Spoken At Home
- WA: State/Province: Primary Language
- WA: State/Province: Secure Student Identifier
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Acquisition and Use of Knowledge/Skills - Entry
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Acquisition and Use of Knowledge/Skills - Exit
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Acquisition and Use of Knowledge/Skills - Progress
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Appropriate Behaviors and Skills - Entry
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Appropriate Behaviors and Skills - Exit
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Appropriate Behaviors and Skills - Progress
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Positive Social-Emotional Skills - Entry
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Positive Social-Emotional Skills - Exit
- WA: State/Province: Special Education Information: Special Education Enrollments and Exits: PreK Positive Social-Emotional Skills - Progress
- WA: State/Province: Special Education Information: Special Education Program Enrollment: Exit Reason Code
- WA: State/Province: Special Education Information: Special Education Program Enrollment: Program End Date
- WA: State/Province: Special Education Information: Special Education Program Enrollment: Program Start Date
- WA: State/Province: Special Education Timeline Requirements: Consent Received Date
- WA: State/Province: Special Education Timeline Requirements: Determination Delay Reason
- WA: State/Province: Special Education Timeline Requirements: Eligibility Date
- WA: State/Province: Special Education Timeline Requirements: Eligible?
- WA: State/Province: Special Education Timeline Requirements: IEP Date
- WA: State/Province: State Graduation Requirements: ASVAB Administration Year
- WA: State/Province: State Graduation Requirements: ASVAB Test Score
- WA: State/Province: State Graduation Requirements: ASVAB Test Status
- WA: State/Province: State Graduation Requirements: Expected Year of Graduation
- WA: State/Province: State Graduation Requirements: Graduation Requirements Year
- WA: State/Province: Student Attributes and Programs Information: At Grade Level Student Met Learning Goal
- WA: State/Province: Student Attributes and Programs Information: Date of Beginning Score
- WA: State/Province: Student Attributes and Programs Information: Date of End Score
- WA: State/Province: Student Attributes and Programs Information: End Score
- WA: State/Province: Student Attributes and Programs Information: Exit Reason Code
- WA: State/Province: Student Attributes and Programs Information: Extended Learning Time Intervention
- WA: State/Province: Student Attributes and Programs Information: Identification Assessment
- WA: State/Province: Student Attributes and Programs Information: Program Code
- WA: State/Province: Student Attributes and Programs Information: Program End Date
- WA: State/Province: Student Attributes and Programs Information: Program Start Date
- WA: State/Province: Student Attributes and Programs Information: Progress Monitoring Assessment
- WA: State/Province: Student Attributes and Programs Information: Qualification Code
- WA: State/Province: Student Attributes and Programs Information: Tutoring Intervention
Transfer Info
- WA: Transfer Info: Current Enrollment: District of Residence
- WA: Transfer Info: Current Enrollment: ELL Program Enroll Date
- WA: Transfer Info: Current Enrollment: ELL Program Exit Date
- WA: Transfer Info: Current Enrollment: Exit Date
- WA: Transfer Info: Current Enrollment: ExitCode
- WA: Transfer Info: Current Enrollment: Full-Time Equivalency
- WA: Transfer Info: Current Enrollment: School Entry Date
- WA: Transfer Info: Current Enrollment: State Transitional Bilingual Program (STBP)
State Validation Rules
Demographics
- Missing Number Months Non US Attendance in School
- Missing/Invalid Birth Country
- Missing/Invalid Date of Birth
- Missing/Invalid Ethnicity Collection Method
- Missing/Invalid Federal Ethnicity
- Missing/Invalid Gender
- Missing/Invalid Home County District Code
- Missing/Invalid Initial USA School Enrollment
- Missing/Invalid Language Spoken at Home
- Missing/Invalid Legal First Name
- Missing/Invalid Legal Gender
- Missing/Invalid Legal Last Name
- Missing/Invalid Military Family Indicator
- Missing/Invalid Primary Language
- Missing/Invalid Race Collection Method
- Missing/Invalid Secure Student Identifier
- Missing/Invalid Serving County District Code
- Missing/Invalid Student Race
Enrollment
- District Entry Date/School Entry Date Mismatch
- Exit Date/Entry Date Mismatch
- Invalid District Entry Date after Re-enrollment
- Invalid Grade Level for Assigned School
- Invalid Section Enrollment Entry Date
- Invalid Section Enrollment Exit Date
- Mismatch District Exit Date/English Learners End Date
- Mismatch District Exit Date/Special Education Program End Date
- Mismatch Grade Level/Kindergarten Program Enrollment/Kindergarten Program State Funding
- Missing Expected Year of Graduation
- Missing/Invalid ASVAB Administration Year
- Missing/Invalid ASVAB Test Score
- Missing/Invalid ASVAB Test Status
- Missing/Invalid District Entry Date
- Missing/Invalid Entry Code
- Missing/Invalid Entry Date
- Missing/Invalid Exit Code
- Missing/Invalid Exit Date
- Missing/Invalid Full-Time Equivalency
- Missing/Invalid Graduation Requirements Year
- Missing/Invalid Kindergarten Program Enrollment
- Missing/Invalid Kindergarten Program State Funding
- Missing/Invalid School Entry Date
- Missing/Invalid School ID
- Overlapping School Enrollments
EL
- Mismatch Program/Eligibility Designation/Primary Language/Student Language Spoken in the Home
- Missing Initial Placement Test Date
- Missing/Invalid Exit Reason Code
- Missing/Invalid Grade Level at Placement
- Missing/Invalid Instructional Model Code
- Missing/Invalid Placement Status
- Missing/Invalid Placement Test Code
- Missing/Invalid Placement Test Date
- Missing/Invalid Placement Test Score
- Missing/Invalid Program End Date
- Missing/Invalid Program Status Start Date
- Missing/Invalid Program/Eligibility Designation
Special Education
- Mismatch Special Education Exit Reason/Special Education End Date
- Mismatch Special Education Start Date/Special Education End Date
- Missing Other Reason for Late Initial Evaluation
- Missing/Invalid Consent Received Date
- Missing/Invalid Early Childhood Program Skills Assessment Data
- Missing/Invalid Eligible?
- Missing/Invalid Initial IEP Date
- Missing/Invalid LRE Code
- Missing/Invalid Reason for Late Initial Evaluation/Eligibility
- Missing/Invalid Special Program Qualification Code for Special Education Students
Special Programs
- Mismatch Beginning Score/Date of Beginning Score
- Mismatch Date of Beginning Score/Date of End Score
- Mismatch End Score/Date of End Score
- Mismatch Special Program Start Date/Special Program End Date
- Missing At Grade Level Student Met Learning Goal
- Missing Date of Beginning Score
- Missing Special Program End Date
- Missing Special Program Exit Reason Code
- Missing Special Programs Qualification Code
- Missing/Invalid Amount of Academic Growth
- Missing/Invalid Beginning Score
- Missing/Invalid Extended Learning Time Intervention
- Missing/Invalid Identification Assessment
- Missing/Invalid Intervention During Regular School Day
- Missing/Invalid PreK Special Program Code
- Missing/Invalid Progress Monitoring Assessment
- Missing/Invalid Special Program Code 41 and 42 Exit Reason Code
- Missing/Invalid Special Program Exit Information for PreK Special Programs
- Missing/Invalid Special Programs Start Date
Incident Management
- Invalid date values for No Intervention Applied Action Code
- Invalid Duration of Exclusionary Action Days
- Invalid Total Amount of Exclusionary Time
- Mismatch Incident Date and Action Date
- Mismatch Safety and Security Information
- Misplaced Action
- Missing Incident Action
- Missing Incident Behavior
- Missing Incident Duration
- Missing Offender
- Missing Was the student injured during the action?
- Missing Weapon Type
- Missing/Invalid How many staff were injured during the action?
Courses
- Missing CIP Code
- Missing State Course Code
- Missing/Invalid Advanced Placement Course
- Missing/Invalid ALE Course Type for Online Designation
- Missing/Invalid CTE Course Equivalency Identification
- Missing/Invalid CTE Equivalency
- Missing/Invalid International Baccalaureate (IB) Code
Staff
- Missing Staff Type Code
- Missing/Invalid Date of Birth
- Missing/Invalid First Name
- Missing/Invalid Last Name
- Missing/Invalid Teacher Credential ID
Reports/Lists
- Duplicate Secure Student Identifier (SSID)
- Duplicate Student with similar name fields and matching DOB
- List of State Seal of Biliteracy Proficient (Program Code 42) and Graduation Pathway
- Military Family Indicator Data Not Available
- Mismatch Expected Year of Graduation/Graduation Requirements Year
- Students who are Excluded from State Reporting
Historical Grades
- Historical Grade Contains Non-Reportable Value
- Missing/Invalid Location ID
Miscellaneous
- Invalid Scheduled Next Year Grade
- Mismatch Enable Parent Access/Access ID/Access Password
- Mismatch Enable Student Access/Student UserName, Student Password
- Missing/Invalid Next School Information
- Next Year School/Next Year Grade Mismatch
If you have any questions or would like to request additional rules, please reach out to helpdesk@leveldata.com