Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'bldglosses'

Finance - Building Loss (BL)

[bldglosses]

ID Element Name Type Size Values Cycle

Key

BL0010

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

fy Num 2 Table 9
BL0020

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

9 = August 31st
cycle Num 2 Table 9
BL0030

LEA, District/Coop -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. 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 BD 9
BL0040

Identification Number - (Unique number to be incremented for multiple entries).

id_no Alpha 2 9

Building Loss Information

BL0050

Date of Loss - The day the building incurred the damage.

loss_date Date 8 MMDDYYYY 9
BL0060

Type of School - The classification of the school building - elementary, middle, junior high or high school.

type_sch Alpha 15 9
BL0070

Type of Construction - The type of structure.

type_const Alpha 15 9
BL0080

Reason for Loss - The reason for damage to the property.

loss_reason Alpha 15 9
BL0090

Estimated Loss - The estimated amount of damage to the building.

loss_estim Dec 15 ##############.## 9
BL0100

Insurance Coverage - The amount of insurance coverage on the property.

ins_coverage Dec 15 ##############.## 9
No change Added Modified Deleted

Back to List