V_QUERY_CONSTITUENT_DUPLICATECRITERIAEMAIL

This view returns the constituent ID, name and email address so that duplicate constituents can be identified.

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_DUPLICATECRITERIAEMAIL AS



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