service catalog usm_request_pending_action table query

[ss_shubha]

In usm_request_pending_action table we have process_instance_id ,want to know what value will get stored in it. In our test environment this table is filled with subscription detail id but in production its null(no value). Object type is 1,so want to know what is this process instance id and what value it should store

[Louis van Amelsfort]

Good Afternoon Shubha.
 
The following information is related to your current question.
 
Status:
0 - deleted
1 - active
2 - completed by assigned user
3 - completed by another user
4 - delegated
5 - transferred
6 - terminated.
 
ObjectId:
The value is either subscription detail id or offering id
 
Objecttype:
0 - means object id is subscription detail id and
1 - means offering id
 
Thanks and kind regards, Louis van Amelsfort.

[ss_shubha]

Thanks for the reply Louis. But I was asking about "process_instance_id" column. What values should get stored in this column

[Louis van Amelsfort]

Good Morning Shubha.

 

The info I provided was what I could discover for this table.

Perhaps other people in the community can assist in finding the description about the "process_instance_id" column.

 

Thanks and kind regards, Louis.