Contact Migration - AZ Contacts to SIS Contacts

The following data elements are available for contact setup. SIS Contacts can be used for reporting in the Contact and StudentContactAssociation interchanges. Follow these steps for migrating AZ student contacts to SIS contacts.

Navigation:

AZ Contact: Select student, Compliance, Contact

SIS Contact: People, Contacts, New Contact

The data in the following data elements will be migrated from AZ contacts to SIS contacts.

AZ Field Name	AZ [Table]FieldName	SIS Field Name	SIS [Table]FieldName

Demographics
Contact	[S_Contacts_S]first_name	First Name	[person]FIRSTNAME
Contact	[S_Contacts_S]middle_name	Middle Name	[person]MIDDLENAME
Contact	[S_Contacts_S]last_name	Last Name	[person]LASTNAME
Contact	[S_Contacts_S]PREFIX	Prefix	[person]PREFIXCODESETID
Contact	[S_Contacts_S]SUFFIX	Suffix	[person]SUFFIXCODESETID
Gender	[S_Contacts_S]gender	Gender	[person]GENDERCODESETID
Relationship	[S_CONTACT_RELATIONSHIP_C]Relationship	Type	[studentcontactdetail]RELATIONSHIPTYPECODESETID
		Highest Education Level	[person]educationlevel
State Contact Number	[S_Contacts_S]state_contactnumber		[person]STATECONTACTNUMBER
Contact ID	[S_Contacts_S]ID		[person]ID
Employer	[S_Contacts_S]EMPLOYER	Employer	[person]EMPLOYER
		Active	[person]ISACTIVE
Exclude Student From State Reporting	[S_Contacts_S]STATE_EXCLUDEFROMREPORTING		[person]EXCLUDEFROMSTATEREPORTING
			[person]
Personal	[S_Contacts_S]PERSONAL_EMAIL	Email	[emailaddress]EMAILADDRESS
Work	[S_Contacts_S]WORK_EMAIL	Email	[emailaddress]EMAILADDRESS
		Type	[personemailaddressassoc]EMAILTYPECODESETID
		Primary	[personemailaddressassoc]ISPRIMARYEMAILADDRESS
Home Address
Address (Line 1)	[S_Contacts_S]HOME_ADDRESS_1	Address Line 1	[personaddress]STREET
Address (Line 2)	[S_Contacts_S]HOME_ADDRESS_2	Address Line 2	[personaddress]LINETWO
City, State, Postal Code	[S_Contacts_S]HOME_CITY	City	[personaddress]CITY
City, State, Postal Code		State/Province	[personaddress]STATESCODESETID
		Country	[personaddress]COUNTRYCODESETID
City, State, Postal Code	[S_Contacts_S]HOME_POSTAL_CODE	Postal Code	[personaddress]POSTALCODE
		Unit	[personaddress]UNIT
		Type	[personaddressassoc]ADDRESSTYPECODESETID
		Start Date	[personaddressassoc]STARTDATE
		End Date	[personaddressassoc]ENDDATE
Phone number
Cell	[s_contacts_s]CELL_PHONE	Phone Number	[phonenumber]PHONENUMBER
Work	[s_contacts_s]WORK_PHONE	Phone Number	[phonenumber]PHONENUMBER
Home	[s_contacts_s]HOME_PHONE	Phone Number	[phonenumber]PHONENUMBER
	'	Extension	[phonenumber]PHONENUMBEREXT
		Consents to receiving SMS	[phonenumber]ISSMS