V_QUERY_CONSTITUENTMARKETING_OPTIMIZED
This query is used by the marketing component behind the scenes to improve performance by removing unnecessary fields and joins.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTID | uniqueidentifier | System record ID | |
| HOUSEHOLDID | uniqueidentifier | yes | Household ID |
| HEADOFHOUSEHOLD | bit | Head of household | |
| ISHOUSEHOLD | bit | Is household |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:11:53 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTMARKETING_OPTIMIZED AS
select
[CONSTITUENT].[ID] as [CONSTITUENTID],
[CONSTITUENTHOUSEHOLD].[HOUSEHOLDID],
isnull([CONSTITUENTHOUSEHOLD].[ISPRIMARYMEMBER], 0) as [HEADOFHOUSEHOLD],
isnull([CONSTITUENTHOUSEHOLD].[ISHOUSEHOLD], 0) as [ISHOUSEHOLD]
from dbo.[CONSTITUENT]
left join dbo.[CONSTITUENTHOUSEHOLD] on [CONSTITUENTHOUSEHOLD].[ID] = [CONSTITUENT].[ID]