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):
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!