Description
Staff information. The data grain is staff level within a business.
Columns
| Column Name | Type | Description |
|---|---|---|
business_id |
string
|
Unique identifier for the business |
staff_id |
string
|
Unique identifier for the staff |
staff_last_name |
string
|
The last name of the staff |
staff_first_name |
string
|
The first name of the staff |
staff_preferred_first_name |
string
|
The preferred first name of the staff |
primary_school_id |
string
|
Unique identifier for the staff's primary school |
primary_school |
string
|
Name for the staff's primary school |
role_id |
string
|
Unique identifier for the role |
current_status |
string
|
Current employment stage of the staff; enumerated: 'Requested', 'Created', 'Invited', 'Pending', 'Active', or 'Deactivated' |
medical_condition_status |
string
|
Indicates if the staff as a medical condition listed; enumerated: 'Listed' or 'Not Listed' |
allergy_status |
string
|
Indicates if the staff as an allergy listed; enumerated: 'Listed' or 'Not Listed' |
primary_contact_status |
string
|
The status indicating whether the staff has been a primary account contact; enumerated: 'Active Account Primary Contact', 'Inactive Account Primary Contact', or 'Not a Primary Contact' |
non_primary_contact_status |
string
|
The status indicating whether the staff has been a non-primary account contact; enumerated: 'Active Account Non-Primary Contact', 'Inactive Account Non-Primary Contact', or 'Not a Non-Primary Contact' |
date_of_birth |
string
|
The birth date of the staff |
email |
string
|
The email of the staff |
phone |
string
|
The phone number of the staff |
country |
string
|
The country where the staff is located |
state |
string
|
The state where the staff is located |
city |
string
|
The city where the staff is located |
postal_code |
string
|
The postal code of the staff's address |
address |
string
|
The first line of the staff's address |
available_days |
string
|
A simple text-based schedule of the day of week availability for the staff in the form of 'Su, M, T, W, Th, Fr, S' |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |