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.

Student Lite EditorReport Logic

Students enrolled in the calendar(s) selected on the extract editor report.

Students are NOT included if

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.

If 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
DistrictCode	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
LocationCode	The building code of the building in which the student is enrolled. Numeric, 6 digits	System Administration > Resources > School > Location Code customSchool.value
SchoolYear	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
lastName	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
firstName	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
middleInitial	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 will populate with the grade override if 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
raceEthnicity	The race/ethnicity code of the student. Options are: A: Asian I: American Indian or Alaska Native B: Black or African American P: Native Hawaiian or Pacific Islander W: White 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 EdSetting	Not reported.	N/A
english Proficiency	Not reported.	N/A
ELLDuration	Not reported.	N/A
postGradPlans	The code representing the student's plans following graduation. This field reports the student's Graduation Post Grad Plans if the Graduation Diploma Date falls within the Calendar Start Date and End Date of the calendar(s) selected on the extract editor. If the student's Enrollment End Status is 136 OR 629, this field reports regardless of the Graduation Diploma Date. Otherwise, this field reports null. See options in the following Post Grade Plans Options table. 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: A: Active I: Inactive Alphanumeric, 1 character	Student Information > General > Enrollments > End Date enrollment.endDate
lastStatus	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
diplomaType	The code representing the type of diploma the student received upon graduation. If the Enrollment End Status is 629, this field reports regardless of the Diploma Date. See options in the following Diploma Type Options table. Alphanumeric, 3 characters	Student Information > General > Graduation > Diploma Type graduation.diplomaType
specialEdStatus	Not reported.	N/A
grade9Date	The date the student entered ninth grade. If the Date First Entered the 9^th 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
serviceProvider	Not reported.	N/A
inoculationDate	Not reported.	N/A
address1	The number, street name and direction of the student's address. If all household memberships have been end dated, the most recent household address reports. The most recent end dated address reports if a student does not have an active address. Reports the household's most recent physical address if the household address is a PO Box. PO Box does not report. 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.prefix address.street address.tag address.direction
address2	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 address.prefix address.street address.tag address.direction
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
homePhone	The student's home telephone number. Alphanumeric, 14 characters	Census > Household > Household Info > Phone Number household.phoneNumber
guardian1	The name of the student's primary guardian. Alphanumeric, 40 characters	Census > People > Relationships > Guardian identity.lastName identity.firstName relationshipType.guardian
guardian2	The name of the student's additional guardian. Alphanumeric, 40 characters	Census > People > Relationships > Guardian identity.lastName identity.firstName relationshipType.guardian
placeOfBirth	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 CustomIdentity identity.birthState CustomIdentity identity.birthCity
dateEnteredUS	Not reported.	N/A
yearsIn USSchools	Not reported.	N/A
countryOfOrigin	Not reported.	N/A
district CodeOf 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
raceCode2	Not reported.	N/A
raceCode3	Not reported.	N/A
raceCode4	Not reported.	N/A
raceCode5	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
homelessPrimary NighttimeResidence	Not reported.	N/A
Native Language	Not reported.	N/A
careerPathCode	The code used to identify the pathway the student used to graduate. See options in the following Career Path Codes table. Alphanumeric, 8 characters	Student Information > General > Graduation > State Reporting Graduation Fields > Career Path Graduation.gradPath
guidanceCounselor DistrictCode	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
guidanceCounselorID	The Guidance Counselor's ID. If the Include Guidance Counselor checkbox is marked on the extract editor, then this field reports according to the following criteria. Reports the Person Staff State ID of the Counseling Team Member who meets all of the following: Start Date <= Extract Editor Effective Date End Date is one of the following: Equal to or greater than the Calendar Start Date NULL Role = Counselor If 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	Student Information > Counseling > General > Team Members Start Date End Date Role Census > People > Demographics > Staff State ID Person.staffStateID

Post Grad Plans Options

Code	Description
1	Attend 4 year college in NYS
2	Attend 2 year college in NYS
3	Attend other postsecondary school in NYS
4	Attend 4 year college outside NYS
5	Attend 2 year college outside NYS
6	Attend other postsecondary school outside NYS
7	Seek employment
8	Enlist in the military
9	Other
10	Adult Services
11	Unknown

Diploma Type Options

Code	Description
0	Not Graduated
017	Regents with Honors pre July 1, 2001
034	Regents pre July 1, 2001
051	Regents with CTE pre July 1, 2001
068	Local Diploma
070	Local Diploma with Career Ed & Superintendent Determination
102	Local Certificate
119	Career Development & Occupational Studies Commencement Credential
136	Skills and Achievement Commencement Credential
595	Regents with Honors & CTE pre July 1, 2001
612	Local Diploma with Career Ed
629	Previously Earned IEP Diploma
680	Regents Diploma with Adv Designation
697	Regents Diploma with Adv Des & Career Ed
714	Regents Diploma with Adv Des & Honors
731	Regents Diploma with AD & Honors & Career Ed
738	GED
762	Regents with Honors post July 1, 2001
779	Regents post July 1, 2001
796	Regents with CTE post July 1, 2001
813	Regents with Honors & CTE post July 1, 2001
GED	High School Equivalency Diploma

Career Path Codes

Code	Description
ARTS	Arts
CDOS	Career Development and Occupational Studies
CIVIC	Civic Readiness
CTE	Career and Technical Education
HUM	Humanities
HUMALT	Humanities Alternative
LOTE	Language Other Than English
STEMMATH	Mathematics
STEMSCIENCE	Science, Technology, and Engineering
NONE	No Pathway