Database Schema for Handbook 2021-2022

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 2021-2022 reporting year fy must be = 32

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 NumberEmployee number from source table

empl_no Num 10 1

Superintendent/Chief Financial Officer/Business ManagerAll 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