Hi,
I'm not sure that my info is correct, but I'd like to share my finding.
It seems Software Type is in ca_software_type table.
Status is listed in a support case. The meanings are correct, but it seems string is not matched with Reporter.
'0' = 'UNDEFINED'
'1' = 'WAITING'
'2' = 'DELIVERY_ORDERED'
'3' = 'DELIVERING'
'4' = 'DELIVERY_OK'
'5' = 'DELIVERY_ERROR'
'6' = 'ALREADY_DELIVERED'
'7' = 'EXECUTION_ORDERED'
'8' = 'EXECUTING'
'9' = 'EXECUTION_OK'
'10' = 'EXECUTION_ERROR'
'11' = 'UNDELIVERY_ORDERED'
'12' = 'UNDELIVERING'
'13' = 'UNDELIVERY_OK'
'14' = 'UNDELIVERY_ERROR'
'15' = 'ALREADY_INSTALLED'
'16' = 'MANIPULATION_NOT_ALLOWED'
'17' = 'DELIVERY_SUSPEND_ORDERED'
'18' = 'DELIVERY_SUSPEND_INPROGRESS'
'19' = 'DELIVERY_SUSPENDED'
'20' = 'DELIVERY_RESUME_ORDERED'
'21' = 'DELIVERY_RESUME_INPROGRESS'
'22' = 'UNDELIVERY_SUSPEND_ORDERED'
'23' = 'UNDELIVERY_SUSPEND_INPROGRESS'
'24' = 'UNDELIVERY_SUSPENDED'
'25' = 'UNDELIVERY_RESUME_ORDERED'
'26' = 'UNDELIVERY_RESUME_INPROGRESS'
'27' = 'Execution_Order_Staged'
I hope my info can help you.
Thanks
Yas