Traversing from execution to root process instance

[gokceng1]

Hello,
I have some nested processes via call activities.
I need to find root(top most) process instance or execution using a given execution. I've looked at the ACT_RU_EXECUTION, there are some entries with SUPER_EXEC_ not null and there are some entries with PARENT_ID_ not null. I'm not sure about what is the difference between them. Also I don't know whether they can be both not null. As I see, starting execution's SUPER_EXEC_ and PARENT_ID_ values are both null. But checking SUPER_EXEC_ nullity and if it is null checking PARENT_ID_ nullity seems hacky to me, is this the correct approach?

[jbarrez]

super_exec: stored relationship between the process and subprocess when using call activity

parent id: is used in various places, eg when doing concurrency etc. You should be able to find your way up to the process instance id by following both.