Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'underpayments'

Finance - Underpayments (UP)

[underpayments]

ID Element Name Type Size Values Cycle

Key

UP0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2024-2025 reporting year fy must be = 35

fy Num 2 Table 8
UP0020

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

8 = July 31st
cycle Num 2 Table 8
UP0030

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 8

Underpayments to certified personnel:

UP0040

Underpayment Fiscal Year - Enter the fiscal year for which the underpayment was paid.

underpymt_yr Alpha 4 8
UP0050

SSN, Staff - The nine-digit Social Security number of the staff member being identified

ssn Alpha 9 8
UP0055

State Reporting ID, Staff - The unique 10-digit Triand identifier generated for the teacher by the state

uniq_emp_id Alpha 10 ########## 8
UP0056

District Employee NumberEmployee number from source table

empl_no Num 9 8
UP0060

Employee Salary Fund (Budget Unit Information) - The fund code from which the salary is being paid.

1 = Teacher Salary
2 = Operating
3 = Building
6 = Federal
7 = Activity
8 = Food Service

emp_salfd Alpha 1 Table 8
UP0062

Source of Funds (Budget Unit Information) - 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

emp_sof Alpha 3 8
UP0065

Function - A four-digit number that is the fifth, sixth, seventh and eighth digits in the 16-digit budget unit that describes an activity being performed when a service is provided or goods are received.

emp_func Alpha 4 8
UP0068

Object - A five-digit account code that is used to describe the service or commodity received as a result of the expenditure.

emp_object Alpha 5 8
UP0069

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

emp_location Alpha 3 8
UP0075

Program Code - A program is a plan of activities and procedures designed to accomplish a predetermined objective or set of objectives. Nine broad program areas are identified in the Financial Handbook: regular education, special education, vocational education, other instructional (PK-12), non-public school, adultcontinuing education, communityjunior college education, community services and enterprise. The program dimension allows agencies to charge program costs, instructional and support, directly to the benefiting program. For example, special education transportation costs are classified to the support services function, transportation, even though they should be charged directly to the special education program.

prog_code Alpha 3 8

General

UP0080

Underpayment Amount - The actual total amount paid for each prior fiscal year underpayment

underpymt_amt Dec 15,2 ###############.## 8
No change Added Modified Deleted

Back to List