StudentPersonal

RefId

Required

Unique student identifier.

[CST_PUBPUBLISHED_TMP]SIFREFID

LocalId

Required

Local student number.

[Students]Student_Number

StateProvinceId

Optional

State student identifier.

[Students]State_StudentNumber

Name/Type

Optional

Student name type.

CEDS name type

Calculated constant 04

Name/LastName

Optional

Student last name.

[Students]Last_Name

Name/MiddleName

Optional

Student middle name.

[Students]Middle_Name

Name/FirstName

Optional

Student first name.

[Students]First_Name

Name/FullName

Optional

Student full name.

[Students]LastFirst

Name/Suffix

Optional

Student legal suffix.

[StudentCoreFields]PSCore_Legal_Suffix

Demographics/Gender/value

Optional

Student gender.

M, F, U

[Students]Gender

Values outside M/F publish as U.

Demographics/HispanicLatino/value

Optional

Hispanic or Latino indicator.

Yes, No

[Students]FedEthnicity

Publishes Yes when value is 1.

Demographics/BirthDate

Optional

Student date of birth.

[Students]DOB

Formatted YYYY-MM-DD.

Demographics/RaceList/Race/Code/value

Optional

Race descriptor.

CEDS race codes

[StudentRace]RaceCD

Converted to 0998-1002.

Demographics/RaceList/Race/OtherCodeList/OtherCode/value

Optional

State race code.

Iowa race code

[StudentRace]RaceCD

Hispanic students publish H; multiracial students publish M.

Demographics/RaceList/Race/OtherCodeList/OtherCode/Codeset

Optional

Race code-set identifier.

StateProvince

Calculated constant StateProvince

Demographics/LanguageList/Language/Code/value

Optional

Student primary language.

[StudentCoreFields]PrimaryLanguage

Defaults to eng when blank.

Demographics/LanguageList/Language/OtherCodeList/OtherCode/value

Optional

State primary-language code.

[StudentCoreFields]PrimaryLanguage

Defaults to eng when blank.

Demographics/LanguageList/Language/OtherCodeList/OtherCode/Codeset

Optional

Language code-set identifier.

StateProvince

Calculated constant StateProvince

AddressList/Address/PhysicalAddress/Type

Optional

Physical address type.

CEDS address type

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

Publishes 0765 only when all four fields have values.

AddressList/Address/PhysicalAddress/Street/Line1

Optional

Physical street address.

[Students]Street

AddressList/Address/PhysicalAddress/City

Optional

Physical address city.

[Students]City

AddressList/Address/PhysicalAddress/StateProvince/value

Optional

Physical address state.

[Students]State

AddressList/Address/PhysicalAddress/PostalCode

Optional

Physical address postal code.

[Students]Zip

AddressList/Address/PhysicalAddress/Country/value

Optional

Physical address country.

Calculated constant US

Requires complete physical address.

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 only when all four fields have values.

AddressList/Address/MailingAddress/Street/Line1

Optional

Mailing street address.

[Students]Mailing_Street

AddressList/Address/MailingAddress/City

Optional

Mailing city.

[Students]Mailing_City

AddressList/Address/MailingAddress/StateProvince/value

Optional

Mailing state.

[Students]Mailing_State

AddressList/Address/MailingAddress/PostalCode

Optional

Mailing postal code.

[Students]Mailing_Zip

AddressList/Address/MailingAddress/Country/value

Optional

Mailing country.

Calculated constant US

Requires complete mailing address.

Immigrant/value

Optional

Immigrant-status indicator.

Yes, No

[S_IA_STU_X]Immigrant

Publishes Yes when value is 1.

MostRecent/GradeLevel/Code/value

Optional

Grade level for the current publishing context.

Iowa grade-level descriptor

[Students]Grade_Level

Converted by SIF_IA_LIB.getGradeLevelDescriptor().

MostRecent/SchoolLocalId

Optional

School number for the current publishing context.

[CST_PUBPUBLISHED_TMP]RUNTIMEPROPINT_2

Value is prepared during SIF Unity preprocessing.

OtherIdList/OtherId/Type

Optional

Other student identifier type.

0004, 9999

[Students]SSN and [CST_PUBPUBLISHED_TMP]RUNTIMEPROPINT_2

Two possible rows: 0004 for SSN and 9999 for school identifier.

OtherIdList/OtherId/value

Optional

Other student identifier.

[Students]SSN; calculated SCHOOL: plus [CST_PUBPUBLISHED_TMP]RUNTIMEPROPINT_2

Restricted PII element. Requires FERPA review.

FirstUSEnrollment

Optional

First date enrolled in a U.S. school.

[StudentCoreFields]DateOfEntryIntoUSA

Validated and formatted YYYY-MM-DD.

ProjectedGraduationYear

Optional

Projected graduation year.

[StudentCoreFields]Graduation_Year

SIF_ExtendedElements/SIF_ExtendedElement/Name

Optional

Iowa extension group name.

Calculated constant IA Profile Extensions

SIF_ExtendedElements/SIF_ExtendedElement/value/IASex

Optional

Iowa legal gender value.

[StudentCoreFields]PSCore_Legal_Gender

SIF_ExtendedElements/SIF_ExtendedElement/value/LegalLastName

Optional

Student legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name; fallback [Students]Last_Name

SIF_ExtendedElements/SIF_ExtendedElement/value/LegalFirstName

Optional

Student legal first name.

[StudentCoreFields]PSCore_Legal_First_Name; fallback [Students]First_Name

SIF_ExtendedElements/SIF_ExtendedElement/value/LegalMiddleName

Optional

Student legal middle name.

[StudentCoreFields]PSCore_Legal_Middle_Name; fallback [Students]Middle_Name

SIF_ExtendedElements/SIF_ExtendedElement/value/LegalSuffix

Optional

Student legal suffix.

[StudentCoreFields]PSCore_Legal_Suffix

SIF_ExtendedElements/SIF_ExtendedElement/value/ExcludeFromStateReporting

Optional

State-reporting exclusion indicator.

Yes, No

[Students]State_ExcludeFromReporting

Publishes Yes when value is 1.