Database Schema for Handbook 2021-2022

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 2021-2022 reporting year fy must be = 32

fy Num 2 Table 1-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-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-9
CO0040

Coordinator Code - Type of coordinator:

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 = AP Coordinators
9 = Triand Primary Contact in SIS
A = ALE Contact Person
B = Bus Inspector
C = Test Coordinator
D = Safe and Drug-Free Schools (SDFS) Coordinator
E = Treasurer
F = SIS eFinancePlus Coordinator for Cycles 1, 8, 9
G = General Business Manager (Act 1591 of 2007)
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)
N = Equity Assistance Coordinator (A.C.A. 6-17-1902)
O = English for Speakers of Other Languages Coor.
P = Principal or School Administrator
R = Child Nutrition Manager
S = SIS eSchoolPlus Coordinator for Cycles 2 thru 7
SN = School Nurse
T = Technology Coordinator
U = Superintendent
V = Family Engagement Facilitator (School)
W = SPED Supervisor/Early Childhood Coordinator
X = Assistant Superintendent
Y = Family Engagaement Coordinator (District)
Z = CTE Coordinator for COOPs and regular school districts.  (Not for Open Enrollment Charters)
0 =   Facilities / Maintenance Director
coor_code Alpha 2 1-9, A-Z 1-9

General

CO0050

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

ssn Alpha 9 ######### 1-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-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-9
CO0070

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

admin_prefix Alpha 4 1-9
CO0075

First Name - Coordinator's first name

fname Alpha 20 1-9
CO0080

Middle Name - Coordinator's middle name

mname Alpha 15 1-9
CO0085

Last Name - Coordinator's last name

lname Alpha 25 1-9
CO0090

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

admin_suffix Alpha 3 1-9
CO0100

Address - Coordinator's address

addr Alpha 30 1-9
CO0105

City - Coordinator's city

city Alpha 20 1-9
CO0110

State - Coordinator's state

state Alpha 2 AR 1-9
CO0115

Zip - Coordinator's zip code

zip Num 5 1-9
CO0120

Zip-4 - Coordinator's extended zip code

zip4 Num 4 1-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-9

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

CO0140

Area Code - Coordinator's telephone area code

work_area Alpha 3 1-9
CO0145

Prefix - Coordinator's telephone prefix

work_prefix Alpha 3 1-9
CO0150

Suffix - Coordinator's telephone suffix

work_suffix Alpha 4 1-9
CO0155

Extension - Coordinator's telephone extension

work_ext Alpha 5 1-9

Fax Phone Number The Office fax number of the Coordinator.

CO0165

Area Code - Coordinator's fax area code

fax_area Alpha 3 1-9
CO0170

Prefix - Coordinator's fax prefix

fax_prefix Alpha 3 1-9
CO0175

Suffix - Coordinator's fax suffix

fax_suffix Alpha 4 1-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-9
CO0190

Prefix - Coordinator's cell prefix

mobile_prefix Alpha 3 1-9
CO0195

Suffix - Coordinator's cell suffix

mobile_suffix Alpha 4 1-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-9
No change Added Modified Deleted

Back to List