View: dbo.Filter_Base_Type_View
View definition
create view dbo.Filter_Base_Type_View
as
select
filter_base_type_KEY = FBT.filter_base_type_KEY
, filter_type_KEY = FBT.filter_type_KEY
, filter_line_type_KEY = FBT.filter_line_type_KEY
, filter_line_type__description = FLT.description
, filter_line_type__subfilter__filter_type_KEY = FLT.subfilter__filter_type_KEY
, description = FBT.description
, filter_column = FBT.filter_column
, update__staff_KEY = FBT.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FBT.update_date
from
dbo.Filter_Base_Type FBT
left outer join
dbo.Filter_Type FT on FT.filter_type_KEY = FBT.filter_type_KEY
left outer join
dbo.Filter_Line_Type FLT on FLT.filter_line_type_KEY = FBT.filter_line_type_KEY
left outer join
dbo.Staff S on S.staff_KEY = FBT.update__staff_KEY
cross join
(select property_value from dbo.Database_Property DP where property_name = N'Database Configuration') DP
where
-- Exclude the Service base type record for the Client filter when running SBPR. SBPR doesn't support services.
not (DP.property_value = N'SBPR' and FBT.filter_base_type_KEY = 664)
and
-- Exclude the Client Services base type record for the Client filter when running ACS. ACS handles those in a different way.
not (DP.property_value <> N'SBPR' and FBT.filter_base_type_KEY = 766)