Schedule a demo

Delivering Data You Can Trust

2 min read

Simplify Your CEDARS State Reporting for Washington in PowerSchool

July 7, 2022 at 9:00 AM

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

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
Al Momrik
Written by Al Momrik

Al Momrik works at Level Data as a Data Quality Analyst, arriving in 2013. He works primarily with the State Data Validation Suite, a series of services which help PowerSchool users to find errors in their data and correct them in a shorter amount of time. Before coming to Level Data, Al worked in a school district in Michigan for 23 years. He was a Technology Director, a SysAdmin for PowerSchool, and was responsible for all State data submissions. He has worked with PowerSchool since 2007. Al also is a presenter at 6-8 PowerSchool conferences around the country annually.

Post a Comment