USP_CONSTITUENTSMARTFIELD_UNIFIEDRECOGNITIONANDREVENUE

Provides a single procedure for aggregating revenue and recognition data across households and individuals.

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CALCULATIONTYPE	tinyint	IN
@CALCULATEDREVENUE	tinyint	IN
@ASOF	datetime	IN
@DATETYPECODE	tinyint	IN
@STARTDATERECENTDATEUNITCODE	tinyint	IN
@STARTDATERECENTDATEINTERVAL	int	IN
@REVENUETYPECODES	xml	IN
@SELECTIONS	xml	IN
@REVENUEAPPLICATIONSELECTION	uniqueidentifier	IN
@RECOGNITIONTYPES	xml	IN
@INCLUDEHISTORICALDATA	bit	IN
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDID	uniqueidentifier	IN
@SITES	xml	IN

Definition

Copy



      CREATE procedure dbo.USP_CONSTITUENTSMARTFIELD_UNIFIEDRECOGNITIONANDREVENUE
      (
        @STARTDATE datetime = null,
        @ENDDATE datetime = null,
        @CALCULATIONTYPE tinyint,
        @CALCULATEDREVENUE tinyint,
        @ASOF datetime,                
        @DATETYPECODE tinyint = null,
        @STARTDATERECENTDATEUNITCODE tinyint = null,
        @STARTDATERECENTDATEINTERVAL int = null,        
        @REVENUETYPECODES xml = null,
        @SELECTIONS xml = null,                
        @REVENUEAPPLICATIONSELECTION uniqueidentifier = null,
        @RECOGNITIONTYPES xml = null,
        @INCLUDEHISTORICALDATA bit = null,
        @CURRENCYID uniqueidentifier = null,
        @SMARTFIELDID uniqueidentifier = null,
        @SITES xml = null
      )
      as
      set nocount on;

      --When calculating for non-households, call USP_CONSTITUENTSMARTFIELD_REVENUESPLITAMOUNTS which was the original procedure 

      --and is suitable for these calculations. For household-specific options (@CALCULATEDREVENUE = 2 and 3), do household calculations.

      if @CALCULATEDREVENUE = 0 or @CALCULATEDREVENUE = 1 
      begin
        --Note that this SP does not need @INCLUDEHISTORICALDATA since that option is household-specific

        exec dbo.[USP_CONSTITUENTSMARTFIELD_REVENUESPLITAMOUNTS] 
          @STARTDATE, 
          @ENDDATE, 
          @CALCULATIONTYPE, 
          @CALCULATEDREVENUE, 
          @ASOF,
          @DATETYPECODE, 
          @STARTDATERECENTDATEUNITCODE, 
          @STARTDATERECENTDATEINTERVAL,
          @REVENUETYPECODES, 
          @SELECTIONS, 
          @REVENUEAPPLICATIONSELECTION,
          @RECOGNITIONTYPES,
          @CURRENCYID,
          @SMARTFIELDID,
          @SITES;
      end
      else
      begin        
        exec dbo.[USP_CONSTITUENTSMARTFIELD_HH_REVENUESPLITANDRECOGNITIONS] 
          @STARTDATE, 
          @ENDDATE, 
          @CALCULATIONTYPE, 
          @CALCULATEDREVENUE, 
          @ASOF,
          @DATETYPECODE, 
          @STARTDATERECENTDATEUNITCODE, 
          @STARTDATERECENTDATEINTERVAL,
          @REVENUETYPECODES, 
          @SELECTIONS, 
          @REVENUEAPPLICATIONSELECTION,
          @RECOGNITIONTYPES, 
          @INCLUDEHISTORICALDATA,
          @CURRENCYID,
          @SMARTFIELDID,
          @SITES;
      end