Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'emp_leave'

Finance - Employee Leave (EL)

[emp_leave]

ID Element Name Type Size Values Cycle

Key

EL0010

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
EL0020

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
EL0030

LEA, District/School/Coop - 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,C,D 2,5,6,8
EL0040

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

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

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

uniq_emp_id Alpha 10 2,5,6,8

General

EL0060

District Employee NumberEmployee number from source table

empl_no Num 9 2,5,6,8
EL0070

LocationThree-digit number LEA number pulled from ‘check location’

emp_location Alpha 3 2,5,6,8
EL0080

Location DescriptionDescription of Location from source

location_desc Alpha 25 2,5,6,8
EL0090

Job CodeNumber 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
EL0100

Leave Value/Unit The unit of leave expressed in:

D = Days
H = Hours
U = District-defined Units
A = Timecard Amount
P = Per Period Rate

leave_unit Alpha 3 2,5,6,8
EL0110

Leave UnitsNumber of Units of Leave taken

leave_time Dec 8,4 2,5,6,8
EL0120

Leave CodeCode indicating type of leave

leave_code Alpha 3 2,5,6,8
EL0130

Leave Description- Description based on Leave Code:

'100' : 'Sick'
'200' : 'Personal'
'300' : 'Vacation'
'400' : 'Bereavement'
'500' : 'School Business'
'600' : 'Professional Development'
'700' : 'Military'
'800' : 'Jury'
'900' : 'LWOP (Leave without Pay)'
'999' : 'Other'

leave_desc Alpha 25 2,5,6,8
EL0140

Pay CodeCode from source table

pay_code Alpha 3 2,5,6,8
EL0150

Pay DescriptionText of “Check Title” (Except for codes 090-097 which are 'LWOP')

pay_desc Alpha 25 2,5,6,8
EL0160

Leave Starting Date

start_date Date 2,5,6,8
EL0170

Leave Ending Date

stop_date Date 2,5,6,8
No change Added Modified Deleted

Back to List