| Field |
Required |
Type |
Sample Values |
Notes |
| Teacher_Id |
No |
Key ID Field |
“1234” |
|
| Teacher_Last_Name |
Yes |
Text |
“Smith” |
|
| Teacher_First_Name |
Yes |
Text |
“Jim” |
|
| Teacher_Office |
No |
Text |
“US01” |
|
| Alternate_Teacher_Id |
No |
Text |
“A1b3” |
|
| Teacher_Sex |
No |
Datasource Data |
“Male” |
Admin > Staff > Details - Gender |
| 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 |
| Teacher_Ethnic_Group |
No |
Datasource Data |
“African American” |
Admin > Staff > Details - Ethnic Group |
| Hired_Date |
No |
Date |
“2021/12/31” |
|
| Phone_Number |
No |
Text |
“(123)-456-7890 |
|
| Household_ID |
Yes, if Household_Name is not unique |
Identifier |
“1234” |
|
| Household_Name |
Yes, if Household_ID is not specified |
Lookup |
“Smith Family” |
|