Classic View: NY State Reporting > SIRS Extracts > Student Lite
Search Terms: SIRS Extract
The SIRS Student Lite Extract collects basic student demographic and enrollment information.
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 (if more than one, most recent start date) | 1 |
S: Partial (if more than one, most recent start date) | 2 |
N: Sped (if 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, if the district number is 662001, the District Code is NY662001. Numeric, 8 digits | System Administration > Resources > District Information > District Number district.number |
Location Code | The building code of the building in which the student is enrolled. Numeric, 6 digits | System Administration > Resources > School > 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 | System Administration > Calendar > Calendar > End Date (year only) calendar.endYear |
Student ID | The student's Local Student Number. Alphanumeric,12 characters | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber |
Last Name | The last name of the student. Alphanumeric, 40 characters | Census > People > Demographics > Last Name OR Census > People > Identities > Protected Identity Information > Legal Last Name person.lastName, person.legalLastName |
First Name | The first name of the student. Alphanumeric, 35 characters | Census > People > Demographics > First Name OR Census > People > Identities > Protected Identity Information > Legal First Name identity.firstName, identity.legalFirstName |
Middle Initial | The first letter of the student's middle name. Alphanumeric, 1 character | Census > People > Demographics > Middle Name OR Census > People > Identities > Protected Identity Information > Legal Middle Name identity.middleName, identity.legalMiddleName |
Grade | The grade level of the student's enrollment. Grade populates with the grade override when the field is not null. Alphanumeric, 3 characters | Student Information > General > Enrollments > Grade enrollment.grade |
Homeroom | The section number of the student's homeroom class. Numeric, 6 digits | Scheduling > Course > Section > Homeroom AND Student Information > General > Schedule > Homeroom course section.homeroomSection |
Birthdate | The date of birth of the student. Date Field, 10 characters, YYYY-MM-DD | Census > People > Demographics > Birthdate identity.birthdate |
Gender | The designation of the student as male or female. Alphanumeric, 1 character, M , F, or X (non-binary) | Census > People > Demographics > Gender OR Census > People > Identities > Protected Identity Information > Legal Gender identity.gender, identity.legalGender |
Race Ethnicity | The race/ethnicity code of the student. Options are:
Alphanumeric, 1 character | Census > People > Demographics > Race/Ethnicity identity.raceEthnicity |
Language | The language spoken in the student's home. Alphanumeric, 16 characters | Identity > 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 | Student Information > General > Graduation > Post Grad Plans graduation.postGradPlans |
Status | Indicates if the student has an active enrollment at the time the report was generated. Options are:
Alphanumeric, 1 character | Student Information > General > Enrollments > End Date enrollment.endDate |
Last Status | The date on which the report was generated. Date field, 10 characters, YYYY-MM-DD | NY State 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 | Student Information > General > 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 | Student Information > General > Graduation > Date First Entered the 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 if the Address is marked as Private. Alphanumeric, 30 characters | Census > Household > Addresses > Address > Number, Prefix, Street, Tag, Direction address.number |
Address 2 | Any additional address details, if applicable. PO Box does not report. Alphanumeric, 30 characters | Census > Household > Addresses > Address > Number, Prefix, Street, Tag, Direction address.number |
City | The city of the student's address. Reports blank if a student does not have a physical address reported in the address1 field. Alphanumeric, 25 characters | Census > Household > Addresses > Address > City address.city |
State | The state of the student's address. Reports blank if a student does not have a physical address reported in the address1 field. Alphanumeric, 2 characters | Census > Household > Addresses > Address > State address.state |
Zip | The zip code of the student's address. Reports blank if a student does not have a physical address reported in the address1 field. Numeric, 10 digits | Census > Household > Addresses > Address > Zip address.zip |
Home Phone | The student's home telephone number. Alphanumeric, 14 characters | Census > Household > Household Info > Phone Number household.phoneNumber |
Guardian 1 | The name of the student's primary guardian. Alphanumeric, 40 characters | Census > People > Relationships > Guardian identity.lastName |
Guardian 2 | The name of the student's additional guardian. Alphanumeric, 40 characters | Census > People > Relationships > Guardian identity.lastName |
Place Of Birth | The city, state and country of the student's birth place. Alphanumeric, 50 characters | Census > People > 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 | Student Information > General > Enrollments > State Reporting Fields > District of Residence district.number |
Hispanic Indicator | Indicates if the student is considered to be of Hispanic/Latino descent. Alphanumeric, 1 character, Y or N | Census > People > 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 if the student is a migrant. Alphanumeric, 1 character, Y or N | Student Information > General > Enrollments > State Reporting Fields > Migrant enrollment.migrant |
Immigrant Indicator | Not reported. | N/A |
Neglected Delinquent | Indicates if the student is considered to be a Neglected Delinquent. Alphanumeric, 1 character, Y or N | Student Information > General > 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 | Student Information > General > 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 | System Administration > District Info > 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.
Alphanumeric, 12 characters | Student Information > Counseling > General > Team Members
Census > People > Demographics > Staff State ID Person.staffStateID |
County of Residence | The county of the primary address where the student resides. Logic: This is required for NYS P-Tech students. While not required, this information may be reported for students not participating in this program. This field reports blank when the County of Residence is not specified. Alphanumeric, 20 characters | Census > Household > Addresses > Address > County Address.county |
Educational Level of Parent | The highest educational level of the student's 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 | Census > People > 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 Crisis Event Start Date is prior to the new student's Enrollment Start Date. Otherwise, this reports as blank. Alphanumeric, 20 characters | Student Information > General > 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 | Student Information > General > Program Participation > State Programs > Crisis Event > Crisis Name CrisisEvent.crisisName |