V_QUERY_MODELILNGANDPROPENSITYUPDATEBATCHCONTROLREPORT
View used for output for Modeling and Propensity Update Batch Control Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CONSTITUENTNAME | nvarchar(700) | yes | Constituent name |
| LOOKUPID | nvarchar(100) | yes | Lookup ID |
| ANNUALGIFTLIKELIHOOD | int | yes | Annual giving likelihood |
| MAJORGIVINGLIKELIHOOD | int | yes | Major giving likelihood |
| RANGE | nvarchar(50) | yes | Target gift range |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:33:20 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MODELILNGANDPROPENSITYUPDATEBATCHCONTROLREPORT AS
select
C.ID,
dbo.UFN_NAMEFORMATFUNCTION_SIMPLE(C.ID, C.KEYNAME, C.FIRSTNAME, C.MIDDLENAME, (select DESCRIPTION from dbo.TITLECODE where ID = C.TITLECODEID), (select DESCRIPTION from dbo.SUFFIXCODE where ID = C.SUFFIXCODEID),'','','','','') as CONSTITUENTNAME,
C.LOOKUPID,
MP.ANNUALGIFTLIKELIHOOD,
MP.MAJORGIVINGLIKELIHOOD,
TGR.RANGE
from
dbo.CONSTITUENT C
left join dbo.MODELINGANDPROPENSITY MP on C.ID = MP.ID
left join dbo.TARGETGIFTRANGE TGR on TGR.ID = MP.TARGETGIFTRANGEID