USP_REPORT_MODELINGANDPROPENSITYCONTROLREPORT

Returns the data necessary for the Modeling and Propensity Batch Control report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_MODELINGANDPROPENSITYCONTROLREPORT(@BATCHID uniqueidentifier)
            with execute as owner
            as
                set nocount on;

                declare @SQL nvarchar(1000);
                set @SQL = N'
                    set nocount on;            
                    select
                        ID,
                        ANNUALGIFTLIKELIHOOD,
                        ANNUITYLIKELIHOOD,
                        BEQUESTLIKELIHOOD,
                        CRTLIKELIHOOD,
                        MAJORGIVINGLIKELIHOOD,
                        PLANNEDGIFTLIKELIHOOD,
                        PATIENTRESPONSELIKELIHOOD,
                        WPSCREENINGINDICATOR,    
                        CONSTITUENTNAME,
                        LOOKUPID
                    from
                        dbo.' + dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0) + N' 
                    order by
                        KEYNAME, FIRSTNAME, MIDDLENAME;
                ';

                exec sp_executesql @SQL;