Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'empadd_duty'

Finance - Employee Additional Duties (FA)

[empadd_duty]

ID Element Name Type Size Values Cycle

Key

FA0010

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

fy Num 2 Table 1
FA0020

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

1 = September 30th
cycle Num 2 Table 1
FA0030

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
FA0040

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

ssn Alpha 9 ######### 1
FA0045

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

uniq_emp_id Alpha 10 1
FA0047

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
FA0050

Additional Duty - Salary paid in addition to salary schedulerangestep amount.

ad_desc Alpha 30 1

InformationInformation pulled is for current year additional duty salary).

FA0060

Salary - Total amount paid for additional duties.

salary Dec 12,2 ############.## 1
FA0070

FTE - Full-time equivalency percentage entered as a decimal (1.0 = 100%); represents the portion of a full-time position that applies to the additional duty.

fte Dec 9,6 #.###### 1
No change Added Modified Deleted

Back to List