edge_staffers


Description

Contains information about staff members within the company, including their roles, bio, access info, etc.

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”.

Relationships