Teachers_ncf31, 5 (ver3.6.1)
This table is no longer used by the application. This table was renamed Teachers_ncf31. The SchoolStaff table and Users table have been created in its place.
Note: The information that appeared in the Teachers table can now be viewed in the Teachers reporting view.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Access | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
AdminLDAPEnabled | 4.3.0/5.0.7 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
AllowLoginEnd | 3.6.1 | Time | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
AllowLoginStart | 3.6.1 | Time | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Balance1 | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Balance2 | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Balance3 | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Balance4 | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CanChangeSchool | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
City | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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 | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DefaultStudScrn | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Email_Addr | 3.6.1 | Varchar(50) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Ethnicity | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FedEthnicity | 6.0.0.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FedRaceDecline | 6.0.0.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
First_Name | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
GradebookType | 5.0.13 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Group | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Home_Phone | 4.0.0 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
HomePage | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Homeroom | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
IPAddrRestrict | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Last_Name | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
LastFirst | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
LastMeal | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Log | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
LoginID | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Lunch_ID | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Maximum_Load | 5.0.12 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Middle_Name | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
NameAsImported | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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. |
NumLogins | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Password | 3.6.1 | Varchar(15) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PeriodsAvail | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Photo | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PowerGradePW | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PreferredName | 3.6.1 | Varchar(45) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PSAccess | 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_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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Classroom | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Department | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Gender | 3.6.1 | Varchar(2) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_Homeroom | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_HouseCode | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_IsTeacherFree | 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_Lunch | 3.7.0 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaximumConsecutive | 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_MaximumCourses | 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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaxPers | 5.0.0 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_MaxPreps | 5.0.0 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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_UseHouse | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
School_Phone | 4.0.0 | Varchar(20) | 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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SIF_StatePrid | 5.0.11.1 | Varchar(32) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SSN | 3.6.1 | Varchar(12) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StaffPers_guid | 4.0.0 | Varchar(32) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StaffStatus | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
State | 3.6.1 | Varchar(2) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Status | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Street | 3.6.1 | Varchar(80) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SupportContact | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TeacherLDAPEnabled | 4.3.0/5.0.7 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TeacherLoginID | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TeacherLoginIP | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TeacherLoginPW | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TeacherNumber | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Title | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Address | 3.6.1 | Varchar(70) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Alias | 3.6.1 | Varchar(70) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_CreateDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_CreateTime | 3.6.1 | Time | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Exclude | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Password | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Status | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_StatusDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_TA_Date | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_TA_Flag | 3.6.1 | Varchar(3) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Tier | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Zip | 3.6.1 | Varchar(10) | No longer used by application as of ver6.0.1.6. Indicates the school's preference for counting attendance.W:wholeday;H:halfday. Captured from Schools custom field UEAT_Whole_Day_Ind. |