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 |
|
|
|
|
|