Skip to main content
Ange Malakas
Community Manager
Nov 18, 2026 5:53 AM UTC

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

 

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?