V_SEARCH_RE7MEMBERSHIPRENEWAL

Fields

Field	Field Type	Null
ID	int
NAMEONRENEWAL	nvarchar(100)	yes
SENTTO	varchar(14)	yes
FULLNAME	nvarchar(255)	yes
IDENTIFIER	nvarchar(375)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 8:50:39 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_RE7MEMBERSHIPRENEWAL AS



      select
        [MR].[LOCALID] [ID],
        [MR].[NAMEONRENEWAL],
        case [MR].[SENTTOCODE_LOCALID] when 0 then 'Donor' when 1 then 'Primary member' when 2 then 'Both' end [SENTTO],
        [C].[FULLNAME],
        case when isnull([MR].[NAMEONRENEWAL], '') = '' then [C].[FULLNAME] + ' - ' + case [MR].[SENTTOCODE_LOCALID] when 0 then 'Donor' when 1 then 'Primary member' when 2 then 'Both' end
        else [C].[FULLNAME] + ' - ' + case [MR].[SENTTOCODE_LOCALID] when 0 then 'Donor' when 1 then 'Primary member' when 2 then 'Both' end + ' - ' + [MR].[NAMEONRENEWAL] end [IDENTIFIER]
      from [dbo].[RE7_MEMBERSHIPRENEWAL] [MR]
      left outer join dbo.[RE7_CONSTITUENTMEMBERSHIP] [CM] on [MR].[TRANSACTION_LOCALID] = [CM].[LOCALID]
      left outer join dbo.[RE7_CONSTITUENT] [C] on [CM].[CONSTITUENT_LOCALID] = [C].[LOCALID];