UFN_FUNDINGPLAN_USERHASSITEACCESS

Validates that the application user has access to the funding plan based on site permissions.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@APPUSERID uniqueidentifier IN
@FUNDINGPLANID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_FUNDINGPLAN_USERHASSITEACCESS
            (
                @APPUSERID uniqueidentifier,
                @FUNDINGPLANID uniqueidentifier
            ) 
            returns bit with execute as caller
            as
            begin                

                if dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, dbo.UFN_SITEID_MAPFROM_FUNDINGPLANID(@FUNDINGPLANID)) = 1 
                    return 1
                else
                    return 0

                return 0
            end