Classified Staff Accounting Report

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

• All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Select Staff

Indicate which staff members to include in the report by selecting one of the following options:

• The selected [number] staff only – Run the report for a selected group of staff members.

• All staff – Run the report for all staff members in the current school or district that meet the selection criteria.

Snapshot Date

A snapshot of the information is generated based on the specified snapshot date.

Field #

Data Element

Description

[Table]Field

Field Type

Field Length

*R/O/C

1

DistrictID

The unique district state ID number.

[Prefs]value where [Prefs]name = DistrictNumber

String

9

R

2

SchoolID

The unique school code as assigned by DEED. If a staff member works at more than one school, the member is listed in each appropriate school with the corresponding FTE (his/her total FTE must not be greater than 100).

[S_AK_USR_Assignments_C]SchoolID

If the above is blank then:

[Users]HomeSchoolID

String

30

R

3

LastName

The last name of the employee.

[Users]Last_Name

String

30

R

4

FirstName

The first name of the employee.

[Users]First_Name

String

30

R

5

MiddleName

Employee’s middle name or middle initial.

[Users]Middle_Name

String

30

O

6

SSN

The social security number of the employee. This must match the SSN submitted to Teacher Certification. No dashes are displayed.

[Users]SSN

Note: make sure to strip out the hyphens if they exist.

String

50

R

7

BirthDate

The date of birth of the employee. This must match the date of birth submitted to Teacher Certification.

Format - MM/DD/YY or MM/DD/YYYY

[Users]DOB

String

2

R

8

Gender

The gender of the employee.

[Users]Gender

String

5

R

9

Race

The racial or ethnic background of the employee.

Valid values:

1. White (Caucasian)

2. African American

3. Hispanic

4. Asian

5. American Indian

6. Alaska Native

7. Two or more races

8. Native Hawaiian or Pacific Islander

[Users]Ethnicity

String

4

O

10

HireDate

The date of which the employee was hired by the district.

[S_AK_USR_X]HireDate

Note: If a teacher had been on a leave of absence and has returned to their position, use the date the teacher was employed by district prior to the leave of absence as the date of hire.

String

10

R

11

JobResponsibility

Appropriate job from the Job Description Code. If a staff member has more than one job responsibility, all appropriate job codes and the corresponding FTE are included.

[S_AK_USR_Asignment_C]JobCode

Text

2

R

12

HiredForSPED

Used for following job codes to determine if staff member was employed or contracted to provide special education and related services.

• Counselors (11),

• Nurses (20),

• Psychologists (24),

• Speech Therapists (26),

• Physical Therapists (27),

• Occupational Therapists (28),

• Audiologists (29),

• Recreational Therapists (30),

• Orientation and Mobility Specialists (33)

• Social Worker (73)

The report displays an “X” if the employee does not work in any of the job codes listed above.

[S_AK_USR_Asignment_C]HiredForSpEd

Varchar

1

R

13

TitleI

This is used to identify if this person is a Title I instructional paraprofessional. In a Title I schoolwide school, ALL instructional paraprofessionals are Title I.  In a Title I targeted assistance school, only the instructional paraprofessionals paid in whole or in part by Title I are considered Title I paraprofessionals.

Valid values:

• Y - Yes

• N - No

• X - Not applicable (is not an instructional paraprofessional or is a classified employee) 

[S_AK_USR_X]TitleIParaProf

Varchar2(1)

1

R

14

Title I Hire Date

The date on which this instructional paraprofessional employee was hired into a Title I program. This may or may not be the same date as the Date of Hire as a paraprofessional. If this person is not Title I, the report displays a blank.

Format:  MM/DD/YY or MM/DD/YYYY

[S_AK_USR_X]TitleIHireDate

Date

C

15

HSDiploma

Indicates if an instructional paraprofessional has a high school diploma or a recognized equivalent (such as a GED).

Valid values:

• Y - Yes

• N - No

• X - Not applicable (non-instructional paraprofessional only)

S_AK_USR_X]HSDiploma

Varchar2(1)

1

C

16

SPEDAide

Indicates if the staff is a special education paraprofessional?

Valid values:

• Y - Yes

• N - No

• X - Not applicable (is not a paraprofessional or is a classified employee) 

[S_AK_USR_ASSIGNMENTS_C]SPEDAide

Varchar2(1)

1

R

17

SPEDAide3-5

Does this special education aide paraprofessional work primarily with children 3-5 not in kindergarten?

• Y - Yes

• N - No

• X - Not applicable (is a classified employee OR is not a Special Education Aide) 

[S_AK_USR_ASSIGNMENTS_C]SPEDAide35

Varchar2(1)

1

R

18

MinQuals

Used for instructional paraprofessionals to identify the minimum qualifications met using the following codes. Must be completed for all instructional paraprofessionals in a Title I schoolwide school and all those paid with Title I funds in a targeted assistance school.

Valid values:

• 1 - Holds an associate degree (or higher)

• 2 - Has earned two years of college credit (48 semester hour credits)

• 3 - Has passed the Paraprofessional Standard Checklist and the Parapro (or HELP) test.

• 6 - On a paraprofessional plan

• 9 - None of the above

• X - Not applicable / Non instructional paraprofessional 

[S_AK_USR_X.MinQua]

String

2

R

19

FTE

This is the FTE for each job code and teacher assignment reported in whole numbers. The total FTE for each staff cannot exceed 100. An FTE of 100 is a full-time staff member and an FTE of 50 is a half-time staff.

[S_AK_USR_Asignment_C]FTE

String

30

R

20

FederallyFundedFTE

This is the Federal funding source, if applicable, for the FTE for this position:

Valid values:

• 1 - Title I-A, Targeted and Schoolwide Program

• 2 - Title II-A, Teacher & Principal Training & Class-Size Reduction

• 3 - Title III-A, Language Instruction for Limited English Proficient Students

• 4 - Title I-C, Services to Migrant Education Students or Program

• 6 - Consolidated Administration

• X - Not funded by one of the above federal sources

[S_AK_USR_Asignment_C]FedFundedFTE

String

2

R

21

Notes

A note is required if Job Code 53 has been reported.

[S_AK_USR_Asignment_C]Notes

String

100

O