V_QUERY_RATINGSBATCHCONTROLREPORT

View used for output for Ratings Batch Control Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
ANNUALGIFTLIKELIHOOD	int		ANNUALGIFTLIKELIHOOD
ANNUITYLIKELIHOOD	int		ANNUITYLIKELIHOOD
BEQUESTLIKELIHOOD	int		BEQUESTLIKELIHOOD
CRTLIKELIHOOD	int		CRTLIKELIHOOD
MAJORGIFTLIKELIHOOD	int		MAJORGIFTLIKELIHOOD
PLANNEDGIFTLIKELIHOOD	int		PLANNEDGIFTLIKELIHOOD
TARGETASKMONTH	nvarchar(9)	yes	TARGETASKMONTH
PASTGIVERTYPE	nvarchar(16)	yes	PASTGIVERTYPE
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

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:13:08 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RATINGSBATCHCONTROLREPORT AS



                select 
                    P.ID,
                    P.ANNUALGIFTLIKELIHOOD,
                    P.ANNUITYLIKELIHOOD,
                    P.BEQUESTLIKELIHOOD,
                    P.CRTLIKELIHOOD,
                    P.MAJORGIFTLIKELIHOOD,
                    P.PLANNEDGIFTLIKELIHOOD,
                    P.TARGETASKMONTH,
                    P.PASTGIVERTYPE,
                    C.NAME as CONSTITUENTNAME,
                    C.LOOKUPID,
                    C.KEYNAME,
                    C.FIRSTNAME,
                    C.MIDDLENAME
                from 
                    dbo.PROSPECT P                  
                    inner join dbo.CONSTITUENT C on C.ID = P.ID