Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'financegen'

Finance - General Ledger (FG)

[financegen]

ID Element Name Type Size Values Cycle

Key

FG0010

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

fy Num 2 Table 1,9
FG0020

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

1 = September 30th
9 = August 31st
cycle Num 2 Table 1,9
FG0030

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

Budget Unit

FG0040

Fund - A one-digit number that is the first digit in the 16 digit budget unit from 1-8 that represents the set of self-balancing accounts for each of the eight fund classifications of teacher salary fund, operating fund, building fund, debt service fund, capital outlay fund, federal grants fund, activity fund, and food service fund.

1=Teacher Salary Fund
2=Operating Fund
3=Building Fund
4=Debt Service Fund
5=Capital OutlayDedicated M&O
6=Federal Grants Fund
7=Activity Fund
8=Food Service Fund

fund Alpha 1 Table 1,9
FG0050

Source of Funds - A three-digit number that is the second, third and fourth digits in the 16 digit budget unit that is assigned to restricted revenues to enable the revenues and expenditures to be accounted for by the specific revenue source.

sof Alpha 3 1,9
FG0080

Object - A five digit account code that is used to describe the assets, liabilities, reserves and fund balance of a fund. Listed below are the code ranges for the program.

((g.account >= 01000 AND g.account <= 01059) OR
(g.account >= 01110 AND g.account <= 01129) OR
(g.account >= 06000 AND g.account <= 07999) OR
(g.account >= 01230 AND g.account <= 01510) OR
(g.account >= 01580 AND g.account <= 01680) OR
(g.account >= 01850 AND g.account <= 01930) OR
(g.account = 01140) OR
(g.account = 01220) OR
(g.account = 01180) OR
(g.account = 01210) OR
(g.account = 01215) OR
(g.account = 01530) OR
(g.account = 01710) OR
(g.account = 01720) OR
(g.account = 01810) OR
(g.account = 02110) OR
(g.account = 02210) OR
(g.account = 02220) OR
(g.account = 02310) OR
(g.account = 02320) OR
(g.account = 02410) OR
(g.account = 02420) OR
(g.account = 02510) OR
(g.account = 02520) OR
(g.account = 02710) OR
(g.account BETWEEN "04000" AND "05120"))

object Alpha 5 1,9
FG0100

Location - A three-digit number that is the ninth, tenth and eleventh digits in the 16 digit budget unit that describes the building receiving the benefit of the transaction and is determined by the last three digits of the building LEA number.

location Alpha 3 AppendixC 1,9

Disbursement

FG0120

Amount Balance - The amount calculated for the prior year with the account ranges 06000-07999 and leaving out the objects designated as fund balance, expenditure control, revenue control, expenditure budget control and revenue budget control.

amt_bal Dec 15,2 ##############.## 9
FG0140

Amount of Budget - The amount calculated for the current fiscal year with the account ranges 06000-07999 and leaving out the objects designated as fund balance, expenditure control, revenue control, expenditure budget control and revenue budget control.

amt_bud Dec 15,2 ##############.## 1
No change Added Modified Deleted

Back to List