Spreadsheet: 29d62bc5-b9c4-4b00-8291-6e87569f5f24
Sheet: Sheet1

ID | Rule | Error Message_Code | Error Message | ENRL | TEST | EOYA | [NAME] | MILT | EXIT | ASGT | QERY | ODT | AUDT* | Vendors | Unnamed: 15
001 | Blank = "0" = Null = Empty where indicated on the "Required-Optional" tab of this document.  A submission with no data in the specified fields will be treated the same as a submission with a "0" in the specified fields.  Therefore, even when required, these fields can be blank. |  |  | X | X | X | X | X | X | X | X
021 | D14: Current School Year must be a valid year.  A valid School Year is defined as a 4 digit year.  The acceptable range is from the current program/graduation year to the current program/graduation year plus one. | SCHYR+1 | Current School Year must be from the current program/graduation year to the current program/graduation year plus one. |  |  |  |  |  |  | X |  | X |  | X
022 | Students must have a TEST record for the specific subject in the KIDS system in order to take an Online State Assessment. |  |  |  | X |  |  |  |  |  |  |  |  |  | Rule about how KIDS Records are used by another system.
023 | TEST records can only be submitted for K-12 students (D10: Current Grade Level = 05-17). | TESTGRADE | The grade level can only be K-12 |  | X |  |  |  |  |  |  | X |  | X
024 | Student transfer emails will be sent to the D2: AYP/QPA and the D16: Attendance schools/districts when the D2: AYP School changes from a value entered on any previous individual student record for the current school year. | EMAILLOSS | GAINED STUDENTS:   {1}    STUDENTS CLAIMED BY ANOTHER DISTRICT:   {2}     The KIDS system indicates that you have gained/lost this/these student(s) as noted above. If you have questions regarding submissions to the KIDS system, please contact the person in your district/school who is responsible for the KIDS data submissions.    For LOST Students:  If you agree with this information, please submit a KIDS Collection EXIT record for each student you have LOST.    If a student is noted as LOST, but actually is still enrolled at your school and has NOT moved to the gaining school, please contact the gaining school to resolve this issue. Please note that the student will be credited to the gaining school until the matter is resolved.    This email was generated by an automated system.  Please do not use the reply feature in your email software to respond to this claim.
 |  | EMAILLOSSHINT | Urgent records request recommended.
026 | EXIT records can be submitted only by the school listed as D2: AYP/QPA School on the EXIT record or the district that contains the school listed as D2.  If an EXIT record is submitted by the school listed as the D15: Funding or [NAME]: Attendance school (and not the D2 school), the record will be rejected. |  |  |  |  |  |  |  | X |  |  |  |  | X
028 | Students that have a TEST record in the KIDS System will have their State Assessments counted for AYP/QPA Accountability Purposes.  State assessments taken during the testing window for elementary and middle school students and at any time during the school year prior to the end of the testing window for high school students will be counted in the results for the current school year.  Assessments taken after 05/01/2011 will be counted for the following school year’s assessment results for students in grades 14 and 15 and will be attributed to the current school. |  |  |  | X |  |  |  |  |  |  |  |  |  | Rule about how KIDS Records are used by another system.
029 | For an individual batch, D13: State Student ID (when present) must be unique by record type. | SIDDUP | The State Student Identifier was entered multiple times for this record type. | X |  |  | X | X |  | X |  |  |  | X
030 | By batch, D13: State Student ID must be unique by D2: AYP/QPA School and D1: Record Type. | SIDDUP | The State Student Identifier was entered multiple times for this record type. |  | X | X |  |  | X | X |  |  |  | X
031 | Any combination of record types excluding QERY can be submitted in an individual batch, but there are restrictions on the schedules for certain record types. |  |  | X | X | X | X | X | X | X |  |  |  | X
032 | Only the D2: AYP/QPA school can modify fields in the Assignment System for records that contain a D13: State Student ID.  If a record is submitted to Collection by the D2: AYP School that contains a valid State Student ID in D13, and the D2: AYP School, D4: last name, D9: DOB, D8: gender, and D10: Grade Level fields do not match what’s in Assignment, the Assignment system will be updated through the Manage Core Data Process before the Collection record can be processed. |  |  | X |  |  |  | X
033 | If a record is submitted by D15: Funding School, only D13: State Student ID (if present) has to match an ID in the KIDS Assignment System.  If the State Student ID submitted does not match an existing ID, they get an error saying ID does not exist in Assignment. |  |  | X
034 | D3: Resident District ID information submitted to Collection never has to match what is listed in Assignment. |  |  | X | X | X | X | X | X | X
036 | All valid QERY records will be stored in a separate table, but will not be included in a student's history. |  |  |  |  |  |  |  |  |  | X
037 | Batches containing QERY records can contain only QERY records. |  |  |  |  |  |  |  |  |  | X |  |  | X
038 | If a D13: State Student ID is included in a QERY record, it supersedes all other data included.  However, any data included in the record must be valid. |  |  |  |  |  |  |  |  |  | X
039 | If a QERY record submitted contains a D13: State Student ID that has the submitting school listed as D2: AYP/QPA School in the Assignment System, "Most current values" will be defined as the most recent value submitted by the school listed as D2 in Assignment immediately prior to the school submitting the QERY record.  For these type of QERY records, the system will search the current school year and the school year immediate prior only. |  |  |  |  |  |  |  |  |  | X
040 | If a QERY record submitted does not contain a D13: State Student ID or contains a D13: State Student ID that does not have the submitting school listed as D2: AYP/QPA School in the Assignment System, "Most current values" will be defined as the most recent value submitted by the school currently listed as [NAME] in Assignment.  For these QERY records, the system will search KIDS records for all school years. |  |  |  |  |  |  |  |  |  | X
042 | If a QERY record submitted contains a D13: State Student ID that has the submitting school listed as D2: AYP/QPA School in the Assignment System, the following fields will be returned to the submitter:  D2, D4-D10, D12-D14, D16, [NAME], D20, D32-D35, D37-D40, D55, D56.  The values in these fields will reflect the latest information submitted by the school and district listed as [NAME] in Assignment immediately prior to the school submitting the QERY record.  If the D13: State Student ID has not been “owned” by any other school in Assignment, then the values in these fields will reflect the latest information submitted by the school and district currently listed as [NAME] in Assignment. |  |  |  |  |  |  |  |  |  | X
043 | If a QERY record submitted does not contain a D13: State Student ID or contains a D13: State Student ID that does not have the submitting school listed as D2: AYP/QPA School in the Assignment System, the following fields will be returned to the submitter: D2, D4-D10, D12-D14, D16.  The values in these fields will reflect the latest information submitted by the school and district currently listed as [NAME] in Assignment. |  |  |  |  |  |  |  |  |  | X
45 | D15: Current School Year must be a valid year. A valid School year is defined as a 4 digit year.   The acceptable value is the current program/graduation year and the current program/graduation year minus one. | SCHYR-1 | Current School year must be from the current program/graduation year minus 1 and the current program/graduation year. |  |  |  |  |  | X |  |  | X |  | X
046 | D10: Current Grade Level must reflect a valid grade level for the D2: AYP school listed in the record.  Valid grade levels are defined as those grade levels included in the KSDE Directory web application for the school in question.  If the AYP school is listed as "0001" or "0002," the grade level must be valid for the school listed in D17:  Attendance School. | GRADELVLAYP | [NAME] {0} does not have grade level {1} |  | X | X |  |  | X | X |  |  | X | X
 |  | GRADELVLATT | [NAME] {0} does not have grade level {1} |  | X |  |  |  | X | X
 |  | GRADELVLAYP | [NAME] {0} does not have grade level {1} |  |  | X
 |  | FUNDBLDG | If AYP/QPA School Identifier = "0001" or "0002," Funding School must contain a valid School ID number belonging to an accredited school or district central office. |  |  |  |  |  | X
047 | D13: State Student Identifier must be present and must exist in the KIDS Assignment System. |  |  |  |  | X | X |  | X |  |  |  |  | X
048 | If D32: Primary Disability Code contains a valid non-blank value , D10: Current Grade Level cannot equal "04." | 4YRIEP | 4 year olds at risk cannot have a Primary Disability Code (P.E.) or a Gifted Student Code (S.E.) | X |  | X |  | X |  | X |  |  |  | X
049 | On EXIT Records, D29: Post Graduation Plans is required if "8", "9", or "22" is entered on D27: Exit/Withdrawal Type. | POSTGRAD | Post-Graduation Plans cannot be empty if the Exit/Withdrawal is a graduation. |  |  |  |  |  | X |  |  | X |  | X
050 | On TEST Records, if "1" is entered on D88: Kansas English Language Proficiency Assessment (KELPA), D40: ESOL/Bilingual Program Participation Code must equal "1"-"4" or "6." | KELPA | If "1" is entered on KELPA, ESOL/Bilingual Program Participation Code must equal 1 - 4 or 6. |  | X |  |  |  |  |  |  | X |  | X
051 | On TEST Records, if "2" is entered on D88: Kansas English Language Proficiency Assessment (KELPA), D40: ESOL/Bilingual Program Participation Code must be blank or "5. | KELPA2 | The entered KELPA value requires an empty ESOL/Bilingual Program Participation Code or "5" |  | X |  |  |  |  |  |  | X |  | X
052 | On EOYA Records, if "1"-"7" is entered on D44: Title I Supplemental Educational Services (SES), D45: Title I SES Hours Participated must be "1"-"3" and D46: Title I SES Provider must contain a valid non-blank value that includes at least one "1" in a position.  If D44 is empty or "8", D45 must also be empty and D46 must equal "0000000000000000000000000000000000." | TITLEISES2 | Title I SES fields must all be empty or must all contain valid, non-blank data |  |  | X |  |  |  |  |  |  |  | X
 |  | TITLEISES5 | Invalid value for Title I SES Hours |  |  | X
 |  | TITLEISES6 | [NAME] for Title I SES Provider. |  |  | X
053 | "19" is a valid value for D10: Current Grade Level in the Assignment System, but not in the Collection System.  If any record is submitted to Collection with D10 = "19," the record will be rejected. |  |  | X | X | X | X | X | X | X | X | X |  | X
054 | Assessments marked on TEST records with values other than 'C' must be valid for the grade level listed on the record.  Valid grade levels for assessments are as follows:   D79, D80 = "08" - "16" D81 = "09" or "12" D82, D83 = "14" - "16" D84 = not offered D85, D86 = "14" or "16" D87 = "10" "13" or "16" D88 = "05"- "17" | ASSESS1 | Assessment selection requires kindergarten through 12th grade. |  | X |  |  |  |  |  |  | X |  | X
 |  | ASSESS2 | Assessment selection requires 4th or 7th grade. |  | X
 |  | ASSESS3 | Assessment selection requires 10th or 12th grade. |  | X
 |  | ASSESS4 | Assessment selection requires 6th or 8th grade. |  | X
 |  | [NAME] | Assessment selection is not valid for any grade level |  | X
 |  | ASSESS6 | Assessment selection requires 9th through 12th grade. |  | X
 |  | [NAME] | Assessment selection requires 3rd through 11th grade.
056 | For ENRL and MILT Records, if a student is marked as "1" or "3" on D17: Virtual Education Student, the Address fields (D49, D50, and D51) must contain valid non-blank values. | [NAME] | Virtual Education Student must have an address in the record | X |  |  |  | X |  |  |  | X | X | X
059 | In order to remove a student from the test roster and participation list for a particular subject, a new TEST record will need to be sent for that student with a code of  C="Clear test subject indicator" code listed in that assessment field. |  |  |  | X |  |  |  |  |  |  | X
060 | If a record is submitted to Collection by the D16: Attendance School, and the D16: Attendance School is different than the D2: AYP School, the record must match what is currently in Assignment on the D2: AYP/QPA School field, the D13: State Student Identifier field, and the D14: Current School Year field.  If the D2: AYP/QPA School does not match what is currently in Assignment, an error message will be provided specifying the D2: AYP/QPA School value that is in Assignment. |  |  |  | X
061 | [NAME]:  Attendance School can submit records only when the D15:  Funding School value is "0003" = Student attends a non-accredited Juvenile Detention Facility |  |  | X |  | X |  |  | X |  |  |  |  | X
062 | D15: Funding School must contain a valid School ID number belonging to an accredited school or district central office, or "0003" = Student attends a non-accredited Juvenile Detention Facility.  D17: Attendance School must contain a valid School ID number. |  |  | X | X | X | X | X | X | X |  |  | X | X
063 | If a record is submitted to Collection by the D2: AYP School, the record must match what is currently in  Assignment on the D2: AYP/QPA School field, the D13: State Student Identifier field, and the D14: Current School Year field.  If the D2: AYP/QPA School does not match what is currently in Assignment, the Manage Core Data Process will be triggered. |  |  |  | X
066 | Only the D2: AYP/QPA School or the D16: Attendance School can submit these records unless D2 = "0001" or "0002".  In this  situation, D17: Funding School can submit. |  |  |  | X |  |  |  |  |  |  |  |  | X
069 | In order to mark 3, 4, 5, 9, K, I, J, V, W or M on D79 - D86 record must have a valid nonblank value in D32:  Primary Disability Code. | ASSESSGI | To mark an Assessment as "Alternate" or KAMM, the Primary Disability Code must be not empty. |  | X |  |  |  |  |  |  |  |  | X
070 | For ENRL records, D18: School Entry Date cannot be 09/21/2012 or after. | AFTER920 | School Entry Date ({0}) cannot be after September 21. | X |  |  |  |  |  |  |  |  |  | X
071 | For MILT records, D18: School Entry Date cannot be 02/21/2013 or after. | AFTER220 | School Entry Date ({0}) cannot be after February 21. |  |  |  |  | X |  |  |  |  |  | X
072 | For [NAME] and EOYA, D21: Days in Membership and D22: Days in Attendance must both be greater than zero. |  |  |  |  | X | X |  |  |  |  |  |  | X
073 | For [NAME] records, D18: School Entry Date cannot be after 12/01/2012. | AFTER1201 | School Entry Date ({0}) cannot be after December 1. |  |  |  | X |  |  |  |  |  |  | X
074 | The D10: Grade Level values in ENRL and MILT records submitted as Audit Records do not have to match the values indicated for that school in the Directory Application. |  |  | X |  |  |  | X |  |  |  |  | X
075 | D10: Current Grade Level must reflect a valid grade level for the D15: Funding school listed in the record.  Valid grade levels are defined as those grade levels included in the KSDE Directory web application for the school in question.  If the funding school is listed as "0003," the grade level must be a valid value. | GRADELVLFND | [NAME] {0} does not have grade level {1} | X |  |  | X | X |  |  |  |  | X | X
076 | If D15: Funding School = “0003,” [NAME]: Attendance School must be a Juvenile Detention Facility in the submitting district, and D2: AYP/QPA School must be the Central Office of the submitting district. | NOTCENTJUVENILE | [NAME] ({0}) must be Central Office and [NAME] ({1}) a Juvenile Detention Center | X | X | X | X | X | X | X |  |  |  | X
 |  | MUSTBELONG_08 | The user must be a member of the [NAME] building ({0}) and [NAME] building ({1})
077 | If present, D41: ESOL Contact Minutes must contain a valid numerical value less than 999.  The value cannot be larger than the value in D24:  Minutes Enrolled if [NAME] >0. | [NAME] | ESOL Contact Minutes are greater than Minutes Enrolled. | X |  |  |  | X |  |  |  |  |  | X
087 | In order to have a value greater than 0 in D42: CTE Contact Minutes, D10: Grade Level must be 14-18. | TEDGRADE | Technical Education students must be in ninth grade or higher | X |  |  |  | X |  |  |  |  |  | X
088 | Students marked with a disability code on D32: Primary Disability Code must be marked as a "1" on [NAME]: Qualified for 504 | SPED504 | Primary Disability requires a "1" in the Qualified for 504 field. |  |  | X |  |  |  |  |  |  |  | X
 |  | A36 | Students with disabilities must be marked as "Qualified for 504". |  |  | X
089 | If a Public School submits, the user must be a member of the D15: Funding School (or a member of the D16: Attendance School if D15 = 0003).  If a private school is submitting, the user must be a member of the AYP school. | [NAME] | If Public School submitting, the user must be a member of the Funding building ({1}) or [NAME] ({2}) (if Funding = 0003). If Private School submitting, the user must be a member of the [NAME] building ({0}). | X |  |  | X | X |  |  |  |  |  | X
090 | To undo a TITL or EOYA record, re-send the same record with the D21: Days in Membership = -1. |  |  |  |  | X | X
093 | For ENRL and MILT records, if D47: [NAME] is greater than or equal to 2.5, the Transportation Address fields (D49, D50, and D51) must contain valid nonblank values. | TRANSMILES | Address information is required as [NAME] is equal or over 2.5 miles. | X |  |  |  | X |  |  |  |  | X | X
094 | If an EOYA record is submitted with a value in D2: AYP/QPA that does not match the value for D2 in Assignment, the Manage Core Data Process will not be triggered. |  |  |  |  | X
095 | If an EOYA record is submitted with a value in D2: AYP/QPA that matches the value for D2 in Assignment, but there are values in other core data element fields that do not match the values in Assignment, the Manage Core Process may be triggered. |  |  |  |  | X
096 | Once the Dropout/Graduation Summary Report has been submitted by a school, EXIT records with exit/withdrawal dates on or before 9/30/12 and with that school as the AYP school will be rejected. |  |  |  |  |  |  |  | X |  |  |  | X
097 | If D2 = "0001" or "0002," D16: Attendance School must contain a valid School ID number belonging to an accredited school or district central office within the submitting district. |  |  |  | X | X |  |  | X
098 | In order to mark 1-5 on D25: Concurrent High School Enrollment, D10: Current Grade Level must be 15-18, unless the student has "GI" in field [NAME]; in which case D10: Current Grade Level must be 14-18. | CONCURRENT | In order to mark 1-5 on Concurrent High School Enrollment, Current Grade Level must be 15-18, unless student has a  Gifted Student Code ([NAME]) of "GI"; in which case Current Grade Level must be 14-18 | X |  |  |  | X
099 | D2: AYP/QPA School must contain a valid School ID number belonging to an accredited school or district central office, “0001,” or “0002” |  |  | X | X |  | X | X |  | X |  |  |  | X
100 | D2: AYP/QPA School must contain a valid School ID (open or closed) number belonging to an accredited school or district central office. |  |  |  |  |  |  |  | X
101 | Only the D2: AYP/QPA School can submit these records unless D2 = "0001" or "0002".  In this situation, the D16: Attendance School can submit. | MUSTBELONGEOYA | The user must be a member of the AYP Building ({0}) or [NAME] ({1}) if [NAME] is 0001 or 0002. |  |  | X |  |  |  |  |  | X |  | X
102 | Required and optional fields for each record type are defined in the "Required-Optional" tab of this document.  Required fields must contain a valid value in order for the record to be accepted.  Optional fields may be blank, but values submitted will be stored. |  |  | X | X | X | X | X | X | X | X | X | X | X
94 | D56:  Country of Birth must contain a nonblank value if D55:  Immigrant Student contains a valid nonblank value. | IMMIGRANTCOB | Country of Birth is required if a value of "1" or "2" is reported for Immigrant Student. | X |  | X |  |  |  |  |  |  |  | X
105 | Assessments marked on TEST records with values of 'C' Clear test subject indicator can be sent for any Grade Level for all Assessment subjects D75-D88. |  |  |  | X |  |  |  |  |  |  |  |  | X
106 | Only students with D10: Current Grade Level >13 can have an EXIT record with a D27: Exit/Withdrawal Type of 8, 9, or 22. |  |  |  |  |  |  |  | X |  |  |  |  | X
108 | No EXIT records should be submitted with a D26: Exit/Withdrawal Date prior to 10/1/2011. |  |  |  |  |  |  |  | X |  |  |  | X
109 | D27: Exit/Withdrawal Type = 98 (Unresolved Exit) is only a valid value when batch type = AUDIT.  Any other record with D27: Exit/Withdrawal = 98 will result in an error. | DV01_1 | Exit Withdrawal Type 98 is reserved for KSDE use only. |  |  |  |  |  | X
110 | Once the AYP Data Checklist/Signoff Tool has been submitted by a school, TEST and EOYA records for the current school year will no longer be accepted. |  |  |  | X | X
111 | If present, D38: First Entry Date into a School in the United States must be on or before D20: State Entry Date | USENTDTE | If present First Entry Date into a School in the United States must be on or before State Entry Date. | X | X | X |  | X
112 | In order to have a non-blank value in D17: Virtual Education Student, D10: Current Grade Level must be 05-18. | VIRTGRADE | In order to have a non-blank value in Virtual Education Student, Current Grade Level must be 05-18. | X |  | X |  | X
114 | D26: Exit/Withdrawal Date must be after D9: Date of Birth. | EXTDTBDAY | Exit/WithDrawal Date must be after Date of Birth. |  |  |  |  |  | X
115 | D52: 10 Mile Law must contain a blank value if D3: Residence District Identifier is the same as the Funding District. | NOTENMILE | 10 Mile Law cannot contain a non-blank value if Funding School is in the Residence District | X |  |  |  | X
116 | In order to have a value other than 0000 in D35: Early Childhood Program Participation, D10: Current Grade Level must be 00-04. | EARLYEMPTY | In order to have a value other than 0000 in Early Childhood Prog. Part. Current Grade Level must be 00-04 |  |  | X
119 | If [NAME]: Attendance School = "9100" then D2: AYP/QPA school must be a High School building in the submitting district and D15: Funding School must be the district central office of the submitting district. | ATTEND9100 | When the Attendance School is "9100", then the AYP School ({0}) must be the High school the student would have attended and the Funding School ({1}) must be the District Central Office. | X
120 | D3: Residence District ID must be an "active" district for the current school year or current school year -1 in the Directory based on the date the District Central Office building was opened. |  | The Residence District must be a valid state district or two letter state abbreviation. | X | X | X | X | X | X | X
121 | If D27: Exit/Withdrawal Type = '22', then D32: Primary Disability Code must contain a valid non-blank value. |  | If Exit/Withdrawal Type is '22' then Primary Disability Code must contain a valid non-blank value. |  |  |  |  |  | X
122 | If D29: Post-Graduation Plans = '9', the D27: Exit/Withdrawal Type must equal '22'. |  | If Post-Graduation Plans is '9', then the Exit/Withdrawal Type must be '22'. |  |  |  |  |  | X
123 | D18: School Entry Date cannot be prior to the school year when the building opened in the Directory application. |  | School Entry Date cannot be prior to the school year when the building opened in the Directory Updates application. | X | X | X | X | X | X
124 | [NAME]: District Entry Date cannot be prior to the school year when the District Central office building opened in the Directory application. |  | District Entry Date cannot be prior to the school year when the District Central Office building opened in the Directory Updates application. | X | X | X | X | X | X
125 | D26: Exit/Withdrawal Date must be on or after the D18: School Entry Date. |  | Exit/Withdrawal Date must be on or after the School Entry Date |  |  |  |  |  | X
126 | If D40: ESOL Program Participation Code = 1, 2 or 3 then D37: ESOL Program Entry Date, D38: US Entry Date, D39: First Language, and D41: ESOL Contact Minutes must contain valid nonblank values. |  | If ESOL Program Participation Code is 1, 2, or 3, ESOL Program Entry Date, US Entry Date, First Language, and ESOL Contact Minutes must contain valid nonblank values. | X |  |  |  | X |  |  |  |  |  | X
127 | If D40: ESOL Program Participation Code = 1, 2 or 3 then D37: ESOL Program Entry Date, D38: US Entry Date, and D39: First Language must contain valid nonblank values. |  | If ESOL Program Participation Code is 1, 2, or 3, ESOL Program Entry Date, US Entry Date, and First Language must contain valid nonblank values. |  | X | X |  |  |  |  |  |  |  | X
128 | If D40:  ESOL Program Participation Code = 4, 5 or 6 then D37: ESOL Program Entry Date, D38: US Entry Date, and D39: First Language must contain valid nonblank values; while D41: ESOL Contact Minutes  must be blank. |  | If ESOL Program Participation Code is 4, 5 or 6,  ESOL Program Entry Date, US Entry Date, and First Language must contain valid nonblank values; while ESOL Contact Minutes  must be blank. | X |  |  |  | X |  |  |  |  |  | X
129 | If D40:  ESOL Program Participation Code = 4, 5 or 6 then D37: ESOL Program Entry Date, D38: US Entry Date, and D39: First Language must contain valid nonblank values. |  | If ESOL Program Participation Code is 4, 5 or 6,  ESOL Program Entry Date, US Entry Date, and First Language must contain valid nonblank values. |  | X | X |  |  |  |  |  |  |  | X
130 | If D40: ESOL Program Participation Code = 0 or Blank then D37:  ESOL Program Entry Date, D38: US Entry Date, and D41: ESOL Contact Minutes must be blank. |  | If ESOL Program Participation Code is 0 or Blank, ESOL Program Entry Date, US Entry Date, and ESOL Contact Minutes must be blank. | X | X | X |  | X |  |  |  |  |  | X
131 | For D80: K-8 State History/Gov Assessment the only valid value is blank.  Any other values will result in an error. |  | The K-8 State History/Gov Assessment is not offered this year.  Blank is the only valid value. |  | X
132 | For D46: Title I SES Provider the following positions must contain a '0':  2, 5, 10, 11, 12, 14, 16, 17, 18, 20, 22, 27, and 29. |  | Title I SES Provider contains an invalid value. |  |  | X
133 | In order to mark D or E on D79 - D86 the record must have a value of 'HI' in D32:  Primary Disability Code. |  | In order to mark a value of 'D' or 'E' on one of the Assessments, the Primary Disability Code must be 'HI'. |  | X
* | AUDT Shows rules that are ignored for Audit Records.
A03 | Allowable values for fields will follow definitions listed in the Collection System File Specifications document, unless otherwise specified in these business rules. |  |  | X | X | X | X | X | X | X | X |  |  | X
A18 | In order to be marked as “1" through "7” on D44: Title I Supplemental Education Services, a student must be marked as “1” or “2” on [NAME]: Eligibility for National School Lunch Program. | SUPEDERR | In order to be marked as "1" through "7" on D48: Title I Supplemental Education Services, a student must be marked as 1 or 2 on D32: Eligibility for National School Lunch Program. |  |  | X |  |  |  |  |  | X |  | X
A19 | If record has a value greater than “0” in D48: Transportation FTE or in D47: [NAME], it must have a value greater than “0” in both fields. | TRANSERR_2 | Transportation FTE and [NAME] Transported must both be zero or both greater than 0. | X |  |  |  | X |  |  |  | X |  | X
 |  | TRANSERR_2 | Transportation FTE and [NAME] Transported must both be zero or both greater than 0. | X |  |  |  | X
A22 | If information is entered in any one of the following fields: D53: Student's Transportation Street Address, D54: Student's Transportation City, or D55: Student's Transportation Zip, then information must be entered in all three fields. | TRANSERR | Transportation Address Information is incomplete. |  |  |  |  | X |  |  |  | X |  | X
A30 | D26: Exit/Withdrawal Date, D27: Exit/Withdrawal Type, and D29: Post-Graduation Plans are collected on EXIT record types.  On a non-EXIT record these fields MUST BE empty/blank.  Any non-exit records sent with non-blank values in D26, D27, and/or D29 will result in an error. | EXITWTH02 | Exit/Withdrawal Information is only allowable on EXIT record types | X | X | X | X | X | X | X |  | X |  | X
A33 | If a record is submitted to Collection by the D15: Funding School, the record must match Assignment only on the D2: AYP/QPA School field, the D13: State Student Identifier field (if present), and the D14: Current School Year field.  If the D2: AYP/QPA School does not match, an error message will be provided specifying the D2: AYP/QPA School value that is in Assignment. |  |  |  |  |  |  | X
B02 | If student submitted does not exactly match any pre-existing records in Assignment, user will be led through the process of claiming that student in Assignment. |  |  |  |  |  |  |  |  | X
B05 | If student submitted does not match any pre-existing students, user will be informed “no matches found.” |  |  |  |  |  |  |  |  |  | X
B06 | If student submitted matches multiple pre-existing students, user will be returned the QERY record with a list of State Student IDs for potential matches appended on the end.  The list of IDs will be limited to the first 10 potentially matching IDs. |  |  |  |  |  |  |  |  |  | X
B07 | All QERY records must contain D1: Record Type of QERY and at least D13: State Student ID or (D2: AYP/QPA School and D4: Legal Last Name). |  |  |  |  |  |  |  |  |  | X
B09 | If D11: Local Student Identifier is included in QERY record, the value submitted will be returned in resulting file but will not be used in the search. |  |  |  |  |  |  |  |  |  | X
B11 | If D15: Funding School (or corresponding district) submits a record without a D13: State Student ID, they will be allowed to obtain a D13: State Student ID from the Assignment System through the Assign New ID or Near Match Process.  This means the D15: Funding School will be able to change the D2: AYP/QPA school in the Assignment System. |  |  | X
B12 | When a record is submitted with “0001” or “0002” in D2: AYP/QPA School, Collection will use the D15: Funding School value in Assignment for verification. | FNDSUBMITTER | Submitter is not a member of the AYP or Funding School. | X |  |  |  | X
B13 | Determination of whether a student is still active in a particular D2: AYP/QPA School or district will be based on the D26: Exit/Withdrawal date listed in the EXIT record. |  |  |  |  |  |  |  | X
B14 | To undo an exit record, re-send the same exit/withdrawal record with the D27: Exit/Withdrawal Type changed to "99" |  |  |  |  |  |  |  | X |  |  |  |  | X
B17 | If multiple schools submit, all records are accepted and the records from the D15: Funding School and the D2: AYP/QPA School will be used for their respective Principal’s Building Reports.  If no ENRL records are submitted by [NAME] (for the entire school, not just for a particular student), the D15 records will be used for the Principal's Building Reports for both the D2 and the D15 schools.  If [NAME]: Attendance School submits an ENRL record, it will result in an error. |  |  | X |  |  |  |  |  |  |  |  |  |  | Rule about how KIDS Records are used by another system.
B18 | If D2: AYP/QPA School submits, that record will be used; if no D2: AYP/QPA School record exists, then [NAME]: Attendance School record will be used; if D15: Funding School submits, the record will result in an error. |  |  |  | X |  |  |  |  |  |  |  |  |  | Rule about how KIDS Records are used by another system.
B22 | Only the D2: AYP/QPA School can submit these records unless D2 '0001' or '0002', then the D16: Attendance School can submit. | AYPSUBMITTER | Submitter is not a member of the AYP/QPA school. |  |  |  |  |  | X
B23 | Only the D2: AYP/QPA School can submit these records unless a) D2 = "0001" or "0002," or b) The D13: State Student ID is null.  In these two situations, D15: Funding School can submit. | FNDSUBMITTER | Submitter is not a member of the AYP or Funding School. |  |  |  |  |  |  | X |  | X |  | X
 |  | AYPSUBMITTER | Submitter is not a member of the AYP/QPA school. |  |  |  |  |  |  | X
B24 | Any School may submit QERY records. |  |  |  |  |  |  |  |  |  | X |  |  | X
B26 | Student transfer emails will be sent to the D2: AYP/QPA Schools/districts when the D2: AYP/QPA school is changed for an individual student record.  The email will indicate what school/district submitted the batch leading to the change. |  |  | X |  |  |  | X |  | X
B27 | Student transfer emails will be sent to the  D2: AYP/QPA School and the D16: Attendance School/Program when [NAME] the D16 changes from a D2 and/or D16 value entered on any previous individual student record for the current school year. |  |  |  |  | X
B28 | When a record is submitted with “0001” or “0002” in D2: AYP/QPA School, Collection will use the D16: Attendance School value in Assignment for verification. |  |  |  | X | X |  |  |  | X
C02 | Since multi-district access is not currently possible with the Assignment System, the Collection System will determine what school and/or district an Assignment batch file should be sent from when generating these files and sending them to the Assignment district for multi-district user types.
C03 | Multi-district logins will have to be approved by all involved districts.
D01 | (H2) Extract Date:  Extract Date must be a valid date and less than or equal to Today |  |  |  |  |  |  |  |  |  |  | X |  | X
D02 | (H3) Extract Time:  Extract Time must be a valid time. |  |  |  |  |  |  |  |  |  |  | X |  | X
D03 | (H4) Transmission ID:  Transmission ID cannot be empty and must match the Transmission ID in the Trailer Record. |  |  |  |  |  |  |  |  |  |  | X |  | X
D04 | (H5) Version Number:  Version number must be a valid version number. Currently must be 8.0. |  |  |  |  |  |  |  |  |  |  | X |  | X
D05 | (H6) Delimiter:  Delimiter value must be set correctly. |  |  |  |  |  |  |  |  |  |  | X |  | X
D06 | (T1) Record Type:  The last record must contain TT as the first 2 characters. |  |  |  |  |  |  |  |  |  |  | X |  | X
D07 | (T2) Transmission ID:  Transmission ID cannot be empty and must match the Transmission ID in the Header Record. |  |  |  |  |  |  |  |  |  |  | X |  | X
D08 | (T3) Number of Records:  Must be numeric and the numeric value must be equal to the number of detail records plus 2 (trailer and header record). |  |  |  |  |  |  |  |  |  |  | X |  | X
E01 | There must be a least one [NAME] D1: Record Type must contain a valid value. |  |  | X | X | X | X | X | X | X | X |  |  | X
E03 | D2: AYP/QPA School must contain a valid School ID number, “0001,” or “0002” |  |  |  |  |  |  |  |  |  |  |  |  | X
E05 | D3: Resident District Identifier must be a valid school district or a valid 2-character State (or territory) abbreviation. |  |  | X | X | X | X | X | X | X |  |  |  | X
E10 | D8: Gender must be a valid value. |  |  | X | X | X | X | X |  | X |  |  |  | X
E11 | D9: Date of Birth must be a valid date and must be before Today but not before 1/1/1900. |  |  | X | X | X | X | X |  | X |  | X |  | X
[NAME] | D11: Local Student Identifier must not be empty. |  |  | X | X | X | X | X |  | X |  |  |  | X
E15 | If present, D13: State Student Identifier must exist in the KIDS Assignment System.  If not present, Collection will compare fields with fields in Assignment.  The record will need to be updated using the Manage Core Data Process. |  |  | X | X | X |  | X
E16 | D14: Current School Year must be a valid year. A valid School year is defined as a 4 digit year. | SCHYR | Current School Year must be the current program/graduation year. | X | X | X | X | X |  |  |  |  |  | X
E19 | D18: School Entry Date must be a valid date after the student's birth date (D9).  The date cannot be after the submission date. | SCHENTDTE | School Entry Date must be a valid date after the student's birth date | X | X | X | X | X |  |  |  | X |  | X
E20 | [NAME]: District Entry Date must be a valid date and must be before or the same as  D18: School Entry Date, after the student's D9: birth date, and before the submission date. | DISENTDTE | District Entry Date must be a valid date and must be before or the same as School Entry Date and after Student birth date. | X | X | X | X | X |  |  |  | X |  | X
E21 | D20: State Entry Date must be a valid date and must be before or the same as [NAME]: District Entry Date, after the student's D9: birth date, and before the submission date. | STEENTDTE | State Entry Date must be a valid date and must be before or the same as District Entry Date and after Student birth date. | X | X | X | X | X |  |  |  | X |  | X
E22 | D21: Number of Days in Membership must be greater than or equal to D22: Number Of Days Attended or must equal -1. | [NAME] | Number of Days in Membership must be greater than or equal to Number Of Days Attended. |  |  | X | X |  |  |  |  | X |  | X
 |  | MBRATTZERO | Membership Days and Days Attended cannot be zero.
E23 | [NAME]: Number of Days Attended must be greater than 0 unless D23: Number of days in Membership equals -1. |  |  |  |  | X | X |  |  |  |  |  |  | X
E25 | D25: Minutes Enrolled must be a valid numeric value greater than or equal to 0 and cannot be greater than 999. |  |  | X |  |  |  | X |  |  |  |  |  | X
E27 | D26: Exit/Withdrawal Date must be a valid date and must be present if D27: Exit/Withdrawal Type is present. |  |  |  |  |  |  |  | X |  |  | X |  | X
E45 | D42: Technical Education Contact Minutes must be empty or contain a valid numeric value.  The value cannot be larger than the value in D24:  Minutes enrolled if [NAME] >0.  If [NAME] = 0, D42 cannot be larger than 999. | TEDMINERR | Technical Education Contact Minutes are greater than Minutes Enrolled. | X |  |  |  | X |  |  |  | X |  | X
E48 | If not null, D47: Miles Transported must contain a valid numeric value. The value cannot be over the maximum allowed (99.9). |  |  | X |  |  |  | X |  |  |  |  |  | X
E49 | If not null, D48: Transportation FTE must contain a valid numeric value. The value cannot be greater than 1.0. |  |  | X |  |  |  | X |  |  |  |  |  | X
F01 | ENRL Submission Dates = 9/20/2012 - 10/10/2012.  Data must be current as of September 20th. |  |  | X
F02 | TEST Submission Dates = TEST records can be submitted any time after 08/20/2012 through [NAME] for all students.  Data must be current as of the student's test date. |  |  |  | X
F04 | [NAME] = 5/6/2013 - 6/14/2013.  Data must be current as of Last Day of School. |  |  |  |  | X
F05 | TITL Submission Dates = 12/3/2012 - 1/11/2013.  Data must be current as of December 1st |  |  |  |  |  | X
F06 | MILT Submission Dates = 2/20/2013 - 3/11/2013.  Data must be current as of February 20th |  |  |  |  |  |  | X
F07 | EXIT, ASGT, and QERY [NAME] = any. |  |  |  |  |  |  |  | X | X | X |  |  | X