Certified Staff Accounting Report
Introduction
This report contains staff member data, including demographics and assignment information. All paraprofessional & classified employees employed by the district on the first work day of October must be included in this report. See the EED Forms & Grants page for additional information.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Staff Selection
The report selects records from the [Users] and [S_AK_USR_Assignment_C] tables based on the following criteria:
The staff member must not be checked to indicate that they were on leave for the year, or that they are a long-term substitute and were not teaching on October 1.
The Is this staff on leave for the full year or were they on leave on October 1st? field must be unchecked.
The staff member must have at least one assignment record that was active on October 1.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Select Schools | Choose one of the following:
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:
|
Snapshot Date | Enter a snapshot date for the report. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | Path [Table]FieldName | Notes | Field Type | Req |
|---|---|---|---|---|---|---|
1 | District Number | The unique district ID number. | District Start Page> District Setup> District Info> District Number [Prefs]value where [Prefs]name = DistrictNumber | Number | Y | |
2 | School ID | The unique school ID assigned by DEED. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> School ID Override [S_AK_USR_Assignments_C]SchoolID Start page> [Select Staff]> Security Settings> Home School [Users]HomeSchoolID | If the staff assignment record does not have a specific school ID selected, the staff member's home school ID will be reported. | Number | Y |
3 | Last Name | The staff member's last name. | Start page> [Select Staff]> Information> Name (Last, First, MI) [Users]Last_Name | Text | Y | |
4 | First Name | The staff member's first name. | Start page> [Select Staff]> Information> Name (Last, First, MI) [Users]First_Name | Text | Y | |
5 | Middle Name | The staff member's middle name or middle initial. | Start page> [Select Staff]> Information> Name (Last, First, MI) [Users]Middle_Name | Text | N | |
6 | SSN | The staff member's social security number. | Start page> [Select Staff]> Information> SSN [Users]SSN | Hyphens and dashes will be stripped from the saved value if present. | Numeric | N |
7 | ATI | The staff member's Alaska Teacher Identifier (ATI). | Start page> [Select Staff]> Information> Alaska Teacher Identifier (ATI) [S_AK_USR_X]ATI | Numeric | Y | |
8 | BirthDate | The staff member's date of birth. | Start page> [Select Staff]> Information> DOB [Users]DOB | Date | Y | |
9 | Gender | The staff member's gender. | Start page> [Select Staff]> Information> Gender [Users]Gender | Valid values:
| M/F | Y |
10 | Race | The staff member's race or ethnicity. | Start page> [Select Staff]> Information> Reporting Ethnicity [Users]Ethnicity | Valid values:
| Numeric | Y |
11 | Highest Degree | The staff member's highest degree earned. | Start page> [Select Staff]> Information> Employee's highest degree earned [S_AK_USR_X]HighestDegree | Valid Values:
| Numeric | Y |
12 | Limited Certificate | Identifies if an individual is teaching under a limited certificate (Type E, I, or M) issued by the Teacher Certification Unit at DEED. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Staff is teaching under a limited certificate [S_AK_USR_Assignment_C]LimitedCert | Applies to the following Job Codes:
All other job codes report as X. | Y/N/X | Y |
13 | ESL Endorsement | Indicates the type of ESL endorsement the teacher has. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> ESL Endorsement [S_AK_USR_Assignment_C]ESLEndorsement | Applies to the following Job Codes:
Applies to the following teaching Assignment Codes:
All others report as X. | Option Set | Y |
14 | SPED Endorsement | Indicates the type of SPED endorsement the teacher has. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> SPED Endorsement [S_AK_USR_Assignment_C]SPEDEndorsement | Applies to the following Job Codes:
All others report as X. | Y/N/X | Y |
15 | Salary | The basic contract salary. | Start page> [Select Staff]> Information> Basic Contract Salary [S_AK_USR_X]Salary | If the staff has several FTEs, report the same full salary (as a whole number) for each entry. | Integer | Y |
16 | Years Experience | The sum of years of experience the staff member has in their current job class. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Years of experience the staff member has in his/her current job class [S_AK_USR_Assignment_C]YearsExperience | A teacher's years of experience should reflect the total years of experience in the Job Code of 15. | Numeric | Y |
17 | Job Code | The Job Code the staff performs. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Job Code [S_AK_USR_Assignment_C]JobCode | If a staff member has more than one job responsibility, include all appropriate Job Codes and each corresponding FTE. | Numeric | Y |
18 | Same Job | Indicates if the staff member worked in the same Job Code, at the same school site during the previous year. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Did this person work in the same job code, at the same school site last year? [S_AK_USR_Assignment_C]SameJob | If the staff member was a teacher last year and a principal this year, answer (N)o. If they were a teacher both years, but changed schools, answer (N)o. If they were a teacher at the same site both years, but changed teacher assignment codes, answer (Y)es. If they had any teacher job code last year and changed teacher job codes this year, answer (Y)es. | Y/N | Y |
19 | Date of Hire | The staff member's first date of hire by the district. | Start page> [Select Staff]> Information> First date of hire by district for employee [Users]HireDate | If a teacher has been on a leave of absence and has returned to their position, use the date the teacher was employed by the district prior to the leave of absence. | Date | Y |
20 | New to District | Indicates if the staff member is new to the district. | Start page> [Select Staff]> Information> Is this person a new employee to this district? [Users]NewtoDistrict | If a teacher is new to the district, or if the teacher previously taught in the district and returned after a break in service, answer (Y)es. | Y/N | Y |
21 | New to State | Indicates if the staff member worked exclusively in another state or country the previous year. | Start page> [Select Staff]> Information> Did this person work exclusively in another state or country last year? [Users]NewtoState | If the source field is blank, the report will return N. | Y/N | Y |
22 | New to Profession | Indicates if the staff member is new to their profession as defined by their Job Code (not new to the Assignment Code). | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Is this person new to his/her profession as defined by his/her job code? [S_AK_USR_Assignment_C]NewtoProfession | If the staff member is a teacher and last year was a teacher in another school or district or state, answer (N)o. If a teacher last year had any type of teacher job code and still has any one of the teacher job codes this year, new to profession answer is still (N)o. If the staff member is a principal this year and last year was a teacher in any school or district or state, then answer Y(es). | Y/N | Y |
23 | Long Term Substitute | Indicates of the teacher is a long-term substitute for more than 19 consecutive days. Required for all teachers. | Start page> [Select Staff]> Information> Long Term Sub [S_AK_USR_X]LongTermSub | The Long Term Sub flag is used in conjunction with the Section Co-Teaching dates. | Y/N/X | Y |
24 | Assignment Code | The staff member's Teacher Assignment Code. If the staff member is not a curriculum specialist or a teacher, the Assignment Code will be 0. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Assignment Code [S_AK_USR_Assignment_C]AssignmentCode | Numeric | Y | |
25 | Number of classes | If the staff member has a teaching Job Code, this is the number of classes taught. Note: The value is extracted from the Number of classes field available in the Staff Assignments page. If there is no value in the Number of classes field, the existing report logic is considered. If the staff is not a teacher, this will be 0. | Start Page> School Setup> Sections> [Select Course]> [Select Section]> Grade Level [Sections]Grade_Level | If the staff member is not a teacher, number of classes is 0. For elementary teachers, this is a count of distinct courses taught by the teacher. The Grade Level field is used to identify elementary level sections ([Sections]Grade_Level <= 6) For secondary teachers, this is a count of distinct sections taught by the teacher. The Grade Level field is used to identify secondary level sections ([Sections]Grade_Level > 6) | Integer | Y |
26 | Hired for SpEd | Indicates if the staff member was employed or contracted to provide special education and related services. Staff members that do not work an applicable Job Code will report X. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Was this person hired for SpEd [S_AK_USR_Assignment_C]HiredforSPED | Use for following job codes:
All others report as X. | Y/N/X | C |
27 | Lowest Grade | The lowest grade for which the teacher is responsible. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Lowest grade taught [S_AK_USR_Assignment_C]LowestGrade | Applies to the following job codes:
This will be blank for staff that are not assigned a teaching Job Code. | Option Set | C |
28 | Highest Grade | The highest grade for which the teacher is responsible. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Highest grade taught [S_AK_USR_Assignment_C]HighestGrade | Applies to the following job codes:
This will be blank for staff that are not assigned a teaching Job Code. | Option Set | C |
29 | Full-Time Equivalent (FTE) | The FTE for each Job Code and teacher AssignmentCode reported in whole numbers. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> FTE for the Job Code & Assignment Code [S_AK_USR_Assignment_C]FTE | The FTE of each staff member, across all assignments, cannot exceed 1. | Numeric | Y |
30 | Federally Funded FTE | If applicable, this is the federal funding source for the FTE for this position | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Federal funding source [S_AK_USR_Assignment_C]FedFundedFTE | If part of the FTE for the position is funded through one of these programs and part is not, report each FTE funded portion separately (create multiple assignments). | Option Set | Y |
31 | Notes | The Notes column can be used for adding additional information on any record. | Start page> [Select Staff]> Information> Staff Assignments> New/Edit> Notes [S_AK_USR_Assignment_C]Notes | A note is required if the Job Code is 53. | String | C |