USP_DATAFORMTEMPLATE_VIEW_ACTIONITEMSUMMARY

Returns summary information for a given constituent ID

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@FIRSTACTIONITEMDATE	datetime	INOUT
@LASTACTIONITEMDATE	datetime	INOUT
@NUMBEROFLIFETIMEOFACTIONITEM	int	INOUT
@NUMBEROFACTIONTHISYEAR	int	INOUT
@DATALOADED	bit	INOUT

Definition

Copy



      CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ACTIONITEMSUMMARY
      (
        @CONSTITUENTID uniqueidentifier,
        @FIRSTACTIONITEMDATE datetime = null output,
        @LASTACTIONITEMDATE datetime = null output,
        @NUMBEROFLIFETIMEOFACTIONITEM int = 0 output,
        @NUMBEROFACTIONTHISYEAR int = 0 output,
        @DATALOADED bit = 0 output
      )
      as
      begin
          Declare @FirstPetitionDate       datetime
        Declare @LastPetitionDate        datetime
        Declare @NumberOfLifeOfPetition  int
        Declare @NumberOfPetionYear      int

        --action

        Select @FIRSTACTIONITEMDATE=MIN(DateAdded), @DATALOADED = 1,@LASTACTIONITEMDATE=MAX(DateAdded), 
               @NUMBEROFLIFETIMEOFACTIONITEM=count(ID)
        from dbo.ADVOCACYACTIVITY where CONSTITUENTID = @CONSTITUENTID;


        Select @NUMBEROFACTIONTHISYEAR = COUNT(ID) from dbo.ADVOCACYACTIVITY (nolock)
            where YEAR(DateAdded) = YEAR(GetDate())
              and CONSTITUENTID = @CONSTITUENTID


        Set @FIRSTACTIONITEMDATE = Convert(varchar,@FIRSTACTIONITEMDATE, 101)
        Set @LASTACTIONITEMDATE = Convert(varchar, @LASTACTIONITEMDATE, 101)
      end