Understanding Roles Reporting in Native Reporting
This article explains how to report on user roles in Native Reporting after your organization moves to the updated permissions model. If you use Permission Sets reports or queries that use permissions, it also explains what changes for them.
📌If you use Permission Sets reports or queries: After your organization migrates, update affected reports and queries to use the new roles data so they continue to reflect role and permission changes. Existing reports remain available, but they are not updated automatically. The legacy permission tables are not being deleted as part of the November 30, 2026 migration.
Â
Overview
The updated permissions model stores roles and role assignments in new tables. Native Reporting now has a Roles field list. You can use it to report on who has which role in which program, using current data.
If you built reports with the old Permission Sets fields, those reports are not updated automatically. If you wrote dynamic queries that use permission data, those queries also need to be updated.
Â
Who this affects
-
Organizations that use the updated permissions model (role-based permissions).
-
Admins who built Native Reporting reports with Permission Sets fields.
-
Admins who wrote dynamic queries that use permission data.
Organizations that still use legacy permissions, or that do not build reports with permissions fields, are not affected.
Â
Important things to know
-
Your existing permission reports are not updated automatically. They still run. After your organization is on the updated permissions model, they show old information when a user's roles or permissions change.
-
Old tables stop updating after the migration. They are not deleted on November 30, 2026. Please update your reports and queries to get the most up to date data.
-
Who can use the Roles fields: Admins, Site Admins, and users with the Manage User/Program Profiles role, where eligible.
-
What you can report on: role assignments and role details.
-
We're rolling this out in phases. For most organizations, the Roles fields will appear on November 18. Organizations on legacy permissions won't be impacted by this change.
Â
What is in the Roles field list
User Program Roles
Shows which user has which role in which program.
| Field | Description |
|---|---|
| User | The name of the user |
| Program | The name of the program |
| Role | The name of the role |
| Active | Shows if the role assignment is active |
| Modified By / Date Modified | Who last changed the assignment, and when |
| Created By / Creation Date | Who created the assignment, and when |
Â
Roles
Shows details about each role.
| Field | Description |
|---|---|
| Role Name | The name of the role |
| Description | The description of the role |
| Active | Shows if the role is active |
| Modified By / Date Modified | Who last changed the role, and when |
| Created By / Creation Date | Who created the role, and when |
Names show in place of ID numbers for users, programs, roles, Modified By, and Created By.
Â
What is supported
| Supported | Not supported, or still being checked |
|---|---|
| Building a section from the Users form and adding Roles fields | Using Roles fields with Attendance or Enrollments fields in the same section |
| Building a section from the Programs form and adding Roles fields | Using the full Users form and the full Programs form in one section. Use one supported base form for each section. |
| Using Sites and Programs fields where they are available through the supported Roles connections | Reporting on what a role allows (role permissions) |
| Filtering on the Active columns | Showing inactive users, programs, roles, or assignments. This behavior is still being tested. Test your report before you depend on it. |
| Names in place of IDs for users, programs, roles, Modified By, and Created By | Using the Created By value from the Programs form as the person who created the role assignment. That value describes the program record. |
| Showing users who have a role assignment | Showing users who have no role assigned |
Â
How often the data updates
Saved role changes appear immediately when someone reruns a report.
Â
Next steps
-
To rebuild an old permission report, see How do I rebuild a permission report with the Roles fields?
-
To update a dynamic query, see How do I update a dynamic query for the updated permissions model?
-
For common questions, see Roles Reporting in Native Reporting: FAQs.
Â
Need help?
If you have questions or run into issues, create a support ticket, and our team will help.
What are the Roles fields in Native Reporting? | How do I report on user roles in Apricot? | Why does my permission report show old information? | What happens to my Permission Sets reports after the migration? | Are the old permission tables deleted on November 30, 2026? | Who can use the Roles fields in Native Reporting?
