Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
ID of the staffer. |
| bio | text |
|
|
A description of the staffer’s bio. |
| telephone | varchar |
|
|
|
| profile_id | int4 |
|
|
ID of the profile associated with the staffer. See edge_profiles for details. |
| avatar | varchar |
|
|
Avatar of the staffer. |
| company_id | int8 |
|
|
ID of the parent company of the staffer. |
| admin_roles | _varchar |
|
|
An array of admin role available to the staffer. For example, {“care_management”,“finance”,“human_resources”,“legal”,“marketplace”}. |
| staffer_role_id | int8 |
|
|
ID of the staffer role assigned to the staffer. See edge_staffer for details. |
| workato_id | varchar |
|
|
ID of the staffer in the Workato automation tool. |
| access_reach | varchar |
|
|
Desribes access level of the staffer. For example “full”, “general”, “restricted”. |
| can_access_automations | bool |
|
|
Whether the staffer has access to the automation tools. For example, TRUE or FALSE. |
| analytics_user_type | varchar |
|
|
Analytics access level of the staffer in the Lookout portal. For example, “read-only”, “super”, “starter”. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_staffers_pkey | Primary key | Asc | id |