My user needs a report on membership rule violations. The data basically should come from the T_AV_ROLE_OUTOFCONSTRAINT table.
In the column ROLE_TYPEID I find values starting with a C. They refer to roles. But what are the values starting with a P?
C stands for committed roles so the ID appended to it is the ID of a role. P stands for Pending role so the ID appended to it is the ID or a role version.
I would probably ignore the Pending role entries since they are not committed/final role states.
Retrieving data ...