S_AK_USR_ASSIGNMENTS_C (ver 18.9.0)
This table is a child of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 18.9.0 | Number(11,0) | Primary Key |
AssignmentCode | 18.9.0 | Varchar2(5) | The assignment code for teaching job codes. |
| AssignmtType | 19.12.1.0 | Varchar2(1) | The assignment type. |
| EndDate | 18.9.0 | Date | The assignment end date. |
| ESLEndorsement | 18.9.0 | Varchar2(1) | The staff member's ESL endorsement. |
| FedFundedFTE | 18.9.0 | Varchar2(1) | The federal funding source for the staff members FTE. |
| FTE | 18.9.0 | Number(25,10) | The FTE percentage of this assignment. |
| HighGrade | 18.9.0 | Varchar2(2) | The highest grade for which a teacher is responsible. |
| HiredForSpEd | 18.9.0 | Varchar2(1) | Indicates if the staff member was employed or contracted to provide special education and related services. |
JobCode | 18.9.0 | Varchar2(5) | The job code for the staff member's position. |
| LimitedCert | 18.9.0 | Varchar2(1) | Indicates if the staff member is teaching under a limited certificate. |
| LowGrade | 18.9.0 | Varchar2(2) | The lowest grade for which a teacher is responsible. |
| NewToProfession | 18.9.0 | Boolean | Indicates if the staff is new to this job. |
| Notes | 18.9.0 | Varchar2(1000) | Additional information about this staff member. |
| SameJob | 18.9.0 | Boolean | Indicates if the staff worked for the same job code in the same school. |
SchoolID | 18.9.0 | Number(11,0) | The school_number value of the school to which this record belongs. |
| SPEDAide | 19.12.1.0 | Varchar2(1) | Indicates if the staff member is a special education paraprofessional. |
| SPEDAide35 | 19.12.1.0 | Varchar2(1) | Indicates if the special education aide paraprofessional works primarily with 3- to 5-year-olds. |
| SPEDEndorsement | 18.9.0 | Varchar2(1) | Indicates the type of SPED endorsement the teacher has. |
| StartDate | 18.9.0 | Date | The assignment start date. |
| YearsExperience | 18.9.0 | Number(25,10) | The number of years of experience the staff member has in the current job class. |