170 likes | 273 Views
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
E N D
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 Data Warehouse Yonkers Monroe LHRIC WFL Level 2 Nassau Rochester Suffolk WNYRIC Buffalo NYC SED Data Repository Level 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
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
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
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)
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
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
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
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
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
New York State Student Identification System (NYSSIS) Districts Regional Data Warehouses (Level 1) New York State Student Identification System (NYSSIS) Response File
“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
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
Regional Data Warehouse (Level 1) State ID District SMS Student ID Data Set NYSSIS Near Match Resolution
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
Contact CNYRIC DW TEAM http://cnyric.org Data Warehouse