V_QUERY_CONSTITUENT_DUPLICATECRITERIA

This view returns the fields by which duplicate constituents will be identified.

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_DUPLICATECRITERIA 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