2012 Class Size File Layout

2012 CLASS SIZE FILE LAYOUT

gEORGIa depARTMENT of education (GaDOE)

Office of Technology Services – Technology Management

FY 2012 Class Size Data Collection

File Layout

Document Revision Updates

REVISION DATE

DATA ELEMENTS AFFECTED

COMMENTS

07.29.2011

/ /

Initial Document for FY2012

Class Size Record Layout (Bnn) /
Element
ID / Layout
ID / Element / Field Type / Format / Length / Starting Position / Ending Position / Description / Edits / Edit
# /
B001 / Fiscal Year / A / yyyy / 4 / 1 / 4 / Fiscal year of record. / yyyy is the complete year.
‘2012’ is the value for this current fiscal year.
Fiscal year not valid. / E010
B002 / Period / A / n / 1 / 5 / 5 / Reporting period of record. / Always equal to ‘1’ or ‘3’.
Report period must equal ‘1’ or ‘3’. / E020
B003 / System Code / A / nnn / 3 / 6 / 8 / School System Code / Must be an active school SYSTEM CODE in the Facilities Database in the range of 601-799. / E040
B004 / School Code / A / nnnn / 4 / 9 / 12 / School Code / SCHOOL CODE must be an active FTE school in the Facilities Database (where LIFE STAGE = '4' or '7' and REPORT FTE = "Yes"). / E050
If active school reported FTE, then Class Size data should be reported. / E3148
B005 / Report Type / N / n / 1 / 13 / 13 / ‘1’ Scheduling – no class change. This occurs primarily in K-5 schools.
‘2’ Scheduling – class change
Report type 1 and 2 are not limited to specific grade configurations. / REPORT TYPE is not valid. REPORT TYPE must be a ‘1’ or ‘2’. / E3085
REPORT TYPE should be the same on all records for a given school. / E3095
B006 / Class Period / N / nn / 2 / 14 / 15 / Period during the day the teacher instructs class. / CLASS PERIOD information valid only during report type ‘2’. / E3087
Valid periods are: 01- 99 / E3092

Georgia Department of Education

Dr. John D. Barge, State School Superintendent

September 8, 2011∙• 1:21 PMPage 6 of 6

Class Size Record Layout (Bnn) /
Element
ID / Layout
ID / Element / Field Type / Format / Length / Starting Position / Ending Position / Description / Edits / Edit
# /
B007 / Grade Level / N / nn / 2 / 16 / 17 / GRADE LEVEL of class instructed by teacher. GRADE LEVEL should not be submitted for grades 9-12. / ‘UK’ Underage Kindergarten
‘KK’ Kindergarten
‘U1’ Underage Grade 1
‘01’ Grade 1
‘02’ Grade 2
‘03’ Grade 3
‘04’ Grade 4
‘05’ Grade 5
‘06’ Grade 6
‘07’ Grade 7
‘08’ Grade 8 / E079
GRADE LEVEL is required for report type=’1’. GRADE LEVEL is not valid for
REPORT TYPE =’2’. / E3096
B008 / Teacher ID / N / nnnnnnnnn / 9 / 18 / 26 / SOCIAL SECURITY NUMBER must be employee's 9-digit Social Security Number, right justified with expressed leading zeros. This includes long-term substitutes and
3rd party contract employees. / TEACHER ID cannot be all one value (111111111, 222222222) or a number series (123456789, 012345678, etc). Must be 9-digit numeric number. / E064
Duplicate record reported
For REPORT TYPE = ‘1’, SYSTEM CODE, SCHOOL CODE, and TEACHER ID are duplicated.
For REPORT TYPE = ’2’, SYSTEM CODE, SCHOOL CODE, TEACHER ID, CLASS TYPE, CLASS PERIOD, and COURSE SECTION NUMBER are duplicated. / E3105
TEACHER ID was not reported in CPI-1. Please verify data. / W5595
Must be in compliance with SBOE Rule 160-4-2-.03 or 160-4-2-.20. / E905
B009 / Course Number (Class Type) / N / nn.nnnnnnn / 10 / 27 / 36 / COURSE NUMBER (formerly called Class Type) is the 10-digit number designating an official course specified in SBOE 160-4-2-.03 or 160-4-2-.20. Only core courses should be reported. / Complete COURSE NUMBER must be reported for REPORT TYPE = ‘2’. / E3098
COURSE NUMBER (Class Type) must be null if REPORT TYPE = ’1’. / E3099
Core course has been submitted with .4, .5, .6 or .7 after the decimal. Report core COURSE NUMBERS only. / E093
B010 / Class Size / N / xxx / 3 / 37 / 39 / Number of students enrolled in current class.
For report type ‘1’, maximum class size for the teacher for the day. / Must be a valid number between ‘001 to 150’ / E3094
B011 / # of Parapros / N / n / 1 / 40 / 40 / Indicates number of paraprofessionals in the classroom. / Valid values are (‘1’,’2’,’3’,’4’,or null) / E3103
B012 / # of additional teachers / N / n / 1 / 41 / 41 / Indicates the number of additional teachers in the classroom. / Valid values are (‘1’,’2’,’3’,’4’,or null) / E3104
B013 / Course Section number / N / nnn / 3 / 42 / 44 / A unique number which identifies a particular section of a course. / COURSE SECTION NUMBER must be reported for Report Type ‘2’. / E910
COURSE SECTION NUMBER must be null if Report Type = ‘1’. / E3108
COURSE SECTION NUMBER must be a numeric value between 000 and 999. / E3109
B014 / Gifted Delivery Model / A / n / 1 / 45 / 45 / The GIFTED DELIVERY MODEL represents the method by which gifted services are delivered. / Must equal one of the following values:
‘1’ – Resource Model (RM)
‘2’ – Advanced Content (AC)
‘3’ – Cluster Group (CG) Modification
‘4’ – Collaborative Teaching (CT) Modification
‘5’ – Internship/Mentorship
‘6’ – PSO/Joint Enrollment
‘7’ –Approved Innovative Model.
Blank – N/A
GIFTED DELIVERY MODEL was reported. The first digit after the decimal must = ‘2’. / E2530
E233
If the first digit after the decimal is ‘2’, then GIFTED DELIVERY MODEL is required. / E3027
For REPORT TYPE = ‘2’, a reported GIFTED DELIVERY MODEL must be the consistent for the same TEACHER ID and CLASS PERIOD. / E3038

Georgia Department of Education

Dr. John D. Barge, State School Superintendent

September 8, 2011∙• 1:21 PMPage 6 of 6