Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'propertyvalues'

Finance - Property Value (PV)

[propertyvalues]

ID Element Name Type Size Values Cycle

Key

PV0010

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

fy Num 2 Table 9
PV0020

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

9 = August 31st
cycle Num 2 Table 9
PV0030

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,D 9

Property Value Information

PV0050

Appraised Value of all Buildings - The market value of all buildings. Appraised value as of June 30th of each fiscal year.

app_bldgs Dec 15,2 ##############.## 9
PV0060

Appraised Value of all Furniture and Equipment - The market value of all furniture and equipment. Appraised value as of June 30th of each fiscal year.

app_fur_equip Dec 15,2 ##############.## 9
PV0070

Appraised Value of all Real Estate - The market value of all real property. Appraised value as of June 30th of each fiscal year.

app_realest Dec 15,2 ##############.## 9
PV0080

Total Appraised Value - The combined total of the market value of the building, all furniture and equipment, and all real estate (LAND). (Value of Buildings, Furniture, Equipment and Land = TOTAL APPRAISED VALUE)

app_total Dec 15,2 ##############.## 9
PV0090

Total Insurance Carried on Property - The amount of insurance coverage for all real and personal property (Buildings, Furniture, and Equipment). Real Estate (Land) is not insurable...Thus, total insurance will not equal total appraised value.

ins_prop Dec 15,2 ##############.## 9
No change Added Modified Deleted

Back to List