Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'contactPerson'

Contact Persons (CO)

[contactPerson]

ID Element Name Type Size Values Cycle

Key
CO0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

 fy Num 2 Table 1,2,3,4,5,6,7,8,9
CO0020

Cycle – The reporting cycle for which the data is submitted:

1 = September 30th

2 = October 15th                         

3 = November 15th

4 = December 15th           

5 = February 15th

6 = April 15th     

7 = June 15th

8 = July 31st  

9 = August 31st

 
cycle Num 2 Table 1,2,3,4,5,6,7,8,9
CO0030

LEA, District - Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001000
60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
 lea Alpha 7 Appendix B 1,2,3,4,5,6,7,8,9
CO0040

Coordinator Code - Type of coordinator:

0 = Facilities / Maintenance Director
1 = Federal Program Coordinator
2 = Gifted & Talented Coordinator
3 = Title III Federal Grant Coordinator
4 = Curriculum Coordinator
5 = Section 504 Coord (Rehabilitation Act of 1973)
6 = Bookkeeper
7 = School Counselor
8 = Advanced Placement® District Coordinator
8S = Advanced Placement® School Coordinator.
9 = Triand Primary Contact in SIS
A = Alternative Education (ALE) Contact Person
AP = Assistant Principal
B – Bus Inspector
C = Test Coordinator
CO - Communications Manger / Director (District)
D = Safe and Drug-Free Schools (SDFS) Coordinator
DS = Data Steward for Duplicate Enrollment, ACGRS, ACE, Notice Of Intent to Homeschool
E = Treasurer
ES = Effectiveness System Coordinator (District Only)
F = SIS eFinancePlus Coordinator for Cycles 1, 8, 9
G = General Business Manager (Act 1591 of 2007)
GO = General Observer (EES - Optional)
H = Liaison for Homeless Coordinator
I = Title VI Coordinator (Civil Rights Act of 1964)
J = Child Nutrition Director
K = Techstart Coordinator/Contact Name
L = Foster Care Liaison Coordinator
M = Title IX Coordinator (Educ. Amendments of 1972)
MC = Mentoring Point of Contact (District)
N = Equity Assistance Coordinator (A.C.A. 6-17-1902)
O = English for Speakers of Other Languages Coor.
P = Principal or School Administrator
PA = Visual and Performing Arts Coordinator
PS = Pre-AP® School Coordinator
PD = Pre-AP® District Coordinator
R = Child Nutrition Manager
RR = Mentoring Program Specialist (COOPs only)
S = SIS eSchoolPlus Coordinator for Cycles 2 thru 7
SO = School Safety Coordinator
SL = School Library Media Specialists
SN = School Nurse
T = Technology Coordinator
TC = Teacher Center Coordinator (COOPs only)
U = Superintendent
V = Family Engagement Facilitator (School)
W = SPED Supervisor/Early Childhood Coordinator
WC - Wellness Committee Chairperson 
X = Assistant Superintendent
Y = Family Engagement Coordinator (District)
Z = CTE Coordinator for COOPs and regular school districts.  (Not for Open Enrollment Charters)
 coor_code Alpha 2 0 - ZZ 1,2,3,4,5,6,7,8,9

General
CO0050

SSN, Staff - The nine-digit Social Security number of the staff member being identified.

 ssn Alpha 9 ######### 1,2,3,4,5,6,7,8,9
CO0060

State Reporting ID, Staff - The unique 10-digit Triand identifier generated for the teacher by the state.

 uniq_emp_id Alpha 10 ########## 1,2,3,4,5,6,7,8,9
CO0065

Coordinator's Position Title - The position and/or title of the person responsible for submission of the Annual Equity Compliance Report.

 coord_pos Alpha 30 1,2,3,4,5,6,7,8,9
CO0070

Coordinator Prefix - The formal salutatory name prefix including period if applicable. (Dr.)

 admin_prefix Alpha 4 1,2,3,4,5,6,7,8,9
CO0075

First Name - Coordinator's first name

 fname Alpha 20 1,2,3,4,5,6,7,8,9
CO0080

Middle Name - Coordinator's middle name

 mname Alpha 15 1,2,3,4,5,6,7,8,9
CO0085

Last Name - Coordinator's last name

 lname Alpha 25 1,2,3,4,5,6,7,8,9
CO0090

Coordinator Suffix - The formal name extension period if applicable. (Jr., III)

 admin_suffix Alpha 3 1,2,3,4,5,6,7,8,9
CO0100

Address - Coordinator's address

 addr Alpha 30 1,2,3,4,5,6,7,8,9
CO0105

City - Coordinator's city

 city Alpha 20 1,2,3,4,5,6,7,8,9
CO0110

State - Coordinator's state

 state Alpha 2 AR 1,2,3,4,5,6,7,8,9
CO0115

Zip - Coordinator's zip code

 zip Num 5 1,2,3,4,5,6,7,8,9
CO0120

Zip-4 - Coordinator's extended zip code

 zip4 Num 4 1,2,3,4,5,6,7,8,9
CO0130

General Business Manager's Job Qualifications:

C = Meets CASBO requirements
E = Enrolled in CASBO Courses
X = Exempt from Requirements - Hired prior to July 31, 2007
 job_qual Alpha 1 1,2,3,4,5,6,7,8,9

Work Phone Number – The office phone number of the Coordinator.
CO0140

Area Code - Coordinator's telephone area code

 work_area Alpha 3 1,2,3,4,5,6,7,8,9
CO0145

Prefix - Coordinator's telephone prefix

 work_prefix Alpha 3 1,2,3,4,5,6,7,8,9
CO0150

Suffix - Coordinator's telephone suffix

 work_suffix Alpha 4 1,2,3,4,5,6,7,8,9
CO0155

Extension - Coordinator's telephone extension

 work_ext Alpha 5 1,2,3,4,5,6,7,8,9

Fax Phone Number – The Office fax number of the Coordinator.
CO0165

Area Code - Coordinator's fax area code

fax_area Alpha 3 1,2,3,4,5,6,7,8,9
CO0170

Prefix - Coordinator's fax prefix

fax_prefix Alpha 3 1,2,3,4,5,6,7,8,9
CO0175

Suffix - Coordinator's fax suffix

fax_suffix Alpha 4 1,2,3,4,5,6,7,8,9

Mobile/Cell Phone Number – The mobile or cell phone number of the Coordinator.
CO0185

Area Code - Coordinator's cell area code

mobile_area Alpha 3 1,2,3,4,5,6,7,8,9
CO0190

Prefix - Coordinator's cell prefix

mobile_prefix Alpha 3 1,2,3,4,5,6,7,8,9
CO0195

Suffix - Coordinator's cell suffix

mobile_suffix Alpha 4 1,2,3,4,5,6,7,8,9

E-Mail Address for Correspondence
CO0245

E-Mail Address of the Coordinator - E-mail address used to communicate with the Department of Education.

 coor_email Alpha 40 1,2,3,4,5,6,7,8,9
No change Added Modified Deleted

Back to List