added support for soft deletes and expiration dates on role assignments