V_QUERY_RESEARCHGROUPADDMEMBERSRATINGS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| ANNUALGIFTLIKELIHOOD | int | yes | |
| ANNUITYLIKELIHOOD | int | yes | |
| BEQUESTLIKELIHOOD | int | yes | |
| CRTLIKELIHOOD | int | yes | |
| MAJORGIVINGLIKELIHOOD | int | yes | |
| MEMBERSHIPLIKELIHOOD | int | yes | |
| PLANNEDGIFTLIKELIHOOD | int | yes | |
| SUGGESTEDMEMBERSHIPLEVEL | nvarchar(50) | yes | |
| SUGGESTEDMEMBERSHIPLEVELSCORE | int | yes | |
| TARGETGIFTRANGE | nvarchar(50) | yes | |
| TARGETGIFTRANGESCORE | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:10:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESEARCHGROUPADDMEMBERSRATINGS AS
select
MODELINGANDPROPENSITY.ID,
nullif(MODELINGANDPROPENSITY.ANNUALGIFTLIKELIHOOD, -1) ANNUALGIFTLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.ANNUITYLIKELIHOOD, -1) ANNUITYLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.BEQUESTLIKELIHOOD, -1) BEQUESTLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.CRTLIKELIHOOD, -1) CRTLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.MAJORGIVINGLIKELIHOOD, -1) MAJORGIVINGLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.MEMBERSHIPLIKELIHOOD, -1) MEMBERSHIPLIKELIHOOD,
nullif(MODELINGANDPROPENSITY.PLANNEDGIFTLIKELIHOOD, -1) PLANNEDGIFTLIKELIHOOD,
SUGGESTEDMEMBERSHIPLEVEL.RANGE as SUGGESTEDMEMBERSHIPLEVEL,
SUGGESTEDMEMBERSHIPLEVEL.SCORE as SUGGESTEDMEMBERSHIPLEVELSCORE,
TARGETGIFTRANGE.RANGE as TARGETGIFTRANGE,
TARGETGIFTRANGE.SCORE as TARGETGIFTRANGESCORE
from
dbo.MODELINGANDPROPENSITY
left join dbo.SUGGESTEDMEMBERSHIPLEVEL on MODELINGANDPROPENSITY.SUGGESTEDMEMBERSHIPLEVELID = SUGGESTEDMEMBERSHIPLEVEL.ID
left join dbo.TARGETGIFTRANGE on MODELINGANDPROPENSITY.TARGETGIFTRANGEID = TARGETGIFTRANGE.ID