Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'empben'

Finance - Employee Benefits (CF)

[empben]

ID Element Name Type Size Values Cycle

Key
CF0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

 fy Num 2 Table 1
CF0020

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

1 = September 30th
 cycle Num 2 Table 1
CF0030

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 C 1
CF0040

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

 ssn Alpha 9 1

General
CF0050

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

uniq_emp_id Alpha 10 1
CF0051

District Employee Number – Employee number from source table

 empl_no Num 10 1

Superintendent/Chief Financial Officer/Business Manager – All salary paid to the employee including unused sick leave. Actual fiscal year (2013/ 14).
CF0060

Employee Title (Fund Code Information) - The title of the person from which the benefit is being paid.

1 = Superintendent
2 = Chief Financial Officer
3 = Business Manager
4 = Assistant Superintendent
5 = Other

 emp_title Num 1 Table 1
CF0070

First - Employee's first name

 fname Alpha 20 1
CF0080

Middle - Employee's middle name

 mname Alpha 15 1
CF0090

Last - Employee's last name

 lname Alpha 25 1
CF0100

Employee Benefits - All payments and services provided employee in addition to salary. This would be benefits that are not available to all employees.

1 = Vehicle Benefit
2 = Housing Benefit
3 = Dental
4 = Health Insurance
5 = LifeDisability
6 = AnnuitiesAdditional Retirement
7 = MembershipProf & Other Dues and Fees
8 = Travel
9 = Other

 emp_benefits Num 2 Table 1
CF0110

Benefit Total - Amount paid annually for employee benefits.

benefit_amt Dec 10,2 ##########.## 1
No change Added Modified Deleted

Back to List