THE FOLLOWING CHANGES ARE FOR FISCAL YEAR 1213 Education Information and Accountability Services is in the process of converting the 2010-11 Database Manuals to a 508 compliant format. If you are visually impaired and need assistance reading the manuals, please contact Education Information and Accountability Services at [email protected] or (850) 245-0400. STUDENT COURSE TRANSCRIPT INFORMATION - REJECT RULES 32. If Course Number is not 1200310, 1200320, 1200380, 1209810, 1200390, 2000310, 2000320, 2000322, 2000430, 2000800, 2000850, 2002440, 2002450, 2000340, 1206310, 1206320, 1206810 or 1209820 then Course Assessment Status must be Z. -record rejectedEXAMPLE The first record listed below would be loaded to the data base assuming no other reject rule would cause its rejection. The second record would be rejected because the Course Assessment Status code is not correct for the Course Number reported. District Number, Current Instruction/ Service Student Number Identifier, Florida Course Number Course Assessment Status 02 * 02 123456789X 123456791X 1200320 1200300 A A DISTRICT RESPONSIBILITY If the rejected record should not have been submitted, no action is required. However, if the district wishes the data in the rejected record to be loaded to the data base, the district must correct the Course Assessment Status code or the Course Number and resubmit the record. DATE: 7/12 STUDENT DATA BASE EDITS PAGE - 31 STUDENT COURSE TRANSCRIPT INFORMATION - STATE VALIDATION RULES 51. If Course Assessment Status is A, then Credit Earned, Course must be 050 or 100 on this record or on a matching Student Course Transcript Information record. The match is based on Student Number Identifier, Florida; Survey Period Code; School Year – Record Submission and Course Number, which must be one of the following: • For EOC Algebra 1 courses = 1200310, 1200320, 1200380, 1209810 or 1200390. • For EOC Biology 1 courses = 2000310, 2000320, 2000322, 2000430, 2000800, 2000850, 2002440, 2002450 or 2000340. • For EOC Geometry courses = 1206310, 1206320, 1206810 or 1209820. – state validation- EXAMPLE The first two records listed below would not cause an error message to be generated. The third record would cause an error message to be generated because the Credit Earned, Course is 000 and there is no matching record with Credit Earned, Course of 050 or 100. District Number, Current Enrollment Student Number Identifier, Florida Course Number 02 02 123456789X 123456789X 1200320 1200320 A A 100 000 * 02 123412341X 1200320 A 000 Course Credit Assessment Earned, Status Course DISTRICT RESPONSIBILITY The district must either correct the record by changing the Course Assessment Status code or the Credit Earned, Course or the district must submit a matching record with Credit Earned, Course of 050 or 100. DATE: 7/12 STUDENT DATA BASE EDITS PAGE - 37 STUDENT END OF YEAR STATUS – EXCEPTION REPORT (New Edit for 1213) 46. If the Online Course Exempt code is D, then there must be a matching Exceptional Student record (based on District Number, Current Enrollment; Student Number Identifier, Florida; Survey Period Code; and Year) with at least one Exceptionality, Primary or Exceptionality, Other code that is not L. –state validation- EXAMPLE The first Student End of Year Status record listed below which is marked with an asterisk would cause a message to be generated because the matching Exceptional Student record has only L and Z codes in Exceptionality, Primary and Exceptionality, Other. The second Student End of Year Status record would pass this edit. The third Student End of Year Status record would cause a message to be generated because a matching Exceptional Student record does not exist. Student End of Year Status records District Number, Current Enrollment * 01 01 * 01 School Number, Current Enrollment Student Number Identifier, Florida Survey Period Code Year Online Course Exempt 0011 0011 0011 123456789X 234567891X 345678912X 5 5 5 1213 1213 1213 D D D Exceptional Student records District Number, Current Enrollment 01 01 School Student Number, Number Current Identifier, Enrollment Florida 0011 0011 123456789X 234567891X Survey Period Code 5 5 Exceptionality, Exceptionality, Year Primary Other 1213 1213 L K ZZZZZZZZZZ OZZZZZZZZZ DISTRICT RESPONSIBILITY DATE: 7/12 STUDENT DATA BASE EDITS PAGE –85 STUDENT END OF YEAR STATUS – REJECT RULES (New Edit for 1213) 2Q. If the Online Course Exempt code is T then Grade Level must be 12. -record rejectedEXAMPLE The first two records listed below would be loaded to the data base assuming no other reject rule would cause their rejection. The third record would be rejected because the Online Course Exempt code is T and the Grade Level is not 12. Student Number Identifier, Florida 123456789X 129876543X * 123456790X School Year Grade Level Online Course Exempt **** **** **** 12 12 10 T T T **** = Valid fiscal year for data submission. DISTRICT RESPONSIBILITY If the rejected record should not have been submitted, no action is required. However, if the district wishes the data in the rejected record to be loaded to the data base, the district should correct the Online Course Exempt code or the Grade Level and resubmit the record. DATE: 7/12 STUDENT DATA BASE EDITS PAGE –43 STUDENT END OF YEAR STATUS – REJECT RULES (New Edit for 1213) 2R. Online Course Exempt must be D, T or Z. -record rejected- EXAMPLE The first record listed below would be loaded to the data base assuming no other reject rule would cause its rejection. The second and third records listed below would be rejected. The second record would be rejected because the Online Course Exempt code is an invalid code. The third record would be rejected because the Online Course Exempt field is blank. District Number, Current Enrollment Student Number Identifier, Florida 30 * 30 * 30 301234567X 301234568X 301234569X Online Course Exempt D E DISTRICT RESPONSIBILITY If the rejected records should not have been submitted, no action is required. However, if the district wishes the data in the rejected records to be loaded to the data base, the district must correct the Online Course Exempt codes and resubmit the records. DATE: 7/12 STUDENT DATA BASE EDITS PAGE –44 STUDENT END OF YEAR STATUS – REJECT RULES (New Edit for 1213) 2S. If FTE Earned: Unpaid Credits for Early Graduates is greater than zero, then Diploma Type must be W06, WFT or WFW. –record rejectedEXAMPLE The first record listed below would pass this edit. The second and third records would be rejected because the FTE Earned: Unpaid Credits for Early Graduates is greater than zero and the Diploma Type codes are not W06, WFT or WFW. Student End of Year Status records District Number, Current Enrollment Student Number Identifier, Florida Diploma Type 36 * 36 * 36 123456780X 223456780X 323456780X W06 W6A ZZZ FTE Earned, Unpaid Credits for Early Graduates 0.1667 0.1667 0.1667 DISTRICT RESPONSIBILITY The district must review the Diploma Type codes and the FTE Earned: Unpaid Credits for Early Graduates amounts and correct the items that are in error. The district must then resubmit the records. DATE: 7/12 STUDENT DATA BASE EDITS PAGE –45 STUDENT END OF YEAR STATUS – REJECT RULES (New Edit for 1213) 2T. FTE Earned, Unpaid Credits for Early Graduates must be numeric and must be less than or equal to 1.0000. -record rejectedNOTE: Four decimal places assumed. EXAMPLE The first record listed below would be loaded to the data base assuming no other reject rule would cause its rejection. The second and third records listed below would be rejected. The second record would be rejected because FTE Earned, Unpaid Credits for Early Graduates is not numeric. The third record would be rejected because FTE Earned, Unpaid Credits for Early Graduates is greater than 1.0000. District Number, Current Enrollment Student Number Identifier, Florida 30 * 30 * 30 301234567X 301234568X 301234569X FTE Earned, Unpaid Credits for Early Graduates 01667 ZZZZZ 33333 DISTRICT RESPONSIBILITY If the rejected records should not have been submitted, no action is required. However, if the district wishes the data in the rejected records to be loaded to the data base, the district must correct the FTE Earned, Unpaid Credits for Early Graduates and resubmit the records. DATE: 7/12 STUDENT DATA BASE EDITS PAGE –46
© Copyright 2024