PowerSchool SIS Iowa

SchoolInfo

Events

Add, Change, and Delete events are supported.

Dependencies

SchoolInfo references an existing LEAInfo record. Other SIF Unity objects, including TermInfo, SchoolCourseInfo, SectionInfo, and AttendanceCodeInfo.

Element Mappings

Element Name or @Attribute

Submission

Definition

Code Set, if applicable

[Table]Field Mapping

Business Rules

RefId

Required

Unique school identifier.


[CST_PUBPUBLISHED_TMP]SIFREFID


StateProvinceId

Optional

State-assigned school identifier.


[Schools]SIF_StatePrId; or [CST_SUBDISTRICTS]Subdistrict_Number

Subdistrict values are padded as required.

SchoolName

Required

School name.


[Schools]Name; or [CST_SUBDISTRICTS]Subdistrict_Name

Subdistrict office names include District Office.

LocalId

Required

Local school number.


[Schools]School_Number; or [CST_SUBDISTRICTS]Subdistrict_Number


LEAInfoRefId

Required

Parent LEA reference.


SIF_UNITY_COMMON.F_GETREFID() based on district or subdistrict


PrincipalInfo/ContactName

Optional

Principal name.


[Schools]Principal


AddressList/Address/Type

Optional

School address type.

CEDS address type

[Schools]SchoolAddress, SchoolCity, SchoolState, SchoolZIP

Publishes 0765 when the address is complete.

AddressList/Address/Street/Line1

Optional

School street address.


[Schools]SchoolAddress


AddressList/Address/City

Optional

School city.


[Schools]SchoolCity


AddressList/Address/StateProvince/value

Optional

School state.


[Schools]SchoolState


AddressList/Address/County

Optional

School county.


[Schools]CountyName


AddressList/Address/Country/value

Optional

School country.


Calculated constant US


AddressList/Address/PostalCode

Optional

School postal code.


[Schools]SchoolZIP


PhoneNumberList/PhoneNumber/Type

Optional

School phone type.

CEDS phone type

Calculated constant 0096


PhoneNumberList/PhoneNumber/Number

Optional

School phone number.


[Schools]SchoolPhone


PhoneNumberList/PhoneNumber[2]/Type

Optional

School fax type.

CEDS phone type

Calculated constant 2364


PhoneNumberList/PhoneNumber[2]/Number

Optional

School fax number.


[Schools]SchoolFax


GradeLevels/GradeLevel/Code/value

Optional

Grade served by the school.

Iowa grade-level descriptor

[Schools]Low_Grade through [Schools]High_Grade

Converted by SIF_IA_LIB.getGradeLevelDescriptor().

SIF_ExtendedElements/SIF_ExtendedElement/Name

Optional

Iowa extension group name.


School extension staging value


SIF_ExtendedElements/SIF_ExtendedElement[@Name="IA Profile Extensions"]/ProgramId

Optional

School program identifier.


[S_IA_SCH_X]ProgramId

Publishes the school program identifier when populated