Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'salrang'

Finance - Salary Range (SL)

[salrang]

ID Element Name Type Size Values Cycle

Key

SL0010

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

fy Num 2 Table 1
SL0020

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

1 = September 30th
cycle Num 2 Table 1
SL0030

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 B,D 1
SL0040

Code - Code identifying this salary schedule.

code Alpha 10 1
SL0050

Range - Identifies a single range in a schedule.

range Alpha 10 1

Information - Information pulled for current year salary range.

SL0060

Description - Description of the range for the range and schedule defined in the range field: examples: BS, MA + 15, PHD.

desc Alpha 30 1
SL0070

Step 1 - Incremental Salary.

step_1 Dec 8,2 ######.## 1
SL0071

Step 2 - Incremental Salary.

step_2 Dec 8,2 ######.## 1
SL0072

Step 3 - Incremental Salary.

step_3 Dec 8,2 ######.## 1
SL0073

Step 4 - Incremental Salary.

step_4 Dec 8,2 ######.## 1
SL0074

Step 5 - Incremental Salary.

step_5 Dec 8,2 ######.## 1
SL0075

Step 6 - Incremental Salary.

step_6 Dec 8,2 ######.## 1
SL0076

Step 7 - Incremental Salary.

step_7 Dec 8,2 ######.## 1
SL0077

Step 8 - Incremental Salary.

step_8 Dec 8,2 ######.## 1
SL0078

Step 9 - Incremental Salary.

step_9 Dec 8,2 ######.## 1
SL0079

Step 10 - Incremental Salary.

step_10 Dec 8,2 ######.## 1
SL0080

Step 11 - Incremental Salary.

step_11 Dec 8,2 ######.## 1
SL0081

Step 12 - Incremental Salary.

step_12 Dec 8,2 ######.## 1
SL0082

Step 13 - Incremental Salary.

step_13 Dec 8,2 ######.## 1
SL0083

Step 14 - Incremental Salary.

step_14 Dec 8,2 ######.## 1
SL0084

Step 15 - Incremental Salary.

step_15 Dec 8,2 ######.## 1
SL0085

Step 16 - Incremental Salary.

step_16 Dec 8,2 ######.## 1
SL0086

Step 17 - Incremental Salary.

step_17 Dec 8,2 ######.## 1
SL0087

Step 18 - Incremental Salary.

step_18 Dec 8,2 ######.## 1
SL0088

Step 19 - Incremental Salary.

step_19 Dec 8,2 ######.## 1
SL0089

Step 20 - Incremental Salary.

step_20 Dec 8,2 ######.## 1
SL0090

Step 21 - Incremental Salary.

step_21 Dec 8,2 ######.## 1
SL0091

Step 22 - Incremental Salary.

step_22 Dec 8,2 ######.## 1
SL0092

Step 23 - Incremental Salary.

step_23 Dec 8,2 ######.## 1
SL0093

Step 24 - Incremental Salary.

step_24 Dec 8,2 ######.## 1
SL0094

Step 25 - Incremental Salary.

step_25 Dec 8,2 ######.## 1
SL0095

Step 26 - Incremental Salary.

step_26 Dec 8,2 ######.## 1
SL0096

Step 27 - Incremental Salary.

step_27 Dec 8,2 ######.## 1
SL0097

Step 28 - Incremental Salary.

step_28 Dec 8,2 ######.## 1
SL0098

Step 29 - Incremental Salary.

step_29 Dec 8,2 ######.## 1
SL0099

Step 30 - Incremental Salary.

step_30 Dec 8,2 ######.## 1
SL0100

Step 31 - Incremental Salary.

step_31 Dec 8,2 ######.## 1
SL0101

Step 32 - Incremental Salary.

step_32 Dec 8,2 ######.## 1
SL0102

Step 33 - Incremental Salary.

step_33 Dec 8,2 ######.## 1
SL0103

Step 34 - Incremental Salary.

step_34 Dec 8,2 ######.## 1
SL0104

Step 35 - Incremental Salary.

step_35 Dec 8,2 ######.## 1
SL0105

Step 36 - Incremental Salary.

step_36 Dec 8,2 ######.## 1
SL0106

Step 37 - Incremental Salary.

step_37 Dec 8,2 ######.## 1
SL0107

Step 38 - Incremental Salary.

step_38 Dec 8,2 ######.## 1
SL0108

Step 39 - Incremental Salary.

step_39 Dec 8,2 ######.## 1
SL0109

Step 40 - Incremental Salary.

step_40 Dec 8,2 ######.## 1
SL0110

Step 41 - Incremental Salary.

step_41 Dec 8,2 ######.## 1
SL0111

Step 42 - Incremental Salary.

step_42 Dec 8,2 ######.## 1
SL0112

Step 43 - Incremental Salary.

step_43 Dec 8,2 ######.## 1
SL0113

Step 44 - Incremental Salary.

step_44 Dec 8,2 ######.## 1
SL0114

Step 45 - Incremental Salary.

step_45 Dec 8,2 ######.## 1
SL0115

Step 46 - Incremental Salary.

step_46 Dec 8,2 ######.## 1
SL0116

Step 47 - Incremental Salary.

step_47 Dec 8,2 ######.## 1
SL0117

Step 48 - Incremental Salary.

step_48 Dec 8,2 ######.## 1
SL0118

Step 49 - Incremental Salary.

step_49 Dec 8,2 ######.## 1
SL0119

Step 50 - Incremental Salary.

step_50 Dec 8,2 ######.## 1
SL0120

Step 51 - Incremental Salary.

step_51 Dec 8,2 ######.## 1
SL0121

Step 52 - Incremental Salary.

step_52 Dec 8,2 ######.## 1
SL0122

Step 53 - Incremental Salary.

step_53 Dec 8,2 ######.## 1
SL0123

Step 54 - Incremental Salary.

step_54 Dec 8,2 ######.## 1
SL0124

Step 55 - Incremental Salary.

step_55 Dec 8,2 ######.## 1
SL0125

Step 56 - Incremental Salary.

step_56 Dec 8,2 ######.## 1
SL0126

Step 57 - Incremental Salary.

step_57 Dec 8,2 ######.## 1
SL0127

Step 58 - Incremental Salary.

step_58 Dec 8,2 ######.## 1
SL0128

Step 59 - Incremental Salary.

step_59 Dec 8,2 ######.## 1
SL0129

Step 60 - Incremental Salary.

step_60 Dec 8,2 ######.## 1
SL0130

Step 61 - Incremental Salary.

step_61 Dec 8,2 ######.## 1
SL0131

Step 62 - Incremental Salary.

step_62 Dec 8,2 ######.## 1
SL0132

Step 63 - Incremental Salary.

step_63 Dec 8,2 ######.## 1
SL0133

Step 64 - Incremental Salary.

step_64 Dec 8,2 ######.## 1
SL0134

Step 65 - Incremental Salary.

step_65 Dec 8,2 ######.## 1
SL0135

Step 66 - Incremental Salary.

step_66 Dec 8,2 ######.## 1
SL0136

Step 67 - Incremental Salary.

step_67 Dec 8,2 ######.## 1
SL0137

Step 68 - Incremental Salary.

step_68 Dec 8,2 ######.## 1
SL0138

Step 69 - Incremental Salary.

step_69 Dec 8,2 ######.## 1
SL0139

Step 70 - Incremental Salary.

step_70 Dec 8,2 ######.## 1
SL0140

Step 71 - Incremental Salary.

step_71 Dec 8,2 ######.## 1
SL0141

Step 72 - Incremental Salary.

step_72 Dec 8,2 ######.## 1
SL0142

Step 73 - Incremental Salary.

step_73 Dec 8,2 ######.## 1
SL0143

Step 74 - Incremental Salary.

step_74 Dec 8,2 ######.## 1
SL0144

Step 75 - Incremental Salary.

step_75 Dec 8,2 ######.## 1
SL0145

Step 76 - Incremental Salary.

step_76 Dec 8,2 ######.## 1
SL0146

Step 77 - Incremental Salary.

step_77 Dec 8,2 ######.## 1
SL0147

Step 78 - Incremental Salary.

step_78 Dec 8,2 ######.## 1
SL0148

Step 79 - Incremental Salary.

step_79 Dec 8,2 ######.## 1
SL0149

Step 80 - Incremental Salary.

step_80 Dec 8,2 ######.## 1
SL0150

Step 81 - Incremental Salary.

step_81 Dec 8,2 ######.## 1
SL0151

Step 82 - Incremental Salary.

step_82 Dec 8,2 ######.## 1
SL0152

Step 83 - Incremental Salary.

step_83 Dec 8,2 ######.## 1
SL0153

Step 84 - Incremental Salary.

step_84 Dec 8,2 ######.## 1
SL0155

Step 85 - Incremental Salary.

step_85 Dec 8,2 ######.## 1
SL0156

Step 86 - Incremental Salary.

step_86 Dec 8,2 ######.## 1
SL0157

Step 87 - Incremental Salary.

step_87 Dec 8,2 ######.## 1
SL0158

Step 88 - Incremental Salary.

step_88 Dec 8,2 ######.## 1
SL0159

Step 89 - Incremental Salary.

step_89 Dec 8,2 ######.## 1
SL0160

Step 90 - Incremental Salary.

step_90 Dec 8,2 ######.## 1
SL0161

Step 91 - Incremental Salary.

step_91 Dec 8,2 ######.## 1
SL0162

Step 92 - Incremental Salary.

step_92 Dec 8,2 ######.## 1
SL0163

Step 93 - Incremental Salary.

step_93 Dec 8,2 ######.## 1
SL0164

Step 94 - Incremental Salary.

step_94 Dec 8,2 ######.## 1
SL0165

Step 95 - Incremental Salary.

step_95 Dec 8,2 ######.## 1
SL0166

Step 96 - Incremental Salary.

step_96 Dec 8,2 ######.## 1
SL0167

Step 97 - Incremental Salary.

step_97 Dec 8,2 ######.## 1
SL0168

Step 98 - Incremental Salary.

step_98 Dec 8,2 ######.## 1
SL0169

Step 99 - Incremental Salary.

step_99 Dec 8,2 ######.## 1
No change Added Modified Deleted

Back to List