View: dbo.Privilege_Requiring_Compliance_View
View definition
-- Privileges to exclude if there's no Compliance license.
-- Compliance
-----------------------------------------------------------
-- If this list changes set Firm.has_compliance to true so
-- if the user doesn't have a Compliance license we'll react.
-----------------------------------------------------------
CREATE VIEW dbo.Privilege_Requiring_Compliance_View
AS
SELECT
privilege_KEY = P.privilege_KEY
FROM
dbo.Privilege P
WHERE privilege_KEY IN (
44, -- SBPR_Setup_FirmInfo_TaxAgt
80, -- SBPR_Setup_FirmInfo_TaxAgt_Main
256, -- SBPR_Setup_FirmInfo_TaxAgt_Main_View
257, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Add
401, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Edit
258, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Del
81, -- SBPR_Setup_FirmInfo_TaxAgt_DirDep
402, -- SBPR_Setup_FirmInfo_TaxAgt_DirDep_View
403) -- SBPR_Setup_FirmInfo_TaxAgt_DirDep_Edit