New York Statewide Data Warehouse Guidelines for Extracts ...



New York State

Student Information Repository System

- SIRS -

Guidelines for Extracts

for use in

2007-08

April 30, 2008

Version 3.2

The University of the State of New York

THE STATE EDUCATION DEPARTMENT

Information and Reporting Services

Albany, New York 12234

New York State Education Department Contact Information

|Information and Reporting Services (IRS) |Clara Browne |(518) 474-7965 |

| |Ron Danforth | |

|Test Administration |Steven Katz |(518) 474-5099 |

|Students with Disabilities |Inni Barone |(518) 486-4678 |

|NYS Alternate Assessment |Victoria Ferrara |(518) 474-1129 |

|Bilingual Education |Pedro Ruiz |(518) 474-8775 |

|System of Accountability for Student Success |Ira Schwartz |(718) 722-2796 |

|Migrant Education Program |Ivelisse Rivera |(518) 473-0295 |

|Compensatory Education |Roberto Reyes |(518) 473-0295 |

| |Sandra Norfleet |(718) 722-2636 |

|Child Nutrition Program |Fran O’Donnell |(518) 473-8781 |

Statewide Data Warehouse e-mail address:

Use this address for questions and comments about this document.

StudentData@mail.

Important Web Addresses:

New York State Education Department



Information and Reporting Services

emsc.irts

New York State Testing and Accountability Reporting Tool

or emsc.irts/nystart

New York State Student Identification System (NYSSIS)

emsc.irts/SIRS/

State Repository System

emsc.irts/SIRS/

Office of State Assessment

emsc.osa/

System of Accountability for Student Success

emsc.nyc/accountability.html

New York State Alternate Assessment

vesid.specialed/alterassessment/home

Vocational and Educational Services for Individuals with Disabilities

vesid.

Special Education Data Collection Analysis and Reporting (SEDCAR)

vesid.sedcar/

Academic Intervention Services

emsc.part100/pages/topics.html

NYSED information on education requirements, exams, tests and assessments

emsc.deputy/Documents/alternassess.htm

Revision History

|Version |Date |Comments |

|3.0 |December 19 |Initial Release |

|3.1 |March 20 |o Section 1; minor rewrites for clarity and under “Who must be reported?”, clarified issue about |

| | |home-schooled students status |

| | |o page 7 and former pages 48 & 49; deleted Extract Specifications – Template and Sample Data for |

| | |Post_School_Survey (Special Education) |

| | |o page 7; changed the first note about field and data element names |

| | |o page 12; Under “Instructions or Rules” for field #39, changed range to 1-25 and aligned text with |

| | |Data Dictionary |

| | |o page 20; Added, in field #13, ending reasons/codes for changes in disability status |

| | |o page 20; Added, in field #19, CTE/Tech Prep Program Intensity explanation |

| | |o page 36; Under “Instructions or Rules” for field #46, changed note about sole provider and |

| | |referenced Data Dictionary |

| | |o pages 36 & 38; snapshot date changed from 12/1/07 to 12/3/07 and 6/30/08 to 7/1/07 |

| | |o page 39; Under “Instructions or Rules” for field #1, dropped reference to “8nnnnnnn” and added |

| | |note about not reporting here |

| | |o page 39; Under “Recommended Code” for field #1, dropped reference to “schools/agencies other than |

| | |public districts/charters required to report…” |

| | |o page 39; Under “Instructions or Rules” for field #5, replaced the word “five’ with “four” and |

| | |dropped the chain referring to High School student applies to VESID or CBVH…” |

| | |o page 40; Under “Instructions or Rules” for field #12, in the first referral event type record; |

| | |dropped “evaluation results are discussed” and replaced it with “eligibility determination is made” |

| | |o page 40; Under “Recommended Code” for field #12, dropped the word “Blank” and replaced it with |

| | |“U”, also added “or meeting is not held” |

| | |o page 40; Under “Instructions or Rules” for field #12, in the second referred event type record, |

| | |replaced “CSPE03” with “CPSE03” |

| | |o page 41; Under “Instructions or Rules” for field #20, reduced the list of “reason for delay” from |

| | |5 to 3. Dropped reason “If child transitioning from EI to preschool is found eligible for preschool|

| | |education…” and reason “For students parentally placed in a nonpublic school, if >60 calendar |

| | |days….” |

| | |o page 41; Under “Instructions or Rules” for field #31, changed “being submitted for student or if |

| | |event type code is VRS01. Submit with initial referral event type code record” to “is submitted for|

| | |student. Submit with every record of each chain after the initial referral event type code record” |

| | |o page 43; Under “Instructions or Rules” for field #33, reduced the number of ways to calculate the |

| | |Number of Days from 4 to 3 by deleting “Calendar days between receipt of parent consent to evaluate |

| | |school age student placed parentally in a nonpublic school….”. |

| | |o page 44; Reworked the entire “Section 2: Extract Specifications – SE Events Template Sample Data” |

| | |to include more examples and for clarity |

|3.2 |April 30 |o page 1; updated “Levels of SIRS” to include special education references |

| | |o page 4; in the 2nd paragraph - clarified reporting rules when the CSE responsibility is not housed|

| | |at the same district that has NCLB accountability |

| | |o page 4; in the 3rd paragraph – noted those enrollment types that require program participation |

| | |data |

| | |o page 5; 1st bullet under Special Education Enrollment Data Template – changed “and the |

| | |coordinating service provider…” to “or the coordinating service provider…” |

| | |o page 5; 3rd and 4th bullets under Special Education Enrollment Data Template – added “child care |

| | |institution with affiliated schools, State agencies and State-operated schools” |

| | |o page 5; rewrote 3rd bullet under Special Education End-of-Year Data Template |

| | |o page 6; dropped the last bullet under Special Education End-of-Year Data Template that dealt with |

| | |date of application for voc-rehab services |

| | |o page 6; changed the 2nd bullet for pre-school children in Who must be reported? from “who have |

| | |been determined to be eligible for services for preschool children with disabilities” to “who are |

| | |receiving special education services for preschool children with disabilities” |

| | |o page 10; on the Student_Lite Template, fields 18 & 24, noted these apply to high school completers|

| | |as well |

| | |o page 36; on the Special_Ed_Snap Template, field 46, noted that this field is required for both the|

| | |December and the EOY snapshot dates |

| | |o page 44: on the SE_Events Template, field 33, under Instructions or Rules , in the first tilde – |

| | |changed the last “OR” from “if IEP is not implemented, the number of calendar days between child’s |

| | |third birthday and August 31” to |

| | |“if IEP is not implemented, the number of calendar days August 31 is past the child’s third |

| | |birthday” |

| | |o page 45: on the SE_Events Template Sample Data for SPP Indicator 11, |

| | |- Under Student in Rows 1-3; changed “..and evaluation was completed on December 5, 2007;” to “..and|

| | |CSE met to discuss evaluation results on December 5, 2007;..” |

| | |- Under Student in Rows 4-6; added “..and child was found eligible for special education.” at the |

| | |end of the last sentence |

| | |- Under Student in Rows 7-9; changed “..and student’s evaluation was completed on November 20, |

| | |2007;” to “..and CSE met to discuss evaluation results on November 20, 2007;..” |

| | |- Under Student in Rows 10-12 & 13-16; changed row references to reflect above changes |

| | |- Updated the chart to reflect above changes |

| | |o page 46: on the SE_Events Template Sample Data for SPP Indicator 12, |

| | |- Under Student in Rows 1-4; changed the details of the example used and reflected those changes in |

| | |the chart |

Table of Contents

Section 1: General Information 1

Purpose and Audience 1

Levels of the SIRS (NYS Data Warehouse) 1

“Templates” versus “Extract Specifications” 2

Sets of Elements Collected for 2007-2008 3

Miscellaneous Notes for 2007-08 6

Section 2: Extract Specifications 7

Student_Lite (Student Demographics) Template 8

Student_Lite (Student Demographics) Template Sample Data 15

School_Enroll (Enrollment) Template 16

School_Enroll (Enrollment) Template Sample Data 18

Programs_Fact Template 19

Programs_Fact Template Sample Data 22

Assessment_Fact Template 23

Assessment_Fact Template Sample Data 29

Assessment_Resp (Response) Template 30

Assessment_Resp (Response) Template Sample Data 32

Special_Ed_Snap (Special Education Snapshot) Template 33

Special_Ed_Snap (Special Education Snapshot) Template Sample Data 38

SE_Events (Special Education Events) Template 39

SE_Events (Special Education Events) Template Sample Data 45

Section 3: Glossary of Terms 47

Section 1: General Information

Purpose and Audience

The purpose of the New York State Student Information Repository System (SIRS) is to provide a single source of standardized individual student records for analysis at the local, regional, and State levels to improve student performance and to meet State and federal reporting and accountability requirements.

The purpose of this document is to provide definitions of the data sets to be submitted to SIRS and of the individual data elements in those sets, to provide the business rules and basic edits that apply to those elements, and to outline the formats and layouts required for submissions. The audience for this document is vendors of information systems, individual local educational agencies (LEAs) and those responsible for creating and/or extracting student data.

Levels of the SIRS (NYS Data Warehouse)

There are multiple data collection points within SIRS. The first point is the local student management system (SMS) used by an LEA. Typically, the student demographic, school enrollment and program data are collected in these local systems. LEAs may also use other systems to collect special education data and other program related data. These ancillary systems may be the primary source for data, such as student disability and free and reduced lunch. Test scoring units within RICs or the Big 5 School Districts also provide data related to assessments. LEAs may begin their entry into SIRS at "Level 0".

Level 0 is a web-based application hosted by the RICs. For LEAs, required schools and agencies who must submit data through SIRS, this application provides them the ability to enter and verify these data trough edit checks. Data can be exported into Level 0 or manually. For LEAs that do not have a student management system, Level 0 is the means by which they may enter their data. It may also be used to collect additional data that may not be available in a student management system. Verified data is exported from Level 0 in a format that can be loaded directly into the Level 1 repository.

SIRS repository levels 0, 1, 2 and 3, all use the eScholar® data warehouse system and data model, which hold demographic, enrollment, programmatic, assessment, special education snapshot and special education events data. The primary data source for these repositories is a local LEA’s SMS (including special education student management systems).

Level 1 repositories are implemented and operated by a RIC or a Big 5 School District. Each Level 1 repository includes, at a minimum, all the data elements defined in the data dictionary. In addition to meeting State reporting requirements, users of the Level 1 repositories may make use of additional data elements in the eScholar® templates to meet local or regional needs. These data may be used for local data analysis and reporting or for pre-printing answer sheets. In addition, the demographic data elements are used in the New York State Student Identifier System (NYSSIS - defined below) to create unique student IDs, which are stored and maintained at this level. Data are loaded into Level 1 repositories using data templates and load procedures provided within the eScholar® application. All school districts, charter schools, State-operated schools and State agencies that operate educational programs and child care institutions that operate a school must participate in a Level 1 Repository. These repositories are used to prepare data for submission to the Level 2 (Statewide) Repository. Data in the Level 1 Repository are available only to users with a legitimate educational interest.

The Level 2 Repository is a single statewide data warehouse, where all K-12 (including select Pre-K, Universal Pre-K and preschool) student data from Level 1 are aggregated. Level 2 holds records for all students and provides the basis for NYS and federal No Child Left Behind (NCLB) accountability decisions, and provides a resource for educators and policy makers to employ data-driven decisions to improve curriculum and instruction. Level 2 records include student names and unique identifiers assigned by the NYSSIS. Data in the Level 2 Repository are available only to users with a legitimate educational interest.

The Level 3 Repository is the NYSED data warehouse. This is a single warehouse used by NYSED to meet State and federal reporting requirements. This level replicates the student records on the Level 2 repository but with student names and unique identifiers encrypted to protect the privacy of students. Standard aggregations of data from the Level 3 Repository are placed in the Annual Reporting Database to provide the general public with access to school performance data.

NYSSIS is a key element of SIRS. NYSED developed this system to assign a stable, unique student identifier to every preschool and pre-kindergarten through grade 12 public school student in New York State. Unique identifiers enhance student data reporting, improve data quality and ensure that students can be tracked longitudinally as they transfer between LEAs. In the Level 2 Repository, each student record is uniquely identified with a 10-digit number assigned when the student first enters a State public school (including Charter schools), State-operated school, public agency, child care institution that operates a school or participating nonpublic school. The Level 3 Repository contains an encrypted version of this identifier on each student record.

Data in the SIRS are accessed through nySTART, a web-based statewide reporting service. nySTART provides LEAs and other personnel with a baseline group of reports and analyses about students as well as a series of reports that are used to verify and certify the completeness and accuracy of data in the Level 2 Repository. Note that the “PD” data system, independently of nySTART, also provides a group of reports that are used to verify and certify the completeness and accuracy of special education data.

“Templates” versus “Extract Specifications”

In brief, a “template” is a generic organizing structure - a conceptual grouping of technical specifications built around the unifying theme of a real-world construct (for example: the collective activities of an organizational procedure or cognitive process; the collective attributes of objects or entities.) Templates are designed to be flexible - to accommodate numerous possible ways of loading a set or subset of related data elements into a database or warehouse (in this case, to populate SIRS.)

An “extract specification” is a detailed set of guidelines that helps extract developers understand how to build their data collection software in such a way that - when data are extracted (to be loaded into another database or warehouse) - their extracts meet both the load specifications of the templates as well as the current business rules/edits of the contracting organization (in this case, NYSED.)

What is a template?

For the purposes of this document, a “template” is a group of specifications (including formats) needed to load a set of related data elements - e.g., the set/subset of demographic data elements - into SIRS. Some key characteristics of templates are:

• They are produced by the same third-party vendor that produces and maintains the databases used by SIRS. They were “generically” designed (for broad purposes across numerous possible applications), intended primarily to collect related sets of data elements (for example, demographics.) For the most part, they were not designed explicitly for or by NYS nor were they intended expressly for the SIRS data warehouse effort.

• The full scope of elements that can be collected under a given template - e.g., all the testing-related elements that the Assessment_Fact template allows - represents what the vendor believes to be all the possible data collection needs of its customers (not those of the SIRS alone.) Since the data collection requirements of NYS may comprise only a subset of data elements within a given template, some data elements may not be used. In some cases, a data element intended for one use by the templates’ vendor, may even be “appropriated” for a different use by the contracting entity (i.e., NYS; or the Level 1 Centers may have a local/regional use for an ‘unused” element not required by the State.)

• The templates’ format specifications are defined by the vendor to facilitate loading a set/subset of data elements - e.g., elements in the Programs_Fact template - into an instance of the vendor’s database for data transformation and/or storage. These specifications/rules define the allowable size and type of each data element, the sequence of elements, which are mandatory, and so forth.

What is an extract specification?

For the purposes of this document, an “extract specification” equates to a series of transferal and/or transformative procedures - directions on how to extract a given set (or, just as likely, subset) of data elements. For example, of the superset of data elements collected within the enrollment data set in an LEA’s student management system (SMS), most (but not necessarily all) elements may be required for reporting to SIRS. Specifications dictate how the extracted results must meet the format required to load the data into the SIRS -i.e., will satisfy the template’s rules - and at the same time meet the business rules and edit checks explicitly required by NYS.

Some key characteristics of extract specifications:

• The specific elements in a given data set to be collected in SIRS may change from year to year. Elements required last year may not be required this year; new elements may be required this year that were not collected last year, and so on.

• Business rules and edit checks for any given data element—for example, the “Diploma Type Code” element in the set of demographic elements - may change from year to year as Federal reporting requirements and/or SIRS data-collection requirements evolve. This necessitates that extract developers reassess and augment extracts from year to year.

• It may be that not every data element within a given template is required for extraction. For example, not all assessment-related elements collected in templates at the local level are necessarily collected in SIRS. In cases where template elements are not used at the level to which the extract is being loaded, the directions in the extract specification may dictate that the extract should output a null or a blank (or other determined value) for these particular elements.

Sets of Elements Collected for 2007-2008

Demographics (“Student_Lite” template)

Demographic data elements describe the individual student and they are also used in the NYSSIS system. For any given student within a given school district there will be one row stored in a SIRS per school year. That row can be updated throughout the school year to reflect any changes in the attributes of the student. For example, the Student_Lite record for a student who graduates will be updated to show the type of diploma received.

The Demographics Extract Specification provides directions for producing an extract in the Student_Lite Template format. It holds the demographic student data, including those elements used in the NYSSIS system. Use this template to provide one set of data for each student for each school year.

While the Student_Lite template is the primary structure for demographic data, not all demographics are collected in the Student_Lite template. Some are collected through specific fields in the Programs_Fact and other templates.

School Enrollment (“School_Enroll” template)

School enrollment data elements define reportable enrollment actions (entries and exits). For any given student there will be at least one - and probably more - school enrollment records per school year. All reportable students require a school entry enrollment record for each year. Additional records are required when a student changes grade level and/or building during the same school year. Data is used for district and school accountability and cohort membership. Calculations utilizing this data will be able to provide dropout and graduation rates, school enrollment counts, special education snapshot data and special education compliance data as well as assessment participation rates.

There are two types of school enrollment transactions. One type is an enrollment entry transaction. This records the date a student enters a building or grade level and the school building of enrollment. The second type is an enrollment exit transaction, which records the date and reason a student leaves a school building or grade level. A student cannot be enrolled in more than one building at a time. However, for 2007-08 (and subsequent school years), whenever the Committee on Special Education (CSE) responsibility for students with disabilities is housed by a school district that is not accountable under NCLB for the student’s State assessment results, two separate enrollment records must be submitted on the same student. The school district with CSE responsibility will submit a reason for beginning enrollment code 5905 (CSE Responsibility Only) and school district with accountability responsibility under NCLB will submit a reason for beginning enrollment code 0011 (Enrollment in Building or Grade). The district that submits a reason for beginning enrollment code 5905 is required to submit the special education information found under the Special Education Snapshot and the Special Education Events templates. The school district that submits a reason for beginning enrollment code 0011 is required to submit State assessment information. Both districts need to submit disability program service records.

The School_Enroll Extract Specification provides directions for producing an extract in the School_Enroll Template format.

Programs Participation (“Programs_Fact” template)

Programs Participation data elements define students’ involvement in reportable program services. Programs_Fact is also transactional data, where each program service must be reported for each student for each school year. Programs are defined as attributes of a student that can change over time. They have specific starting and ending points. Examples of programs that follow this definition are Limited English Proficient (LEP) Eligibility, Type of Disability, Title 1 Status and Academic Intervention Services. The extract should include all needed records; enter as many records as needed for each student. For students with disabilities, school districts that create an enrollment record using a reason for beginning enrollment code of;

0011 - Enrollment in building or grade,

5544 - Transferred in under the NCLB Title I “School in Improvement Status” transfer option,

5654 - Enrollment in a AHSEP or HSEP program,

5905 - CSE responsibility only,

7000 - Transferred in under the NCLB Title I “Persistently Dangerous School” transfer option, or

7011 - Transferred in under the NCLB Title I “Victim of Serious Violent Incident” transfer option

are required to submit Programs Participation information.

The Programs Participation Extract Specification provides directions for producing an extract in the Programs_Fact Template format.

Because program services data are typically tracked not only in the district’s Student Management System (SMS) but also in other district-based information repositories - e.g., the Special Education System (SES), the Cafeteria Information Systems (CIS) - it is recommended that separate extracts be used. It is also recommended that a separate file be used for each program type, as follows (from the Program Codes headings in Data Dictionary Appendix 5 – Detailed Definitions of Program Services);

Limited English Proficient (LEP) Eligibility,

LEP Programs,

No Child Left Behind (NCLB) Funded Program Services,

NCLB Transfer Options,

Type of Disability,

Safety Net,

Career Technical Education/Tech Prep, and

Other.

Assessment Scores (“Assessment_Fact” template)

Assessment_Fact (scores) data elements describe a student’s achievement on each reportable assessment and includes the name of the student, the name of the assessment, and overall holds a record for each assessment for each student. This records the name of the assessment, the overall score achieved on the assessment, and the language in which it was administered.

The Assessment_Fact Extract Specification provides directions for producing an extract in the Assessment_Fact Template format.

Assessment Responses (“Assessment_Resp” template)

Assessment_Resp data elements describes the student’s achievement for each question and shows a record of the response to a question asked in an assessment. This records the name and date of the assessment, the question number, the student’s response to a multiple-choice question, and the number of points earned for the multiple-choice, constructed response, or essay question.

The Assessment_Resp Extract Specification provides directions for producing an extract in the Assessment_Resp Template format.

Special Education Enrollment Data (“Special_Ed_Snap” Template)

This template is new for the 2007-08 school year. In previous years school districts reported these data in the PD-1/4 and PD-7 reports. Some of the fields in the Special Education “Snapshot” template will contain the state of data as of December 3, 2007; some will reflect data as collected at the end of the school year. The data collected with this template includes the following:

• Type of special education service provided to preschool students with disabilities, service provider code or the coordinating service provider code if student receives services from two or more providers. This information will be collected two times, as of December 3 and at the end of the school year. These data are reported by all school districts each year.

• Placement status of students with disabilities in approved private schools (residential or day), school district placement or court placement. See specific directions for reporting these data in the SIRS Dictionary of Reporting Data Elements. This is December 3 snapshot data. These data are reported by all school districts each year.

• The least restrictive environment setting in which preschool students with disabilities are enrolled. This is December 3 snapshot data. These data are reported by all school districts, child care institutions with affiliated schools, State agencies and State-operated schools each year.

• The least restrictive environment setting in which school aged students with disabilities are provided special education services. This is December 3 snapshot data. These data are reported by all school districts, child care institutions with affiliated schools, State agencies and State-operated schools each year.

Special Education End of Year Data (“SE_Event” Template)

This template is new for the 2007-08 school year. In the previous year, school districts that were assigned to report data on special education SPP Indicators 11 and 12 used the PD-11 and 12 to report these data. Some of the data in this template was previously collected in the PD-1/4 report and some is a new data reporting requirement for the 2007-08 school year. The data collected with this template includes the following:

• Dates for referral, parent consent to evaluate, CPSE meeting to discuss evaluation results for preschool children who are new referrals to determine special education eligibility and outcome of the eligibility decision and if necessary, reason for exceeding State established timelines. These data are reported by school districts in the year in which they are required to report on SPP Indicator 11. See the school year in which your district is scheduled to report these data at

• Dates for referral, parent consent to evaluate, CSE meeting to discuss evaluation results for school-aged students who are new referrals to determine special education eligibility and outcome of the eligibility decision and if necessary, reason for exceeding State established timelines. These data are reported by school districts in the year in which they are required to report on SPP Indicator 11. See the school year in which your district is scheduled to report these data at

• Dates for referral, parent consent to evaluate, CPSE meeting to determine eligibility, IEP implementation for preschool children who are new referrals for transitioning from IDEA, Part C (Early Intervention) to IDEA, Part B (preschool) and if necessary, reason for exceeding State established timelines or for not implementing child’s IEP by the child’s third birthday. These data are reported by school districts in the year in which they are required to report on SPP Indicator 12. See the school year in which your district is scheduled to report these data at

• Dates for referral, parent consent to evaluate, CSE meeting to discuss evaluation results, IEP implementation for parentally placed school aged students in nonpublic schools who are new referrals to determine eligibility for special education services and if necessary, reason for exceeding State established timelines. These data are reported by all school districts each year.

Miscellaneous Notes for 2007-08

What file format is recommended?

It is strongly recommended that extracts produce files in comma-separated variable (.csv) format. While fixed-format is still currently accommodated, this is largely being deprecated in favor of the more extensible delimited format of .csv.

What are the associated appendices?

Appendices are found in the Dictionary of Reporting Data Elements (“Data Dictionary”). Appendices contain code-translation tables for data elements that are extracted in code form from the source system. These appendices are either required or recommended (and this distinction should be noted with use of each.) In the case of recommendations, Data Warehouse support teams should be notified of variations, i.e., if source systems use other codes than those noted in the Data Dictionary.

Who must be reported?

• Preschool children;

o who have been referred to the CPSE for determination of eligibility

o who are receiving special education services for preschool children with disabilities

• Students in grades Pre-Kindergarten through Grade 12 (including “ungraded”);

o that are enrolled in the district or charter school

o that are placed by district personnel in an out-of-district placement

o who are home schooled students with disabilities

o who are home schooled and who “walk-in” to take an assessment

o that are referred to the CSE for special education eligibility determination

o that are students with disabilities and who are parentally placed in nonpublic schools

This includes all students who are;

• New York State English as a Second Language Achievement Test (NYSESLAT) participants,

• Reading First participants, or

• New York State Alternate Assessment (NYSAA) participants.

See the SIRS Policy Manual for additional information on the students who must be reported.

Section 2: Extract Specifications

Student_Lite (Student Demographics) Template

School_Enroll (Enrollment) Template

Programs_Fact Template

Assessment_Fact Template

Assessment_Resp (Response) Template

Special_Ed_Snap (Special Education Snapshot) Template

SE_Events (Special Education Events) Template

NOTE 1: Under the “Data Description” column in each template the eScholar templates’ field names are shown. These are shown in uppercase. Also shown are any corresponding SIRS Data Element names. These are shown in parentheses, in uppercase, bold and italicized.

NOTE 2: Sample Data follow each template. Rows are “abridged” in order to focus primarily on only the required SIRS Data Elements (and not other fields which may be used locally or not at all.) This abridgment is facilitated by inserting “breaks” in the template. Breaks occur as pairs of “broken lines” where the non-required data elements would otherwise appear. This is only to be interpreted as a visual aid, and this does not mean that these fields should be removed or ignored in ETLs or other programming.

Student_Lite (Student Demographics) Template

|  |  |  |  |DATA DESCRIPTION | |  | |  |

|  |  |  |  |  | |  |  |  |

|2 |9 |14 |6 |* LOCATION CODE |NYS |Building code used by the Data Warehouse, uniquely |alphanumeric |  |

| | | | |(BUILDING OF ENROLLMENT BEDS CODE) |Reporting |identifying the building in which a student is | | |

| | | | | | |enrolled, typically assigned by the local student | | |

| | | | | | |management system. | | |

|3 |15 |24 |10 |* SCHOOL YEAR DATE |NYS |Use June 30 of the reported school year. Ex: For |date |  |

| | | | |(SCHOOL YEAR) |Reporting |2007-08, use 2008-06-30 |yyyy-06-30 | |

|4 |25 |36 |12 |* STUDENT ID |NYS |The unique identifier assigned by the Local |alphanumeric |  |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Education Agency (LEA) in which the student is |nnnnnnnnn | |

| | | | | | |enrolled. Use all 9 numeric characters, left padded | | |

| | | | | | |with zeros. | | |

|5 |37 |46 |10 |* ACTIVITY DATE |Local use |Must match the enrollment date. |date |  |

| | | | | |only | |yyyy-06-30 | |

|6 |47 |56 |10 |* ENROLLMENT DATE |NYS |For Entry Enrollment, the date a student enrolls in |date | |

| | | | |(ENROLLMENT ENTRY DATE and |Reporting |a building or grade level. For Exit Enrollment, the|yyyy-06-30 | |

| | | | |ENROLLMENT EXIT DATE) | |last date of enrollment. | | |

|7 |57 |62 |6 |* ENROLLMENT CODE |NYS |This is an entrance or exit reason for each |alphanumeric |Beginning Enrollment Codes, see Data Dictionary |

| | | | |(REASON FOR BEGINNING ENROLLMENT CODE and |Reporting |enrollment record. | |Appendix 3 |

| | | | |REASON FOR ENDING ENROLLMENT CODE) | | | |Ending Enrollment Codes, see Data Dictionary |

| | | | | | | | |Appendix 4 |

|8 |63 |102 |40 |ENROLLMENT COMMENT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|9 |103 |104 |2 | * ENROLLMENT GRADE LEVEL |NYS |Use the grade level at the time of the enrollment |alphanumeric |See table of codes under “Grade Level” element |

| | | | |(GRADE LEVEL) |Reporting |date. | |(Templates 3090 "Student Lite" and 320 "Student") in|

| | | | | | | | |Data Dictionary |

|10 |105 |116 |12 |RESIDENCE STATUS CODE | | Leave blank. |alphanumeric |  |

|11 |117 |128 |12 |ENROLL CHANGE CODE | | Leave blank. |alphanumeric |  |

School_Enroll (Enrollment) Template Sample Data

|Row |Distr|Locat|Sch|Student |Activity |Enrollment |Enrollment |Enrollment |

| |ict |ion |ool|ID |Date |Date |Code |Comment |

| |Code |Code |Yea| | | | | |

| | | |r | | | | | |

| | | |Dat| | | | | |

| | | |e | | | | | |

|  |  |  |  |  | |  |  |  |

|2 |9 |14 |6 | |Local use |Required by eScholar load plan. Typically the |alphanumeric | |

| | | | |* LOCATION CODE |only |building code (assigned by local student management| | |

| | | | | | |system and used by L1 Data Warehouse) which | | |

| | | | | | |uniquely identifies building in which a student is | | |

| | | | | | |receiving the service. Programs can optionally use| | |

| | | | | | |‘0000’ | | |

|3 |15 |24 |10 |* SCHOOL YEAR DATE |NYS |Use June 30 of the reported school year. Ex: For |date |  |

| | | | |(SCHOOL YEAR) |Reporting |2007-08, use 2008-06-30 |yyyy-06-30 | |

|4 |25 |36 |12 |* STUDENT ID |NYS |The unique identifier assigned by the Local |alphanumeric |  |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Education Agency (LEA) in which the student is |nnnnnnnnn | |

| | | | | | |enrolled. Use all 9 numeric characters, left padded| | |

| | | | | | |with zeros. | | |

|5 |37 |44 |8 |* PROGRAMS CODE |NYS |Record the program service code applicable to a |alphanumeric |Program Service Codes: see Data Dictionary Appendix 5|

| | | | |(PROGRAM SERVICE CODE) |Reporting |student. | |CTE/Tech Prep Program Codes: see Data Dictionary |

| | | | | | | | |Appendix 6 |

|6 |45 |54 |10 |* BEGINNING DATE |NYS |The program start date must be between July 1st and|date |  |

| | | | |(PROGRAM SERVICE ENTRY DATE) |Reporting |June 30th of the reported school year. Ex: for |yyyy-06-30 | |

| | | | | | |2007-08, use a date between 2007-07-01 and | | |

| | | | | | |2008-06-30 | | |

|7 |55 |64 |10 |+ ENDING DATE |NYS |To be used ONLY if a program service ends*. Leave |date |  |

| | | | |(PROGRAM SERVICE EXIT DATE) |Reporting |blank otherwise. *(Refer to individual program |yyyy-06-30 | |

| | | | | | |rules for specifics, e.g. school-level programs end| | |

| | | | | | |if a student changes buildings within a District or| | |

| | | | | | |to an out-of-District placement.) | | |

| | | | | | |Program end date must be between July 1st and June | | |

| | | | | | |30th of reported school year. | | |

|8 |65 |84 |20 |+ STATE LOCATION ID |NYS |Report the NYSED BEDS Code of the institution |alphanumeric | For NYSED BEDS codes: |

| | | | |(PROGRAM SERVICE PROVIDER BEDS CODE) |Reporting |providing the program service. This is required |nnnnnnnnnnnn |admin/bedsdata.html |

| | | | | | |for school level services only. For district level| | |

| | | | | | |services, leave this field blank. | | |

|9 |85 |104 |20 |PROGRAM INTENSITY |NYS |This field is required when the student’s program |alphanumeric | Enrollee = CTE or TP/CP Enrollee |

| | | | |(CTE/TECH PREP PROGRAM INTENSITY) |Reporting |service is identified as one of the CTE/Tech Prep | |Participant = CTE or TP/CP Participant |

| | | | | | |codes and reflects the student’s progression | |Concentrator = CTE or TP/CP Concentrator |

| | | | | | |through this program service. | | |

|10 |105 |114 |10 |ENTRY REASON CODE 1 |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|11 |115 |124 |10 |ENTRY REASON CODE 2 |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|12 |125 |134 |10 |ENTRY REASON CODE 3 |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|13 |135 |144 |10 |+ EXIT REASON CODE 1 |NYS |This field is required: |alphanumeric |646 = Completion of Program Service |

| | | | |(REASON FOR ENDING CODE) |Reporting |1. when a student exits a CTE/Tech Prep program | |663 = Left without Completing Program Service |

| | | | |Note; this is not a Data Element in SIRS but a| |(codes 646, 663) | |849 = Student Achieved English Proficiency |

| | | | |code showing why specific Program Services | |2. for students no longer LEP eligible (code 849) | |901 = Student is declassified |

| | | | |have ended | |3. when a students disability status changes (codes| |912 = Students disability type changes |

| | | | | | |901, 912) | | |

| | | | | | | | | |

|14 |145 |154 |10 |EXIT REASON CODE 2 |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|15 |155 |164 |10 |EXIT REASON CODE 3 |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|16 |165 |224 |60 |PROGRAM COMMENT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|17 |225 |234 |10 |ORIGINAL PGM START DATE |Local use |  |date |  |

| | | | | |only | |yyyy-06-30 | |

|18 |235 |240 |6 |+ PARTICIPATION INFO CODE |NYS |This field is required when the student’s program |alphanumeric | TPREP = Tech Prep Program |

| | | | |(CTE/TECH PREP PROGRAM TYPE) |Reporting |service is identified as one of the CTE/Tech Prep | | |

| | | | | | |codes, to delineate between the two program types. | | |

| | | | | | | | | CTE = Conventional CTE Program |

Programs_Fact Template Sample Data

|Row|Distr|Locat|Sch|Student |Programs |Beginning |Ending |State |

| |ict |ion |ool|ID |Code |Date |Date |Location ID |

| |Code |Code |Yea| | | | | |

| | | |r | | | | | |

| | | |Dat| | | | | |

| | | |e | | | | | |

|  |  |  |  |  | |  | |  |

|2 |9 |23 |15 |* TEST DESCRIPTION |NYS |This is the “short version” of the Test |alphanumeric |See Data Dictionary Appendix 7 for “Test Group” |

| | | | |(TEST GROUP) |Reporting |Description: an alpha code called “Test Group”, | |categories/codes (appearing in quotes within the |

| | | | |Note; this is not a Data Element in SIRS but | |(e.g., AAOS, ALTREG, CTE, NYS, NYSAA, Regents, | |Assessment Measure Standard Descriptions table “Test|

| | | | |an alpha code showing which specific Test | |etc.) | |Group” subheaders) |

| | | | |Group this assessment belongs to. | | | | |

|3 |24 |33 |10 |* ASSESSMENT SCHOOL YEAR |NYS |Version date is always June 30th of the school year|date | |

| | | | |DATE |Reporting |of test administration. Ex: 2008-06-30 |yyyy-06-30 | |

| | | | |(VERSION) | | | | |

| | | | |Note; this is not a Data Element in SIRS but a| | | | |

| | | | |date used to identify the school year of test | | | | |

| | | | |administration. | | | | |

|4 |34 |83 |50 |* ITEM DESCRIPTION |NYS |This is—character for character—the description |alphanumeric |See Data Dictionary Appendix 7 for “Description” |

| | | | |(DESCRIPTION) |Reporting |stored in the “Description” field in the Data | |field in the Assessment Measure Standard |

| | | | |Note; this is not a Data Element in SIRS but a| |Dictionary’s Assessment Measure Standard | |Descriptions table |

| | | | |short description of the specific | |Descriptions table. | | |

| | | | |assessment. | | | | |

|5 |84 |93 |10 |* TEST DATE |NYS |First date of administration, or first day of |date |First date of administration is; |

| | | | |(ASSESSMENT DATE OF ADMINISTRATION) |Reporting |window in which it was offered. If taken on a |yyyy-06-30 |ELA 345 = 2008-01-07 |

| | | | | | |make-up day, use the date of original | |ELA 678 = 2008-01-14 |

| | | | | | |administration. | |Math 345 = 2008-03-03 |

| | | | | | | | |Math 678 = 2008-03-06 |

| | | | | | | | |NYSESLAT = 2008-04-14 |

| | | | | | | | |NYSAA = 2007-10-01 |

| | | | | | | | |Social Studies 5 = 2007-11-14 |

| | | | | | | | |Social Studies 8 = 2008-06-03 |

| | | | | | | | |Science 4 & 8 = 2008-04-02 |

| | | | | | | | |Reading First = 2008-05-14 |

| | | | | | | | |January RCT & Regents = 2008-01-22 |

| | | | | | | | |June RCT, Regents & SLPs = 2008-06-17 |

| | | | | | | | |August RCT & Regents = 2007-08-16 |

| | | | | | | | |CompRetest = 2008-05-15 |

| | | | | | | | |Technical Skills Assessment (CTE) = Any |

| | | | | | | | |Day |

| | | | | | | | |COSF = Any Day |

|6 |94 |105 |12 |* STUDENT ID |NYS |The unique identifier assigned by the Local |alphanumeric |  |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Education Agency (LEA) in which the student is |nnnnnnnnn | |

| | | | | | |enrolled. Use all 9 numeric characters, left padded| | |

| | | | | | |with zeros. | | |

|7 |106 |111 |6 |* LOCATION CODE |Local use |Building code used by the Data Warehouse, uniquely |alphanumeric |  |

| | | | | |only |identifying the building in which a student is | | |

| | | | | | |enrolled, typically assigned by the local student | | |

| | | | | | |management system. | | |

|8 |112 |117 |6 |SCORE DISPLAY |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|9 |118 |123 |6 |+ ALPHA SCORE |NYS |Use when resulting score for an assessment is not |alphanumeric |  |

| | | | |(ASSESSMEMNT SCORE) |Reporting |numeric. Ex: P = Pass, or F = Fail | | |

|10 |124 |131 |8 |+ NUMERIC SCORE |NYS |Use when resulting score is numeric. This is the |alphanumeric |  |

| | | | |(ASSESSMEMNT SCORE) |Reporting |score reported to NYSED. | | |

|11 |132 |139 |8 |CREDITS |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|12 |140 |147 |8 |NATIONAL PERCENTILE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|13 |148 |155 |8 |LOCAL PERCENTILE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|14 |156 |158 |3 |MASTERY |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|15 |159 |178 |20 |ASSESSMENT STATUS |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|16 |179 |182 |4 |* ASSESSMENT LANGUAGE CODE |NYS |This identifies the language in which the |alphanumeric |See codes in Data Dictionary under “Assessment |

| | | | |(ASSESSMEMNT LANGUAGE CODE) |Reporting |assessment was administered. | |Language Code” element (Template 2000 |

| | | | | | | | |"Assessment_Fact") |

|17 |183 |186 |4 |* STANDARD ACHIEVED CODE |NYS |This code represents the level of performance, or |alphanumeric |See Data Dictionary Standard Achieved Codes, |

| | | | |(ASSESSMEMNT STANDARD MET CODE) |Reporting |the reason why there is no score. | |Appendix 8. |

| | | | | |and Local | | |Cut scores/ranges can be found on NYSED’s SIRS page |

| | | | | |Use | | |at: |

| | | | | | | | |home.shtml under “Technical Information” heading. |

|18 |187 |193 |7 |NORM CURVE EQUIV |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|19 |194 |201 |8 |RAW SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|20 |202 |207 |6 |SCALE SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|21 |208 |213 |6 |PERCENT SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|22 |214 |219 |6 |LOCAL STANINE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|23 |220 |225 |6 |NATIONAL STANINE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|24 |226 |231 |6 |NATIONAL PERCENTILE BY AGE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|25 |232 |237 |6 |NUMBER OF ITEMS CORRECT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|26 |238 |243 |6 |OBJECTIVE MASTERY SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|27 |244 |249 |6 |DEGREES OF READING POWER |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|28 |250 |255 |6 |INTELLIGENCE QUOTIENT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|29 |256 |261 |6 |STANDARD PERFORMANCE INDEX |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|30 |262 |267 |6 |STANDARD PERFORMANCE LEVEL |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|31 |268 |273 |6 |GRADE EQUIVALENT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|32 |274 |279 |6 |SPECIAL NORM GROUP |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|33 |280 |294 |15 |LEVEL OF AGGREGATION |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|34 |295 |304 |10 |+ TESTING MODIFICATION |NYS |Use all the codes applicable to the student. |alphanumeric |Applies to SwD & students w/504 plans - |

| | | | |(ASSESSMEMNT ACCOMMODATION CODE) |Reporting | | |1 = Flexibility in scheduling/timing |

| | | | | | |Concatenate into one field, entered in any order. | |2 = Flexibility in setting |

| | | | | | | | |3 = Method of presentation (excl. Braille) |

| | | | | | |For example, if a student used test accommodations | |4 = Method of response |

| | | | | | |of 1, 2 and F, data may be entered as: F21 | |5 = Other |

| | | | | | | | |6 = Braille |

| | | | | | |Codes 1 through 6 are applicable to students with | |Applies only to LEP students - |

| | | | | | |disabilities and students with Section 504 plans. | |A = Time extension |

| | | | | | | | |B = Separate location |

| | | | | | |Codes A through G are applicable to LEP students. | |C = Third reading of listening section (ELA |

| | | | | | | | |assessment only) |

| | | | | | | | |D = Translated edition (not applicable to ELA |

| | | | | | | | |assessments) |

| | | | | | | | |E = Bilingual dictionaries and glossaries |

| | | | | | | | |F = Oral Translation (not applicable to ELA |

| | | | | | | | |assessments) |

| | | | | | | | |G = Responses written in native language (not |

| | | | | | | | |applicable to ELA assessments) |

|35 |305 |314 |10 |TEST ASSIGNMENT DATE |Local use |  |date |  |

| | | | | |only | |yyyy-06-30 | |

|36 |315 |326 |12 |EVALUATOR ID |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|37 |327 |366 |40 |EVALUATOR NAME |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|38 |367 |376 |10 |SCHOOL YEAR DATE | |Leave blank |date |  |

|39 |377 |382 |6 |SUBTEST SCALE SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|40 |383 |384 |2 |NUMBER OF TIMES TESTED |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|41 |385 |392 |8 |CONVERTED SCORE |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|42 |393 |395 |3 |ASSESSMENT ACCOUNTABLE DISTRICT |Local use |  |alphanumeric |  |

| | | | | |only | | | |

|43 |396 |398 |3 |TESTING ACCOMMODATION |Local use |  |alphanumeric | |

| | | | | |only | | | |

|44 |399 |406 |8 |STANDARD ERROR OF MEASUREMENT |Local use |  |alphanumeric | |

| | | | | |only | | | |

|45 |407 |418 |12 |* SCORING MODEL CODE |NYS |Grades 3-8 ELA, math and NYSESLAT; and NYSAA |alphanumeric |Grades 3-8 codes (1 through 5) see any School |

| | | | |(SCORING MODEL KEY) |Reporting | | |Administrator’s Manual (SAM) “Planning the Scoring |

| | | | |Note; this is not a Data Element in SIRS but a| |‘N/A’ must be used if no scoring model applicable | |Operations…” section, Scoring Models subheading: |

| | | | |code identifying the specific scoring model.| |(i.e., Regents) | | |

| | | | | | | | |home.htm |

| | | | | | | | |NYSAA 4-digit scoring model codes based on BOCES or |

| | | | | | | | |Big 5 doing scoring. |

| | | | | | | | | |

| | | | | | | | | |

|46 |419 |421 |3 |+ SURVEY COMPLETION |NYS | For NYSAA ONLY: Y if Yes, N if No |alphanumeric | |

| | | | |INDICATOR |Reporting |(Otherwise leave blank) | | |

| | | | |(SURVEY COMPLETION INDICATOR) | | | | |

| | | | |Note; this is not a Data Element in SIRS but | | | | |

| | | | |an indicator identifying whether the NYSAA | | | | |

| | | | |survey has been completed. | | | | |

|47 |422 |424 |3 |ASSESSMENT ACCOUNTABLE SCHOOL |Local use |  |alphanumeric | |

| | | | | |only | | | |

|48 |425 |430 |6 |LEXILE MINIMUM SCORE |Local use |  |alphanumeric | |

| | | | | |only | | | |

|49 |431 |436 |6 |LEXILE MAXIMUM SCORE |Local use |  |alphanumeric | |

| | | | | |only | | | |

|50 |437 |442 |6 |NUMBER OF ITEMS ATTEMPTED |Local use |  |alphanumeric | |

| | | | | |only | | | |

|51 |443 |448 |6 |NUMBER OF ITEMS OMITTED |Local use |  |alphanumeric | |

| | | | | |only | | | |

|52 |449 |454 |6 |NUMBER OF ITEMS INCORRECT |Local use |  |alphanumeric | |

| | | | | |only | | | |

Assessment_Fact Template Sample Data

|Row|Distr|Test |Ass|Item |Test |Student |Location |Score |

| |ict |Descr|ess|Description |Date |ID |Code |Display |

| |Code |iptio|men| | | | | |

| | |n |t | | | | | |

| | | |Sch| | | | | |

| | | |ool| | | | | |

| | | |Yea| | | | | |

| | | |r | | | | | |

| | | |Dat| | | | | |

| | | |e | | | | | |

|  |  |  |  |  | |  |  |  |

|2 |9 |23 |15 |* TEST DESCRIPTION |NYS |This is the “short version” of the Test |alphanumeric |See Data Dictionary Appendix 7 for “Test Group” |

| | | | |(TEST GROUP) |Reporting |Description: an alpha code called “Test Group”, | |categories/codes (appearing in quotes within the |

| | | | |Note; this is not a Data Element in SIRS but | |(e.g., AAOS, ALTREG, CTE, NYS, NYSAA, Regents, | |Assessment Measure Standard Descriptions table “Test|

| | | | |an alpha code showing which specific Test | |etc.) | |Group” subheaders) |

| | | | |Group this assessment belongs to. | | | | |

|3 |24 |33 |10 |* ASSESSMENT SCHOOL YEAR DATE |NYS |Version date is always June 30th of the school year|date |  |

| | | | |(VERSION) |Reporting |of test administration. Ex: 2008-06-30 |yyyy-06-30 | |

| | | | |Note; this is not a Data Element in SIRS but a| | | | |

| | | | |date used to identify the school year of test | | | | |

| | | | |administration. | | | | |

|4 |34 |83 |50 |* ITEM DESCRIPTION |NYS |This is—character for character—the description |alphanumeric |See Data Dictionary Appendix 7 for “Item |

| | | | |(DESCRIPTION) |Reporting |stored in the “Item Description” field in the Data | |Description” field in the Assessment Measure |

| | | | |Note; this is not a Data Element in SIRS but a| |Dictionary’s Assessment Measure Standard | |Standard Descriptions table |

| | | | |short description of the specific | |Descriptions table. | | |

| | | | |assessment. | | | | |

|5 |84 |93 |10 |* TEST DATE |NYS |First day of administration window in which it was |date |  |

| | | | |(ASSESSMENT DATE OF ADMINISTRATION) |Reporting |offered. If taken on a make-up day, use the date |yyyy-06-30 | |

| | | | | | |of original administration. | | |

|6 |94 |105 |12 |* STUDENT ID |NYS |The unique identifier assigned by the Local |alphanumeric |  |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Education Agency (LEA) in which the student is |nnnnnnnnn | |

| | | | | | |enrolled. Use all 9 numeric characters, left padded| | |

| | | | | | |with zeros. | | |

|7 |106 |130 |25 |* ITEM RESPONSE DESCRIPTION |NYS |Provided by the RIC or Big 5 district that is |alphanumeric |  |

| | | | |(ASSESSMENT ITEM RESPONSE DESCRIPTION) |Reporting |hosting the Data Warehouse. | | |

|8 |131 |134 |4 |+ ALPHA VALUE |NYS |For multiple-choice response. |alphanumeric | |

| | | | |(ASSESSMENT ITEM RESPONSE VALUE) |Reporting |~If no response to the question, fill in with a ‘-‘| | |

| | | | | | |(dash). If multiple responses to the question, | | |

| | | | | | |fill in with an ‘*’ (asterisk). | | |

| | | | | | |~If scored by the publishers, the publisher will | | |

| | | | | | |convert the answers when data are returned (i.e., | | |

| | | | | | |correct responses will be converted to an alpha | | |

| | | | | | |value.) | | |

| | | | | | |~If scored at the local scoring center to be stored| | |

| | | | | | |in Level 1, correct answer will be the alpha value | | |

| | | | | | |corresponding to that item, and incorrect answers | | |

| | | | | | |will be the numeric equivalent. | | |

|9 |135 |140 |6 |+ NUMERIC VALUE |NYS |The number of points earned for multiple-choice, |alphanumeric | |

| | | | |(ASSESSMENT ITEM RESPONSE VALUE) |Reporting |constructed response, or essay questions. If a | | |

| | | | | | |student who was present for the assessment failed | | |

| | | | | | |to respond, enter the capital letter ”A” | | |

|10 |141 |155 |15 | LEVEL OF AGGREGATION |Local use | |alphanumeric | |

| | | | | |only | | | |

|11 |156 |165 |10 | SCHOOL YEAR DATE | | Leave blank. |date | |

|12 |166 |171 |6 | LOCATION CODE |Local use |Building code used by the Data Warehouse, uniquely |alphanumeric | |

| | | | | |only |identifying the building in which a student is | | |

| | | | | | |enrolled, typically assigned by the local student | | |

| | | | | | |management system. | | |

|13 |172 |175 |4 | ACHIEVEMENT LEVEL |Local use |  |alphanumeric | |

| | | | | |only | | | |

|14 |176 |187 |12 |STAFF ID |Local use | | | |

| | | | | |only | | | |

Assessment_Resp (Response) Template Sample Data

|Row |Distri|Test |Asse|Item |Test |Student |Item |Alpha |

| |ct |Descri|ssme|Description |Date |ID |Response |Value |

| |Code |ption |nt | | | |Descrip. | |

| | | |Scho| | | | | |

| | | |ol | | | | | |

| | | |Year| | | | | |

| | | |Date| | | | | |

|  |  |  |  |  | |  | | |

|2 |9 |14 |6 |*LOCATION CODE |Local use |Building code used by Data Warehouse, uniquely |alphanumeric | |

| | | | | |only |identifying building in which student is enrolled, | | |

| | | | | | |typically assigned by local student management | | |

| | | | | | |system. | | |

|3 |15 |24 |10 |*SCHOOL YEAR DATE |NYS |Use June 30 of the reported school year. Ex: For |date | |

| | | | |(SCHOOL YEAR DATE) |Reporting |2007-08, use 2008-06-30 |yyyy-06-30 | |

| | | | |Note; this is not a Data Element in SIRS but a | | | | |

| | | | |date used to identify the school year. | | | | |

|4 |25 |36 |12 |SOCIAL SECURITY NUMBER |Local use | | | |

| | | | | |only | | | |

|5 |37 |48 |12 |*STUDENT ID |NYS |The unique identifier assigned by the Local |alphanumeric | |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Education Agency (LEA) in which the student is |nnnnnnnnn | |

| | | | | | |enrolled. Use all 9 numeric characters, left padded | | |

| | | | | | |with zeros. | | |

|6 |49 |73 |25 |LAST NAME SHORT |Local use | | | |

| | | | | |only | | | |

|7 |74 |88 |15 |FIRST NAME SHORT |Local use | | | |

| | | | | |only | | | |

|8 |89 |89 |1 |MIDDLE INITIAL |Local use | | | |

| | | | | |only | | | |

|9 |90 |91 |2 |CURRENT GRADE LEVEL |Local use | | | |

| | | | | |only | | | |

|10 |92 |121 |30 |SPECIAL EDUCATION TEACHER NAME |Local use | | | |

| | | | | |only | | | |

|11 |122 |151 |30 |PRIMARY DISABILITY |Local use | | | |

| | | | | |only | | | |

|12 |152 |181 |30 |SECONDARY DISABILITY |Local use | | | |

| | | | | |only | | | |

|13 |182 |191 |10 |LAST IEP DATE |Local use | | | |

| | | | | |only | | | |

|14 |192 |201 |10 |LAST EVALUATION DATE |Local use | | | |

| | | | | |only | | | |

|15 |202 |231 |30 |SERVICE LEVEL |Local use | | | |

| | | | | |only | | | |

|16 |232 |261 |30 |RELATED SERVICES |Local use | | | |

| | | | | |only | | | |

|17 |262 |291 |30 |SERVICES PROVIDED (R/RR/S) |Local use | | | |

| | | | | |only | | | |

|18 |292 |303 |12 |SPECIAL EDUCATION TEACHER ID |Local use | | | |

| | | | | |only | | | |

|19 |304 |313 |10 |ANNUAL REVIEW DATE |Local use | | | |

| | | | | |only | | | |

|20 |314 |323 |10 |TRIENNIAL REVIEW DATE |Local use | | | |

| | | | | |only | | | |

|21 |324 |353 |30 |EXPECTED DIPLOMA TYPE |Local use | | | |

| | | | | |only | | | |

|22 |354 |356 |3 |2ND LANGUAGE EXEMPT |Local use | | | |

| | | | | |only | | | |

|23 |357 |359 |3 |ALTERNATE ASSESSMENT |Local use | | | |

| | | | | |only | | | |

|24 |360 |375 |16 |INSTRUCTION LANGUAGE |Local use | | | |

| | | | | |only | | | |

|25 |376 |395 |20 |COMMUNICATION MODE |Local use | | | |

| | | | | |only | | | |

|26 |396 |398 |3 |BRAILLE INSTRUCTION |Local use | | | |

| | | | | |only | | | |

|27 |399 |414 |16 |SPECIAL TRANSPORTATION |Local use | | | |

| | | | | |only | | | |

|28 |415 |417 |3 |EXTENDED SCHOOL YEAR |Local use | | | |

| | | | | |only | | | |

|29 |418 |420 |3 |HOME SCHOOLED |Local use | | | |

| | | | | |only | | | |

|30 |421 |428 |8 |PROGRAMS CODE |Local use | | | |

| | | | | |only | | | |

|31 |429 |436 |8 |+PRIMARY SERVICE CODE |NYS |Required only for preschool students with | |See Data Dictionary “Primary Service Code” |

| | | | |(PRIMARY SERVICE CODE) |Reporting |disabilities. | |data element (Template 0590 "Special |

| | | | | | |As of December 3: | |Education Snapshot") and Appendix 9 for |

| | | | | | |~ If student received multiple services, service | |Special Ed Primary Service codes. |

| | | | | | |received for majority of school day. | | |

| | | | | | |~ If multiple services received for equal amount of | | |

| | | | | | |day, service with numerically lower code value. | | |

| | | | | | |At end of school year: | | |

| | | | | | |~ All preschool SwD who received some special | | |

| | | | | | |education service any time during school year (July | | |

| | | | | | |1 to June 30). | | |

| | | | | | |~ If different services received during SY, code | | |

| | | | | | |that reflects last service on IEP. | | |

| | | | | | |~ If multiple services received for equal amount of | | |

| | | | | | |day, service with numerically lower code value. | | |

|32 |437 |452 |16 |+PRIMARY PLACEMENT TYPE |NYS |Required only for Dec. 3 snapshot. |alphanumeric |PLC01: Court or State Agency placement |

| | | | |(PRIMARY PLACEMENT TYPE) |Reporting |~ PLC01 used by: State agencies and child care | |(Article 81) |

| | | | | | |institutions with affiliated school, to designate | |PLC02: Residential placement by school |

| | | | | | |students for whom they have CSE responsibility; | |district (Article 89) |

| | | | | | |School districts, to designate court or State agency| |PLC03: Non Residential placement by school |

| | | | | | |placements of students with disabilities in | |district (Article 89) |

| | | | | | |out-of-State facilities for whom the public school | |See “Primary Placement Type” data element |

| | | | | | |district in which the student resided at the time of| |(Data Dictionary Template 0590 "Special |

| | | | | | |placement maintains CSE responsibility. | |Education Snapshot") for reporting directions.|

| | | | | | |~ PLC02 and PLC03 used by: Public school districts | | |

| | | | | | |to designate students placed in approved private | | |

| | | | | | |schools on a residential basis (PLC02) or on a day | | |

| | | | | | |basis (PLC03). | | |

|33 |453 |462 |10 |SPECIAL ED ENTRY DATE |Local use | | | |

| | | | | |only | | | |

|34 |463 |472 |10 |SPECIAL ED EXIT DATE |Local use | | | |

| | | | | |only | | | |

|35 |473 |482 |10 |*SNAPSHOT DATE |NYS |Template is collected twice a year. |Date | |

| | | | |(SNAPSHOT DATE) |Reporting |First collection reflects December 3rd data, |yyyy-12-03 | |

| | | | | | |subsequent collection reflects July 1st data of same|or | |

| | | | | | |SY |yyyy-07-01 | |

|36 |483 |485 |3 |IEP COMPLIANCE |Local use | | | |

| | | | | |only | | | |

|37 |486 |515 |30 |FUNDING PRIMARY DISABILITY CODE |Local use | | | |

| | | | | |only | | | |

|38 |516 |523 |8 |DISABILITY PRIMARY CAUSE CODE |Local use | | | |

| | | | | |only | | | |

|39 |524 |531 |8 |LIVING SETTING CODE |Local use | | | |

| | | | | |only | | | |

|40 |532 |539 |8 |HEARING IMPAIRMENT LEVEL CODE |Local use | | | |

| | | | | |only | | | |

|41 |540 |547 |8 |VISION IMPAIRMENT LEVEL CODE |Local use | | | |

| | | | | |only | | | |

|42 |548 |577 |30 |TERTIARY DISABILITY CODE |Local use | | | |

| | | | | |only | | | |

|43 |578 |607 |30 |QUATERNARY DISABILITY CODE |Local use | | | |

| | | | | |only | | | |

|44 |608 |615 |8 |* PRIMARY SETTING CODE |NYS |Required only for Dec. 3 snapshot. |alphanumeric |Codes see Data Dictionary Appendix 10, “Least |

| | | | |(LEAST RESTRICTIVE ENVIRONMENT CODE) |Reporting |Preschool & school age students with disabilities’ | |Restrictive Environment Code” element in |

| | | | | | |educational environment (least restrictive | |Template 0590 "Special Education Snapshot” |

| | | | | | |environment) as of 12/3. | | |

|45 |616 |623 |8 |TRANSITION IEP STATUS CODE |Local use | | | |

| | | | | |only | | | |

|46 |624 |643 |20 |+PRIMARY SERVICE PROVIDER |NYS |Required for December 3 snapshot and End-of-Year |alphanumeric | |

| | | | |(PRIMARY SERVICE PROVIDER) |Reporting |Snapshot. | | |

| | | | | | |Report only for preschool students with | | |

| | | | | | |disabilities. | | |

| | | | | | |If preschoolers receive services from more than one | | |

| | | | | | |provider, use the BEDS code of the coordinating | | |

| | | | | | |service provider (CSP). CSP is designated by CPSE. | | |

| | | | | | |Otherwise use the BEDS code of the sole service | | |

| | | | | | |provider. See Data Dictionary element “Primary | | |

| | | | | | |Service Provider” for Guidelines on reporting. | | |

|47 |644 |644 |1 |*SCHOOL AGED INDICATOR |NYS |Report this information for December 3. |alphanumeric |Y = Yes, student is school age. |

| | | | |(SCHOOL AGED INDICATOR) |Reporting | | |N = No, student is preschool age. |

| | | | | | | | | |

| | | | | | | | |See Data Dictionary for reporting directions |

| | | | | | | | |under “School Aged Indicator” element in |

| | | | | | | | |Template 0590 "Special Education Snapshot" |

Special_Ed_Snap (Special Education Snapshot) Template Sample Data

|Row |District |Location |School Year Date |Social Security |Student ID |Last Name Short |

| |Code |Code | |Number | | |

|1 | | |SA01 | | |Y |

|2 | | |PS03 | |90002000 |N |

|3 | | |SA04 | | |Y |

|4 | | |SA04 | | |Y |

|5 | | | | |90003000 |N |

NB: Breaks in sample data above are for display purposes only. Please see NOTE 2 on opening page of (Extract Specifications) Section 2 for details.

Student with Disabilities (SwD) in Row 1 is school age, attended a school building within the district, and in regular classes at least 80% of the day.

SwD in Row 2 is in preschool, received related services from more than one provider, and in a regular early childhood program less than 40% of the day.

SwD in Row 3 is school age, in a secondary ungraded program, and attends an approved private school for SwD.

SwD in Row 4 is school age, in an elementary ungraded program, and placed in a residential school for SwD.

SwD in Row 5 is in preschool, and received full-day (3-4 hours) special class program in an integrated setting for several months during 2007-08 SY.

SE_Events (Special Education Events) Template

| | | | |DATA DESCRIPTION | | | | |

|  |  |  |  |  |  |  |  |  |

|2 |9 |14 |6 |*LOCATION CODE |Local use |Building code used by data warehouse, uniquely |alphanumeric | |

| | | | | |only |identifying building in which student is enrolled, |nnnnnnnnn | |

| | | | | | |typically assigned by local SMS. | | |

|3 |15 |24 |10 |*SCHOOL YEAR DATE |NYS |Use June 30 of the reported school year. Ex: For |date | |

| | | | |(SCHOOL YEAR DATE) |Reporting |2007-08, use 2008-06-30 |yyyy-06-30 | |

| | | | |Note; this is not a Data Element in SIRS but a | | | | |

| | | | |date used to identify the school year. | | | | |

|4 |25 |36 |12 |*STUDENT ID |NYS |Unique identifier assigned by Local Education |alphanumeric | |

| | | | |(SCHOOL DISTRICT STUDENT ID) |Reporting |Agency in which student is enrolled. Use all 9 |nnnnnnnnn | |

| | | | | | |numeric characters, left padded with zeros. | | |

|5 |37 |52 |16 |*EVENT TYPE CODE |NYS |Reported at end of school year. |alphanumeric |See Data Dictionary Appendix 11 for Special Ed Event|

| | | | |(EVENT TYPE CODE) |Reporting | |nnnnnnnnn |Type Codes and “Event Type Code” element details in |

| | | | | | |NYS collects codes for four chains of events: | |Template 0550 "Special Education Event” |

| | | | | | |~ Referral from Early Intervention (EI) to CPSE; | | |

| | | | | | |Receipt of parent consent to evaluate student; CPSE| | |

| | | | | | |meeting to determine eligibility; full | | |

| | | | | | |implementation of IEP | | |

| | | | | | |~ Referral of preschool student to CPSE; Receipt of| | |

| | | | | | |parent consent to evaluate; CPSE meeting to discuss| | |

| | | | | | |evaluation results | | |

| | | | | | |~ Referral of school age student to the CSE; | | |

| | | | | | |Receipt of parent consent to evaluate; CSE meeting | | |

| | | | | | |to discuss evaluation results | | |

| | | | | | |~ Referral to CSE of school age student parentally | | |

| | | | | | |placed in nonpublic school; Receipt of parent | | |

| | | | | | |consent to evaluate; CSE meeting to discuss | | |

| | | | | | |evaluation results; IEP/IESP/SP implemented | | |

|6 |53 |62 |10 |*EVENT DATE |NYS |Provide a date associated with each Event Type Code|date |See Data Dictionary “Event Date” element in Template|

| | | | |(EVENT DATE) |Reporting | |yyyy-06-30 |0550 "Special Education Event” |

|7 |63 |78 |16 |EVENT REASON CODE 1 |Local use | | | |

| | | | | |only | | | |

|8 |79 |94 |16 |EVENT REASON CODE 2 |Local use | | | |

| | | | | |only | | | |

|9 |95 |110 |16 |EVENT REASON CODE 3 |Local use | | | |

| | | | | |only | | | |

|10 |111 |126 |16 |EVENT SOURCE CODE |Local use | | | |

| | | | | |only | | | |

|11 |127 |142 |16 |EVENT STATUS CODE |Local use | | | |

| | | | | |only | | | |

|12 |143 |158 |16 |+EVENT OUTCOME CODE |NYS |Identify whether/not student was determined |alphanumeric |Y = Yes, student determined eligible for special |

| | | | |(EVENT OUTCOME CODE) |Reporting |eligible for special education for following event |nnnnnnnnn |education services |

| | | | | | |type codes. To be provided with initial referral | |N = No, student ineligible for special education |

| | | | | | |event type record: | |services |

| | | | | | |~ CPSE meeting at which eligibility determination | |U--eligibility decision is undetermined or meeting |

| | | | | | |is made for student transitioning from EI to | |is not held - must be accompanied by reason code |

| | | | | | |preschool (EI03) | |(field 20 below) to explain why determination not |

| | | | | | |~ CPSE meeting at which evaluation results are | |made within reporting period. |

| | | | | | |discussed for students referred to CPSE for | | |

| | | | | | |evaluation (CPSE03) | |See Data Dictionary “Event Outcome Code” element |

| | | | | | |~ CSE meeting at which evaluation results are | |details in Template 0550 "Special Education Event” |

| | | | | | |discussed for students referred to CSE for | | |

| | | | | | |evaluation (CSE03) | | |

| | | | | | |~ CSE meeting at which evaluation results are | | |

| | | | | | |discussed for students parentally placed in | | |

| | | | | | |nonpublic schools and referred to CSE for | | |

| | | | | | |evaluation (CSENP03) | | |

|13 |159 |168 |10 |MEETING DATE |Local use | | | |

| | | | | |only | | | |

|14 |169 |184 |16 |MEETING TYPE CODE |Local use | | | |

| | | | | |only | | | |

|15 |185 |194 |10 |EFFECTIVE DATE |Local use | | | |

| | | | | |only | | | |

|16 |195 |202 |8 |ORGANIZATION CODE |Local use | | | |

| | | | | |only | | | |

|17 |203 |232 |30 |ORGANIZATION NAME |Local use | | | |

| | | | | |only | | | |

|18 |233 |262 |30 |ORGANIZATION CLUSTER |Local use | | | |

| | | | | |only | | | |

|19 |263 |272 |10 |COMPLIANCE DATE |Local use | | | |

| | | | | |only | | | |

|20 |273 |288 |16 |+NON COMPLIANCE REASON |NYS |There are three instances when reason for delay is | |See Data Dictionary Appendix 12 for Special Ed |

| | | | |(REASON CODE) |Reporting |required. Reason Code must be submitted with | |Reason Codes, |

| | | | | | |initial referral event type record for: | |and |

| | | | | | |~ For children transitioning from EI to preschool | |“Reason Code” data element details Template 0550 |

| | | | | | |and found to be NOT eligible for preschool special | |"Special Education Events” |

| | | | | | |education, if >30 school days between date of | | |

| | | | | | |receipt of parent consent to evaluate and date of | | |

| | | | | | |CPSE meeting at which eligibility determination | | |

| | | | | | |made OR if CPSE meeting not held or determination | | |

| | | | | | |of eligibility not made by August 31 OR for | | |

| | | | | | |children transitioning from EI to preschool and | | |

| | | | | | |found to be eligible for preschool special | | |

| | | | | | |education, if IEP is not implemented by the third | | |

| | | | | | |birthday or by August 31; | | |

| | | | | | |~ For preschool children referred to CPSE for | | |

| | | | | | |evaluation, if >30 school days between date of | | |

| | | | | | |receipt of parent consent to evaluate and date of | | |

| | | | | | |CPSE meeting at which evaluation results discussed | | |

| | | | | | |OR if CPSE meeting not held by August 31; | | |

| | | | | | |~ For school age student, if >60 calendar days | | |

| | | | | | |between date of receipt of parent consent to | | |

| | | | | | |evaluate and date of CSE meeting at which results | | |

| | | | | | |were discussed; OR students for whom CSE meeting | | |

| | | | | | |not held by August 31. | | |

|21 |289 |318 |30 |CHALLENGE TYPE |Local use | | | |

| | | | | |only | | | |

|22 |319 |348 |30 |CHALLENGE TYPE DISORDER 1 |Local use | | | |

| | | | | |only | | | |

|23 |349 |378 |30 |CHALLENGE TYPE DISORDER 2 |Local use | | | |

| | | | | |only | | | |

|24 |379 |408 |30 |CHALLENGE TYPE DISORDER 3 |Local use | | | |

| | | | | |only | | | |

|25 |409 |438 |30 |PREVIOUS CHALLENGE TYPE |Local use | | | |

| | | | | |only | | | |

|26 |439 |441 |3 |INTEGRATED PERCENTAGE |Local use | | | |

| | | | | |only | | | |

|27 |442 |444 |3 |SPECIAL ED PERCENTAGE |Local use | | | |

| | | | | |only | | | |

|28 |445 |447 |3 |STUDENT PRESENT |Local use | | | |

| | | | | |only | | | |

|29 |448 |450 |3 |PARENT PRESENT |Local use | | | |

| | | | | |only | | | |

|30 |451 |460 |10 |EVENT END DATE |Local use | | | |

| | | | | |only | | | |

|31 |461 |476 |16 |*INITIAL EVENT TYPE CODE |NYS |Code of first event in the chain of events reported|alphanumeric |See Data Dictionary for “Initial Event Type Code” |

| | | | |(INITIAL EVENT TYPE CODE) |Reporting |for student. Initial event type codes for initial |nnnnnnnnn |element details and codes, in Template 0550 "Special|

| | | | | | |referral to CPSE or CSE (EI01 or CPSE01; CSE01 or | |Education Event” |

| | | | | | |CSENP01). NOT required when only one event type | | |

| | | | | | |code is submitted for student. Submit with every | | |

| | | | | | |record of each chain after the initial referral | | |

| | | | | | |event type code record. | | |

|32 |477 |486 |10 |*INITIAL EVENT DATE |NYS |Date associated with Initial Event Type Code |date |See Data Dictionary for “Initial Event Date” data |

| | | | |(INITIAL EVENT DATE) |Reporting | |yyyy-06-30 |element details in Template 0550 "Special Education |

| | | | | | | | |Event” |

|33 |487 |490 |4 |*NUMBER OF DAYS |NYS |Report the number of days with the initial referral|alphanumeric |See Data Dictionary for “Number of Days” data |

| | | | |(NUMBER OF DAYS) |Reporting |event type record as follows: |nnnnnnnnn |element details in Template 0550 "Special Education |

| | | | | | |~ For children transitioning from EI to preschool, | |Event” |

| | | | | | |determined to be NOT eligible for preschool special| | |

| | | | | | |education, number of school days between receipt of| | |

| | | | | | |parent consent to evaluate preschool child (EI02 | | |

| | | | | | |Event Code Date) and date CPSE met to determine | | |

| | | | | | |eligibility (EI03 Event Code date) OR if meeting | | |

| | | | | | |was not held or determination of eligibility not | | |

| | | | | | |made, the number of school days between parent | | |

| | | | | | |consent to evaluate and August 31 OR for children | | |

| | | | | | |determined to be eligible for preschool special | | |

| | | | | | |education, number of calendar days past the child’s| | |

| | | | | | |third birthday when IEP was implemented OR if IEP | | |

| | | | | | |is not implemented, the number of calendar days | | |

| | | | | | |August 31 is past the child’s third birthday. | | |

| | | | | | |~ The number of school days between receipt of | | |

| | | | | | |parent consent to evaluate preschool student | | |

| | | | | | |(CPSE02 Event Code date) and date CPSE met to | | |

| | | | | | |discuss results (CPSE03 Event Code date) or if CPSE| | |

| | | | | | |meeting was not held, the number of school days | | |

| | | | | | |between parent consent to evaluate and August 31. | | |

| | | | | | | | | |

| | | | | | |~ The number of calendar days between receipt of | | |

| | | | | | |parent consent to evaluate school age student | | |

| | | | | | |(CSE02 Event Code date) and date of CSE meeting to | | |

| | | | | | |discuss results (CSE03 Event Code date) or if CSE | | |

| | | | | | |meeting was not held, the number of calendar days | | |

| | | | | | |between parent consent to evaluate and August 31. | | |

SE_Events (Special Education Events) Template Sample Data

Sample of school district submitting data for Special Education SPP Indicator 11 (includes evaluation of children transitioning from EI to preschool and evaluation of students who are parentally placed in nonpublic schools):

Student in Rows 1-3 is preschool student referred to CPSE on September 8, 2007. Parents provided consent to evaluate student on October 5, 2007 and CSE met to discuss evaluation results on December 5, 2007; CPSE determined student has a disability. Since district exceeded 30 school days between parental consent to evaluate and CPSE meeting at which evaluation results were discussed, they provided reason for delay.

Student in Rows 4-6 is a preschool student who is transitioning from Early Intervention to preschool. Parents referred the child on November 17, 2007 and provided consent to evaluate student on November 26, 2007. The CPSE met to discuss evaluation results on January 28, 2008 and child was found eligible for special education.

Student in Rows 7-9 is school age student referred to CSE on October 1, 2007. Parents provided consent to evaluate student on October 10, 2007 and CSE met to discuss evaluation results on November 20, 2007. Student was determined not eligible for special education. Since district did not exceed 60 calendar days between parental consent to evaluate and CSE meeting to discuss evaluation results, district did not have to provide reason code.

Student in Rows 10-12 and in rows 13-16 is the same student. This is a parentally placed student in a nonpublic school in the district. Parents referred student for special education eligibility determination on July 15, 2007 and provided consent to evaluate on same date. School district arranged for evaluation and CSE met to discuss evaluation results on August 1, 2007. Student was determined eligible for special education services. Student started receiving special education services on September 5, 2007 in accordance with an Individual Service Plan. Since district is scheduled to submit data on Indicator 11, student is reported in the CSE chain (rows 10-12) as well as in the CSENP chain (rows 13-16). It took district 18 calendar days to complete the evaluation and convene a CSE meeting to determine eligibility for special education. Since this is within 60 calendar days, a reason code is not needed.

Row |District Code |Location Code |School Year Date |Student ID |Event Type Code |Event Date |Eve Rea Cod |ent

tus

de |Event Outcome Code |Mee

Da |ance

te |Non

Comp.

Reason |Chal

Ty |ent

d

te |Initial Event Type Code |Initial Event Date |Number of Days | |1 |NY12345 |0001 |2008-06-30 |900000001 |CPSE01 |2007-09-08 | | |Y | | |CPSER04 | | | | |39 | |2 |NY12345 |0001 |2008-06-30 |900000001 |CPSE02 |2007-10-05 | | | | | | | | |CPSE01 |2007-09-08 | | |3 |NY12345 |0001 |2008-06-30 |900000001 |CPSE03 |2007-12-05 | | | | | | | | |CPSE01 |2007-09-08 | | |4 |NY12345 |0000 |2008-06-30 |900000008 |CPSE01 |2007-11-17 | | |Y | | |CPSER05 | | | | |35 | |5 |NY12345 |0000 |2008-06-30 |900000008 |CPSE02 |2007-11-26 | | | | | | | | |CPSE01 |2007-11-07 | | |6 |NY12345 |0000 |2008-06-30 |900000008 |CPSE03 |2008-01-28 | | | | | | | | |CPSE01 |2007-11-07 | | |7 |NY12345 |0002 |2008-06-30 |900000002 |CSE01 |2007-10-01 | | |N | | | | | | | |42 | |8 |NY12345 |0002 |2008-06-30 |900000002 |CSE02 |2007-10-10 | | | | | | | | |CSE01 |2007-10-01 | | |9 |NY12345 |0002 |2008-06-30 |900000002 |CSE03 |2007-11-20 | | | | | | | | |CSE01 |2007-10-01 | | |10 |NY12345 |0003 |2008-06-30 |900000003 |CSE01 |2007-07-15 | | |Y | | | | | | | |18 | |11 |NY12345 |0003 |2008-06-30 |900000003 |CSE02 |2007-07-15 | | | | | | | | |CSE01 |2007-07-15 | | |12 |NY12345 |0003 |2008-06-30 |900000003 |CSE03 |2007-08-01 | | | | | | | | |CSE01 |2007-07-15 | | |13 |NY12345 |0003 |2008-06-30 |900000003 |CSENP01 |2007-07-15 | | |Y | | | | | | | | | |14 |NY12345 |0003 |2008-06-30 |900000003 |CSENP02 |2007-07-15 | | | | | | | | |CSENP01 |2007-07-15 | | |15 |NY12345 |0003 |2008-06-30 |900000003 |CSENP03 |2007-08-01 | | | | | | | | |CSENP01 |2007-07-15 | | |16 |NY12345 |0003 |2008-06-30 |900000003 |CSENP04 |2007-09-05 | | | | | | | | |CSENP01 |2007-07-15 | | |

Sample of district submitting data for SPP Indicators 12, Transition of students from IDEA Part C (Early Intervention) to IDEA Part B (preschool).

Student in Rows 1-4 is preschool child whose birthday is September 5, 2004. Parent provided consent to evaluate student on July 6, 2007, student was determined eligible for preschool special education. Student’s IEP was implemented on September 10, 2007, which is 5 days past student’s 3rd birthday, so district provides reason for delay in implementing IEP (Parents chose to continue student in EIP and transition to preschool special education after child became three.)

Row |District Code |Location Code |School Year Date |Student ID |Event Type Code |Event Date |Eve

Rea

Cod |ent

tus

de |Event Outcome Code |Mee

Da |iance

te |Non

Comp.

Reason |Chall

Ty |ent

nd

te |Initial Event Type Code |Initial Event Date |Number of Days | |1 |NY12345 |0001 |2008-06-30 |900000009 |EI01 |2007-07-02 | | |Y | | |EIR13 | | | | |5 | |2 |NY12345 |0001 |2008-06-30 |900000009 |EI02 |2007-07-06 | | | | | | | | |EI01 |2007-07-06 | | |3 |NY12345 |0001 |2008-06-30 |900000009 |EI03 |2007-08-23 | | | | | | | | |EI01 |2007-07-06 | | |4 |NY12345 |0001 |2008-06-30 |900000009 |EI04 |2007-09-10 | | | | | | | | |EI01 |2007-07-06 | | |

Section 3: Glossary of Terms

AAOS Alternate Assessments in Other States

AHSEP Alternative High School Equivalency Preparation

APR Annual Performance Report for Special Education

BEDS Basic Education Data System

CPSE Committee on Preschool Special Education

CSE Committee on Special Education

CTE Career Technical Education

GED General Education Diploma

HSEP High School Equivalency Preparation

IEP Individualized Education Program

IESP Individualized Education Service Program

LEA Local Education Agency

LEP Limited English Proficiency

NCLB No Child Left Behind

NYSAA New York State Alternate Assessment

NYSED New York State Education Department

NYSESLAT New York State English as a Second Language Achievement Test

NYSSIS New York State Student Identifier System

RCT Regents Competency Test

RIC Regional Information Center

SLP Second Language Proficiency

SP Service Plan

SPP State Performance Plan (for Special Education)

VESID Vocational Education Services for Individuals with Disabilities

-----------------------

A = Active

I = Inactive

1 = 4-year college in NYS

2 = 2-year college in NYS

3 = Other postsecondary sch. in NYS

4 = 4-year college outside NYS

5 = 2-year college outside NYS

6 = Other postsecondary school outside NYS

7 = Seek employment

8 = Enlist in the military

For students with disabilities only:

13 = ungraded elementary K-6

14 = ungraded secondary 7-12

01 = grade 1

02 = grade 2

03 = grade 3

04 = grade 4

05 = grade 5

06 = grade 6

07 = grade 7

I = American Indian or Alaska Native

A = Asian

B = Black or African American

H = Hispanic

W = White

P = Native Hawaiian or other Pacific Islander

M = Male

F = Female

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download