Role Mapping

Hi,

We have cases of rolemapping using the Peoplesoft delivered function but therre is data inconsistency in the psoprcls and psroleuser tables. There are certain roles which appear in the psoprcls table but not in th epsroleusers tables. Can I check what could have caused the discrepancy?

SELECT * FROM psoprcls WHERE oprid ='S21752' and oprclass NOT IN (
   SELECT rolename  FROM psroleuser WHERE roleuser ='S21752')

There is 2 records for this case 2 roles is found in oprcls and not psroleuser table.

Regards