Hi @Bretas
I think one aspect of your issue is that the field Param_Name on the Process_param_perform_val table is not in the database, its Non DB.
you can try using this sql as an example to see the param_name
SELECT
metrix_perform_param.element_name AS param_name,
process_param_perform_val.*,
metrix_perform_param.*
FROM
process_param_perform_val WITH (NOLOCK)
LEFT JOIN
metrix_process_param_def WITH (NOLOCK)
ON process_param_perform_val.process_id = metrix_process_param_def.process_id
AND process_param_perform_val.param_sequence = metrix_process_param_def.param_sequence
LEFT JOIN
metrix_perform_param WITH (NOLOCK)
ON metrix_perform_param.sequence = process_param_perform_val.perform_param_seq
AND metrix_perform_param.perform_name = metrix_process_param_def.perform_name_to_call
AND metrix_perform_param.element_name is not null
WHERE
process_param_perform_val.process_id = '03'
Hope this helps,
Morris