Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'act28'

Finance - ACT 28 (AT)

[act28]

ID Element Name Type Size Values Cycle

Key

AT0010

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

fy Num 2 Table 9
AT0020

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

9 = August 31st
cycle Num 2 Table 9
AT0030

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

General ALE

AT0040

Standardized reasons for maintaining an ALE Fund Balance - ALE balance needed for expenditures due prior to October funds distribution.

ale_a Alpha 1 Y/N 9
AT0050

Standardized reasons for maintaining an ALE Fund Balance - Received more funds than budgeted.

ale_b Alpha 1 Y/N 9
AT0060

Standardized reasons for maintaining an ALE Fund Balance - Employee resignations reduced budgeted expenditures.

ale_c Alpha 1 Y/N 9
AT0070

Standardized reasons for maintaining an ALE Fund Balance - Utilized other revenue sources for eligible categorical expenditures.

ale_d Alpha 1 Y/N 9
AT0080

Balance - Balance will be budgeted in the next fiscal year.

ale_e Alpha 1 Y/N 9
AT0090

Standardized reasons for maintaining an ALE Fund Balance - Funds received too late in the fiscal year to fully expend.

ale_f Alpha 1 Y/N 9
AT0100

Standardized reasons for maintaining an ALE Fund Balance - New program to be implemented in the next fiscal year.

ale_g Alpha 1 Y/N 9
AT0110

Standardized reasons for maintaining an ALE Fund Balance - ALE program at Coop.

ale_h Alpha 1 Y/N 9
AT0120

Standardized reasons for maintaining an ALE Fund Balance - ALE program with other districts.

ale_i Alpha 1 Y/N 9
AT0130

Standardized reasons for maintaining an ALE Fund Balance - No ALE program in the next school year.

ale_j Alpha 1 Y/N 9
AT0140

Standardized reasons for maintaining an ALE Fund Balance - Will transfer to another categorical fund next year where it can be spent in accordance with ACSIP.

ale_k Alpha 1 Y/N 9
AT0150

Standardized reasons for maintaining an ALE Fund Balance - To cover salary and benefit increases during the first or second year of the biennium when categorical funds per student did not increase

ale_l Alpha 1 Y/N 9
AT0160

Standardized reasons for maintaining an ALE Fund Balance - None of the above

ale_m Alpha 1 Y/N 9

ELL

AT0170

Standardized reasons for maintaining an ELL Fund Balance - ELL balance needed for expenditures due prior to January funds distribution.

ell_a Alpha 1 Y/N 9
AT0180

Standardized reasons for maintaining an ELL Fund Balance - Received more funds than budgeted.

ell_b Alpha 1 Y/N 9
AT0190

Standardized reasons for maintaining an ELL Fund Balance - Employee resignations reduced budgeted expenditures

ell_c Alpha 1 Y/N 9
AT0200

Standardized reasons for maintaining an ELL Fund Balance - Utilized other revenue sources for eligible categorical expenditures

ell_d Alpha 1 Y/N 9
AT0210

Standardized reasons for maintaining an ELL Fund Balance - Balance will be budgeted in the next fiscal year.

ell_e Alpha 1 Y/N 9
AT0220

Standardized reasons for maintaining an ELL Fund Balance - Funds received too late in the fiscal year to fully expend

ell_f Alpha 1 Y/N 9
AT0230

Standardized reasons for maintaining an ELL Fund Balance - New program to be implemented in the next fiscal year.

ell_g Alpha 1 Y/N 9
AT0240

Standardized reasons for maintaining an ELL Fund Balance - Failed to find qualified staff.

ell_h Alpha 1 Y/N 9
AT0250

Standardized reasons for maintaining an ELL Fund Balance - Federal funds were used in place of state funds.

ell_i Alpha 1 Y/N 9
AT0260

Standardized reasons for maintaining an ELL Fund Balance - Coop program for multiple districts.

ell_j Alpha 1 Y/N 9
AT0270

Standardized reasons for maintaining an ELL Fund Balance - No ELL program in the school year.

ell_k Alpha 1 Y/N 9
AT0280

Standardized reasons for maintaining an ELL Fund Balance - Will transfer to another categorical fund next year where it can be spent in accordance with ACSIP.

ell_l Alpha 1 Y/N 9
AT0290

Standardized reasons for maintaining an ELL Fund Balance - To cover salary and benefit increases during the first or second year of the biennium when categorical funds per student did not increase

ell_m Alpha 1 Y/N 9
AT0300

Standardized reasons for maintaining an ELL Fund Balance - None of the above.

ell_n Alpha 1 Y/N 9

ESA - Enhanced Student Acheivement (formerly NSLA)

AT0310

Standardized reasons for maintaining an ESA Fund Balance - ESA balance needed for expenditures due prior to August funds distribution

esa_a Alpha 1 Y/N 9
AT0320

Standardized reasons for maintaining an ESA Fund Balance - Received more funds than budgeted.

esa_b Alpha 1 Y/N 9
AT0330

Standardized reasons for maintaining an ESA Fund Balance - Employee resignations reduced budgeted expenditures.

esa_c Alpha 1 Y/N 9
AT0340

Standardized reasons for maintaining an ESA Fund Balance - ESA balance needed for expenditures due prior to August funds distribution.

esa_d Alpha 1 Y/N 9
AT0350

Standardized reasons for maintaining an ESA Fund Balance - Balance will be budgeted in the next fiscal year.

esa_e Alpha 1 Y/N 9
AT0360

Standardized reasons for maintaining an ESA Fund Balance - Funds received too late in the fiscal year to fully expend

esa_f Alpha 1 Y/N 9
AT0370

Standardized reasons for maintaining an ESA Fund Balance - New program to be implemented in the next fiscal year.

esa_g Alpha 1 Y/N 9
AT0380

Standardized reasons for maintaining an ESA Fund Balance - Failed to find qualified staff.

esa_h Alpha 1 Y/N 9
AT0390

Standardized reasons for maintaining an ESA Fund Balance - Due to a decline in F&R percentage, balance to be used to transition program.

esa_i Alpha 1 Y/N 9
AT0400

Standardized reasons for maintaining an ESA Fund Balance - Due to fewer students, expended less funds than budgeted.

esa_j Alpha 1 Y/N 9
AT0410

Standardized reasons for maintaining an ESA Fund Balance - Will transfer to another categorical fund next year where it can be spent in accordance with ACSIP.

esa_k Alpha 1 Y/N 9
AT0420

Standardized reasons for maintaining an ESA Fund Balance - To cover salary and benefit increases during the first or second year of the biennium when categorical funds per student did not increase.

esa_l Alpha 1 Y/N 9
AT0430

Standardized reasons for maintaining an ESA Fund Balance - Fully utilize ARRA funds for expenses which might have been covered by ESA since there is a spending deadline for these funds while conserving state and local funds while using the ARRA fund first.

esa_m Alpha 1 Y/N 9
AT0435

Standardized reasons for maintaining an ESA Fund Balance - None of the above.

esa_n Alpha 1 Y/N 9

PD (Professional Development)

AT0440

Standardized reasons for maintaining a Professional Development Fund Balance - PD balance needed for expenditures due prior to August funds distribution.

pd_a Alpha 1 Y/N 9
AT0450

Standardized reasons for maintaining a Professional Development Fund Balance - Received more funds than budgeted.

pd_b Alpha 1 Y/N 9
AT0460

Standardized reasons for maintaining a Professional Development Fund Balance - Employee resignations reduced budgeted expenditures

pd_c Alpha 1 Y/N 9
AT0470

Standardized reasons for maintaining a Professional Development Fund Balance - Utilized other revenue sources for eligible categorical expenditures.

pd_d Alpha 1 Y/N 9
AT0480

Standardized reasons for maintaining a Professional Development Fund Balance - Balance will be budgeted in the next fiscal year.

pd_e Alpha 1 Y/N 9
AT0490

Standardized reasons for maintaining a Professional Development Fund Balance - Funds received too late in the next fiscal year to fully expend.

pd_f Alpha 1 Y/N 9
AT0500

Standardized reasons for maintaining a Professional Development Fund Balance - New program to be implemented in the next fiscal year.

pd_g Alpha 1 Y/N 9
AT0510

Standardized reasons for maintaining a Professional Development Fund Balance - Balance used for summer programs.

pd_h Alpha 1 Y/N 9
AT0530

Standardized reasons for maintaining a Professional Development Fund Balance - Will transfer funds to ALE.

pd_j Alpha 1 Y/N 9
AT0540

Standardized reasons for maintaining a Professional Development Fund Balance - Will transfer funds to ELL

pd_k Alpha 1 Y/N 9
AT0550

Standardized reasons for maintaining a Professional Development Fund Balance - Will transfer funds to ESA.

pd_l Alpha 1 Y/N 9
AT0570

Standardized reasons for maintaining a Professional Development Fund Balance - To cover salary and benefit increases during the first or second year of the biennium when categorical funds per student did not increase.

pd_n Alpha 1 Y/N 9
AT0580

Standardized reasons for maintaining a Professional Development Fund Balance - None of the above.

pd_o Alpha 1 Y/N 9

Legal Balance

AT0590

Standardized reasons for maintaining a Legal Balance Fund Balance - Balance needed for expenditures due prior to August 31 funds distribution.

lb_a Alpha 1 Y/N 9
AT0600

Standardized reasons for maintaining a Legal Balance Fund Balance - Received more funds than budgeted.

lb_b Alpha 1 Y/N 9
AT0620

Standardized reasons for maintaining a Legal Balance Fund Balance - Funds received too late in fiscal year to fully expend.

lb_d Alpha 1 Y/N 9
AT0630

Standardized reasons for maintaining a Legal Balance Fund - New program to be implemented in the next fiscal year.

lb_e Alpha 1 Y/N 9
AT0640

Standardized reasons for maintaining a Legal Balance Fund - Failed to find qualified staff that were budgeted

lb_f Alpha 1 Y/N 9
AT0650

Standardized reasons for maintaining a Legal Balance Fund - Federal funds were used in place of state funds that were budgeted.

lb_g Alpha 1 Y/N 9
AT0660

Standardized reasons for maintaining a Legal Balance Fund - Due to fewer students, expended less funds than budgeted.

lb_h Alpha 1 Y/N 9
AT0670

Standardized reasons for maintaining a Legal Balance Fund - Balance used for summer programs.

lb_i Alpha 1 Y/N 9
AT0680

Standardized reasons for maintaining a Legal Balance Fund - It is prudent to carry over a balance for emergencies.

lb_j Alpha 1 Y/N 9
AT0690

Standardized reasons for maintaining a Legal Balance Fund - Carry over for capital expenditures.

lb_k Alpha 1 Y/N 9
AT0700

Standardized reasons for maintaining a Legal Balance Fund - Carry over for technology purchases

lb_l Alpha 1 Y/N 9
AT0710

Standardized reasons for maintaining a Legal Balance Fund - No Comment.

lb_m Alpha 1 Y/N 9
AT0720

Standardized reasons for maintaining a Legal Balance Fund - Balance is required to pay encumbrances from a prior year.

lb_n Alpha 1 Y/N 9
AT0730

Standardized reasons for maintaining a Legal Balance Fund - A portion of the balance was used to purchase inventory that has not yet been placed into service and is reflected on the balance sheet.

lb_o Alpha 1 Y/N 9
AT0740

Standardized reasons for maintaining a Legal Balance Fund - A portion of the balance includes accounts receivable that has not been collected. The balance should be maintained because of the risk of not collecting the full amount. The timing of collections is another consideration with regard to this item.

lb_p Alpha 1 Y/N 9
AT0750

Standardized reasons for maintaining a Legal Balance Fund - The balance includes various debt service sinking funds obligated to pay debt principal and interest in a future year. Included in these are regular bond issue payments as well as QZAB escrow amounts.

lb_q Alpha 1 Y/N 9
AT0760

Standardized reasons for maintaining a Legal Balance Fund - To ensure continuity of services in future years when funding sources decline, a reasonable balance is required.

lb_r Alpha 1 Y/N 9
AT0770

Standardized reasons for maintaining a Legal Balance Fund - A portion of the balance is designated to cover (a) insurance deductibles (b) unemployment benefits (c) operating fund capital outlay purchases (d) deferred maintenance.

lb_s Alpha 1 Y/N 9
No change Added Modified Deleted

Back to List