Back to List
View Source Document for Table 'emp_leave'
Fiscal Year - The fiscal year that this reporting represents:For the 2021-2022 reporting year fy must be = 32
Cycle - The reporting cycle for which the data is submitted:
2 = October 15th5 = February 15th6 = April 15th8 = July 31st
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:
SSN, Staff – The nine-digit Social Security number of the staff member being identified.
State Reporting ID, Staff – The unique 10-digit Triand identifier generated for the teacher by the state.
District Employee Number – Employee number from source table
Location – Three-digit number LEA number pulled from ‘check location’
Location Description – Description of Location from source
Job Code – Number assigned by the ADE to each job assignment performed by a staff person
Leave Value/Unit – The unit of leave expressed in:
D = Days H = Hours U = District-defined UnitsA = Timecard AmountP = Per Period Rate
Leave Units – Number of Units of Leave taken
Leave Code – Code indicating type of leave
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'
Pay Code – Code from source table
Pay Description – Text of “Check Title” (Except for codes 090-097 which are 'LWOP')
Leave Starting Date
Leave Ending Date
Back to List