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 |
|
[emailaddress]EMAILADDRESS |
|
Work |
[S_Contacts_S]WORK_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 |