99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.

Main2026

Posted August 25, 2026

Importing Data for Existing Records - Staff

Follow the steps for Importing Data for Existing Records.

Staff records hold employment information. This import updates employment fields on existing staff records. Identify each row by one of the following: Teacher_Id, Lookup_Teacher_Id, the combination of Lookup_Teacher_First_Name and Lookup_Teacher_Last_Name, or Lookup_Alternate_Teacher_Id. Each row must match exactly one staff record. Only the columns included in the file are updated.

Field	Required	Type	Sample Values	Notes
Teacher_Id	Yes if no lookup field is specified	Identifier	"1234"	Staff ID of the record to update.
Lookup_Teacher_Id	Yes if Teacher_Id and the other lookup fields are not specified	Lookup	"1234"	Staff ID.
Lookup_Teacher_First_Name	Yes together with Lookup_Teacher_Last_Name when names identify the record	Lookup	"Tina"	The first and last name together must match exactly one staff record.
Lookup_Teacher_Last_Name	Yes together with Lookup_Teacher_First_Name when names identify the record	Lookup	"Smith"
Lookup_Alternate_Teacher_Id	Yes if Teacher_Id and the other lookup fields are not specified	Lookup	"A1b3"
Teacher_Office	Yes, if this field needs to be updated	Text	"US01"
Teacher_Active	Yes, if this field needs to be updated	Boolean	"1"
Alternate_Teacher_Id	Yes, if this field needs to be updated	Text	"A1b3"
Employment_Status	Yes, if this field needs to be updated	Datasource Data	"Full Time"	Admin > Staff > Details - Employment Status
Lunch_Table	Yes, if this field needs to be updated	Datasource Data	"Table A"	Admin > Staff > Details - Lunch Table
Hired_Date	Yes, if this field needs to be updated	Date	"2021/12/31"
Phone_Number	Yes, if this field needs to be updated	Text	"(123)-456-7890"
Teacher_Url	Yes, if this field needs to be updated	Text	"https://school.org/staff/jsmith"

A staff member's name, preferred name, sex, and ethnicity live on the household contact record and are updated with Importing Data for Existing Records - Households.