V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATEINPUTCRITERIA

This view returns the input constituents in which duplicate constituents will be identified in a differential search.

Fields

Field	Field Type	Null	Description
CONSTITID	uniqueidentifier		CONSTITID
NAME	nvarchar(254)	yes	NAME
ADDRESS	nvarchar(150)	yes	ADDRESS
ISGROUP	bit		ISGROUP

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:30 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATEINPUTCRITERIA AS



                select  c.ID as CONSTITID, 
                        c.NAME + dbo.UFN_SUFFIXCODE_GETDESCRIPTION(c.SUFFIXCODEID) as NAME, 
                        substring(dbo.UFN_BUILDFULLADDRESS(a.ID, a.ADDRESSBLOCK, a.CITY, a.STATEID, a.POSTCODE, a.COUNTRYID), 0, 150) as ADDRESS,
                        c.ISGROUP
                from    dbo.CONSTITUENT (nolock) as c inner join
                        dbo.ADDRESS (nolock) as a on a.CONSTITUENTID = c.ID and a.ISPRIMARY = 1
                where    
                    c.DATEADDED > (select convert (datetime, value)
                                     from fn_listextendedproperty('bb_FilterDate', default, default, default, default, default, default))