Classic View: KS State Reporting > Collection Extract > SMSC: Dec 1 SMSCe Allocation

Search Terms: Collection Extract

The KIDS Collection SMSC Extract report gathers information on small districts eligible for Rural Education Achievement Program (REAP) funding. Data is not related to Title 1 Programming.

Information reported in this extract are reported up to December 2 of the selected school year. The Data to Filter Date auto-populates to December 1.

Screenshot of the KIDS SMSC extract editor highlighting the extract type field. KIDS SMSC Editor

Report Logic

See the KIDS Collection Extracts article for general reporting logic.

Districts with an Average Daily Attendance of 3,000 students or less and that have a Common Core of Data code of 6, 7 or 8 may be eligible for additional REAP grant funding. For this reason, records for students in grades K-12 who are enrolled any time between the first day of school and December 3 are included in the SMSC collection.

This extract only reports enrollment records that are active within the Reporting Range entered on the Extract Editor (Data Filter From Date, Data Filter To Date). If the Enrollment Start Date or Enrollment End Date fall on the day of the reporting range (Data Filter From Date and Data Filter To Date is the same), the enrollment is included.

One record per enrolled student reports from the selected calendar for the entered Reporting Range.

Students do not report when:

The Enrollment record is marked as State Exclude or No Show.
The Calendar of Enrollment is marked as State Exclude.
The Grade Level of Enrollment is marked as State Exclude.

Generate the Report

See the KIDS Collection Extracts editor for description of the Report Editor fields and Sample Report Formats.

Select the SMSC: Dec 1 SMSCe Allocation from the Extract Type dropdown list.
Enter a Data Filter From Date, if desired. The Data Filter To Date is already populated with the December 1 date of the selected year.
Select the Assessment Disaggregation Method 1 option, if desired.
Select the Assessment Disaggregation Method 2 option, if desired.
Mark the Students without State IDs checkbox, if desired.
Mark the Social Security Number Optional, if desired.
Select an Ad hoc Filter, if desired.
Select the appropriate Format for the extract.
If generating the extract in the State Format (tab delimited), enter the Records Limit Per File number.
Select the Calendars to include in the extract.
Click the Generate Report button. The report will display in the selected format.

Report Layout

Data Element	Description	Location
Record Type	Type of extract being generated, chosen on the Report Editor. Alphanumeric, 4 characters	Data not stored
Accountability School Identifier	Indicates the school number of the student's enrollment. Alphanumeric, 4 characters	System Administration > Resources > School > School Detail > State School Number School.number
Resident District	District number where student resides (but not necessarily attends). If Home District field is blank, data reports from the State District Number field. Alphanumeric, 5 characters	Student Information > General > Enrollments > State Reporting Fields > Home District Enrollment.residentDistrict System Administration > Resources > District Information > District Info > State District Number District.number
Legal Last Name	Reports the last name of the student. If the Legal Last Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName Census > People > Demographics > Person Information > Last Name Identity.lastName
Legal First Name	Reports the legal first name of the student. If the Legal First Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName Census > People > Demographics > Person Information > First Name Identity.firstName
Legal Middle Name	Middle name or middle initial of the student. If only the middle initial is available, this will be reported. If no middle name or initial is available for the student, this field will report blank. If the Legal Middle Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name Identity.legalMiddleName Census > People > Demographics > Person Information > Middle Name Identity.middleName
Suffix	Indicates student's name is generational (Jr., III, etc.). If the Legal Suffix field is populated, information reports from that field. Alphanumeric, 10 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Suffix Identity.legalSuffix Census > People > Demographics > Person Information > Suffix Identity.suffix
Gender	Indication of student being either male or female. If the Legal Gender field is populated, information reports from that field. Numeric, 1 digit (0 = Female, 1 = Male)	Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender
Date of Birth	Date on which student was born. Date field, 10 characters (MM/DD/YYYY)	Census > People > Demographics > Person Information > Birth Date Identity.birthDate
Grade	Grade level or primary instructional level at which the student enters and receives services in a school or an educational institution during a given academic session. See the Report Logic section for more information on grade levels. When the enrollment State Grade Level is 04 and the Primary Disability reports a value of WD, a value of 02 reports. Otherwise, this field reports the mapped state grade level of the local grade level. Alphanumeric, 2 characters	Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade
Student Identifier	Unique identifier assigned to the student by the school and/or district. Alphanumeric, 20 characters	Census > People > Demographics > Person Identifiers > Student Number Person.student Number
Hispanic Ethnicity	Indication of student being of Hispanic/Latino ethnicity. If yes, will report as Y; if No, will report as N. Alphanumeric, 1 character	Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.hispanicLatino
State Student Identifier	Student's state identification number. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > State ID Person.stateID
School Year	The ending year of the current school year. If reporting for the 2010-11 school year, this will report as 2011. Numeric, 4 digits	System Administration > Calendar > Calendar > Calendar Information > End Date Calendar.year
Funding School	Override field for the school that receives funding for the student. Alphanumeric, 4 characters	System Administration > Resources > School > School Editor > State School Number Student Information > General > Enrollments > State Reporting Fields > Funding School EnrollmentKS.fundingSchool
Attendance School	Unique number of the school or program in which the student is physically located and where he/she takes the state assessments. Numeric, 4 digits	Student Information > General > Enrollments > State Reporting Fields > Attendance School EnrollmentKS.attendanceSchool
Virtual Education Student	No value reports for this field in the SMSC Extract.	N/A
School Entry Date	Reports the student's start date of enrollment at the school. If this Entry into School field is blank on the enrollment record, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into School EnrollmentKS.schoolDate
District Entry Date	Reports the student's first date of entry at the district. If the Entry into District field is blank on the enrollment record, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into District EnrollmentKS.districtDate
State Entry Date	Reports the student's first date of entry at a school in the state. If this Entry into State field is blank, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into State EnrollmentKS.stateDate
First Instructional Date	No value reports for this field in the SMSC Extract.	N/A
Membership Days	Calculated field. See the Report Logic section for details on the attendance calculations. Reports the number of days the student has been enrolled (days present plus days absent) in this school when school was in session during the current school year. Only dates from the most recent enrollment in the selected calendar are calculated. For kindergarten students, partial day attendance is based on the half day attendance period that constitutes an entire attendance day. If the student's most recent enrollment has an End Status of 18, a value of 0 reports. Numeric, 5 digits (XXX.X)	Data not stored
Attended Days	Calculated field. See the Report Logic section for details on the attendance calculations. Repo[rts the number of days the student has been present in this school between the entered Date Filter From and Date Filter To Date entered on the editor. Only dates from the most recent enrollment in the selected calendar are calculated. If the student's most recent enrollment has an End Status of 18, a value of 0 reports. Numeric, 5 digits (XXX.X)	Data not stored
Truant Student	No value reports for this field in the SMSC Extract.	N/A
Minutes Enrolled	No value reports for this field in the SMSC Extract.	N/A
Concurrent HS Enrollment	No value reports for this field in the SMSC Extract.	N/A
Exit Withdrawal Date	No value reports for this field in the SMSC Extract.	N/A
Exit Withdrawal Type	No value reports for this field in the SMSC Extract.	N/A
Unweighted Grade Point Average	No value reports for this field in the SMSC Extract.	N/A
Special Circumstance Transfer Choice	No value reports for this field in the SMSC Extract.	N/A
Post Graduation Plans	No value reports for this field in the SMSC Extract.	N/A
Comprehensive Race	Indicates the student's race/ethnicity. All five positions must be filled with either a 0 or a 1. For a student designed as being White, this field will report as "00005." Position 5 - White Position 4 - Native Hawaiian or Other Pacific Islander Position 3 - Black or African American Position 2 - Asian Position 1 - American Indian or Alaska Native Bit field, 6 characters	Census > People > Demographics > Person Information > Federal Race Identity.raceEthnicity
Lunch Program	No value reports for this field in the SMSC Extract.	N/A
Primary Disability Indicator	No value reports for this field in the SMSC Extract.	N/A
Gifted Student Indicator	No value reports for this field in the SMSC Extract.	N/A
Section 504	No value reports for this field in the SMSC Extract.	N/A
Residence of Homeless	No value reports for this field in the SMSC Extract.	N/A
ESOL/Bilingual Program Entry Date	No value reports for this field in the SMSC Extract.	N/A
First Entry Date into a school in the US	No value reports for this field in the SMSC Extract.	N/A
First Language	No value reports for this field in the SMSC Extract.	N/A
ESOL/Bilingual Participation Code	No value reports for this field in the SMSC Extract.	N/A
Language Instruction Education Program Type	No value reports for this field in the SMSC Extract.	N/A
ESOL/Bilingual Program Ending Date	No value reports for this field in the SMSC Extract.	N/A
ESOL/Bilingual Student Contact Minutes	No value reports for this field in the SMSC Extract.	N/A
Career Tech Ed Contact Minutes	No value reports for this field in the SMSC Extract.	N/A
Title 1 Participation	No value reports for this field in the SMSC Extract.	N/A
Miles Transported	No value reports for this field in the SMSC Extract.	N/A
Transportation FTE	No value reports for this field in the SMSC Extract.	N/A
Student's Street Address	No value reports for this field in the SMSC Extract.	N/A
Student's City	No value reports for this field in the SMSC Extract.	N/A
Student's Zip	No value reports for this field in the SMSC Extract.	N/A
Non-Resident Transportation 10 Mile Law	No value reports for this field in the SMSC Extract.	N/A
Military Connected Student Indicator	No value reports for this field in the SMSC Extract.	N/A
Immigrant Student	No value reports for this field in the SMSC Extract.	N/A
Country of Birth	No value reports for this field in the SMSC Extract.	N/A
Neglected Student	No value reports for this field in the SMSC Extract.	N/A
Kansas Preschool Program (KPP)	No value reports for this field in the SMSC Extract.	N/A
Kansas Parents as Teachers Participant (KPAT)	No value reports for this field in the SMSC Extract.	N/A
Dyslexia Screener	No value reports for this field in the SMSC Extract.	N/A
Dyslexia Subtest	No value reports for this field in the SMSC Extract.	N/A
Dyslexia Spring Benchmark Performance Level	No value reports for this field in the SMSC Extract.	N/A
Math Grouping Indicator 1	No value reports for this field in the SMSC Extract.	N/A
Math Grouping Indicator 2	No value reports for this field in the SMSC Extract.	N/A
English Language Arts - ELA Grouping Indicator 1	No value reports for this field in the SMSC Extract.	N/A
English Language Arts - ELA Grouping Indicator 2	No value reports for this field in the SMSC Extract.	N/A
Science Grouping Indicator 1	No value reports for this field in the SMSC Extract.	N/A
Science Grouping Indicator 2	No value reports for this field in the SMSC Extract.	N/A
Comprehensive Agriculture Grouping Indicator	No value reports for this field in the SMSC Extract.	N/A
Animal Systems Grouping Indicator	No value reports for this field in the SMSC Extract.	N/A
Plant Systems Grouping Indicator	No value reports for this field in the SMCS Extract.	N/A
KELPA2 Grouping Indicator 1	No value reports for this field in the SMSC Extract.	N/A
KELPA2 Grouping Indicator 2	No value reports for this field in the SMSC Extract.	N/A
State Math Assessment Type	No value reports for this field in the SMSC Extract.	N/A
State English Language Arts - ELA Assessment Type	No value reports for this field in the SMSC Extract.	N/A
State Science Assessment Type	No value reports for this field in the SMSC Extract.	N/A
State History/Government Assessment Type	No value reports for this field in the SMSC Extract.	N/A
History/Gov Claim/Thesis Score	No value reports for this field in the SMSC Extract.	N/A
History/Gov Evidence Score	No value reports for this field in the SMSC Extract.	N/A
History/Gov Reasoning Score	No value reports for this field in the SMSC Extract.	N/A
Comprehensive Agriculture Assessment	No value reports for this field in the SMSC Extract.	N/A
Animal Systems Assessment	No value reports for this field in the SMSC Extract.	N/A
Plant Systems Assessment	No value reports for this field in the SMSC Extract.	N/A
Kansas English Language Proficiency Assessment (KELPA)	No value reports for this field in the SMSC Extract.	N/A
KELPA Proctor ID	No value reports for this field in the SMSC Extract.	N/A
KELPA Proctor First Name	No value reports for this field in the SMSC Extract.	N/A
KELPA Proctor Last Name	No value reports for this field in the SMSC Extract.	N/A
Individual Plan of Study	No value reports for this field in the SMSC Extract.	N/A
User Field 1	N/A	N/A
User Field 2	N/A	N/A
User Field 3	N/A	N/A

KIDS SMSC Extract (Kansas) [.2335 and previous]

Report Logic

Generate the Report

Report Layout

Related Articles