Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
The unique ID of the record. @example 123. |
| name | varchar |
|
|
The name of the role. @example “Care Manager”. |
| permissions | _varchar |
|
|
A string array of permissions associated with the role. Valid permissions include: - billing - bulk_data_management - care_management - custom_attributes - custom_attribute_values - finance - finance_admin - human_resources - legal - login_management - marketplace - marketplace_admin - recruitment_management - rostering - technical - verification - workflow - workforce - workforce_compliance @example “{finance_admin,human_resources,legal,marketplace_admin}” |
| company_id | int8 |
|
|
The company ID. @example 345. |
| created_at | timestamp |
|
|
The date and time the record was created (in UTC). @example 2021-03-02 00:12:59.996101. |
| updated_at | timestamp |
|
|
The date and time the record was last updated (in UTC). @example 2021-05-07 01:53:28.564341. |
| description | varchar |
|
|
An optional description for the role. @example “Admin user with access to finance and billing”. |
| created_at_in_company_tz | timestamp |
|
|
The date and time the record was created (in the company timezone). @example 2021-03-02 10:12:59.996101. |
| updated_at_in_company_tz | timestamp |
|
|
The date and time the record was last updated (in the company timezone). @example 2021-05-07 11:53:28.564341. |
| company_timezone | varchar |
|
|
The timezone in which the company operates. @example “Australia/Brisbane”. |
| staffer_role_link | text |
|
|
A link to the page to edit the role. @example https://livewell.thelookoutapp.com/admin/staffer_roles/1867/edit |