USP_SIMPLEDATALIST_PLANNEDGIFTLETTERCODE

Returns a list of planned gift letters.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



        CREATE procedure dbo.USP_SIMPLEDATALIST_PLANNEDGIFTLETTERCODE
        (
          @CURRENTAPPUSERID uniqueidentifier = null,
          @SECURITYFEATUREID uniqueidentifier = null,
          @SECURITYFEATURETYPE tinyint = null
        )
        as
          set nocount on;

          select distinct
            [PLANNEDGIFTLETTERCODE].[ID] as [VALUE],
            [PLANNEDGIFTLETTERCODE].[NAME] as [LABEL]
          from
            dbo.[PLANNEDGIFTLETTERCODE]
            left join dbo.[PLANNEDGIFTLETTERCODESITE] on [PLANNEDGIFTLETTERCODE].[ID] = [PLANNEDGIFTLETTERCODESITE].[PLANNEDGIFTLETTERCODEID]
          where
            [PLANNEDGIFTLETTERCODE].[ISACTIVE] = 1 and
            [PLANNEDGIFTLETTERCODE].[IDSETREGISTERID] is not null
            and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[PLANNEDGIFTLETTERCODESITE].[SITEID] or (SITEID is null and [PLANNEDGIFTLETTERCODESITE].[SITEID] is null)))
          order by
            [PLANNEDGIFTLETTERCODE].[NAME];