SchoolStaff (ver7.8.0)
This table maintains School information related to the one or more teachers are assigned to.
Note: The Teachers table is no longer used and has been renamed Teachers_ncf31. The SchoolStaff table and Users table have been created in its place. The information that appeared in the Teachers table can now be viewed in the Teachers reporting view.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Balance1 | 3.6.1 | Float | Lunch balance. |
Balance2 | 3.6.1 | Float | Beginning lunch balance for the year, copied from balance 1 in the end-of-year process. |
Balance3 | 3.6.1 | Float | Fees balance. |
Balance4 | 3.6.1 | Float | Beginning fee balance for the year, copied from balance 3 in the end-of-year process. |
Classpua | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Custom | 3.6.1 | CLOB | This field holds all the teacher custom fields and their values. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Log | 3.6.1 | CLOB | Log file is updated with importing. |
NoOfCurClasses | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Notes | 7.6.1 | CLOB | Miscellaneous notes. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Sched_ActivityStatusCode | 3.6.1 | Varchar(8) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_BuildingCode | 3.6.1 | Varchar(10) | The building the teacher is in. |
Sched_Classroom | 3.6.1 | Varchar(10) | The classroom this teacher is in most of the time. |
Sched_Department | 3.6.1 | Varchar(10) | The department to which the teacher belongs. |
Sched_Gender | 3.6.1 | Varchar(2) | Valid values: M = Male, F = Female. |
Sched_Homeroom | 3.6.1 | Varchar(10) | The teachers' homeroom. |
Sched_HouseCode | 3.6.1 | Varchar(10) | The house to which the teacher belongs. |
Sched_IsTeacherFree | 3.6.1 | Number(10,0) | Flag stating weather the teacher is always free. True=no limit on how many courses a teacher can teach at a time, most often used with fake or SPED teachers. False= teacher can only teach one class at a time unless other wise specified at the course level. |
Sched_Lunch | 3.7.0 | Number(10,0) | Identifies the teacher to the engine as one who should be assigned a lunch period for each valid lunch day (according to the lunch courses valid days) when automated lunch is scheduled. This flag is used in lieu of creating course assignments for lunch. |
Sched_MaximumConsecutive | 3.6.1 | Number(10,0) | The most courses a teacher can teach in a row without a break. |
Sched_MaximumCourses | 3.6.1 | Number(10,0) | The maximum number of courses the teacher can teach. |
Sched_MaximumDuty | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaximumFree | 3.6.1 | Number(10,0) | The maximum number of preparatory periods the teacher can have. |
Sched_MaxPers | 5.0.0 | Number(10,0) | Reflects a long-standing setting in the Engine for Max Periods Per Day the Teacher is to be scheduled. |
Sched_MaxPreps | 5.0.0 | Number(10,0) | Reflects the setting in the Engine for Max Prep Codes (per Term) a Teacher is to be scheduled. |
Sched_PrimarySchoolCode | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Scheduled | 3.6.1 | Number(10,0) | Flag indicating whether or not this user is used for scheduling: True=Is used for scheduling. False=Not used for scheduling. |
Sched_Substitute | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_TeacherMoreOneSchool | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Team | 3.6.1 | Varchar(12) | The team the teacher is on. |
Sched_TotalCourses | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_UseBuilding | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaximumDuty | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaximumFree | 3.6.1 | Number(10,0) | The maximum number of preparatory periods the teacher can have. |
Sched_MaxPers | 5.0.0 | Number(10,0) | Reflects a long-standing setting in the Engine for Max Periods Per Day the Teacher is to be scheduled. |
Sched_MaxPreps | 5.0.0 | Number(10,0) | Reflects the setting in the Engine for Max Prep Codes (per Term) a Teacher is to be scheduled. |
Sched_PrimarySchoolCode | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Scheduled | 3.6.1 | Number(10,0) | Flag indicating whether or not this user is used for scheduling: True=Is used for scheduling. False=Not used for scheduling. |
Sched_Substitute | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_TeacherMoreOneSchool | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Team | 3.6.1 | Varchar(12) | The team the teacher is on. |
Sched_TotalCourses | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_UseBuilding | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
| SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
| StaffStatus | 3.6.1 | Number(10,0) | Current title for staff. Valid values: 0 = Not Assigned, 1 = Teacher, 2 = Staff, 3 = Lunch Staff, 4 = Substitute. Indexed. |
| Status | 3.6.1 | Number(10,0) | Indicates whether the teacher is active or not. Valid values: 1 = Current, 2 = No longer here. Indexed. |
| Users_DCID | 7.6.1 | Number(10,0) | Internal number for the associated User record. Indexed. Required. |