Student Data Synchronization

The following table lists out the data that is provided to SchoolMessenger by the Schooltool Data Sync program, and provides a brief explanation of where each data item comes from in Schooltool.


=>This document contains a printable version of the information in the table below.



Column ID

Data Column Name

Schooltool Field and Data Description

SchoolMessenger Student Record Screen

UniqueID

Variable Digit Student ID

For more information on Managing Phone Numbers, Types and Ranks, see this article: https://www.edutech.org/resources/student-systems/...



FirstName

Student’s First name

LastName

Student’s Last Name

Language

Student’s Primary Language Spoken

Grade

Student’s Grade (Optional Field)

Gender

Student’s Gender (Optional Field)

ContactType

All set to "Student" - Used to Categorize the Type or Record being synchronized

SchoolID

Name of the building the student is primarily enrolled in

Address 1

The first line of the Street Address that is assigned to the student’s Primary Contact

Address 2

The second line of the Street Address that is assigned to the student’s Primary Contact

City

The City of the Home Address that is assigned to the student’s Primary Contact

State

The State of the Home Address that is assigned to the student’s Primary Contact

Zip

The Zip of the Home Address that is assigned to the student’s Primary Contact

Phone 1

Phone Number for the student with Rank 1 in Schooltool

Phone 2

Phone Number for the student with Rank 2 in Schooltool

Email 1

Student’s Email Address

Email 2

Not Used: Schooltool only is capable of storing one email address per contact by default.

SMS 1

Same as Phone 1 above, assuming it's "Type" the number in Schooltool is set to "Cell - SMS"

SMS2

Same as Phone 2, assuming it's "Type" the number in Schooltool is set to "Cell - SMS"

Guardians

The guardians that appear the bottom of student records are only those guardians whom have a relationship to the student that is considered “is parentandreceives mail