Skip to main content
Skip table of contents

StaffPersonal

This object contains the personal information that relates to a staff member. The staff may be a teacher or other employee of the school or district.

The Oklahoma SMP provides publishing capabilities for the following data object and its elements:

Element/@Attribute

Source

Table

Column

Business Rules

@RefId

 

   

LocalId

Database

Users

TeacherNumber

 

StateProvinceId

Database

Users

SIF_StaffPrId

 

Name/Prefix

Database

Users

Title

 

Name/LastNameDatabaseUsers

Last_Name

 
Name/FirstNameDatabaseUsersFirst_Name 
Name/MiddleNameDatabaseUsersMiddle_Name 
Name/FullNameDatabaseUsersLastFirst 

Demographics/RaceList/Race/Code

Database

TeacherRace
Users

RaceCD
Ethnicity

By default, the SIF Agent will use the Reporting Ethnicity value that is stored in Users table in PowerSchool. To publish the Race value, change the publishing option for StaffPersonal. Refer to SIF Data Object Settings for in the PowerSchool SIF Agent documentation for more information.

Demographics/HispanicLatinoDatabaseUsersFedEthnicity 
Demographics/GenderDatabaseUsersCoreFieldsGender 
Demographics/BirthDateDatabaseUsersCoreFieldsDOB 

AddressList/Address[@Type="0765"]/Street/Line1

Database

Users

Street

The staff member's addresses.

AddressList/Address[@Type="0765"]/CityDatabaseUsersCity 

AddressList/Address[@Type="0765"]/StateProvince

DatabaseUsersState 
AddressList/Address[@Type="0765"]/Country   Hardcoded to US.

AddressList/Address[@Type="0765"]/PostalCode

DatabaseUsersZip 

PhoneNumberList/PhoneNumber[@Type="0096"]/Number

Database

Users

Home_Phone

 

PhoneNumberList/PhoneNumber[@Type="0350"]/Number

DatabaseUsersSchool_Phone 
EmailList/Email[@Type="Primary"]DatabaseUsersEmail_Addr 

SIF_ExtendedElements/SIF_ExtendedElement [@Name="StaffStatus"]

Database

SchoolStaff

StaffStatus

The values as published by the Oklahoma SMP:

0 = Not Assigned
1 = Teacher
2 = Staff
3 = Lunch Staff
4 = Substitute

SIF_ExtendedElements/SIF_ExtendedElement
[@Name="StaffId"]

Database

SchoolStaff

StaffId

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.