Tool Search: SIRS Extracts
The SIRS Student Lite Extract collects basic student demographic and enrollment information. 
Student Lite Editor
Students enrolled in the calendar(s) selected on the extract editor report.
Students are NOT included when:
- their enrollment record is marked as State Exclude;
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as State Exclude; or
- their Calendar of enrollment is marked as State Exclude.
When a student has multiple non-state-excluded enrollment records in a given calendar, a single record reports based on the enrollment record that has the highest primacy ranking based on the following chart:
Type | Primacy |
|---|---|
| P: Primary (when more than one, most recent start date) | 1 |
| S: Partial (when more than one, most recent start date) | 2 |
| N: Sped (when more than one, most recent start date) | 3 |
Extract Editor Field Descriptions
| Field | Description |
|---|---|
| Extract Type | The SIRS Extract to be run. |
| Effective Date | The date for which information reports. |
| Included State Grade Levels | Identifies the state grade levels to include in the report. |
| Format | The Format in which the report should generate. Options are State Format (CSV) and HTML. Use State Format for reporting information to the state and the other types for data review and verification. |
| Ad Hoc Filter | Selecting a filter limits the results to only those included in the filter. |
| Column Headers | Indicates whether Column Headers should be included in the report. This dropdown list applies to State Format (CSV). |
| Include Guidance Counselor | When this checkbox is marked, the Guidance Counselor ID element reports the Staff State ID of the counseling team member. |
| Use Protected Identity | When this checkbox is marked, the student's protected identity information reports. |
Generate Extract/ Submit to Batch | Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
| Select Calendars | Identifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year. |
Student Lite Extract Layout
Element | Description | Location |
|---|---|---|
District Code | The identification number of the district. The prefix "NY" is added to the district number. For example, when the district number is 662001, the District Code is NY662001. Numeric, 8 digits | District Information > District Number District.number |
Location Code | The building code of the building in which the student is enrolled. Numeric, 6 digits | School Information > Location Code CustomSchool.value |
School Year | The school year of the program. Reports as June 30 of the reported school year. Date field, 10 characters, YYYY-6-30 | Calendar > End Date (year only) Calendar.endYear |
Student ID | The student's Local Student Number. Alphanumeric,12 characters | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
Last Name | The last name of the student. Alphanumeric, 40 characters | Demographics > Last Name OR Identities > Protected Identity Information > Legal Last Name Person.lastName |
First Name | The first name of the student. Alphanumeric, 35 characters | Demographics > First Name OR Identities > Protected Identity Information > Legal First Name Identity.firstName |
Middle Initial | The first letter of the student's middle name. Alphanumeric, 1 character | Demographics > Middle Name OR Identities > Protected Identity Information > Legal Middle Name Identity.middleName |
Grade | The grade level of the student's enrollment. Grade populates with the grade override when the field is not null. Alphanumeric, 3 characters | Enrollments > Grade Enrollment.grade |
Homeroom | The section number of the student's homeroom class. Numeric, 6 digits | Section Information > Homeroom AND Schedule > Homeroom Course Section.homeroomSection |
Birthdate | The date of birth of the student. Date Field, 10 characters, YYYY-MM-DD | Demographics > Birthdate Identity.birthdate |
Gender | The student's gender. Alphanumeric, 1 character, M , F, or X (non-binary) | Demographics > Gender OR Identities > Protected Identity Information > Legal Gender Identity.gender |
Race Ethnicity | The race/ethnicity code of the student. Options are:
Alphanumeric, 1 character | Demographics > Race/Ethnicity Identity.raceEthnicity |
Language | The language spoken in the student's home. Alphanumeric, 16 characters | Identities > Home Primary Language Identity.homePrimaryLanguage |
Disability | Not reported. | N/A |
Special Ed Setting | Not reported. | N/A |
English Proficiency | Not reported. | N/A |
ELL Duration | Not reported. | N/A |
Post Grad Plans | The code representing the student's plans following graduation. This is required for P-Tech, Smart Scholars, and Smart Transfer students. While not required, this information may be reported for students not participating in these program. When nothing is selected, this field reports as blank. Numeric, 2 digits | Graduation > Post Grad Plans Graduation.postGradPlans |
Status | Indicates the student has an active enrollment at the time the report was generated. Options are:
Alphanumeric, 1 character | Enrollments > End Date Enrollment.endDate |
Last Status | The date on which the report was generated. Date field, 10 characters, YYYY-MM-DD | Reporting > SIRS Extracts > Student Lite Extract > Effective Date Not dynamically stored |
Poverty | Not reported. | N/A |
Population | Not reported. | N/A |
Mobility | Not reported. | N/A |
Diploma Type | The code representing the type of diploma the student received upon graduation. When the Enrollment End Status is 629, this field reports regardless of the Diploma Date. Alphanumeric, 3 characters | Graduation > Diploma Type Graduation.diplomaType |
Special Ed Status | Not reported. | N/A |
Grade 9 Date | The date the student entered ninth grade. When the Date First Entered the 9th Grade field is NULL, the date reports from the earliest enrollment where Grade = 09. Date field, 10 characters, YYYY-MM-DD | Graduation > Date First Entered 9th Grade Graduation.grade9Date |
Service Provider | Not reported. | N/A |
Inoculation Date | Not reported. | N/A |
Address 1 | The number, street name and direction of the student's address.
Addresses do not report when the Address is marked as Private. Alphanumeric, 30 characters | Household Addresses > Address > Number, Prefix, Street, Tag, Direction Address.number |
Address 2 | Any additional address details, when applicable. PO Box does not report. Alphanumeric, 30 characters | Household Addresses > Address > Number, Prefix, Street, Tag, Direction Address.number Address.prefix |
City | The city of the student's address. Reports blank when a student does not have a physical address reported in the address1 field. Alphanumeric, 25 characters | Household Addresses > Address > City Address.city |
State | The state of the student's address. Reports blank when a student does not have a physical address reported in the address1 field. Alphanumeric, 2 characters | Household Addresses > Address > State Address.state |
Zip | The zip code of the student's address. Reports blank when a student does not have a physical address reported in the address1 field. Numeric, 10 digits | Household Addresses > Address > Zip Address.zip |
Home Phone | The student's home telephone number. Alphanumeric, 14 characters | Household Information > Phone Number Household.phoneNumber |
Guardian 1 | The name of the student's primary guardian. Alphanumeric, 40 characters | Relationships > Guardian Identity.lastName |
Guardian 2 | The name of the student's additional guardian. Alphanumeric, 40 characters | Relationships > Guardian Identity.lastName |
Place Of Birth | The city, state and country of the student's birth place. Alphanumeric, 50 characters | Demographics > Birth Country, Birth State and Birth City Identity.birthCountry |
Date Entered US | Not reported. | N/A |
Years In US Schools | Not reported. | N/A |
Country Of Origin | Not reported. | N/A |
District Code Of Residence | The district in which the student resides. Reports with an 'NY' preceding the district number. Alphanumeric, 8 characters | Enrollments > State Reporting Fields > District of Residence District.number |
Hispanic Indicator | Indicates the student is considered to be of Hispanic/Latino descent. Alphanumeric, 1 character, Y or N | Demographics > Is this Individual Hispanic/Latino? Identity.hispanicEthnicity |
Race Code 2 | Not reported. | N/A |
Race Code 3 | Not reported. | N/A |
Race Code 4 | Not reported. | N/A |
Race Code 5 | Not reported. | N/A |
Homeless Indicator | Not reported. | N/A |
Migrant Indicator | Indicates the student is a migrant. Alphanumeric, 1 character, Y or N | Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
Immigrant Indicator | Not reported. | N/A |
Neglected Delinquent | Indicates the student is considered to be a Neglected Delinquent. Alphanumeric, 1 character, Y or N | Enrollments > State Reporting Fields > Neglected Delinquent CustomStudent.value |
Homeless Primary Nighttime Residence | Not reported. | N/A |
| Native Language | Not reported. | N/A |
| Career Path Code | The code used to identify the pathway the student used to graduate. Alphanumeric, 8 characters | Graduation > State Reporting Graduation Fields > Career Path Graduation.gradPath |
Guidance Counselor District Code | Reports the value found in the District Code element. Guidance Counselor District Code reports null when Guidance Counselor ID reports null. Alphanumeric, 20 characters | District Information > District Number District.number |
| Guidance Counselor ID | The Guidance Counselor's ID. When the Include Guidance Counselor checkbox is marked on the extract editor, then this field reports according to the following criteria.
When multiple Team Members meet the previous criteria, this element reports from the Team Member with the latest Start Date (i.e., most recent) Otherwise, this element reports null. Alphanumeric, 12 characters | Counseling Team Members > Start Date, End Date, Role Demographics > Staff State ID Person.staffStateID |
| County of Residence | The county code of the primary address where the student resides. Logic: This field reports for any student who has a County of Residence specified on their primary address. Reports blank when the County of Residence is not specified. This reports the two digit county code and includes a leading zero for counties with one-digit codes. Note: This is required for NYS P-Tech students. Alphanumeric, 20 characters | Household Addresses > County Counties > Number County.number |
| Educational Level of Parent | The highest educational level of the student's parent/guardian between either parent/guardian. Logic: This is required for NYS P-Tech, Smart Scholars, and Smart Transfer students. While not required, this information may be reported for students not participating in these programs. This field reports blank when the Educational Level for the parent is not specified. Note: This only reports from the parent's Education Level field. A value entered into the student's Education Level field does not report. Alphanumeric, 15 characters | Demographics > Education Level Identity.educationLevel |
| Crisis Impact Code | The crisis impact code for new students who were displaced due to a crisis or disaster. Logic: Reports the Crisis Impact Code when the Displaced Indicator is marked AND the Program Start Date is within the student's reported Enrollment. Otherwise, this reports as blank. Alphanumeric, 20 characters | Program Participation > State Programs > Crisis Event > Crisis Code CrisisEvent.crisisType |
| Crisis Name | The crisis or disaster name that displaced the student. Logic: Reports the Crisis Name when the Displaced Indicator is marked AND the Crisis Event Start Date is prior to the new student's Enrollment Start Date. Otherwise, this reports as blank. Alphanumeric, 50 characters | Program Participation > State Programs > Crisis Event > Crisis Name CrisisEvent.crisisName |
Previous Versions
SIRS Student Lite (New York) [.2251 - .2343]
SIRS Student Lite (New York) [.2243 - .2247]
SIRS Student Lite (New York) [.2215 - .2239]
