Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'transperson'

BUS - Transportation Personnel (TS)

[transperson]

ID Element Name Type Size Values Cycle

Key

TS0010

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

fy Num 2 Table 3
TS0020

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

3 = November 15th
cycle Num 2 Table 3
TS0030

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 3
TS0035

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

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

Driver Information

TS0038

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

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

First Name - The driver's first name.

driver_fname Alpha 20 3
TS0050

Middle Name - The driver's middle name

driver_mname Alpha 15 3
TS0060

Last Name - The driver's last name

driver_lname Alpha 25 3
TS0070

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

cdl_num Alpha 10 3
TS0075

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

cdl_endr Alpha 1 Y/N 3
TS0080

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
TS0090

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
TS0100

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
TS0104

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
TS0110

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
TS0120

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