V_QUERY_MODELILNGANDPROPENSITYUPDATEBATCHEXCEPTIONREPORT
View used for output for Modeling and Propensity Update Batch Exception Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CONSTITUENTNAME | nvarchar(700) | yes | Constituent name |
| LOOKUPID | nvarchar(100) | Lookup ID | |
| ANNUALGIFTLIKELIHOOD | smallint | Annual giving likelihood | |
| MAJORGIVINGLIKELIHOOD | smallint | 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_MODELILNGANDPROPENSITYUPDATEBATCHEXCEPTIONREPORT AS
select
MPU.ID,
coalesce(nullif(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),'','','','',''), ''), MPU.FIRSTNAME + ' ' + MPU.KEYNAME) as CONSTITUENTNAME,
MPU.LOOKUP_ID as LOOKUPID,
MPU.ANNUALGIFTLIKELIHOOD,
MPU.MAJORGIVINGLIKELIHOOD,
TGR.RANGE
from
dbo.BATCHMODELINGANDPROPENSITYUPDATE MPU
left join dbo.CONSTITUENT C on C.ID = MPU.PRIMARYRECORDID
left join dbo.TARGETGIFTRANGE TGR on TGR.ID = MPU.TARGETGIFTRANGEID