Teachers (ver7.8.0)

AccessValue

CLOB

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

Note: Also known as Access.

AdminLDAPEnabled

Number

[From Users] Used for LDAP support (Administrator specific).

AllowLoginEnd

Number

[From Users] Time-restricted login. This is the end time that teachers can log in.

AllowLoginStart

Number

[From Users] Time-restricted login. This is the start of the time that teachers can log in.

Balance1

Float

[From SchoolStaff] Lunch balance.

Balance2

Float

[From SchoolStaff] Beginning lunch balance for the year, copied from balance 1 in the end-of-year process.

Balance3

Float

[From SchoolStaff] Fees balance.

Balance4

Float

[From SchoolStaff] Beginning fee balance for the year, copied from balance 3 in the end-of-year process.

CanChangeSchool

CLOB

[From Users] Semicolon delimited list of Schools.School_Number values the Admin can switch to when logged into the Admin portal.

City

Varchar2(40)

[From Users] City element of the users address.

Classpua

CLOB

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Custom

CLOB

[From SchoolStaff] This field holds all the teacher custom fields and their values.

DCID

Number

[From SchoolStaff] Unique identifier for this table. Indexed. Required.

DefaultStudScrn

CLOB

[From Users] The student page the user wants to appear by default.

Email_Addr

Varchar2(50)

[From Users] Stores the teachers email address and is used for email notifications to the teacher, such as student enrollment information.

Ethnicity

Varchar2(20)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

FedEthnicity

Number

[From Users] 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

Number

[From Users] Valid valuese: 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

Varchar2(20)

[From Users] First name.

GradebookType

Number

[From Users] Indicates the type of gradebook in use by the teacher. Valid values: 0 = PowerGrade, 1 = PowerTeacher gradebook.

GroupValue

Number

[From Users] The security group (from Gen table) this user belongs to in PowerSchool. This determines which pages the user has access to.

Home_Phone

Varchar2(20)

[From Users] Changed name from Home_phone. Home phone number for the staff member.

HomePage

CLOB

[From Users] The page that appears when logging in to PowerSchool.

Homeroom

Varchar2(20)

[From Users] This string does appear on some pages but does not impact any calculations.

HomeSchoolID

Number

[From Users] The teacher's home school. This ID is linked to the School_Number from the School table. Indexed. Required.

ID

Number

[From SchoolStaff] Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.

IPAddRestrict

CLOB

[From Users] 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.

Last_Name

Varchar2(20)

[From Users] Last name.

LastFirst

Varchar2(40)

[From Users] Last, First, Mi. Indexed.

LastMeal

Varchar2(20)

[From Users] Stores the date of last lunch purchase.

Log

CLOB

[From SchoolStaff] Log file is updated with importing.

LoginID

Varchar2(20)

[From Users] The PowerSchool login name. Indexed.

Lunch_ID

Float

[From Users] The PowerLunch number. Indexed.

Maximum_Load

Number

[From Users] Maximum student load permissible for this Teacher.

Middle_Name

Varchar2(20)

[From Users] Middle name.

NameAsImported

Varchar2(40)

[From Users] Used as a matching tool when importing teacher information.

NoOfCurClasses

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Notes

CLOB

[From SchoolStaff] Miscellaneous notes.

NumLogins

Number

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

Password

Varchar2(40 00)

[From Users] The PowerSchool login password.

PeriodsAvail

Varchar2(40)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

Photo

Number

[From Users] Set to 1 if a photo exists for this user.

PowerGradePW

Varchar2(20)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

PreferredName

Varchar2(45)

[From Users] Name the user prefers to use.

PSAccess

Number

[From Users] Indicates if the user can log in to PowerSchool Admin. Valid values: 0 = No, 1 = Yes.

PTAccess

Number

[From Users] Indicates if the user can log in to PowerTeacher. Valid values: 0 = No, 1 = Yes.

Sched_ActivityStatusCode

Varchar2(8)

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_BuildingCode

Varchar2(10)

[From SchoolStaff] The building the teacher is in.

Sched_Classroom

Varchar2(10)

[From SchoolStaff] The classroom this teacher is in most of the time.

Sched_Department

Varchar2(10)

[From SchoolStaff] The department to which the teacher belongs.

Sched_Gender

Varchar2(2)

[From SchoolStaff] Valid values: M = Male, F = Female.

Sched_Homeroom

Varchar2(10)

[From SchoolStaff] The teachers' homeroom.

Sched_HouseCode

Varchar2(10)

[From SchoolStaff] The house to which the teacher belongs.

Sched_IsTeacherFree

Number

[From SchoolStaff] 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

Number

[From SchoolStaff] 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_Maxim umConsecutive

Number

[From SchoolStaff] The most courses a teacher can teach in a row without a break.

Sched_MaximumCourses

Number

[From SchoolStaff] The maximum number of courses the teacher can teach.

Sched_MaximumDuty

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_MaximumFree

Number

[From SchoolStaff] The maximum number of preparatory periods the teacher can have.

Sched_MaxPers

Number

[From SchoolStaff] Reflects a long-standing setting in the Engine for Max Periods Per Day the Teacher is to be scheduled.

Sched_MaxPreps

Number

[From SchoolStaff] Reflects the setting in the Engine for Max Prep Codes (per Term) a Teacher is to be scheduled.

Sched_PrimarySchoolCode

Varchar2(10)

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_Scheduled

Number

[From SchoolStaff] Flag indicating whether or not this user is used for scheduling: True=Is used for scheduling. False=Not used for scheduling.

Sched_Substitute

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_TeacherMoreOneSchool

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_Team

Varchar2(12)

[From SchoolStaff] The team the teacher is on.

Sched_TotalC ourses

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_UseBuilding

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

Sched_UseHouse

Number

[From SchoolStaff] No longer used by application. This field may still be referenced on reports and/or custom pages.

School_Phone

Varchar2(20)

[From Users] Changed name from School_phone. Phone number at the school assigned to this staff member. Not currently used by any application code.

SchoolID

Number

[From SchoolStaff] This ID is linked to the School_Number from the School table. Indexed.

SIF_StatePrID

Varchar2(32)

[From Users] Used by the PowerSchool SIF Agent that requires a state-level unique identifier for teachers. To be used in the SIF StaffPersonal object.

SSN

Varchar2(12)

[From Users] This users Social Security number.

StaffPers_GUID

Varchar2(32)

[From Users] Globally unique identifier for this table for SIF compliancy. Indexed.

StaffStatus

Number

[From SchoolStaff] Current title for staff. Valid values: 0 = Not Assigned, 1 = Teacher, 2
= Staff, 3 = Lunch Staff, 4 = Substitute. Indexed.

State

Varchar2(2)

[From Users] State element of the users address.

Status

Number

[From SchoolStaff] Indicates whether the teacher is active or not. Valid values: 1 = Current, 2 = No longer here. Indexed.

Street

Varchar2(80)

[From Users] Street element of the users address.

SupportContact

Number

[From Users] Value of 1 indicates that this user is an authorized support contact.

TeacherLDAPEnabled

Number

[From Users] Used for LDAP support (teacher specific).

TeacherLoginID

Varchar2(20)

[From Users] The login name for PowerTeacher.

TeacherLoginIP

CLOB

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

TeacherLoginPW

Varchar2(4000)

[From Users] The login password for PowerTeacher.

TeacherNumber

Varchar2(20)

[From Users] The number the district assigns to track the teacher.

Title

Varchar2(40)

[From Users] Stores a title name for the teacher and is used for sorting purposes.

Users_DCID

Number

[From Schoolstaff] Internal number for the associated User record. Indexed. Required.

WM_Address

Varchar2(70)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_Alias

Varchar2(70)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_CreateDate

Date

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_CreateTime

Number

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_Exclude

Number

[From Users] No longer used. Used in one Version fix method.

WM_Password

Varchar2(20)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_Status

Varchar2(10)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_StatusDate

Date

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_TA_Date

Date

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_TA_Flag

Varchar2(3)

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

WM_Tier

Number

[From Users] No longer used by application. This field may still be referenced on reports and/or custom pages.

Zip

Varchar2(10)

[From Users] Zip code element of the users address.