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: Staff_Id, Lookup_Staff_Id, the combination of Lookup_Staff_First_Name and Lookup_Staff_Last_Name, or Lookup_Alternate_Staff_Id. Each row must match exactly one staff record. Only the columns included in the file are updated.

Field	Required	Type	Sample Values	Notes
Staff_Id	Yes if no lookup field is specified	Identifier	"1234"	Staff ID of the record to update.
Lookup_Staff_Id	Yes if Staff_Id and the other lookup fields are not specified	Lookup	"1234"	Staff ID.
Lookup_Staff_First_Name	Yes together with Lookup_Staff_Last_Name when names identify the record	Lookup	"Tina"	The first and last name together must match exactly one staff record.
Lookup_Staff_Last_Name	Yes together with Lookup_Staff_First_Name when names identify the record	Lookup	"Smith"
Lookup_Alternate_Staff_Id	Yes if Staff_Id and the other lookup fields are not specified	Lookup	"A1b3"
Staff_Office	Yes, if this field needs to be updated	Text	"US01"
Staff_Active	Yes, if this field needs to be updated	Boolean	"1"
Alternate_Staff_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"
Staff_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.