Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'SalFTE'

Finance - Salaries and FTE (CC)

[SalFTE]

ID Element Name Type Size Values Cycle

Key

CC0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 8
CC0020

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

8 = July 31st
cycle Num 2 Table 8
CC0030

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 BD 8
CC0040

Reference Number - Enter the reference code from appendix J for the appropriate personnel.

page Alpha 4 Appendix J 8
CC0050

Classification Type - Enter the reference code from the table below for the appropriate personnel.

C= ClassifiedCertified Personnel
A= ClassifiedCertified Adult Education

type Alpha 1 Table 8

Personnel Paid from Operating – General Fund/Source of Fund 2001-2099, 2200-2999

CC0060

Male FTE - Total FTE for male personnel paid from the General Operating Fund.

male_fte_opr_gen Dec 10,4 ####.## 8
CC0070

Male Salary - Total salaries for male personnel paid from the General Operating Fund.

male_sal_opr_gen Dec 16,2 ##############.## 8
CC0080

Female FTE - Total FTE for female personnel paid from the General Operating Fund.

female_fte_opr_gen Dec 10,4 ####.## 8
CC0090

Female Salary - Total salaries for female personnel paid from the General Operating Fund.

female_sal_opr_gen Dec 16,2 ##############.## 8
CC0100

Total FTE - Total FTE for male & female personnel paid from the General Operating Fund.

tot_fte_opr_gen Dec 10,4 ##############.## 8
CC0110

Total Salary - Total salaries for male & female personnel paid from the General Operating Fund

tot_sal_opr_gen Dec 16,2 ##############.## 8

Personnel Paid from the School Food Funds

CC0120

Male FTE - Total FTE for male personnel paid from the Food Service Fund.

male_fte_schfd Dec 10,4 ####.## 8
CC0130

Male Salary - Total salaries for male personnel paid from the Food Service Fund.

male_sal_schfd Dec 16,2 ##############.## 8
CC0140

Female FTE - Total FTE for female personnel paid from the Food Service Fund.

female_fte_schfd Dec 10,4 ####.## 8
CC0150

Female Salary - Total salaries for female personnel paid from the Food Service Fund.

female_sal_schfd Dec 16,2 ##############.## 8
CC0160

Total FTE - Total FTE for male & female personnel paid from the Food Service Fund.

tot_fte_schfd Dec 10,4 ##############.## 8
CC0170

Total Salary - Total salaries for male & female personnel paid from the Food Service Fund

tot_sal_schfd Dec 16,2 ##############.## 8

Personnel Paid from the Salary Funds – General Fund/Source of Fund 1001 -1099 and 1200-1999

CC0180

Male FTE - Total FTE for male personnel paid from the General Salary Fund.

male_fte_sal_gen Dec 10,4 ####.## 8
CC0190

Male Salary - Total salaries for male personnel paid from the General Salary Fund.

male_sal_sal_gen Dec 16,2 ##############.## 8
CC0200

Female FTE - Total FTE for female personnel paid from the General Salary Fund.

female_fte_sal_gen Dec 10,4 ####.## 8
CC0210

Female Salary - Total salaries for female personnel paid from the General Salary Fund.

female_sal_sal_gen Dec 16,2 ##############.## 8
CC0220

Total FTE - Total FTE for male & female personnel paid from the General Salary Fund.

tot_fte_sal_gen Dec 10,4 ##############.## 8
CC0230

Total Salary - Total salaries for male & female personnel paid from the General Salary Fund

tot_sal_sal_gen Dec 16,2 ##############.## 8

Personnel Paid from the Federal Grant Funds

CC0240

Male FTE - Total FTE for male personnel paid from the Federal Grants Fund.

male_fte_fed Dec 10,4 ####.## 8
CC0250

Male Salary - Total salaries for male personnel paid from the Federal Grants Fund.

male_sal_fed Dec 16,2 ##############.## 8
CC0260

Female FTE - Total FTE for female personnel paid from the Federal Grants Fund.

female_fte_fed Dec 10,4 ####.## 8
CC0270

Female Salary - Total salaries for female personnel paid from the Federal Grants Fund.

female_sal_fed Dec 16,2 ##############.## 8
CC0280

Total FTE - Total FTE for male & female personnel paid from the Federal Grants Fund.

tot_fte_fed Dec 10,4 ##############.## 8
CC0290

Total Salary - Total salaries for male & female personnel paid from the Federal Grants Fund

tot_sal_fed Dec 16,2 ##############.## 8

Personnel Paid from Operating – Matrix Fund/Source of Fund 2000, 2100-2199

CC0300

Male FTE - Total FTE for male personnel paid from the Matrix Operating Fund.

male_fte_opr_mat Dec 10,4 ####.## 8
CC0310

Male Salary - Total salaries for male personnel paid from the Matrix Operating Fund.

male_sal_opr_mat Dec 16,2 ##############.## 8
CC0320

Female FTE - Total FTE for female personnel paid from the Matrix Operating Fund.

female_fte_opr_mat Dec 10,4 ####.## 8
CC0330

Female Salary - Total salaries for female personnel paid from the Matrix Operating Fund.

female_sal_opr_mat Dec 16,2 ##############.## 8
CC0340

Total FTE - Total FTE for male & female personnel paid from the Matrix Operating Fund.

tot_fte_opr_mat Dec 10,4 ##############.## 8
CC0350

Total Salary - Total salaries for male & female personnel paid from the Matrix Operating Fund

tot_sal_opr_mat Dec 16,2 ##############.## 8

Personnel Paid from the Salary Funds – Matrix Fund/Source of Fund 1000, 1100-1199

CC0370

Male FTE - Total FTE for male personnel paid from the Matrix Salary Fund.

male_fte_sal_mat Dec 10,4 ####.## 8
CC0380

Male Salary - Total salaries for male personnel paid from the Matrix Salary Fund.

male_sal_sal_mat Dec 16,2 ##############.## 8
CC0390

Female FTE - Total FTE for female personnel paid from the Matrix Salary Fund.

female_fte_sal_mat Dec 10,4 ####.## 8
CC0400

Female Salary - Total salaries for female personnel paid from the Matrix Salary Fund.

female_sal_sal_mat Dec 16,2 ##############.## 8
CC0410

Total FTE - Total FTE for male & female personnel paid from the Matrix Salary Fund.

tot_fte_sal_mat Dec 10,4 ##############.## 8
CC0420

Total Salary - Total salaries for male & female personnel paid from the Matrix Salary Fund.

tot_sal_sal_mat Dec 16,2 ##############.## 8
No change Added Modified Deleted

Back to List