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/LastName	Database	Users	Last_Name
Name/FirstName	Database	Users	First_Name
Name/MiddleName	Database	Users	Middle_Name
Name/FullName	Database	Users	LastFirst
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/HispanicLatino	Database	Users	FedEthnicity
Demographics/Gender	Database	UsersCoreFields	Gender
Demographics/BirthDate	Database	UsersCoreFields	DOB
AddressList/Address[@Type="0765"]/Street/Line1	Database	Users	Street	The staff member's addresses.
AddressList/Address[@Type="0765"]/City	Database	Users	City
AddressList/Address[@Type="0765"]/StateProvince	Database	Users	State
AddressList/Address[@Type="0765"]/Country				Hardcoded to US.
AddressList/Address[@Type="0765"]/PostalCode	Database	Users	Zip
PhoneNumberList/PhoneNumber[@Type="0096"]/Number	Database	Users	Home_Phone
PhoneNumberList/PhoneNumber[@Type="0350"]/Number	Database	Users	School_Phone
EmailList/Email[@Type="Primary"]	Database	Users	Email_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