Business Rule/JOB

Known Issue

Resolution

Status

BR# 162_1: SchoolEntryDate must be greater than or equal to students submission date

All students being submitted are flagged with the BR error check.

Review SQL statement behind the rule

Resolved

BR# E104B: SchoolId '0001' can only be used for for the SchoolType value 'Accountability School' only if the DistrictOfResidence = A Kansas District.

Schools with values that are NOT SchoolID '0001' with SchoolType of 'Accountability' are receiving the BR error check.

Review SQL statement behind the rule.

Not Resolved

JOB - SPED

Schools attempting to run the SPED job are receiving the message 'Records found'' but no students are listed in the job summary.

N/A

Resolved

BR# 183: StreetNumberName may only contain characters A-Z, numbers 0-9, a hyphen '-', a slash '/', a period '.', or the pound sign '#'.

Student Addresses are being flagged with the BR error check due to having spaces in the StreetNumberName field.

Review SQL statement behind the rule and add spaces as an allowable charcter.

Resolved

BR# 185: If DistrictOfResidence is out of state, Student cannot have a value of 'Virtual Education Student' in the StudentType field. 

Students with the StudentType of 'Virtual Education Student' and with thier DistrictOfResidence being in state are flagged with the BR error check.

Review SQL statement behind the rule.

Resolved

BR# A40: If CreditsEarned and CreditsRequiredToGraduate have a value then GradeLevel must be in (Ninth grade, Tenth grade, Eleventh grade, Twelfth grade) 

'N/A' value is being saved as a valid value for the HighschoolCreditsRequired & HighSchoolCreditsEarned field which flags the BR error check for all students not in valid grade levels for BR# A40. 

Review SQL statement behind the rule.

Not Resolved

BR# 098: In order to be indicated as Concurrent High School Enrollment, GradeLevel must be Tenth-Twelfth or Ungraded, unless the student has a StudentCharacteristicType of "Gifted Student"; in which case GradeLevel must be Ninth-Twelfth or Ungraded.

Students with the StudentCharacteristicType value of 'Gifted Student' that are NOT  in GradeLevels Ninth-Twelfth or Ungraded are being flagged with the BR error check. 

Review the SQL statement behind the rule.

Not Resolved

BR# 155: Students age 22, can only be submitted with a GradeLevel of 'Ungraded'

Students NOT aged '22' and NOT having the GradeLevel 'Ungraded' are being indicated as being aged '22' in the rule overview page and being flagged with the BR error check.

Review the SQL statement behind the rule.

Not Resolved

BR# 114: Non-Resident Transportation (10 Mile Law) must contain a blank value if DistrictOfResidence is the same as the FundingDistrict

Students that do NOT have a value inputted for the Non-Resident Transportation (10 mile law) are being flagged with the BR error check. 

Review the SQL statement behind the rule.

Not Resolved

BR#KC_12: In order to have a value in the InstructionalMinutesCompleted field then the IsMigrantStudent field must have a value and the CourseStatus field must contain the value 'Exited before course completion

All students with values uploaded into the three fields are being flagged by the BR error check. (InstructionalMinutesCompleted, IsMigrantStudent, CourseStatus) 

Review the SQL statement behind the rule.

Not Resolved

JOB - COURSES

Receiving 'Contact Administrator' error when attempting to run Courses Job.

Review the SQL statement behind the rule.

Resolved

BR#KC_2: If CreditsEarned contains a value, then the last digit of the KCC_ID value must contain a 'C', 'D', 'L' or 'R'.

Students with '0.00' values for the CreditsEarned field are being flagged by BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved

BR#ST_4: If LetterGradeEarned has a value then CourseStatus must have the values 'Completed (Pass)', 'Completed (Fail)',  'Exited before course completion (Migrant Only)' or 'Record Submitted in Error'

All students with valid values inputted for the 'LetterGradeEarned' and 'CourseStatus' field are being flagged by the BR Error Check.

Review the SQL statement behind the rule.

Not Resolved

BR# 173: DyslexiaSubtest must contain a non-blank value if GradeLevel = (Kindergarten, First grade, Second grade, Third grade, Eighth grade)

Students in the listed grade levels that have a 'N/A' value inputted are being flagged by the BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved

BR# 173_1: If GradeLevel = ('Kindergarten', 'First grade', 'Second grade', 'Third grade' or 'Eighth grade') then DyslexiaSubtest must contain a valid value.

Students in the listed grade levels that have a 'N/A' value inputted are being flagged by the BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved

BR# 174: SpringBenchmarkPerformanceLevel must contain a valid non-blank value if GradeLevel = (Kindergarten, First grade, Second grade, Third grade, Eighth grade)

Students in the listed grade levels that have a 'N/A' value inputted are being flagged by the BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved

BR# 174_1: If GradeLevel = ('Kindergarten', 'First grade', 'Second grade', 'Third grade' or 'Eighth grade') then SpringBenchmarkPerformanceLevel must contain a valid value.

Students in the listed grade levels that have a 'N/A' value inputted are being flagged by the BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved

BR# 048:If PrimaryDisabilityType is 'WD', GradeLevel cannot contain (PR/Preschool)

Preschool Aged Students that have  the PrimaryDisability value of 'WD' are being flagged by the BR Error Check. 

Review the SQL statement behind the rule.

Not Resolved