StudentContact

@RefId

M

@StudentPersonalRefId

M

Schools.School_Number

OtherIdList/OtherId[@Type="9999"]

O

The SIF Agent will publish "SCHOOL:" followed by the value of Schools.School_Number.

Schools.School_Number

OtherIdList/OtherId[@Type="0222"]

O

Students.Father
Students.Mother
Students.Emerg_Contact_1
Students.Emerg_Contact_2
Students.Emerg_Contact_3

Name[@Type='04']/LastName

M

The name values are derived from these fields in PowerSchool. The name should be in the format of "LastName, FirstName MiddleName".

Name[@Type='04']/FirstName

M

Name[@Type='04']/MiddleName

O

Name[@Type='04']/FullName

O

Students.FatherDayPhone
Students.MotherDayPhone
Students.Emerg_Phone_1
Students.Emerg_Phone_2
Students.Emerg_Phone_3

PhoneNumberList/PhoneNumber[@Type='0096']/Number

O

Father and Mother are determined by their field names.
Students.Emerg_1_Rel
Students.Emerg_2_Rel
Students.Emerg_3_Rel

Relationship/Code

O

Refer to valueset 3.7 Relationship_20.

ContactFlags

M

ContactFlags/ParentLegalGuardian

C

This value will be "Yes" when this is a record for the Mother or Father. Otherwise, "Unknown" will be published.

ContactFlags/PickupRights

C

Hardcoded to "Unknown".

ContactFlags/LivesWith

C

Hardcoded to "Unknown".

ContactFlags/AccessToRecords

C

Hardcoded to "Unknown".

ContactFlags/EmergencyContact

C

This value will be "Yes" when this is an Emergency Contact. Otherwise, "Unknown" will be published.

ContactFlags/HasCustody

C

Hardcoded to "Unknown".

ContactFlags/DisciplinaryContact

C

Hardcoded to "Unknown".

ContactFlags/PrimaryCareProvider

C

Hardcoded to "Unknown".

ContactSequence

C

This will only be listed for the Emergency Contacts. It will be 1-3 based on the order of the contact.

@RefId

M

@StudentPersonalRefId

M

Schools.School_Number

OtherIdList/OtherId[@Type="9999"]

O

The SIF Agent will publish "SCHOOL:" followed by the value of Schools.School_Number.

Schools.School_Number

OtherIdList/OtherId[@Type="0222"]

O

Person.LastName

Name[@Type='04']/LastName

M

Person.FirstName

Name[@Type='04']/FirstName

M

Person.MiddleName

Name[@Type='04']/MiddleName

O

Name[@Type='04']/FullName

O

Concatenation of LastName, FirstName MiddleName.

PersonPhoneNumberAssoc.PhoneNumberAsEntered

PhoneNumberList/PhoneNumber[@Type='0096']/Number

O

Person phone number with priority order of 1.

PersonPhoneNumberAssoc.PhoneNumberAsEntered

PhoneNumberList/PhoneNumber[@Type='0350']/Number

O

Person phone number with priority order of 2.

StudentContactAssoc.CurrRelTypeCodeSetID

Relationship/Code

O

Refer to valueset 3.7 Relationship_20 .

ContactFlags

M

ContactFlags/ParentLegalGuardian

C

This value will be "Yes" when the relationship code is Mother, Father, Guardian, Stepmother or Stepfather. Otherwise, "No" will be published.

StudentContactDetail.SchoolPickUpFlg

ContactFlags/PickupRights

C

This will be "Yes" when the School Pickup Flag is checked for the student. Otherwise, "No" will be published.

StudentContactDetail.LivesWithFlg

ContactFlags/LivesWith

C

This will be "Yes" when the Lives With Flag is checked for the student. Otherwise, "No" will be published.

ContactFlags/AccessToRecords

C

Hardcoded to "Unknown".

StudentContactDetail.IsEmergency

ContactFlags/EmergencyContact

C

This will be "Yes" when the Emergency Contact Flag is checked for the student. Otherwise, "No" will be published.

StudentContactDetail.IsCustodial

ContactFlags/HasCustody

C

This will be "Yes" when the Has Custody Flag is checked for the student. Otherwise, "No" will be published.

ContactFlags/DisciplinaryContact

C

Hardcoded to "Unknown".

ContactFlags/PrimaryCareProvider

C

Hardcoded to "Unknown".

StudentContactAssoc.ContactPriorityOrder

ContactSequence

C

This will be the contact priority order listed by the students contact list.