Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'empbasesal'

Finance - Employee Base Salary (BS)

[empbasesal]

ID Element Name Type Size Values Cycle

Key

BS0010

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

fy Num 2 Table 1
BS0020

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

1 = September 30th
cycle Num 2 Table 1
BS0030

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 C 1
BS0040

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

ssn Alpha 9 ######### 1
BS0041

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

uniq_emp_id Alpha 10 1
BS0043

Employee ID Number - The unique 9-digit numeric employee identifier: may or may not be same as social security number without the dashes

emp_id Num 9 1
BS0045

Salary Schedule Code - Corresponds to a specific salary code defined in the salary schedule record.

salsch_code Alpha 10 1

Information - Information pulled is for current year base salary.

BS0050

Class Title - Description of the employees position

class_title Alpha 30 1
BS0060

Contract Days - Number of working days in the contract

cont_days Dec 6 ####.## 1
BS0070

Days Worked - Number of days the employee works in a year

days_worked Dec 6 ####.## 1
BS0110

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

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

salfd Alpha 1 Table 1
BS0120

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.

sof Alpha 3 1
BS0130

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

func Alpha 4 1
BS0140

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

object Alpha 5 1
BS0150

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 1
BS0160

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 1
BS0170

Subject - Subject is the 15th and 16th positions of the 16 digit budget unit.

subject Alpha 2 1
BS0180

Job Rate Flag - There are two rate flags; P (primary rate) or S (secondary rate)

P = Primary Rate
S = Secondary Rate

job_rate_f Alpha 6,4 Table 1
BS0190

Employee Rate - Unique rate number corresponding to the employee; a given employee can have up to 20 rates.

rate_no Num 3 1
BS0200

Job Class Code - A description of the positiontitle a person holds within the district, Example: "Superintendent."

classify Alpha 4 1
BS0210

Percentage - Percentage of the pay amount distributed.

prcent Dec 6,4 ######.#### 1
BS0220

Range - Corresponds to a specific range defined in the salary schedule.

range Alpha 10 1
BS0230

Step - Salary schedule step for the employee rate.

step Num 2 ## 1
BS0240

Base Salary - Salary for range and step.

basesal_amt Dec 10,4 ##########.#### 1
BS0250

Annual Salary - Total contracted salary.

bs_annl_sal Dec 12,4 ############.#### 1
No change Added Modified Deleted

Back to List