USP_DATALIST_REVENUEBATCHLOOKUPID

Allows batch to lookup the Lookup ID for a constituent or lookup the constituent for a lookup ID.

Parameters

Parameter	Parameter Type	Mode	Description
@LOOKUPID	nvarchar(100)	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUEBATCHLOOKUPID
                (
                    @LOOKUPID nvarchar(100) = null,
                    @CONSTITUENTID uniqueidentifier = null
                )
                as
                set nocount on;

                if @LOOKUPID is null or @LOOKUPID = ''
                begin
                    select 
                        CONSTITUENT.LOOKUPID,
                        CONSTITUENT.ID,
                        CONSTITUENT_NF.NAME,
                        CONSTITUENT.GIVESANONYMOUSLY
                    from dbo.CONSTITUENT
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) CONSTITUENT_NF
                    where ID = @CONSTITUENTID
          union
          select '',BATCHREVENUECONSTITUENT.ID,BATCHREVENUECONSTITUENT.NAME, BATCHREVENUECONSTITUENT.GIVESANONYMOUSLY
            from dbo.BATCHREVENUECONSTITUENT
            where BATCHREVENUECONSTITUENT.ID = @CONSTITUENTID;
                end
                else
                begin
                    select 
                        CONSTITUENT.LOOKUPID,
                        CONSTITUENT.ID,
                        CONSTITUENT_NF.NAME,
                        CONSTITUENT.GIVESANONYMOUSLY
                    from dbo.CONSTITUENT 
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) CONSTITUENT_NF
                    where LOOKUPID = @LOOKUPID;
                end