Hi ​@Bretas 

What is the param_name? Can you provide a screenshot of what you are trying to fetch?

About the ‘Column Name to Set’

SELECT 
COLUMN_NAME_TO_SET, 
TABLE_NAME_TO_SET,
PROCESS_ID
FROM
CUST_PROCESS_PARAM_DEF

Cheers!

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

Thanks! This query will help me automate the documentation related to business rules.