Database Schema for Handbook 2024-2025

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 2024-2025 reporting year fy must be = 35

 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