Database Schema for Handbook 2023-2024

Back to List
View Source Document for Table 'salsched'

Finance - Salary Schedule (SA)


ID Element Name Type Size Values Cycle



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

fy Num 2 Table 1

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

1 = September 30th
cycle Num 2 Table 1

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:

60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix B,D 1

Code - Code identifying this salary schedule.

code Alpha 10 1

Information - Information pulled for current year salary schedule.


Description - Description of salary schedule.

desc Alpha 30 1

Hourly or Salary Flag - Schedule type flag:

H (Hourly)
S (Salary)

hs_flag Alpha 1 1

Maximum Number of Steps - Maximum of steps allowed on the schedule.

max_step Num 2 ## 1

Number of Ranges - Number of ranges with this schedule.

num_ranges Num 3 ### 1

Days Worked - Number of contract days in the employee's contract year.

days_worked Dec 6,2 ####.## 1

Hours Per Day - Hours per day employee will work under this schedule.

hours_day Dec 6,2 ####.## 1
No change Added Modified Deleted

Back to List