PSM_Teacher (ver1.0)
This table contains teacher information. Data duplicated here from the originating SIS.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
1.5 | Varchar2(50) | Teacher's email address. | |
Ethnicity | 1.0 | Varchar2(30) | Teacher's ethnicity. |
FirstName | 1.0 | Varchar2(50) | Teacher's first name. Required. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
IsAccessible | 2.6.0.5 | Number(3,0) | The PTAccess value synced into the PSM tables, which is used to grant or deny PTG access. |
LastName | 1.0 | Varchar2(50) | Teacher's last name. Required. |
LDAPEnabled | 1.5.1 | Number(3,0) | 1 indicates the teacher is allowed to log in using LDAP. |
Password | 1.0 | Varchar2(32) | The login password for PowerSchool Teacher. Note: Increased to 32 characters (ver1.5). |
Salt | 1.5 | Varchar2(10) | Encryption type used for password field. |
SSN | 1.0 | Varchar2(30) | Teacher's social security number. |
TeacherIdentifier | 1.0 | Varchar2(30) | Teacher number. Required. |
UserName | 1.0 | Varchar2(50) | The login name for PowerSchool Teacher. Required. |