PowerSchool SIS Iowa

StudentDemographicRecord

Events

SIF Events are not reported for this object.

Dependencies

Requires an existing StudentPersonal record.

Element Mappings for StudentSnapshot

Element Name or @Attribute

Submission

Definition

Code Set, if applicable

[Table]Field Mapping

Business Rules

RefId

Required

Unique demographic-record identifier.

 

[CST_PUBPUBLISHED_TMP]SIFREFID

 

SIF_RefObject

Required

Referenced SIF object type.

 

Calculated constant StudentPersonal

 

SIF_RefId

Required

StudentPersonal reference.

 

[Students]DCID, converted by SIF_UNITY_COMMON.F_GETREFID()

 

ReportingDate

Required

Demographic record publication date.

 

Calculated from CURRENT_DATE

Formatted YYYY-MM-DD.

StudentPersonalData/LocalId

Optional

Local student identifier.

 

[Students]Student_Number

 

StudentPersonalData/StateProvinceId

Optional

State student identifier.

 

[Students]State_StudentNumber

 

StudentPersonalData/SSN

Optional

Student Social Security number.

 

[Students]SSN

Restricted PII. Do not expose outside approved security controls.

StudentPersonalData/Name/Type

Optional

Preferred-name type.

CEDS name type

Calculated constant 04

 

StudentPersonalData/Name/LastName

Optional

Student last name.

 

[Students]Last_Name

 

StudentPersonalData/Name/FirstName

Optional

Student first name.

 

[Students]First_Name

 

StudentPersonalData/Name/MiddleName

Optional

Student middle name.

 

[Students]Middle_Name

 

StudentPersonalData/OtherNames/Name/Type

Optional

Legal-name type.

CEDS name type

Calculated constant 05

 

StudentPersonalData/OtherNames/Name/LastName

Optional

Legal last name.

 

[StudentCoreFields]PSCore_Legal_Last_Name; fallback [Students]Last_Name

 

StudentPersonalData/OtherNames/Name/FirstName

Optional

Legal first name.

 

[StudentCoreFields]PSCore_Legal_First_Name; fallback [Students]First_Name

 

StudentPersonalData/OtherNames/Name/MiddleName

Optional

Legal middle name.

 

[StudentCoreFields]PSCore_Legal_Middle_Name; fallback [Students]Middle_Name

 

StudentPersonalData/OtherNames/Name/Suffix

Optional

Legal suffix.

 

[StudentCoreFields]PSCore_Legal_Suffix

 

StudentPersonalData/DemographicsData/Gender/value

Optional

Student gender.

M, F, U

[Students]Gender

Values outside M/F publish as U.

StudentPersonalData/DemographicsData/BirthDate

Optional

Student date of birth.

 

[Students]DOB

Formatted YYYY-MM-DD.

StudentPersonalData/DemographicsData/HispanicLatino/value

Optional

Hispanic or Latino indicator.

Yes, No

[Students]FedEthnicity

 

StudentPersonalData/DemographicsData/RaceList/Race/Code/value

Optional

Race descriptor.

CEDS race codes

[StudentRace]RaceCD

Converted to 0998-1002.

StudentPersonalData/DemographicsData/RaceList/Race/OtherCodeList/OtherCode/value

Optional

State race code.

Iowa race code

[StudentRace]RaceCD

 

StudentPersonalData/DemographicsData/RaceList/Race/OtherCodeList/OtherCode/Codeset

Optional

Race code-set identifier.

StateProvince

Calculated constant StateProvince

 

StudentPersonalData/AddressList/Address/PhysicalAddress/Type

Optional

Physical address type.

CEDS address type

[Students]Street, [Students]City, [Students]State, [Students]Zip

Publishes 0765 when any address component is present.

StudentPersonalData/AddressList/Address/PhysicalAddress/Street/Line1

Optional

Physical street address.

 

[Students]Street

 

StudentPersonalData/AddressList/Address/PhysicalAddress/City

Optional

Physical city.

 

[Students]City

 

StudentPersonalData/AddressList/Address/PhysicalAddress/StateProvince/value

Optional

Physical state.

 

[Students]State

 

StudentPersonalData/AddressList/Address/PhysicalAddress/Country/value

Optional

Physical country.

 

Calculated constant US

 

StudentPersonalData/AddressList/Address/PhysicalAddress/PostalCode

Optional

Physical postal code.

 

[Students]Zip

 

StudentPersonalData/AddressList/Address/MailingAddress/Type

Optional

Mailing address type.

CEDS address type

[Students]Mailing_Street, [Students]Mailing_City, [Students]Mailing_State, [Students]Mailing_Zip

Publishes 0123 when any mailing component is present.

StudentPersonalData/AddressList/Address/MailingAddress/Street/Line1

Optional

Mailing street address.

 

[Students]Mailing_Street

 

StudentPersonalData/AddressList/Address/MailingAddress/City

Optional

Mailing city.

 

[Students]Mailing_City

 

StudentPersonalData/AddressList/Address/MailingAddress/StateProvince/value

Optional

Mailing state.

 

[Students]Mailing_State

 

StudentPersonalData/AddressList/Address/MailingAddress/Country/value

Optional

Mailing country.

 

Calculated constant US

 

StudentPersonalData/AddressList/Address/MailingAddress/PostalCode

Optional

Mailing postal code.

 

[Students]Mailing_Zip

 

StudentPersonalData/PhoneNumberList/PhoneNumber/Type

Optional

Home-phone type.


CEDS phone type

[Students]Home_Phone

Publishes 0096 when a home phone exists.

StudentPersonalData/PhoneNumberList/PhoneNumber/Number

Optional

Home phone number.

 

[Students]Home_Phone

 

StudentContactsSummary/ParentGuardian1/Name/*

Optional

First parent or guardian name.

 

[Students]Mother; fallback [Students]Father

Parsed into last, first, and middle name.

StudentContactsSummary/ParentGuardian2/Name/*

Optional

Second parent or guardian name.

 

[Students]Father

Publishes only when both Mother and Father values exist.

SIF_ExtendedElements/SIF_ExtendedElement/Name

Optional

Iowa extension group name.

 

[Students]DistrictOfResidence

Publishes when district of residence exists.

SIF_ExtendedElements/SIF_ExtendedElement/value/ResidentDistrictCode

Optional

Student resident-district code.

 

[Students]DistrictOfResidence