V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIAEMAILREFERENCE

This view returns the full list of constituents and email addresses by which duplicate constituents will be identified in a differential search.

Fields

Field	Field Type	Null	Description
CONSTITID	uniqueidentifier		CONSTITID
NAME	nvarchar(254)	yes	NAME
EMAILADDRESS	UDT_EMAILADDRESS		EMAILADDRESS
ISGROUP	bit		ISGROUP

Definition

Copy

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



                select  CONSTITUENT.ID as CONSTITID, 
                        CONSTITUENT.NAME + dbo.UFN_SUFFIXCODE_GETDESCRIPTION(CONSTITUENT.SUFFIXCODEID) as NAME, 
                        EMAILADDRESS.EMAILADDRESS,
                        CONSTITUENT.ISGROUP
                from    dbo.CONSTITUENT (nolock) inner join
                        dbo.EMAILADDRESS (nolock) on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID and EMAILADDRESS.ISPRIMARY = 1