5 - Florida Department of Education

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