1 / 17

Regional Data Warehouse Unique Student ID

Regional Data Warehouse Unique Student ID. District 1. District 2. District 3. District 1. District 2. Statewide Reports Service. District 3. New York State eScholar Data Warehouses. Regional Data Warehouses Level 1. NERIC. SCT. Broome. MORIC. CNYRIC. Syracuse. MHRIC. Statewide

Download Presentation

Regional Data Warehouse Unique Student ID

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Regional Data Warehouse Unique Student ID

  2. District 1 District 2 District 3 District 1 District 2 Statewide Reports Service District 3 New York State eScholar Data Warehouses Regional Data Warehouses Level 1 NERIC SCT Broome MORIC CNYRIC Syracuse MHRIC Statewide Data Warehouse Yonkers Monroe LHRIC WFL Level 2 Nassau Rochester Suffolk WNYRIC Buffalo NYC SED Data Repository Level 3

  3. NYS Student Data System Instructional Resources Statewide Data Warehouse (Level 2) Core Reports Data Readiness/CIO Statewide Data Standards Regional Data Warehouse (Level 1) Student ID

  4. NYS Student Data Warehouse System SED Repository Statewide Data Warehouse with Unique Student ID (Level 2) Regional Data Warehouse (Level 1) with Unique Student ID

  5. New York State Student Identification System (NYSSIS) CENTRAL NEW YORK REGIONAL DATA WAREHOUSE District’s Student Management Systems Sagent Tools (data loading) Statewide Data Warehouse Level 2 Regional Data Warehouse Oracle DB eScholar Data Files DATA MENTOR COGNOS ReportNet & PowerPlay School Districts

  6. Relies on a standard “student identification data set” Data is submitted through regional student data warehouses and ID is returned to the warehouse. Matching engine uses clues and rules to match students to existing ID Three choices: Match New ID Near match Human review for less than 1% NYSED will not have access to any personally identifiable information. NYS Unique ID System(NYSSIS)

  7. New York State Student Identification System (NYSSIS) Districts Statewide Data Warehouse (Level 2) Regional Data Warehouses (Level 1) New York State Student Identification System (NYSSIS) Near Match Reconciliation Response File Request File Report Data

  8. Student ID Data Set • First Name, Middle Name, Last Name • Guardian Name(s) • DOB • Home Language • Birthplace • Date of first polio immunization • Gender • Ethnicity • Address • Date of first entry to grade 9 • Local student ID

  9. Getting an ID • Bulk submission • Extract the “student lite” data from SMS to the data warehouse. • RIC submits a file containing the student ID data set for each student • Submit via secure FTP • Automatic processing of files each night • Tested on 300,000 record file • Required only for “new” students

  10. New York State Student Identification System (NYSSIS) Regional Data Warehouses (Level 1) New York State Student Identification System (NYSSIS) District SMS Request File Demographic Data

  11. Assigned ID is returned via a delimited file File contains NYS Student ID and Local ID etc. File is sent back to RIC 8765432109|32908 ID Assignment State ID Local ID

  12. New York State Student Identification System (NYSSIS) Districts Regional Data Warehouses (Level 1) New York State Student Identification System (NYSSIS) Response File

  13. “Near Match Resolution” • System cannot automatically resolve all requests for Ids • Human review is required for those records that cannot be automatically matched • School district personnel will receive training in “resolving the queue” of unmatched records

  14. New York State Student Identification System (NYSSIS) Districts Regional Data Warehouses (Level 1) New York State Student Identification System (NYSSIS) Near Match Reconciliation Response File

  15. Regional Data Warehouse (Level 1) State ID District SMS Student ID Data Set NYSSIS Near Match Resolution

  16. Authorized Users • Obtain and complete application • CNYRIC Web site http://cnyric.org • Return to CNYRIC • CNYRIC submits to SED • User ID sent via mail • Password sent via email • Password expires every 60 days

  17. Contact CNYRIC DW TEAM http://cnyric.org Data Warehouse

More Related