SIS Handbook | Database Table SchemaFinance - Employee Leave

Main Overview Data Submission Cycles Cycle Reports Data Sources Database Table Schema Previous Table Schema Appendices Handbook Changes Handbook Downloads

Database Schema for Handbook 2024-2025

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 2024-2025 reporting year fy must be = 35	fy	Num	2	Table	2,5,6,8
EL0020	Cycle - The reporting cycle for which the data is submitted: 2 = October 15^th 5 = February 15^th 6 = April 15^th 8 = July 31^st	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, Staff – The nine-digit Social Security number of the staff member being identified.	ssn	Alpha	9	#########	2,5,6,8
EL0050	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
	General
EL0060	District Employee Number – Employee number from source table	empl_no	Num	9		2,5,6,8
EL0070	Location – Three-digit number LEA number pulled from ‘check location’	emp_location	Alpha	3		2,5,6,8
EL0080	Location Description – Description of Location from source	location_desc	Alpha	25		2,5,6,8
EL0090	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
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 Units – Number of Units of Leave taken	leave_time	Dec	8,4		2,5,6,8
EL0120	Leave Code – Code 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 Code – Code from source table	pay_code	Alpha	3		2,5,6,8
EL0150	Pay Description – Text 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