Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'empfrinben'

Finance - Employee Fringe Benefits (FN)

[empfrinben]

ID Element Name Type Size Values Cycle

Key
FN0010

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

 fy Num 2 Table 1
FN0020

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

1 = September 30th
 cycle Num 2 Table 1
FN0030

LEA, District/Coop -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. 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,D 1
FN0040

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

 ssn Alpha 9 ######### 1
FN0050

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

uniq_emp_id Alpha 10 1
FN0051

District Employee Number – Employee number from source table

 empl_no Alpha 10 1

Information – Information pulled for current year fringe benefits.
FN0060

Fringe Benefits Title - Description of benefits paid by the district on behalf of employees.

 title Alpha 30 1
FN0070

Fringe Benefit Method - Benefit method:

N (None)
P/A (Percent/AMT from Table)
R/S (Percent/AMT from employee Record)    

 frng_meth Alpha 3 Table 1
FN0080

Fringe Benefit Amount - Amount

 frng_amt Dec 15,4 ###########.#### 1
FN0090

Type - Frequency of payroll cycle.

B = Biweekly
S = Semimonthly
M = Monthly

 type Alpha 1 Table 1
No change Added Modified Deleted

Back to List