Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'act61tierII'

ACT 61 Tier II (AI)

[act61tierII]

ID Element Name Type Size Values Cycle

Key

AI0010

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

fy Num 2 Table 7
AI0020

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

7 = June 15th

cycle Num 2 Table 7
AI0030

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 7
AI0040

Tier II Training - Have the required district employees received 4 hours of Tier II training?

tier_ii_train Alpha 1 Y/N 7
AI0050

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

ssn Alpha 9 ######### 7

General - List Tier II Trainer(s) who had Tier I training and trained district employees.

AI0060

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

uniq_emp_id Alpha 10 ########## 7
AI0070

First Name - Employee first name

fname Alpha 20 7
AI0080

Middle Name - Employee middle name

mname Alpha 15 7
AI0090

Last Name - Employee last name

lname Alpha 25 7

A.C.A. ยง6-20-2204 (Act 61) requires districts to provide Tier II training and to provide assurance of that training to the ADE.

AI0100

Date - Enter the date the Tier II Trainer attended the required Tier I training for the current year

training_date Date MM/DD/YYYY 7
AI0110

List - Is a List of employees who attended the Tier II Training for the current Fiscal year maintained in the district office as required by A.C.A. 6-20-2204(c)?

training_list Alpha 1 Y/N 7
No change Added Modified Deleted

Back to List