S_AK_USR_X (ver 15.11.0)
This is an extension of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 15.11.0 | Number(10,0) | Primary Key |
ATI | 15.11.0 | Varchar2(9) | Alaska Teacher Identifier (ATI). Migrated from [SchoolStaff.ak_ATI]. |
| HighestDegree | 18.9.0 | Varchar2(1) | The highest degree that the employee has earned. |
| HireDate | 18.9.0 | Date | The first date of hire by the district for the employee |
| HSDiploma | 19.12.1.0 | Varchar2(1) | Indicates if the instructional paraprofessional has a high school diploma or recognized equivalent. |
LongTermSub | 18.9.0 | Number(1,0) | Indicates of the teacher is a long-term substitute for more than 19 consecutive days. |
| MinQua | 20.5.2.0 | Varchar2(2) | Indicates the minimum qualifications of the staff member. |
| NewToDistrict | 18.9.0 | Number(1,0) | Indicates if this staff member is a new employee to this district. |
| NewToState | 18.9.0 | Number(1,0) | Indicates if the staff member worked exclusively in another state or country last year. |
| OnLeave | 18.9.0 | Number(1,0) | Indicates if this staff member is on leave for the full year or were on leave on October 1st. |
RcvdCrisisTrng | 18.7.0 | Number(1,0) | Indicates if the staff member involved in the restraint or seclusion was trained in an approved crisis intervention training program. |
| Salary | 18.9.0 | Number(10,0) | The staff member's basic contract salary. |
| TitleIParaProf | 19.12.1.0 | Varchar2(1) | Indicates if the staff member is a Title I instructional paraprofessional. |
| TitleIHireDate | 19.12.1.0 | Date | The date the instructional paraprofessional employee was hired into a Title I program. |