Table: dim_role

Type: Dimension Columns: 4

Description

Role information which controls permissions. The data grain is at the role level within a business.

Columns

Column Name Description
business_id

Unique identifier for the business

role_id

Unique identifier for the role

role

The role set for the staff indicating level of permissions they have within Kangarootime

role_level

The hierarchical order of the role with 0 being the highest level