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