The PowerSchool SIF Agent provides publishing capabilities for the following data object and its elements:
|
Element/@Attribute |
Source |
Table |
Column |
Notes |
|---|---|---|---|---|
|
@RefId |
Mapped |
Students |
StudentPers_guid |
The ID (GUID) of the student to whom this information is linked. |
|
AlertMessages |
|
|
|
Prefs.Name="districtnumber" |
|
AlertMessages/AlertMessage |
|
|
|
Concatenate County and District. Must be a valid county/district combination in the WISE.
|
|
@Type |
|
|
|
Valid values:
|
|
MedicalAlertMessages |
|
|
|
|
|
MedicalAlertMessages/MedicalAlertMessage |
|
|
|
Medical alert associated with the student. |
|
@Severity |
|
|
|
Valid values:
|
|
LocalId |
Mapped |
Students |
Student_Number |
The locally-assigned identifier for this student. |
|
StateProvinceId |
Mapped |
Students |
State_StudentNumber |
The state-assigned identifier for this student. |
|
ElectronicIdList |
|
|
|
|
|
OtherIdList |
|
|
|
|
|
OtherIdList/OtherId |
|
|
|
|
|
Type |
|
|
|
|
|
Name |
|
|
|
Name of the student.
|
|
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 |
|
|
|
The last name. |
|
Name/NameOfRecordType/BaseNameType/FirstName |
|
|
|
The first name. |
|
Name/NameOfRecordType/BaseNameType/MiddleName |
|
|
|
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 student. |
|
OtherNames/Name |
|
|
|
Name of the person.
|
|
OtherNames/SIF_Action |
|
|
|
In a Change event, this flag can be used to indicate an element has been deleted from the parent list container. At a minimum the key for the list must also be present. |
|
Demographics |
Mapped in Demographic Object |
|
|
This element contains information related to student demographics. |
|
AddressList |
Mapped in Address Object |
|
|
Addresses of the students. |
|
PhoneNumberList |
Mapped |
Students |
Home_Phone
|
|
|
EmailList |
|
Students |
GuardianEmail |
Email addresses of the students. |
|
ProjectedGraduationYear |
Mapped |
Students |
Sched_YearofGraduation |
Currently projected graduation year. |
|
OnTimeGraduationYear |
Mapped |
Students |
Classof |
First projected graduation year, usually determined when student is accepted into 9th grade. |
|
GraduationDate |
|
|
|
Date student officially graduated from secondary education. |
|
MostRecent |
|
|
|
|
|
MostRecent/SchoolLocalId |
|
|
|
|
|
MostRecent/HomeroomLocalId |
|
|
|
|
|
MostRecent/GradeLevel |
|
|
|
|
|
AcceptableUsePolicy |
|
|
|
|
|
Idea |
Mapped |
Students |
[S_WY_STU_X]IDEA |
Is the student IDEA-eligible (special education)?
|
|
Migrant |
Mapped |
Students |
[S_WY_STU_X]Migrant |
Is this a migrant student? |
|
Title1 |
Mapped |
Students |
[S_WY_STU_X]Title1 |
Is the student in Title 1 programs? |
|
GiftedTalented |
Mapped |
Students |
[S_WY_STU_X]GiftedAndTalented |
Is the student in Gifted/Talented programs? |
|
EconomicDisadvantage |
|
|
|
Does the student meet the State criteria for classification as having an economic disadvantage? |
|
ELL |
Mapped |
Students |
[S_WY_STU_X]ELL |
Is the student an English Language Learner under Title 3? |
|
Homeless |
Mapped |
Students |
[S_WY_STU_X]Homeless |
Is the student homeless? |
|
Section504 |
Mapped |
Students |
[S_WY_STU_X]Section504 |
Is the student a qualified individual under Section 504 of the Rehabilitation Act?
|
|
VocationalConcentrator |
|
|
|
Does the student meet the State criteria for classification as a vocational concentrator? |
|
Immigrant |
Mapped |
Students |
[S_WY_STU_X]Immigrant |
Does the student meet the State criteria for classification as being an immigrant? |
|
NeglectedDelinquent |
|
|
|
Is the student participating in programs for neglected, delinquent, or at risk children? |
|
SIF_Metadata |
|
|
|
|
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]ELLMonitor |
ELL monitoring status of the student. |
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]ELL |
Did the student refuse to receive ELL services?
|
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]NationalScholarship |
Indicates if the student has a national scholarship. |
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]StateScholarship |
Indicates if the student has a state scholarship. |
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]StudentFosterCare |
Indicates if the student is in foster care. |
|
SIF_ExtendedElements/SIF_ExtendedElement
|
Mapped |
Students |
[S_WY_STU_X]StudentMilitaryConnected |
Indicates if the student's parent or guardian is an active member of the U.S. Military Services. |