View: dbo.Firm_Additional_Contact_Role_View
View definition
CREATE VIEW dbo.Firm_Additional_Contact_Role_View
AS
SELECT P.*
, active_status_KEY = CASE WHEN P.is_active = 1 THEN 1 ELSE 2 END
FROM
dbo.Firm_Additional_Contact_Role P;