UFN_PLANNEDGIFT_USERHASSITEACCESS

Validates that the application user has access to the planned gift based on site permissions.

Return

Return Type
bit

Parameters

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

Definition

Copy



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

                if exists(select SITEID from dbo.UFN_SITEID_MAPFROM_PLANNEDGIFTID(@PLANNEDGIFTID) as PLANNEDGIFTSITES where dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, PLANNEDGIFTSITES.SITEID) = 1)
                    return 1
                else
                    return 0

                return 0
            end