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 | RaceCD | 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: |
SIF_ExtendedElements/SIF_ExtendedElement | Database | SchoolStaff | StaffId |
|