Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'salsched'

Finance - Salary Schedule (SA)

[salsched]

ID Element Name Type Size Values Cycle

Key

SA0010

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

fy Num 2 Table 1
SA0020

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

1 = September 30th
cycle Num 2 Table 1
SA0030

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
SA0040

Code - Code identifying this salary schedule.

code Alpha 10 1

Information - Information pulled for current year salary schedule.

SA0050

Description - Description of salary schedule.

desc Alpha 30 1
SA0060

Hourly or Salary Flag - Schedule type flag:

H (Hourly)
S (Salary)

hs_flag Alpha 1 1
SA0070

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

max_step Num 2 ## 1
SA0080

Number of Ranges - Number of ranges with this schedule.

num_ranges Num 3 ### 1
SA0090

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

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

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