Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'jobassgn'

Job Assignment (JA)

[jobassgn]

ID Element Name Type Size Values Cycle

Key

JA0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 2,5,6,8
JA0020

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

2 = October 15th
5 = February 15th
6 = April 15th
8 = July 31st

cycle Num 2 Table 2,5,6,8
JA0030

LEA, District/Coop -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. 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,C 2,5,6,8
JA0040

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

ssn Alpha 9 ######### 2,5,6,8
JA0050

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

uniq_emp_id Alpha 10 2,5,6,8
JA0054

District Employee NumberEmployee number from source table

empl_no Num 9 2,5,6,8
JA0055

Job Code - Number assigned by the ADE to each job assignment performed by a staff person.

job_code Alpha 6 Appendix F,G,I 2,5,6,8

General

JA0060

Paraprofessional Qualification - If the job code is for Classified Personnel (listed below) and the individual works in an instructional capacity with students in a Title I School Wide School or with Title I identified students in a Targeted Assistance School, does the employee meet ESEA paraprofessional qualification standards? Districts are required to have evidence for any of the 'yes' items.

1 = Yes, HQ by passing the Praxis Examination for Paraprofessionals (758, 759, 762, & 763)
2 = Yes, HQ by having sixty (60) college/university hours on a Transcript (758, 759, 762, & 763)
3 = Yes, HQ by having has an Associate's Degree (AA) (758, 759, 762, & 763)
4 = Yes, HQ by having a Bachelor's Degree (BA or BS) (758, 759, 762, & 763)
5 = No, Not a highly qualified paraprofessional (760)
6 = No, In the process of becoming highly qualified paraprofessional (758, 759, 762, & 763)
7 = Yes, HQ by having CDA and only works in the preschool (758, 759, 762, & 763)
8 = Yes, HQ only works in the preschool and has Certificate of Proficiency or Technical Certificate issued by college (758, 759, 762, & 763)

 

paraprof_qual Alpha 1 Table 2,5,6,8
JA0065

Highly Qualified Paraprofessional Duties - Every Paraprofessional with a job code qualifier of 1, 2, 3, 4, 6, 7 or 8 (757, 758, 759, and 762) must have a minimum of 1 duty.

1. Provides one-on-one tutoring
2. Assist with classroom management
3. Assist with instructional materials organization
4. Assist with instruction in the computer lab
5. Provides support with instruction in library or media center
6. Provides other instructional services
7. Serves as translator, bilingual aide or parental involvement professional

paraprof_duty Alpha 6 Table 2,5,6,8
JA0070

FTE - The Full Time Equivalents (FTE) for all classified and certified positions that do not require a student count. The FTE must be greater than 0.00

fte Dec 5,4 #.#### 2,5,6,8
No change Added Modified Deleted

Back to List