New CIO Training 2012-2013 Phase III: Verification Errors and Uploading Data to Level 1

1. New CIO Training 2012-2013Phase III:Verification Errors and Uploading Data to Level 1

2. Module Data Needed in Level 1 For Our First Submission • First Data Submission Due Date: 10/31/2011 • Modules: • Demographics (a.k.a. Student Lite) : All student records • Enrollment (a.k.a. Entry/Exit) : All student records • Program Fact (a.k.a. Program Services) : All program services, except CTE • BEDS Day Snapshot Records : BEDS Day Snapshot Records (all classified students who were enrolled on BEDS Day and receiving SE services) • Assessment: August 2012 Regents Assessments

3. Uploading (L1-Data Prep) Rules: • Run ALL verifications errors FIRST before starting to upload data (Reports/Demographics/Run Verification Errors) • Correct ALL Verification errors before starting to upload • After verification errors have been corrected, upload modules in this order: • Demographics • Enroll. • All Program Service Categories (check all option) • All Assessment Categories (check all option) • BEDS Day Snapshot

4. Import Error & Verification Error Review • Import Errors: Module-specific errors. When importing demographic files, you get demographic-only import errors. Clear import errors immediately before continuing. • Verification Errors: After all files (demo, enroll, PS, BEDS Snapshot, and Assessment) and all import errors have been cleared – run your verification errors. These errors are more sophisticated and are not module-specific (For example: verification errors look at enrollment records, and identify an error in Demographics)

5. How to Run All Verification Errors First Without Uploading • Run verification errors for ALL modules and correct these errors before uploading: • Go to “Reports” • Choose your module (i.e. Demographics, Enroll, etc.) • Click the button “Run Verification Errors” • When ALL verification errors have been corrected, you can begin to upload (L1-Data Prep)

6. Demographics (L1-Data Prep Screen) Validate now Check the Box Create File for Level 1 “Save As” for a text file for backup

7. Enrollment (L1-Data Prep Screen) Validate now Check the Box Create File for Level 1 “Save As” for a text file for backup

8. Program Fact (L1-Data Prep Screen) Check the “Check All” box, Validate Now, Create File for Level 1, and then “Save As”

9. Assessment (L1-Data Prep Screen) Check the “Check All” box, Validate Now, Create File for Level 1, and then “Save As”

10. BEDS Snapshot (L1-Data Prep Screen) Check “BEDS Day Snapshot” box, Validate Now, Check the small white box, Create File for Level 1, and then “Save As”

11. Contacts/Cheat Sheets: • Please see our “Level 0: Importing/Manually Entering/Uploading/Errors - Cheat Sheets” section on our Resources/Announcements/Downloads page for Cheat Sheets covering how to upload data: http://portal.neric.org/sites/services/DW/Pages/Downloads.aspx • Please email all questions to: DWHelp@neric.org • Or call our Data Warehouse Hotline at: 518-862-5409