Spreadsheet: 2482af93-075f-41ee-8ba0-7620b9f91232
Sheet: Sheet1

Field Number | Excel Column | KIDS Collection Field Requirements by Record Type 2013-14 | ASGT | ENRL | [NAME] | MILT | TEST | EOYA | EXIT | QERY w/ID | QERY w/o ID
D1 | A | Record Type | R | R | R | R | R | R | R | R | R
D2 | B | Accountability School Identifier | R | R | R | R | R | R | R | O | R
D3 | C | Residence District Identifier | R | R | R | R | R | R | R | O | O
D4 | D | Legal Last Name | R | R | R | R | R | R | R | O | R
D5 | E | Legal First Name | R | R | R | R | R | R | R | O | O
D6 | F | Legal Middle Name | O | O | O | O | O | O | O | O | O
D7 | G | Generation Code | O | O | O | O | O | O | O | O | O
D8 | H | Gender | R | R | R | R | R | R | R | O | O
D9 | I | Date of Birth | R | R | R | R | R | R | R | O | O
D10 | J | Current Grade Level | R | R | R | R | R | R | R | O | O
D11 | K | Local Student Identifier | R | R | R | R | R | R | R | O | O
D12 | L | Hispanic Ethnicity | R | R | R | R | R | R | R | O | O
D13 | M | State Student Identifier | O | O | R | O | R | R | R | R
D14 | N | Current School Year | R | R | R | R | R | R | R | O | O
D15 | O | Funding School Identifier | R | R | R | R | R | R | R | O | O
D16 | P | Attendance School/Program Identifier | R | R | R | R | R | R | R | O | O
D17 | Q | Virtual Education Student |  | X |  | X |  | X
D18 | R | School Entry Date | O | R | R | R | R | R | R
[NAME] | S | District Entry Date | O | R | R | R | R | R | O
D20 | T | State Entry Date | O | R | R | R | R | R | O
D21 | U | Cumulative Number of Days in Membership |  |  | R |  |  | R
D22 | V | Cumulative Number of Days  Attended |  |  | X |  |  | X
D23 | W | Truant Student |  |  |  |  |  | X
[NAME] | X | Minutes Enrolled |  | R |  | R
D25 | Y | Concurrent High School Enrollment |  | X |  | X
D26 | Z | Exit/Withdrawal Date |  |  |  |  |  |  | R
D27 | AA | Exit/Withdrawal Type |  |  |  |  |  |  | R
D28 | AB | Special Circumstances Transfer Choice |  |  |  |  |  | X
D29 | AC | Post-Graduation Plans |  |  |  |  |  |  | R
D30 | AD | Comprehensive Race | R | R | R | R | R | R | R | O | O
[NAME] | AE | Eligibility for National School Lunch Program |  | X |  | X | X | X | X
D32 | AF | Primary Disability Code | X | X |  | X | X | X | X
D33 | AG | Gifted Student Code | X | X |  | X | X | X | X
D34 | AH | Qualified for 504 |  |  |  |  |  | X
D35 | AI | Residence of  Homeless Student while Homeless |  | R |  |  |  | R | R
[NAME] | AJ | ESOL /Bilingual  Program Entry Date |  | X |  | X | X | X
D37 | AK | First Entry Date into a School in the United States |  | X |  | X | X | X
D38 | AL | First Language |  | X |  | X | X | X
D39 | AM | ESOL/Bilingual Program Participation Code | X | X |  | X | X | X | X
D40 | AN | ESOL Bilingual Student Contact Minutes |  | X |  | X
D41 | AO | Career and Technical Education Contact Minutes |  | X |  | X
D42 | AP | Title I Participation |  |  |  |  |  | X
D43 | AQ | Miles Transported |  | R |  | R
D44 | AR | Transportation FTE |  | R |  | R
D45 | AS | Student’s Transportation Street Address |  | X |  | X
D46 | AT | Student’s Transportation City |  | X |  | X
D47 | AU | Student’s Transportation Zip Code |  | R |  | X
D48 | AV | Non-Resident Transportation |  | X |  | X
D49 | AW | Child of Military Family |  |  |  | X
D50 | AX | Immigrant Student |  | X |  |  |  | X
D51 | AY | Country of Birth |  | X |  |  |  | X
D52 | AZ | [NAME] |  |  |  |  |  | X
D53 | BA | Neglected Student |  |  |  |  |  | X
D54 | BB | Math Grouping Indicator 1 |  |  |  |  | O
D55 | BC | Math Grouping Indicator 2 |  |  |  |  | O
D56 | BD | Reading Grouping Indicator 1 |  |  |  |  | O
D57 | BE | Reading Grouping Indicator 2 |  |  |  |  | O
D58 | BF | K-8 Science Grouping Indicator 1 |  |  |  |  | O
D59 | BG | K-8 Science Grouping Indicator 2 |  |  |  |  | O
D60 | BH | High School Life Science Grouping Indicator 1 |  |  |  |  | O
D61 | BI | High School Life Science Grouping Indicator 2 |  |  |  |  | O
D62 | BJ | High School Physical Science Grouping Indicator 1 |  |  |  |  | O
D63 | BK | High School Physical Science Grouping Indicator 2 |  |  |  |  | O
D64 | BL | [NAME] Indicator 1 |  |  |  |  | O
D65 | BM | [NAME] Indicator 2 |  |  |  |  | O
D66 | BN | High School History/Gov: World Focus Grouping Indicator 1 |  |  |  |  | O
D67 | BO | High School History/Gov: World Focus Grouping Indicator 2 |  |  |  |  | O
D68 | BP | High School History/Gov: U.S. Focus Grouping Indicator 1 |  |  |  |  | O
D69 | BQ | High School History/Gov: U.S. Focus Grouping Indicator 2 |  |  |  |  | O
D70 | BR | Writing Grouping Indicator 1 |  |  |  |  | O
D71 | BS | Writing Grouping Indicator 2 |  |  |  |  | O
D72 | BT | KELPA Grouping Indicator 1 |  |  |  |  | O
D73 | BU | KELPA Grouping Indicator 2 |  |  |  |  | O
D74 | BV | State Mathematics Assessment |  |  |  |  | X
D75 | BW | State Reading Assessment |  |  |  |  | X
[NAME] | BX | K-8 State Science Assessment |  |  |  |  | X
D77 | BY | High School  State Life Science Assessment |  |  |  |  | X
D78 | BZ | High School State Physical Science Assessment |  |  |  |  | X
D79 | CA | K-8 State History/Gov Assessment |  |  |  |  | X
D80 | CB | High School State History/Gov. Assessment: World Focus |  |  |  |  | X
D81 | CC | High School State History/Gov. Assessment: U.S.  Focus |  |  |  |  | X
[NAME] | CD | State Writing Assessment |  |  |  |  | X
D83 | CE | Kansas English Language Proficiency Exam (KELPA) |  |  |  |  | X
[NAME] | CF | User Field 1 | O | O | O | O | O | O | O | O | O
D85 | CG | User Field 2 | O | O | O | O | O | O | O | O | O
D86 | CH | User Field 3 | O | O | O | O | O | O | O | O | O
R |  | Required = Must contain a valid non-blank value
X |  | Required = Must contain a valid non-blank value or must be blank; blanks will be considered a null value.
O |  | Optional = Must contain a valid non-blank value or must be blank; blanks will be considered no response.