Role Change Types can be found in each Content Database. The following query demonstrates how to get the Role Change Type.

USE [ContentDatabase]
SELECT Int0 FROM EventCache (NoLock)