USP_DATALIST_PLANNEDGIFT_LETTERS

Returns a list of record letters for a planned gift.

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_LETTERS
                (
                    @PLANNEDGIFTID uniqueidentifier
                )
                as
                    set nocount on;

                    select distinct
                        [PLANNEDGIFTLETTER].[ID],
                        [PLANNEDGIFTLETTERCODE].[NAME],
                        [PLANNEDGIFTLETTER].[PROCESSDATE],
                        [PLANNEDGIFTLETTER].[ACKNOWLEDGEDATE],
                        (
                            select dbo.[UDA_BUILDLIST]([SITE].[NAME])
                            from dbo.[UFN_SITEID_MAPFROM_PLANNEDGIFTLETTERCODEID]([PLANNEDGIFTLETTERCODE].[ID]) [PLANNEDGIFTLETTERCODESITES]
                            inner join dbo.[SITE] on [SITE].[ID]=[PLANNEDGIFTLETTERCODESITES].[SITEID]
                        ) [SITES]
                    from
                        dbo.[PLANNEDGIFTLETTERCODE]
                    inner join 
                        dbo.[PLANNEDGIFTLETTER] on [PLANNEDGIFTLETTERCODE].[ID] = [PLANNEDGIFTLETTER].[PLANNEDGIFTLETTERCODEID]
                    where
                        [PLANNEDGIFTLETTER].[PLANNEDGIFTID] = @PLANNEDGIFTID
                    order by
                        [PLANNEDGIFTLETTERCODE].[NAME];