V_QUERY_MODELINGANDPROPENSITY_SIMPLE
Select all Modeling and Propensity data.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | yes | System record ID |
| ANNUALGIFTLIKELIHOOD | int | yes | Annual giving likelihood |
| ANNUITYLIKELIHOOD | int | yes | Annuity likelihood |
| BEQUESTLIKELIHOOD | int | yes | Bequest likelihood |
| CRTLIKELIHOOD | int | yes | CRT likelihood |
| MAJORGIVINGLIKELIHOOD | int | yes | Major giving likelihood |
| PLANNEDGIFTLIKELIHOOD | int | yes | Planned giving likelihood |
| DATEADDED | datetime | yes | Date added |
| DATECHANGED | datetime | yes | Date changed |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| MEMBERSHIPLIKELIHOOD | int | yes | Membership likelihood |
| ONLINEGIVINGLIKELIHOOD | int | yes | Online giving likelihood |
| PATIENTRESPOINSELIKELIHOOD | int | yes | Patient response likelihood |
| SUGGESTEDMEMBERSHIPLEVEL | nvarchar(50) | yes | Suggested membership level range |
| SUGGESTEDMEMBERSHIPLEVELSCORE | int | yes | Suggested membership level score |
| NCOAMOVEDINDICATOR | bit | yes | NCOA moved indicator |
| TARGETGIFTRANGE | nvarchar(50) | yes | Target gift range |
| TARGETGIFTRANGESCORE | int | yes | Target gift range score |
| WPSCREENINGINDICATOR | nvarchar(1) | yes | WealthPoint screening indicator |
| WEALTHESTIMATORRATING | nvarchar(50) | yes | Wealth estimator rating range |
| WEALTHESTIMATORRATINGSCORE | int | yes | Wealth estimator rating score |
| SUGGESTEDMEMBERSHIPLEVELID | uniqueidentifier | yes | Suggested membership level ID |
| TARGETGIFTRANGEID | uniqueidentifier | yes | Target gift range ID |
| WEALTHESTIMATORRATINGID | uniqueidentifier | yes | Wealth estimator rating ID |
| TAIMPORTID | nvarchar(100) | yes | |
| ADDEDBYID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:36 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MODELINGANDPROPENSITY_SIMPLE AS
select
COALESCE(MP.ID, TAIMPORTIDMAP.ID) as ID,
case MP.ANNUALGIFTLIKELIHOOD when -1 then NULL else MP.ANNUALGIFTLIKELIHOOD end ANNUALGIFTLIKELIHOOD,
case MP.ANNUITYLIKELIHOOD when -1 then NULL else MP.ANNUITYLIKELIHOOD end ANNUITYLIKELIHOOD,
case MP.BEQUESTLIKELIHOOD when -1 then NULL else MP.BEQUESTLIKELIHOOD end BEQUESTLIKELIHOOD,
case MP.CRTLIKELIHOOD when -1 then NULL else MP.CRTLIKELIHOOD end CRTLIKELIHOOD,
case MP.MAJORGIVINGLIKELIHOOD when -1 then NULL else MP.MAJORGIVINGLIKELIHOOD end MAJORGIVINGLIKELIHOOD,
case MP.PLANNEDGIFTLIKELIHOOD when -1 then NULL else MP.PLANNEDGIFTLIKELIHOOD end PLANNEDGIFTLIKELIHOOD,
MP.DATEADDED,
MP.DATECHANGED,
MP.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
case MP.MEMBERSHIPLIKELIHOOD when -1 then NULL else MP.MEMBERSHIPLIKELIHOOD end MEMBERSHIPLIKELIHOOD,
case MP.ONLINEGIVINGLIKELIHOOD when -1 then NULL else MP.ONLINEGIVINGLIKELIHOOD end ONLINEGIVINGLIKELIHOOD,
case MP.PATIENTRESPONSELIKELIHOOD when -1 then NULL else MP.PATIENTRESPONSELIKELIHOOD end PATIENTRESPOINSELIKELIHOOD,
SUGGESTEDMEMBERSHIPLEVEL.RANGE as SUGGESTEDMEMBERSHIPLEVEL,
SUGGESTEDMEMBERSHIPLEVEL.SCORE as SUGGESTEDMEMBERSHIPLEVELSCORE,
MP.NCOAMOVEDINDICATOR,
TARGETGIFTRANGE.RANGE as TARGETGIFTRANGE,
TARGETGIFTRANGE.SCORE as TARGETGIFTRANGESCORE,
MP.WPSCREENINGINDICATOR,
WEALTHESTIMATORRATING.RANGE as WEALTHESTIMATORRATING,
WEALTHESTIMATORRATING.SCORE as WEALTHESTIMATORRATINGSCORE,
SUGGESTEDMEMBERSHIPLEVEL.ID as SUGGESTEDMEMBERSHIPLEVELID,
TARGETGIFTRANGE.ID as TARGETGIFTRANGEID,
WEALTHESTIMATORRATING.ID as WEALTHESTIMATORRATINGID,
TAIMPORTIDMAP.CUSTOMIDENTIFIER as TAIMPORTID,
ADDEDBY.ID as ADDEDBYID
/*#EXTENSION*/
from
dbo.MODELINGANDPROPENSITY MP
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = MP.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = MP.CHANGEDBYID
left join dbo.SUGGESTEDMEMBERSHIPLEVEL on MP.SUGGESTEDMEMBERSHIPLEVELID = SUGGESTEDMEMBERSHIPLEVEL.ID
left join dbo.TARGETGIFTRANGE on MP.TARGETGIFTRANGEID = TARGETGIFTRANGE.ID
left join dbo.WEALTHESTIMATORRATING on MP.WEALTHESTIMATORRATINGID = WEALTHESTIMATORRATING.ID
full outer join dbo.TAIMPORTIDMAP on MP.ID = TAIMPORTIDMAP.ID