AnsweredAssumed Answered

Possible values for Change Request Activity Type

Question asked by George Kwakkernaat on Jan 28, 2020
Latest reply on Feb 10, 2020 by George Kwakkernaat

For our manual fulfillment proces I'm working on an SQL query to differentiate between activities that only affect accounts, and "other" activities. We are interested in this because we wish to have a different assignee for each type of activity.

 

For this purpose I have found the column "TYPE" in the view pv_change_request_activity. However, I can't seem to find a list of all possible values this field can contain (I can only see the types of activities that have actually happened in our test environment).

 

Does anyone have a complete list of all the activity types, or know of a place where these might be documented?  

 

The list of activity types I have so far is as follows (the bold ones are activities that we consider "account only" activities):

AddAccountToGroup
AddAppRoleToAccount
AddAppRoleToPendingBizRole
AddEntToAccount
AddEntToUser
AddGrantEntToPendingBizRole
AddGrantGroupEntToPendingBizRole
AddUserToAppRole
AddUserToBizRole
AddUserToPendingBizRole
AddUserToUserGroup
ChangeGlobalRoleProfile
CreateAccount
CreateGlobalRole
DeleteAccount
DeleteGlobalRole
DisableAccount
RemoveAccountFromGroup
RemoveAppRoleFromAccount
RemoveEntFromAccount
RemoveGranEntFromPendingBizRole
RemoveUserFromBizRole
RemoveUserFromPendingBizRole
RemoveUserFromUserGroup

 

Note: I'm also very much open for any suggestions about neater ways to differentiate between activities that only affect accounts and other types of activities!

Outcomes