Importing Data for Existing Records - Staff
Posted August 25, 2026
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.
Related articles
More from the Knowledge Base
Still have questions?
Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.
New to PCR Educator?
If you landed here from a search and want to see what PCR Educator can do, the demo is the fastest way in. Thirty minutes, no commitment.