I need to produce a list of Business Processes, Forms, Fields, and variable Names for a customer to aid in designing an integration. I have the following query which gives me everything I need except for the variable name. Can you point me to the correct table and joins required to get this information?
SELECT dbo.cf_business_processes.name AS ProcessName, dbo.cf_forms.name AS [Form Name], dbo.cf_fields.label AS [Field Label], dbo.cf_fields.type AS [Field Type], dbo.cf_fields.length, dbo.cf_fields.default_value
FROM dbo.cf_forms INNER JOIN
dbo.cf_form_process_mapping ON dbo.cf_forms.form_id = dbo.cf_form_process_mapping.form_id INNER JOIN
dbo.cf_fields ON dbo.cf_forms.form_id = dbo.cf_fields.form_id INNER JOIN
dbo.cf_bp_processes ON dbo.cf_form_process_mapping.process_id = dbo.cf_bp_processes.process_id INNER JOIN
dbo.cf_business_processes ON dbo.cf_bp_processes.bp_id = dbo.cf_business_processes.bp_id