Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'schoolboardtraining'

School Board Training (SB)

[schoolboardtraining]

ID Element Name Type Size Values Cycle

Key

SB0010

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

fy Num 2 Table 5
SB0020

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

5 = February 15th
cycle Num 2 Table 5
SB0030

LEA, District/Coop - 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 5
SB0040

First Name - The school board member’s first name.

fname Alpha 25 5
SB0050

Middle Name - The school board member’s middle name.

mname Alpha 25 5
SB0060

Last Name - The school board member’s last name.

lname Alpha 40 5
SB0070

E-Mail Address of the School Board Member - E-mail address used to communicate with school board member.

sbt_email Alpha 40 5
SB0075

Current Year Hours of Training for School Board Members - The school board member’s total hours of training for the current year.

cur_yr_train_hours Dec 5,2 ###.## 5
SB0076

Carry Over Hours of Training for School Board Members -The school board member’s total hours of training carry over from previous years.

carry_yr_train_hours Dec 5,2 ###.## 5
SB0080

Total Hours of Training - The school board member’s total hours of training.

tot_hours_train Dec 5,2 5
SB0090

Latest Modified Row Date - The last time the school board member’s information was updated before Cycle 5.

latest_mod_date Date 8 MMDDYYYY 5
No change Added Modified Deleted

Back to List