Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'vendor'

Finance - Vendor (VE)

[vendor]

ID Element Name Type Size Values Cycle

Key

VE0010

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

fy Num 2 Table 9
VE0020

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

9 = August 31st

 
cycle Num 2 Table 9
VE0030

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 9
VE0040

Vendor Number - The vendor dentification number.

ven_id Alpha 8 9

ID Information

VE0050

Vendor Name - The vendor’s name

ven_name Alpha 35 9

Address, Mailing - The street name and building number or PO box where vendor mail is received.

VE0060

Address One - Vendor’s mailing address line one

addr_1 Alpha 30 9
VE0070

Address Two - Vendor’s mailing address line two

addr_2 Alpha 30 9
VE0080

City - Vendor’s mailing address city

city Alpha 20 9
VE0090

State - Vendor’s mailing address state

state Alpha 2 9
VE0100

Zip - Vendor’s mailing address zip code

zip Num 10 9

General

VE0110

Vendor payment - Year-to-date

paid_ytd Dec 12,2 9
VE0120

Vendor Type - The vendor in this table will be for SIP or nurses.

vendor_type Alpha 8 9
No change Added Modified Deleted

Back to List