Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'transperson'

BUS - Transportation Personnel (TS)


ID Element Name Type Size Values Cycle



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

fy Num 2 Table 3

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

3 = November 15th
cycle Num 2 Table 3

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:

60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix B 3

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

ssn Alpha 9 ######### 3

Driver Information


State Reporting ID, Staff - The unique 10-digit Triand identifier generated for the teacher by the state.

uniq_emp_id Alpha 10 ######## ## 3

First Name - The driver's first name.

driver_fname Alpha 20 3

Middle Name - The driver's middle name

driver_mname Alpha 15 3

Last Name - The driver's last name

driver_lname Alpha 25 3

CDL Number - Commercial Drivers License Number issued by the Arkansas State Police.

cdl_num Alpha 10 3

CDL Endorsements - Does the driver have a “P” and “S” endorsement on their CDL license?

cdl_endr Alpha 1 Y/N 3

Physical - Indicate date of most recent physical examination given by a licensed physician as required upon acceptance of employment and every two years thereafter.

physical_date Date 8 MMDDYYYY 3

Driver Record - Indicate if driving record has been verified with the office of Drivers Services as required by Arkansas Code Ann. 6-19-107.  This code requires both pre-employment and semi-annual varifications.

driv_rec Alpha 1 Y/N 3

Criminal Background Check - Indicate if criminal background checks on each driver as required by Act 1314 of 1997.

crim_back Alpha 1 Y/N 3

Central Registry Check - Indicates if central registry checks have been completed on each driver after 07-01-2009 as required by law.

cent_reg_chk Alpha 1 Y/N 3

Pre-Employment Drug/Alcohol Test - Indicate if pre-employment drug/alcohol test stated by the Omnibus Transportation Employee Testing Act.

drug_test Alpha 1 Y/N 3

In-Service Training Date- Indicate the date driver attended bus training as required by ADE.

inserv_train Date 8 MMDDYYYY 3
No change Added Modified Deleted

Back to List