Match Line-of-Business

OVERVIEW:

dbo.SWXL_Category.category_name is used by the GSI, so make sure it is correct and that dbo.Template.line_of_business matches it.

PROCESS:

select
 t.template_id, t.template_name, t.line_of_business, sc.category_name
from
 template t
 join SWXL_Category_template sct on sct.template_id = t.template_id
 join SWXL_Category sc on sc.swxl_category_id = sct.swxl_category_id
where
 t.is_active = 1
 and t.line_of_business != sc.category_name

NOTE:

These can be different but should be the same, particularly before sending workbook to specialist.