Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'act61'

ACT 61 (AC)

[act61]

ID Element Name Type Size Values Cycle

Key

AC0010

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

fy Num 2 Table 4
AC0020

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

4 = December 15th
cycle Num 2 Table 4
AC0030

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 4
AC0040

SSN, Staff - The nine-digit Social Security number of the staff member being identified.

ssn Alpha 9 ######### 4

General

AC0045

Unique Employee ID - The unique 10-digit Triand identifier generated for the employee by the state.

uniq_emp_id Alpha 10 ########## 4
AC0050

First Name - Employee first name

fname Alpha 20 4
AC0060

Middle Name - Employee middle name

mname Alpha 15 4
AC0070

Last Name - Employee last name

lname Alpha 25 4
AC0080

Title - Position person holds within the district, Example: "Superintendent."

title Alpha 30 4
AC0090

Course Name - Act 61 training course.

course Alpha 20 4
AC0100

Date - Date the course was taken.

date Date MM/DD/YYYY 4
AC0110

Sponsor - Sponsor of the course:

0) NO DATA
1) COOP
2) ADE
3) AASBO
4) AAEA
5) OTHER
sponsor Alpha 1 Table 4
AC0130

Hours - Number of hours received from the course.

num_hrs Dec 5,2 ###.## 4
AC0140

Initial or Annual Training - Indicate if training received was initial or annual.

A = Annual
I = Initial
train_type Alpha 1 Table 4
No change Added Modified Deleted

Back to List