Staff records hold employment information only. A staff member's name, preferred name, sex, and ethnicity live on the household contact record, so create the household and its contact first with the Households import, then run this import to attach the staff (employment) record to that contact's slot.
| Field |
Required |
Type |
Sample Values |
Notes |
| Teacher_Id |
No |
Key ID Field |
“1234” |
Staff ID. Provide on every row or none; blank lets the system assign new IDs. |
| Household_Id |
Yes |
Identifier |
“1234” |
Used with Slot to place the staff member into a household contact slot. |
| Slot |
Yes |
1 or 2 |
“1” |
Which contact slot in that household to link this staff member to. The slot must already hold a contact (created via the Households import), and the row is rejected if the slot is already linked to another staff member. |
| Teacher_Office |
No |
Text |
“US01” |
|
| Alternate_Teacher_Id |
No |
Text |
“A1b3” |
|
| Teacher_Active |
Yes |
Boolean |
“1” |
|
| Employment_Status |
No |
Datasource Data |
“Full Time” |
Admin > Staff > Details - Employment Status |
| Lunch_Table |
No |
Datasource Data |
“Table A” |
Admin > Staff > Details - Lunch Table |
| Hired_Date |
No |
Date |
“2021/12/31” |
|
| Phone_Number |
No |
Text |
“(123)-456-7890” |
|
| Teacher_Url |
No |
Text |
“https://school.org/staff/jsmith” |
|
| Expected_Last_Name |
No |
Text |
“Smith” |
Optional safety check against the contact on the chosen slot; the row is rejected if it does not match. Leave blank to skip. Never saved. |
| Expected_First_Name |
No |
Text |
“Jim” |
Optional safety check against the chosen slot's contact. Leave blank to skip. Never saved. |
Names, preferred name, sex, and ethnicity are imported with the Households import, not here. If you include Teacher_First_Name, Teacher_Last_Name, Teacher_NickName, Teacher_Sex, Teacher_Ethnic_Group, or Household_Name, those rows are rejected.