StudentContact

This object is used to create or update the student contact information. There are two versions of StudentContacts in PowerSchool; one for PowerSchool 11.x or lower, and one for PowerSchool 12.x or higher. If a district is using PowerSchool 12.x, StudentContacts are published from the Unlimited Contacts on the students Contact page. With PowerSchool 11.x or lower, StudentContacts are published from the Emergency Contact and Demographic pages: Father, Mother, Guardian, Emergency Contact 1-3.

The Oklahoma SMP provides publishing capabilities for the following data object and its elements.

PowerSchool 11 or below

Element/@Attribute	Source	Table	Column	Business Rules
@RefId
@StudentPersonalRefId
Name/LastName	Database	Students	Father Mother Guardian_LN Emerg_Contact_1 Emerg_Contact_2 Emerg_Contact_3	Derived from the fields given based on the format of LastName, FirstName MiddleName.
Name/FirstName			Father Mother Guardian_FN Emerg_Contact_1 Emerg_Contact_2 Emerg_Contact_3	Derived from the fields given based on the format of LastName, FirstName MiddleName.
Name/MiddleName			Father Mother Guardian_MN Emerg_Contact_1 Emerg_Contact_2 Emerg_Contact_3	Derived from the fields given based on the format of LastName, FirstName MiddleName.
Name/FullName			Father Mother Guardian_LN, Guardian_FN, Guardian_MN Emerg_Contact_1 Emerg_Contact_2 Emerg_Contact_3
AddressList/Address[@Type='0765']/Street/Line1	Database	Students	Street	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/City	Database	Students	City	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/StateProvince	Database	Students	State	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/Country				Hard coded to US.
AddressList/Address[@Type='0765']/PostalCode	Database	Students	Zip	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0123']/Street/Line1	Database	Students	Mailing_Street	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0123']/City	Database	Students	Mailing_City	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0123']/StateProvince	Database	Students	Mailing_State	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0123']/Country				Hard coded to US.
AddressList/Address[@Type='0123']/PostalCode	Database	Students	Mailing_Zip	This field is only published for Father, Mother, and Guardian contacts.
PhoneNumberList/PhoneNumber[@Type='0096']/Number	Database	StudentCoreFields StudentCoreFields StudentCoreFields Students Students StudentCoreFields	FatherDayPhone MotherDayPhone GuardianDayPhone Emerg_Phone_1 Emerg_Phone_2 Emerg_Phone_3
Relationship	Database	Students	Emerg_1_Rel Emerg_2_Rel Emerg_3_Rel	Hard coded for Father, Mother, and Guardian. Emergency contacts are based on the relationship pop-up and are translated by the defaults listed below. Additional translations can be added in the agent.cfg file. Aunt = 1720 Brother = 1722 Father = 1727 Friend = 1729 Grandfather = 1730 Grandmother = 1731 Guardian = 1753 Mother = 1735 Neighbor = 9999 Other = 9999 Sister = 1741 StepFather = 1728 StepMother = 1736 Uncle = 1744 All other relationships default to 9999. A relationship code of 9999 is not published by the Oklahoma SMP.
ContactFlags/ParentLegalGuardian				Yes for Father, Mother, and Guardian. Unknown for others.
ContactFlags/PickupRights				Hard coded for Unknown.
ContactFlags/LivesWith				Hard coded for Unknown.
ContactFlags/AccessToRecords				Hard coded for Unknown.
ContactFlags/EmergencyContact				Yes for Emergency Contacts 1-3. Unknown for others.
ContactFlags/HasCustody				Hard coded for Unknown.
ContactFlags/DisciplinaryContact				Hard coded for Unknown.
ContactFlags/PrimaryCareProvider				Hard coded for Unknown.

PowerSchool 12 or above (Unlimited Contacts)

Element/@Attribute	Source	Table	Column	Business Rules
@RefId
@StudentPersonalRefId
Name/LastName	Database	Person	LastName
Name/FirstName	Database	Person	FirstName
Name/MiddleName	Database	Person	MiddleName
Name/FullName	Database	Person		Concatenation of LastName, FirstName MiddleName.
AddressList/Address[@Type='0765']/Street/Line1	Database	PersonAddressAssoc	Street	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/Street/Line2	Database	PersonAddressAssoc	LineTwo
AddressList/Address[@Type='0765']/City	Database	PersonAddressAssoc	City	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/StateProvince	Database	PersonAddressAssoc	State	This field is only published for Father, Mother, and Guardian contacts.
AddressList/Address[@Type='0765']/Country				Hard coded to US.
AddressList/Address[@Type='0765']/PostalCode	Database	PersonAddressAssoc	PostalCode	This field is only published for Father, Mother, and Guardian contacts.
PhoneNumberList/PhoneNumber[@Type='0096']/Number	Database	PersonPhoneNumberAssoc	PhoneNumberAsEntered	Where PhoneNumber priority = 1
PhoneNumberList/PhoneNumber[@Type='0350']/Number	Database	PersonPhoneNumberAssoc	PhoneNumberAsEntered	Where PhoneNumber priority = 2
Relationship	Database	StudentContactAssoc	CurrRelTypeCodeSetID	Contacts are based on the relationship pop-up and are translated by the defaults listed below. Additional translations can be added in the agent.cfg file. Aunt = 1720 Brother = 1722 Father = 1727 Friend = 1729 Grandfather = 1730 Grandmother = 1731 Guardian = 1753 Mother = 1735 Neighbor = 9999 Other = 9999 Sister = 1741 StepFather = 1728 StepMother = 1736 Uncle = 1744 All other relationships default to 9999. A relationship code of 9999 is not published by the Oklahoma SMP.
ContactFlags/ParentLegalGuardian	Database	StudentContactAssoc	CurrRelTypeCodeSetID	When Relationship equals Father, Mother, Guardian, StepFather, or StepMother, then Yes is published. Otherwise, No is published.
ContactFlags/PickupRights	Database	StudentContactDetail	SchoolPickUpFlg
ContactFlags/LivesWith	Database	StudentContactDetail	LivesWithFlg
ContactFlags/AccessToRecords				Hard coded for Unknown.
ContactFlags/EmergencyContact	Database	StudentContactDetail	IsEmergency	Yes for Emergency Contacts 1-3. Unknown for others.
ContactFlags/HasCustody	Database	StudentContactDetail	IsCustodial	Hard coded for Unknown.
ContactFlags/DisciplinaryContact				Hard coded for Unknown.
ContactFlags/PrimaryCareProvider				Hard coded for Unknown.