160 likes | 245 Views
CEDARS – Comprehensive Education Data and Research System. CEDARS Submissions March 23, 2012 Webinar File Processor Dashboard Submission Exceptions. CEDARS Submission Agenda. CEDARS Submissions File Processor – How does it work? Submissions Tab Dashboard Submission Exceptions
E N D
CEDARS – Comprehensive Education Data and Research System CEDARS Submissions March 23, 2012 Webinar File Processor Dashboard Submission Exceptions
CEDARS Submission Agenda • CEDARS Submissions • File Processor – How does it work? • Submissions Tab • Dashboard • Submission Exceptions • Submission List • CEDARS Resources and Materials Mar 23, 2012
CEDARS Submissions How does data get from the district to CEDARS? Step 1: CEDARS Submission 13 Text Files of Students, Staff and Courses School District Data Students, Staff and Courses from all schools District or Vendor create CEDARS extract Mar 23, 2012
CEDARS Submissions How does data get from the district to CEDARS? Step 2: CEDARS Submission Text Files of Schools, Students, Staff and Courses CEDARS File Processor District or Vendor send submission via SFTP Mar 23, 2012
CEDARS File Processor • CEDARS Progress Bar - 6 steps • Green = Successful/Moves file to next step • Red = Error/Stopped at this step • Grey = In-process or waiting • “Check” indicates that the step is done Mar 23, 2012
CEDARS File Processor • Files Received – Step 1 • Grey background with green letters indicateCEDARS is working on step 2 Mar 23, 2012
CEDARS File Processor • File Structure Check – Step 2 • All required files are there (13 or 15) • Files are named correctly and for the same school year and correct file formatting • Red with “x” indicates step 2 failed Mar 23, 2012
CEDARS File Processor • Data Validation – Step 3 • Submission Exceptions (Submission errors) • Structural • Business System is actively checking for exceptions/errors Data Validation process failure – OSPI must resolve (Should not occur!) Mar 23, 2012
CEDARS File Processor • Hold – Step 4 • Waiting for submission nightly loading Submission has submission exceptions/errors (yellow exclamation) No Submission exceptions/errors Mar 23, 2012
CEDARS File Processor • Logical Delete – Step 5 Logical Delete threshold is reached: submission is stopped and not loaded Mar 23, 2012
CEDARS File Processor • Load to CEDARS – Step 6 Submission is loaded – data is loaded to CEDARS (Submission exception/error records are not loaded) Submission is loaded – data is loaded to CEDARS (No submission exceptions, so all data is successful) Mar 23, 2012
CEDARS File Processor • Performed within about half hour of receipt of the submission! • Allows for resubmission same day to correct submission exceptions/errors Mar 23, 2012
CEDARS File Processor • Check-out some Test data live in our Test environment! Mar 23, 2012
CEDARS Resources and Materials Mar 23, 2012
CEDARS Website: www.k12.wa.us/CEDARS Mar 23, 2012
Questions & Answers • This webinar recording will be posted to the K12 web site at http://www.k12.wa.us/CEDARS THANK YOU! OSPI Customer Support customersupport@k12.wa.us 1.800.725.4311 Emily Rang Meaghan Thompson Magen Blevins Micah Ellison Mar 23, 2012