Does Canvas Data include account (and sub-account) admins information?

[pgo586]

I was hoping to find one or more tables in Canvas Data that contains account roles (that is, admin-like roles) and also enrollments of this type, but I'm having trouble locating this. Does it exist? (in either CD1 or CD2?). Assuming it does not, is the plan to include this in the CD2 roadmap?  

[ColinMurtaugh · Accepted solution]

I believe you'll find what you're looking for in the account_users table.  Role IDs are defined in the roles table -- look for records that have a base_role_type of AccountMembership. 

--Colin

[pgo586]

Yes, thanks @ColinMurtaugh ! I also figured this out after looking carefully at the base_role_type field of the roles table. In contrast, I could not find any such role records (with a base type of AccountMembership) in the Canvas Data 1 'roles' table though. Am I right? If so, I'm glad that it was added to Canvas Data 2. 

[pgo586]

BTW, for completeness, I wanted to clarify that it is not enough to look at the roles (in the roles table) which have a base_role_type of AccountMembership; this gives you all the roles except for those 'built-in', whose base_role_type is 'AccountAdmin' instead of  'AccountMembership' and which have a workflow_state value of 'built_in' (I was initially looking for all the 'active' roles with the 'AccountMembership' role_base_type and unfortunately missing all of the top level admins).