Users (ver7.8.0)
This table maintains teacher demographic information and their preferences.
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 |
|---|---|---|---|
AccessValue | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. Note: Also known as Access. |
AdminLDAPEnabled | 4.3.0/5.0.7 | Number(10,0) | Used for LDAP support (Administrator specific). |
AllowLoginEnd | 3.6.1 | Time | Time-restricted login. This is the end time that teachers can log in. |
AllowLoginStart | 3.6.1 | Time | Time-restricted login. This is the start of the time that teachers can log in. |
CanChangeSchool | 3.6.1 | CLOB | Semicolon delimited list of Schools.School_Number values the Admin can switch to when logged into the Admin portal. |
City | 3.6.1 | Varchar(100) | City element of the users address. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DefaultStudScrn | 3.6.1 | CLOB | The student page the user wants to appear by default. |
Email_Addr | 3.6.1 | Varchar(50) | Stores the teachers email address and is used for email notifications to the teacher, such as student enrollment information. |
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) | Numerical answer to the question "Is the staff member Hispanic or Latino?" Valid values : -1 = Default value, user has not yet made a selection, 0 = No, 1 = Yes, 2 = User-defined answer specified on the Federal Ethnicity and Race Settings page. |
FedRaceDecline | 6.0.0.1 | Number(10,0) | Valid values: 0 = Value assigned by default or one or more values specified in the TeacherRace table, 1 = Declined to specify race (no rows should appear in the TeacherRace table). |
First_Name | 3.6.1 | Varchar(100) | First name. |
GradebookType | 5.0.13 | Number(10,0) | Indicates the type of gradebook in use by the teacher. Valid values: 0 = PowerGrade, 1 = PowerTeacher gradebook. |
GroupValue | 7.6.1 | Number(10,0) | The security group (from Gen table) this user belongs to in PowerSchool. This determines which pages the user has access to. Note: Also known as Group. |
HomePage | 3.6.1 | CLOB | The page that appears when logging in to PowerSchool. |
Home_Phone | 4.0.0 | Varchar(20) | Changed name from Home_phone. Home phone number for the staff member. |
Homeroom | 3.6.1 | Varchar(20) | This string does appear on some pages but does not impact any calculations. |
HomeSchoolID | 3.6.1 | Number(10,0) | The teacher's home school. This ID is linked to the School_Number from the School table. Indexed. |
IPAddrRestrict | 3.6.1 | CLOB | The list of IP addresses the user is allowed to log in from. If blank, he or she can log in from any IP address. |
LastFirst | 3.6.1 | Varchar(305) | Last, First, Mi. Indexed. |
LastMeal | 3.6.1 | Varchar(20) | Stores the date of last lunch purchase. |
Last_Name | 3.6.1 | Varchar(100) | Last name. |
LoginID | 3.6.1 | Varchar(20) | The PowerSchool login name. Indexed. |
Lunch_ID | 3.6.1 | Float | The PowerLunch number. Indexed. |
Maximum_Load | 5.0.12 | Number(10,0) | Maximum student load permissible for this Teacher. |
Middle_Name | 3.6.1 | Varchar(100) | Middle name. |
NameAsImported | 3.6.1 | Varchar(305) | Used as a matching tool when importing teacher information. |
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) | The PowerSchool login password. |
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) | Set to 1 if a photo exists for this user. |
PowerGradePW | 3.6.1 | Varchar(20) | No longer used by application. This field may still be referenced on reports and/or custom pages. |
PreferredName | 3.6.1 | Varchar(305) | Name the user prefers to use. |
| PrefixCodesetID | 24.9.0 | Number(16) | Foreign key to codeset table of category prefix. |
PSAccess | 3.6.1 | Number(10,0) | Indicates whether the user can log in to PowerSchool Admin. Valid values: 0=No, 1=Yes. |
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. |
PTAccess | 3.6.1 | Number(10,0) | Indicates whether the user can log in to PowerTeacher. Valid values: 0=No, 1=Yes. |
SSN | 3.6.1 | Varchar(12) | This users Social Security number. |
School_Phone | 4.0.0 | Varchar(20) | Changed name from School_phone. Phone number at the school assigned to this staff member. Not currently used by any application code. |
SIF_StatePrid | 5.0.11.1 | Varchar(32) | Used by the PowerSchool SIF Agent that requires a state-level unique identifier for teachers. To be used in the SIF StaffPersonal object. |
StaffPers_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
State | 3.6.1 | Varchar(2) | State element of the users address. |
Street | 3.6.1 | Varchar(100) | Street element of the users address. |
SupportContact | 3.6.1 | Number(10,0) | Value of 1 indicates that this user is an authorized support contact. |
TeacherLDAPEnabled | 4.3.0/5.0.7 | Number(10,0) | Used for LDAP support (Teacher specific). |
TeacherLoginID | 3.6.1 | Varchar(20) | The login name for PowerTeacher. |
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) | The login password for PowerTeacher. |
TeacherNumber | 3.6.1 | Varchar(20) | The number the district assigns to track the teacher. |
Title | 3.6.1 | Varchar(40) | Stores a title name for the teacher and is used for sorting purposes. |
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. |
WhenCreated | 7.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 7.0.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
Zip | 3.6.1 | Varchar(10) | Zip code element of the users address. |