StaffPersonal
The PowerSchool SIF Agent provides publishing capabilities for the following data object and its elements:
Element/@Attribute | Source | Table | Column | Notes |
|
|---|---|---|---|---|---|
@RefId | Mapped | Teachers | StaffPers_guid | The ID (GUID) that uniquely identifies this section entity. |
|
LocalId | Mapped | Teachers | TeacherNumber | The locally-assigned identifier for this staff member. |
|
StateProvinceId | Mapped | Teachers | SIF_StatePrId | The state-assigned identifier for this staff member. |
|
ElectronicIdList |
|
|
| Electronic identifier(s) associated with this entity. |
|
OtherIdList |
|
|
| Lists all "other" identifiers associated with the staff member. |
|
OtherIdList/OtherId |
|
|
| Lists an "other" identifier associated with the staff member. |
|
OtherIdList/Type |
|
|
| Code that defines the type of this other ID. |
|
Name |
|
|
| Name of the staff member. Type value of 04 must be used here. |
|
Name/NameOfRecordType |
|
|
| Extends BaseNameType to allow for one Type attribute value, indicating the name is the name of record; serves as the primary name in some SIF objects, including StudentPersonal. |
|
Name/Type |
|
|
| Code that specifies the type of name. |
|
Name/NameOfRecordType/ BaseNameType |
|
|
| Base type, without attributes, for Name elements, primarily to allow structure to be leveraged with different Type attribute values. |
|
Name/NameOfRecordType/ BaseNameType/Prefix |
|
|
| A prefix associated with the name such as Mr., Ms., etc. |
|
Name/NameOfRecordType/ BaseNameType/LastName | Mapped | Teachers | Last_Name | The last name. |
|
Name/NameOfRecordType/ BaseNameType/FirstName | Mapped | Teachers | First_Name | The first name. |
|
Name/NameOfRecordType/ BaseNameType/MiddleName | Mapped | Teachers | Middle_Name | The middle name or initial. |
|
Name/NameOfRecordType/ BaseNameType/Suffix |
|
|
| The suffix, such as II, Jr., etc. |
|
Name/NameOfRecordType/ BaseNameType/PreferredName |
|
|
| The preferred name of the person. |
|
Name/NameOfRecordType/ BaseNameType/SortName |
|
|
| The name used for sorting purposes. |
|
Name/NameOfRecordType/ BaseNameType/FullName |
|
|
| A free text field for the complete name. |
|
OtherNames |
|
|
| Previous, alternate or other names or aliases associated with the staff member. |
|
Demographics | Mapped | See Demographic element. |
|
| This element contains information related to staff member demographics. |
Title | Mapped | Teachers | StaffStatus | The staff member's title. |
|
AddressList | Mapped | See Address element. |
|
| The staff member's addresses. |
PhoneNumberList |
|
|
| The staff member's phone number(s). |
|
EmailList | Mapped | Teachers | Email_Addr | The staff member's e-mail addresses. |
|
EmployeePersonalRefId |
|
|
| Allows for a linkage to the HR/Fin EmployeePersonal object. |
|
SIF_Metadata |
|
|
|
|
|
SIF_ExtendedElements |
|
|
|
|
|