Tool Search: Collection Extract
The Kansas Individual Data on Students Collection Extracts report student data for eight extracts that share the same reporting elements. The following is a list of the extracts and the current submission windows.
KIDS Collection Extract
Read - Access and generate the KIDS Collection Extract.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
There are nine collection extracts available. Click to expand the table below for a description of each one.
Report Logic
Students are included in the Collection Extracts based on the selections in the extract editor. Students who are enrolled within a selected calendar and have an enrollment start or end date within the filter date range entered on the report editor report if they are also included in any Ad hoc filter or grade selected on the editor.
Fields not collected for a particular extract and fields where there is no data to populate (Suffix field, for example) report blank values, unless otherwise noted. The fields are still included in the output format.
Students are not included when (unless otherwise noted):
- Their enrollment record is marked as State Exclude or No Show.
- The grade level of enrollment is marked as State Exclude.
- The calendar of enrollment is marked as State Exclude.
Report Logic for a Specific Collection
ENRL
TEST
SMSC
MILT
EOYA
ASGT
EXIT
QERY
SPED
No additional logic
Data Filter From and To Dates
Attendance Filter To Date
This date field displays on the EOYA and EXIT extracts. In response to COVID-19, when this field is populated:
- Membership Days (field 22) reports attendance up to and including the entered date.
- Attended Days (field 23) reports attendance up to and including the entered date.
- Truant Student (field 24) reports attendance days up to and including the entered date (EOYA Extract only).
Truant
The following definition is used for defining a student as truant:
- Three consecutive full days (based on the student's schedule) of unexcused absences (status of A, Excuse of U)
- Five full days (based on their schedule) in a semester of unexcused absences (status of A, Excuse of U)
- Seven full days (based on their schedule) in a year of unexcused absences (status of A, Excuse of U)
The calculation is based on the following:
- 100% of the scheduled class periods in an institutional day for any individual student are marked as an unexcused absence.
- Includes partial day absence days where the total absent minutes are greater than or equal to the minutes indicated in the Whole Day Absence minutes field for a given student on a given instructional day.
Grade Level
The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.
School Entry Date, District Date, State Entry Date
Attendance Days
When generating the SMSC Extract, these values are determined by the Data Filtered From Date and Data Filtered To Date values entered on the Extract Editor.
Full Day Attendance
Membership days minus absent days on a day by day basis.
- Attended days calculate all minutes in a period. If a student is marked absent for the entire period, those minutes are subtracted from Attended Days.
- If a student is scheduled for multiple courses during the same period, the period length is used and not the total minutes of all classes to determine attendance.
- Attendance is based off the time the student was in school compared to the time the student was scheduled to be in school.
- Half-day kindergarten student's time is not divided by two.
- Cannot be greater than 366.
Partial Day Attendance
Partial Day attendance is calculated by dividing the total daily instructional minutes by all possible daily instructional minutes, leaving the fractional remainder of the AttendedDays to correctly reflect the partial attendance.
- Kindergarten students who are partial day calculate based on the half day attendance period that constitutes an entire attendance day.
- The most recent active primary enrollment is used to calculate attendedDays and membershipDays.
- Each day is counted once.
Minutes Enrolled
The minutes do not include the lunch period or transition time to and from lunch. Passing periods that are between classes a student attends can be counted. The entry can be zero for the September 20 snapshot in cases where the student attends a public school but does not qualify to be counted for funding purposes.
Schools and districts enter minutes. To compute FTE, KSDE divides this number by 360, except for those students who are also enrolled in an area vocational technical school or other postsecondary institution. The number of minutes for dual enrolled students is divided by 300 for FTE purposes. In cases where the number of minutes enrolled per day varies or the student does not attend school 5 days a week, sum all minutes for a normal 5-day week and divide by 5.
ESOL Participation
Logic looks at the Service Type of the student's EL Services record(s) and reports a value (in ESOL Participation field) as follows:
Report Editor
The following options are the available options on the KIDS Collection Extract Editor.
Field | Description |
|---|---|
Extract Type | Selection indicates the extract that generates. |
Data Filter From Date | Students are included in the report if they have an entry date or an exit date on or before the date entered in this field. The default entry is blank. Dates are entered in MMDDYY format, or use the calendar icon to select a date. See the Report Logic section for specific information on this field. |
Data Filter To Date | Students are included in the report if they have an entry date or an exit date on or after the date entered in this field. This field auto-populates to the current date. Dates are entered in MMDDYY format, or use the calendar icon to select a date. See the Report Logic section for specific information on this field. |
| Attendance Filter To Date | This field displays on the EOYA Extract. This field is used to manage COVID-19 attendance changes. When populated, Membership Days, Attended Days and Truant Student totals are calculated up to and including the entered date. |
Assessment Disaggregation Method 1 and 2 | Selection is only needed when generating the TEST Extract. The extract contain a series of grouping indicator selections that when chosen on the report editor populates appropriate fields if the following criteria is met:
|
Students without State IDs | When marked, students assigned a state ID number are not included in the report. This option only returns students who do not have a state ID number. |
Social Security Number Optional | When marked, the last four digits of the student's Social Security number is not displayed. If not marked, the last four digits of the Social Security number are displayed. |
Ad hoc Filter | A selection in this field causes the extracts to only include students included in the Ad hoc filter. For example, if an Ad hoc filter is selected that lists all 9th grade students, only those students are included in the extract. |
File Revision Number | This is required for state submissions. The state only accepts a file name once, so the file name needs to be updated if submitting it more than one time. |
Select Grades by State Code (TEST Only) | Used only for the TEST extract, select the grade levels to include on the extract. |
Format | The KIDS Collection Extracts can be generated in the following ways. Use the State Format when submitting information to the DOE. Use the other formats for data review and testing.
|
Records Limit Per File (State Format only) | When the State Format (tab delimited) format option is selected, files are within a series of tab delimited files within a .zip file if the numeric value entered in this field is LESS than the number of records that are being exported. |
| Calendar Selection | At least one calendar needs to be selected in order to generate the Collection Extracts. Multiple calendars can be selected by using the CTRL and SHIFT keys. |
Sample Report Formats
The following images provide a baseline for how the extracts display in selected formats.
KIDS Collection - HTML Format
KIDS Collection - CSV Format
KIDS Collection - State Format (tab delimited)
KIDS Collection - XML Format
Default Values
The following fields are assigned default values when they report in the selected extract type but the field where the data is stored isn't populated.
Report Layout
The following defines the Report Headers and Report Footers used in the KIDS Collection Extracts. Layouts for each individual extract are available for that specific extract.
Report Header
Element | Description |
|---|---|
Record Type | 2 bytes, must contain the characters TH |
Extract Date | 10 bytes, date the export file was created; MM/DD/YY format |
Extract Time | 8 bytes, time export file was created; HH:MM:SS format |
Transmission ID | 10 bytes, must match the Transmission ID field in the Footer Record |
Version | 10 bytes, always 19.0 |
Delimiter Character | 25 bytes, 0X09 |
Report Elements
Data Element | Description | Collection | Location | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Record Type | Type of extract being generated, chosen on the Report Editor. Alphanumeric, 4 characters | All | Data not stored | |||||||||||||||||||||||||||
Accountability School Identifier | Indicates the school number of the student's enrollment. Alphanumeric, 4 characters | All | School Information > School Detail > State School Number School.number | |||||||||||||||||||||||||||
Resident District | District number where student resides (but not necessarily attends). When Home District field is blank, data reports from the State District Number field. Alphanumeric, 5 characters | All | Enrollments > State Reporting Fields > Home District Enrollment.residentDistrict District Information > District Info > State District Number District.number | |||||||||||||||||||||||||||
Legal Last Name | Reports the legal last name of the student. When the Legal Last Name field is populated, information reports from that field. Alphanumeric, 60 characters | All | Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName Demographics > Person Information > Last Name Identity.lastName | |||||||||||||||||||||||||||
Legal First Name | Reports the legal first name of the student. When the Legal First Name field is populated, information reports from that field. Alphanumeric, 60 characters | All | Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName Demographics > Person Information > First Name Identity.firstName | |||||||||||||||||||||||||||
Legal Middle Name | Middle name or middle initial of the student. When only the middle initial is available, that initial reports. When no middle name or initial is available for the student, this field reports blank. When the Legal Middle Name field is populated, information reports from that field. Alphanumeric, 60 characters | All | Identities > Identity Information > Protected Identity Information > Legal Middle Name Identity.legalMiddleName Demographics > Person Information > Middle Name Identity.middleName | |||||||||||||||||||||||||||
Suffix | Indicates student's name is generational (Jr., III, etc.). When the Legal Suffix field is populated, information reports from that field. Alphanumeric, 10 characters | All | Identities > Identity Information > Protected Identity Information > Legal Suffix Identity.legalSuffix Demographics > Person Information > Suffix Identity.suffix | |||||||||||||||||||||||||||
Gender | Indication of student being either male or female. When the Legal Gender field is populated, information reports from that field. Numeric, 1 digit (0 = Female, 1 = Male) | All | Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender Demographics > Person Information > Gender Identity.gender | |||||||||||||||||||||||||||
Date of Birth | Date on which student was born. Date field, 10 characters (MM/DD/YYYY) | All | 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. 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 | All | Enrollments > General Enrollment Information > Grade Enrollment.grade | |||||||||||||||||||||||||||
Student Identifier | Unique identifier assigned to the student by the school and/or district. Alphanumeric, 20 characters | All | Demographics > Person Identifiers > Student Number Person.studentNumber | |||||||||||||||||||||||||||
Hispanic Ethnicity | Indication of student being of Hispanic/Latino ethnicity. When yes, reports Y; when No, reports N. Alphanumeric, 1 character | All | Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.hispanicLatino | |||||||||||||||||||||||||||
State Student Identifier | Student's state identification number. Numeric, 10 digits | All | Demographics > Person Identifiers > State ID Person.stateID | |||||||||||||||||||||||||||
School Year | The ending year of the current school year. When reporting for the 2022-23 school year, this reports as 2023. Numeric, 4 digits | All | Calendar Information > End Date Calendar.year | |||||||||||||||||||||||||||
Funding School | Override field for the school that receives funding for the student. Alphanumeric, 4 characters | All | School Information > School Editor > State School Number 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 they take the state assessments. Numeric, 4 digits | All | Enrollments > State Reporting Fields > Attendance School EnrollmentKS.attendanceSchool | |||||||||||||||||||||||||||
Virtual Education Student | Indication of student taking classes virtually. Options are:
When no value is selected, a blank value reports. Numeric, 1 character | ENRL MILT EOYA | Enrollments > State Reporting Fields > Virtual Education Student EnrollmentKS.virtualeducation | |||||||||||||||||||||||||||
School Entry Date | Reports the student's start date of enrollment at the school. When this Entry into School field is blank on the enrollment record, the pre-determined Override logic is used. Date field, 10 characters (MM/DD/YYYY) | ASGT ENRL TEST EOYA SMSC MILT EXIT SPED | Enrollments > State Reporting Fields > Entry into School EnrollmentKS.schoolDate | |||||||||||||||||||||||||||
District Entry Date | Reports the student's first date of entry at the district. When the Entry into District field is blank on the enrollment record, the pre-determined Override logic is used. Date field, 10 characters (MM/DD/YYYY) | ASGT ENRL TEST EOYA SMSC MILT EXIT SPED | 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. When this Entry into State field is blank, the pre-determined Override logic is used. Date field, 10 characters (MM/DD/YYYY) | ASGT ENRL TEST EOYA SMSC MILT EXIT SPED | Enrollments > State Reporting Fields > Entry into State EnrollmentKS.stateDate | |||||||||||||||||||||||||||
| First Instructional Date | Reports the first day (month, day and year) the student receives instructional services during the school year. A value reports when the student meets the following criteria (at least one of these is true):
This reports the first day marked for instruction and attendance from the Calendar in which the student is enrolled.
When the school is marked as School Wide in the Title 1 field on the School Editor, all students within the school report their First Instruction Date. Otherwise, a blank value reports. | EOYA SMSC EXIT | Enrollment > General Enrollment Information > Start Date Enrollment.startDate Program Participation > Gifted > Start Date Gifted.startDate State Reporting > Start Date SpecialEDState.startDate Day Setup > Attendance | |||||||||||||||||||||||||||
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. Dates are calculated for ALL enrollments in the selected calendar. 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. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, student membership days are calculated up to and including the entered date. Numeric, 5 digits (XXX.X) | EOYA SMSC EXIT | Data not stored | |||||||||||||||||||||||||||
Attended Days | Calculated field. See the Report Logic section for details on the attendance calculations. The number of days the student has been present in this school when school was in session during the current school year. Dates are calculated for ALL enrollments in the selected calendar. For kindergarten students, partial day attendance is based on the half day attendance period that constitutes an entire attendance day. Part-time students are marked as a full day of attendance if they were present for all of their scheduled time of education. If the student's most recent enrollment has an End Status of 18, a value of 0 reports. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, student attended days are calculated up to and including the entered date. Numeric, 5 digits (XXX.X) | EOYA SMSC EXIT | Data not stored | |||||||||||||||||||||||||||
Truant Student | This field reports as Yes or No, indicating whether a student has met the state definition of truant at any point during the year. See the Truant Student Calculation section for additional information. When no value is selected, a default value of zero (0) reports. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, truant days are calculated up to and including the entered date. Alphanumeric, 1 character | EOYA | Data not stored | |||||||||||||||||||||||||||
Minutes Enrolled | Total number of instructional minutes for which the student is enrolled.
When no values are selected, the default value of zero (0) reports. Numeric, 3 digits | ENRL MILT | Enrollments > State Reporting Fields > Enrolled Minutes Override Enrollment.minutesEnrolled Enrollments > State Reporting Fields > Sept 20th Rule Enrollment.sept20Rule | |||||||||||||||||||||||||||
Concurrent HS Enrollment | Indicates the student is enrolled in multiple accredited programs. The Current Grade Level field must be 15-18 or 14 when the student has an active Gifted record. When no value is selected, a default value of zero (0) reports. Numeric, 1 digit | ENRL MILT | Enrollment > State Reporting Fields > Concurrent Enrollment EnrollmentKS.concurrentEnrollment Gifted > Start Date Gifted.startDate | |||||||||||||||||||||||||||
Exit Withdrawal Date | Date student exited the school. Date field, 10 characters (MM/DD/YYYY) | EXIT | Enrollment > General Enrollment Information > End Date Enrollment.endDate | |||||||||||||||||||||||||||
Exit Withdrawal Type | Reason student ended enrollment. Numeric, 2 digits | EXIT | Enrollment > General Enrollment Information > End Status Enrollment.endstatus | |||||||||||||||||||||||||||
| Unweighted Grade Point Average | Reports the student's unweighted GPA upon graduating from high school with a regular high school diploma. This only reports for students who report a value of 8 in the Exit/Withdrawal Type field. Reports the unweighted GPA (0.00 - 4.00) from the Transcript. If there is no unweighted GPA, this field reports blank. If the GPA is over 4.00, reports a value of 4.00. Numeric, 3 digits (X.XX) | EXIT | Transcript | |||||||||||||||||||||||||||
| High School Credits Earned | Reports the total number of completed credits earned toward high school graduation. This is a required field for students enrolled in a state grade level of 14, 15, 16, or 17 during the effective date range. Students must be assigned a Graduation Program and dates must overlap with the reporting enrollment. Numeric, 4 digits (XX.XX) | ENRL EXIT | Transcript > Credits Earned TranscriptCredit.creditsEarned Graduation Program Setup > Category > Graduation Program.programCategory Programs > Program Program.name | |||||||||||||||||||||||||||
| High School Credits Required to Graduation | Reports the total number of completed credits required for High School graduation. This is a required field for students enrolled in a state grade level of 14, 15, 16, or 17 during the effective date range. Students must be assigned a Graduation Program and dates must overlap with the reporting enrollment. Numeric, 4 digits (XX.XX) | ENRL EXIT | Transcript > Credits Earned TranscriptCredit.creditsEarned Graduation Program Setup > Category > Graduation Program.programCategory Programs > Program Program.name | |||||||||||||||||||||||||||
| Dropout Diploma Completion Virtual Student | An indicator that the student has been identified as a Dropout Diploma Completion Virtual Student. When the student is enrolled in state grade levels of 14, 15, 16 or 17 during the effective date range AND the student is 19 years of age or younger as of the September 20 date, the Dropout Indicator value on the Enrollment record reports. Otherwise, a value of zero (0) reports. When the student is enrolled in a state grade level that is NOT 14, 15, 16 or 17, a NULL (blank) value reports. Numeric, 1 digit | ENRL EOYA | Enrollments > Dropout Indicator Enrollment.dropoutCode Demographics > Birth Date Identity.birthDate | |||||||||||||||||||||||||||
Special Circumstance Transfer Choice | This field indicates the circumstances of the student's transfer out of the district. See the Kansas Enrollment article for a list of options. When no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | EOYA | Enrollment > State Reporting Fields > Special Transfer EnrollmentKS.endType | |||||||||||||||||||||||||||
Comprehensive Race | Indicates the student's race/ethnicity.
Numeric, 6 characters | All | Demographics > Person Information > Federal Race Identity.raceEthnicity | |||||||||||||||||||||||||||
Lunch Program | Indicates student meets requirements for free and reduced meals. A numeric value of 1-4 reports, based on the student's FRAM record dates being within the reporting period and the State Eligibility Code selection.
When no value is selected or there is no FRAM record, a value of zero (0: Not Eligible) reports. Numeric, 1 digit | ENRL TEST EOYA MILT EXIT | Eligibility Fram.eligibility | |||||||||||||||||||||||||||
Primary Disability Indicator | Indicates student's primary disability. When a student has an active Special Education State Reporting record OR an active IEP, a value of WD reports. Otherwise, a value of ND reports. An active Special Education State Reporting record is calculated as follows:
SPED State Reporting records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated. An active IEP record is calculated as follows:
When there is more than one SPED record in a given year for a student, the most recent record that overlaps the dates entered on the extract editor reports. Alphanumeric, 2 characters | ASGT ENRL TEST EOYA MILT EXIT SPED | State Reporting > Disability SpecialEDState.primaryDisability State Reporting > Start Date, End Date SpecialEDState.startDate SpecialEDState.endDate Documents > IEP > Start Date, End Date Plan.startDate Plan.endDate | |||||||||||||||||||||||||||
Gifted Student Indicator | Indicates whether student is considered gifted/talented. When the student has an active Gifted record, a value of GI reports. Otherwise, a blank value reports. Gifted records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated. An active Gifted record is calculated as follows:
Alphanumeric, 2 characters | ASGT ENRL TEST EOYA MILT EXIT SPED | Gifted > Start Date, End Date Gifted.startDate Gifted.endDate | |||||||||||||||||||||||||||
Section 504 | Indicates whether student is qualified for Section 504 services. Logic reports in the following order:
When the From Date on the Extract Editor is blank, logic uses July 1 and the start year of the selected calendar. When a student's status changes between the last day of school and June 30, schools can choose to report the student's status as of June 30. Numeric, 1 digit | EOYA | Section 504 > Start Date, End Date Section504.startDate Sectin504.endDate | |||||||||||||||||||||||||||
Residence of Homeless | Indicates the student meets the federal guidelines of being homeless. When a student has a homeless record with a start date that is BEFORE the Extract Editor To Date and the End Date is blank or AFTER the calendar start date, the following reports:
Numeric, 1 digit | ENRL EOYA EXIT TEST MILT | Homeless > Start Date, End Date, Primary Nighttime Residence, Unaccompanied Youth Homeless.startDate Homeless.endDate Homeless.primaryNightTimeResidence Homeless.unaccompaniedYouth | |||||||||||||||||||||||||||
| K-12 Kansas At-Risk Program Participation | Reports whether the student is enrolled in a K-12 At-Risk Program.
| All | At-Risk Program > Program Status AtRisk.programStatus | |||||||||||||||||||||||||||
ESOL/Bilingual Program Entry Date | Start date of student's participation in ESOL programming. When the ESOL Participation field reports a value of 0, this field does not report. Date field, 10 characters (MM/DD/YYYY) | ENRL TEST EOYA MILT | English Learners (EL) > Identified Date EnrollmentKS.ESOLentryDate lep.Identifieddate | |||||||||||||||||||||||||||
First Entry Date into a school in the US | Date of first enrollment into a school in the United States. This date ONLY reports when the ESOL Participation value for the student is 1-8 and the Date Entered US School is not blank. When a Participation code is selected and no date is in the Date Entered US School field, the report auto-generates a date of 01/01/1900 to make it easier to find these students Date field, 10 characters (MM/DD/YYYY) | ENRL TEST EOYA MILT | Demographics > Person Information > Date Entered US Identity.DateEnteredUSSchool | |||||||||||||||||||||||||||
First Language | This is required for all students.
When no value is selected, a value of ENG reports. Alphanumeric, 3 characters | ENRL TEST EOYA MILT | Demographics > Person Information > Home Primary Language Identity.HomePrimaryLanguage | |||||||||||||||||||||||||||
ESOL/Bilingual Participation Code | Indicates the status of the student's ESOL Participation. See the ESOL Participation section for reporting logic. When no value is selected, a default value zero (0) reports. Alphanumeric, 1 character | ASGT ENRL TEST EOYA MILT EXIT SPED | English Learners (EL) > EL Services > Service Types LepServiceType.code | |||||||||||||||||||||||||||
| Language Instruction Education Program Type | Reports the student's EL Service Type with a value of 01-08. When the ESOL/Bilingual Program Participation Code is 1, 2, 3, 6, 7 or 8 inclusive, the EL Service Type reports when the service falls within the start and end date entered on the extract editor. When there is more than one service type that falls within the start and end date range, the service type with the highest number of ESOL Contact Minutes per day reports. When there are multiple EL Services with the same number of ESOL Contact Minutes per day, the servie type with the highest LEP Service ID reports. When the ESOL/Bilingual Program Participation Code is NOT between 01 and08 inclusive, this field reports a value of 00. Numeric, 2 digits | ENRL | English Learners (EL) > EL Services > Service Types LepServiceType.code | |||||||||||||||||||||||||||
ESOL/Bilingual Student Contact Minutes | Total of minutes taught by a teacher with or working on ESOL endorsement to be approved. Reports when the reported value for ESOL/Bilingual Participation Code is one of the following:
When service minutes are not null and greater than zero, and the Parent Refused checkbox is not marked:
Numeric, 3 digits | ENRL MILT | English Learners (EL) > EL Services > ESOL Contact Minutes LepService.serviceMinutes | |||||||||||||||||||||||||||
Career Tech Ed Contact Minutes | Reports the number of minutes students in grades 9-12 and not graded secondary students received instruction in a state funding approved career and technical education course. This value reports from the Tech Ed Minutes Override field that is populated on the enrollment record. CTE courses are defined by the College/Career Type field on the Course editor being set to F. Use the CTE Minutes Calculation Tool to automatically populate the Tech Ed Minutes Override field on the Enrollment Record. Numeric, 3 digits | ENRL MILT | Enrollments > State Reporting Fields > Tech Ed Minutes Override EnrollmentKS.vocationalMinutes | |||||||||||||||||||||||||||
Title 1 Participation | Indicates the student's Title 1 Participation Status. Options are:
When no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | EOYA | Enrollments > State Reporting Fields > Title 1 Enrollment.title1 | |||||||||||||||||||||||||||
Miles Transported | Number of miles student is transported at district expense. Numeric, 4 digits (XXXX, XX.XX, XXX.X, X.XXX) | ENRL MILT | Transportation > Miles Transported Transportation.milesTransported | |||||||||||||||||||||||||||
Transportation FTE | Total round trip miles the student is transported to the school. This only reports when the Transported at District Expense checkbox on the Transportation editor is selected. Numeric, 3 digits | ENRL MILT | Transportation > FTE Transportation.FTE | |||||||||||||||||||||||||||
Student's Street Address | Reports the student's primary physical street address. Only alphabetic characters A-Z, numeric digits 0-9, hyphens (-), slashes (/), periods (.), and number/pound symbols (#) are allowed. All other characters are removed. The student's Primary Household reports. When the student has multiple primary addresses, the address with the earliest start date that is still active (no end date entered) reports. P.O. Boxes do not report. This reports for ALL students, whether or not they have a Transportation record. When ALL address information is blank, a blank value reports. Alphanumeric, 30 characters | ENRL MILT | Summary > Mailing Address > Primary Address Address.number | |||||||||||||||||||||||||||
Student's City | City in which the student's primary physical address is located. This reports for ALL students, whether or not they have a Transportation record. The student's Primary Household reports. If the student has multiple primary addresses, the address with the earliest start date that is still active (no end date entered) reports. P.O. Boxes do not report. When ALL address information is blank, a blank value reports. Alphanumeric, 20 characters | ENRL MILT | Summary > Mailing Address > Primary Address Address.city | |||||||||||||||||||||||||||
Student's Zip Code | Zip code associated with the student's physical street address. This reports for ALL students, whether or not they have a Transportation record. When ALL address information is blank, a blank value reports. Alphanumeric, 10 characters | ENRL MILT | Summary > Mailing Address > Primary Address Address.zip | |||||||||||||||||||||||||||
Non-Resident Transportation | An indication that the student is attending the district under an agreement by the district under KSA 72-1046b (over 10 mile law). When no value is selected, a default value zero (0) reports. Numeric, 1 character | ENRL MILT | Transportation > Transported at District Expense/10 Mile Law Transportation.tenMileLaw | |||||||||||||||||||||||||||
Military Connected Student Indicator | Indicates whether the student is the child of a parent who is in the military. When no value is selected, a default value zero (0) reports. Alphanumeric, 1 character | MILT ENRL EXIT EOYA TEST | Enrollments > State Reporting Fields > Child of Military Family EnrollmentKS.militaryFamily | |||||||||||||||||||||||||||
Immigrant Student | Indicates whether or not a student is an immigrant student and when they are receiving Title III services. Options are:
When a value is selected for the Immigrant Student field on the Enrollment record, that value reports. When there is a not a value selected for Immigrant Student, the Birth Country field is used:
When no value is selected, a default value zero (0) reports. Alphanumeric, 1 character | ENRL EOYA MILT | Enrollments > State Reporting Fields > Immigrant Student EnrollmentKS.immigrant | |||||||||||||||||||||||||||
Country of Birth | Country in which student was born. Alphanumeric, 30 characters | ENRL EOYA MILT | Demographics > Person Information > Birth Country Identity.birthCountry | |||||||||||||||||||||||||||
Neglected Student | A flag that identifies a neglected student who was served under Title I Part A funds at some time during the year. Students who were not served with these funds should have a blank in this field. When no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | EOYA EXIT | Enrollments > State Reporting Fields > Neglected Student EnrollmentKS.neglectedDelinquent | |||||||||||||||||||||||||||
| Preschool-Aged At-Risk Program Participation | Reports whether the student is enrolled in a Preschool-Aged At-Risk Program. Reports a value of 0 when the state grade mapping is one of the following:
Numeric, 1 digit | All | At-Risk Program > Program Status AtRisk.programStatus Grade Level Setup > State Grade Level Code GradeLevel.stateGrade | |||||||||||||||||||||||||||
| Kansas Preschool Program (KPP) | Reports whether the student enrolled in grades 01, 02, 33 and 04 was an Early Learning Participant. When an Early Learning record exists that was active at any time with the student's enrollment from the selected calendar AND the Early Learning Participant (KS PreK Pilot Program) checkbox was marked, a value of 1 reports. When there is no Early Learning record or the Early Learning Participant (KS PreK Pilot Program) is not marked, a value of 0 reports. An Early Learning record is considered active when the start date is before the student's enrollment end date and the end date is either blank or after the student's enrollment start date. When the student's enrollment end date is blank, the selected calendar's end date is used. Numeric, 1 digit | All | Early Learning > KS PreK Pilot Program EarlyLearning.EarlyLearningParticipant | |||||||||||||||||||||||||||
| Kansas Parents as Teachers Participant (KPAT) | Reports whether the student enrolled in grades 00, 01, 02, 33 and 04 was a Parents as Teachers Participant. When an Early Learning record exists that was active at any time with the student's enrollment from the selected calendar AND the Parents as Teachers checkbox was marked, a value of 1 reports. When there is no Early Learning record or the Parents as Teachers checkbox is not marked, a value of 0 reports. Otherwise, this field reports blank. An Early Learning record is considered active when the start date is before the student's enrollment end date and the end date is either blank or after the student's enrollment start date. When the student's enrollment end date is blank, the selected calendar's end date is used. Numeric, 1 digit | ENRL EOYA | Early Learning > Parents as Teachers EarlyLearning.ParentsAsTeachers | |||||||||||||||||||||||||||
| Dyslexia Screener | For students in grades 05, 06, 07, 08 and 13, the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. When there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | EOYA | Dyslexia > Dyslexia Screener | |||||||||||||||||||||||||||
| Dyslexia Subtest | For students in grades 05, 06, 07, 08 and 13, the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. When there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | EOYA | Dyslexia > Dyslexia Subtest | |||||||||||||||||||||||||||
| Dyslexia Spring Benchmark Performance Level | For students in grades 05, 06, 07, 08 or 13, and the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. When there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | EOYA | Dyslexia > Dyslexia Performance Level | |||||||||||||||||||||||||||
Math Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Math. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Math Course.kidsSubject | |||||||||||||||||||||||||||
Math Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Math. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Math Course.kidsSubject | |||||||||||||||||||||||||||
English Language Arts - ELA Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor.
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for ELA. | TEST | Course Information > KIDS Subject > ELA Course.kidsSubject | |||||||||||||||||||||||||||
English Language Arts - ELA Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor.
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for ELA. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > ELA Course.kidsSubject | |||||||||||||||||||||||||||
Science Grouping | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Science. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Science Course.kidsSubject | |||||||||||||||||||||||||||
Science Grouping | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Science. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Science Course.kidsSubject | |||||||||||||||||||||||||||
| Comprehensive Agriculture Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Agriculture. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > General > Agriculture | |||||||||||||||||||||||||||
| Animal Systems Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Animal Systems. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > General > Animal Systems | |||||||||||||||||||||||||||
| Plant Systems Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Plant Systems. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > General > Plant Systems | |||||||||||||||||||||||||||
| KELPA2 Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Pathways. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Pathways Course.kidsSubject | |||||||||||||||||||||||||||
| KELPA2 Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Pathways. Alphanumeric, 50 characters | TEST | Course Information > KIDS Subject > Pathways Course.kidsSubject | |||||||||||||||||||||||||||
| State Mathematics Assessment Type | Reports the assigned Math Assessment Type value from the student's enrollment record. Values report for students in grades 08-12, 13 and 15 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > Math Assessment Type EnrollmentKS.mathAssessmentType | |||||||||||||||||||||||||||
| State English Language Arts - ELA Assessment | Reports the assigned ELA Assessment Type value from the student's enrollment record. Values report for students in grades 08-12, 13 and 15 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > ELA Assessment Type EnrollmentKS.readingAssessmentType | |||||||||||||||||||||||||||
| State Science Assessment Type | Reports the assigned Science Assessment Type value from the student's enrollment record. Values report for students in grades 10, 13 and 16 only. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > Science Assessment Type EnrollmentKS.scienceAssessmentType | |||||||||||||||||||||||||||
| History/Gov Claim/Thesis Score | Reports the performance level the student achieved for the Recognize and Evaluate Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | EOYA | Assessment > Result | |||||||||||||||||||||||||||
| History/Gov Evidence Score | Reports the performance level the student achieved for the Analyze Context and Draw Conclusions Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | EOYA | Assessment > Result | |||||||||||||||||||||||||||
| History/Gov Reasoning Score | Reports the performance level the student achieved for the Research and Make Connections Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | EOYA | Assessment > Result | |||||||||||||||||||||||||||
| Comprehensive Agriculture Assessment | Reports the assigned Comprehensive Agriculture Assessment Type value from the student's enrollment record. Values report for students in grades 15-17 only. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > General Comprehensive Agriculture Assessment | |||||||||||||||||||||||||||
| Animal Systems Assessment | Reports the assigned Animal Systems Assessment Type value from the student's enrollment record. Values report for students in grades 15-17 only. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > General Animal Systems Assessment | |||||||||||||||||||||||||||
| Plant Systems Assessment | Reports the assigned Plant Systems Assessment Type value from the student's enrollment record. Values report for students in grades 15-17 only. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > General Plant Systems Assessment | |||||||||||||||||||||||||||
| Kansas English Language Proficiency Assessment (KELPA) | Reports the assigned KELPA Exam value from the student's enrollment record. Values report for students in grades 05-17 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | TEST | Enrollments > State Reporting Fields > KELPA Exam EnrollmentKS.KelpaExam | |||||||||||||||||||||||||||
| KELPA Proctor ID | Reports the state staff ID of the staff person administering the ELPA exam. | TEST | Demographics > Person Identifiers > State StaffID | |||||||||||||||||||||||||||
| KELPA Proctor First Name | Reports the first name of the staff person administering the ELPA exam. | TEST | Demographics > Person Information > First Name Identity.firstName Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName | |||||||||||||||||||||||||||
| KELPA Proctor Last Name | Reports the last name of the staff person administration the ELPA exam. | TEST | Demographics > Person Information > Last Name Identity.lastName Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName | |||||||||||||||||||||||||||
| Individual Plan of Study | Reports whether the student has an IPS Plan when the student is in grades 11-17.
Otherwise, a blank value reports. Numeric, 1 digit | EOYA | Individual Plan of Student > Start Date PlanofStudy.startDate | |||||||||||||||||||||||||||
| User Field 1 | This field does not report data. | N/A | ||||||||||||||||||||||||||||
| User Field 2 | This field does not report data. | N/A | ||||||||||||||||||||||||||||
| User Field 3 | This field does not report data. | N/A |
Report Footer
Element | Description |
|---|---|
Record Type | 2 bytes, must contain the characters TT |
Transmission ID | 10 bytes, must match the Transmission ID field in the Header Record |
Number of Record | 10 bytes, number of records including header and footer records |
