V_QUERY_MODELINGANDPROPENSITYBATCHCONTROLREPORT

View used for output for Modeling and Propensity Batch Control Report.

Fields

Field Field Type Null Description
ID uniqueidentifier 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
CONSTITUENTNAME nvarchar(154) yes Constituent name
LOOKUPID nvarchar(100) yes Constituent lookup ID
KEYNAME nvarchar(100) Key name
FIRSTNAME nvarchar(50) First name
MIDDLENAME nvarchar(50) Middle name
MEMBERSHIPLIKELIHOOD int yes MEMBERSHIPLIKELIHOOD
ONLINEGIVINGLIKELIHOOD int yes ONLINEGIVINGLIKELIHOOD
PATIENTRESPONSELIKELIHOOD int yes Patient response likelihood
WPSCREENINGINDICATOR nvarchar(1) WealthPoint screening indicator

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_MODELINGANDPROPENSITYBATCHCONTROLREPORT AS



                select 
                    MP.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,
                    C.NAME as CONSTITUENTNAME,
                    C.LOOKUPID,
                    C.KEYNAME,
                    C.FIRSTNAME,
                    C.MIDDLENAME,
                    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 PATIENTRESPONSELIKELIHOOD,       
                    MP.WPSCREENINGINDICATOR
                from 
                    dbo.MODELINGANDPROPENSITY MP                 
                    inner join dbo.CONSTITUENT C on C.ID = MP.ID
                    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