USP_REPORT_CONSTITUENTHISTORY

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@USERID	uniqueidentifier	IN
@ACTIONTYPECODE	tinyint	IN
@DATETYPE	tinyint	IN
@DATERANGEDISPLAY	nvarchar(100)	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@RECORDTYPECODE	tinyint	IN

Definition

Copy


                create procedure dbo.USP_REPORT_CONSTITUENTHISTORY
                (
                    @CONSTITUENTID uniqueidentifier,
                    @USERID uniqueidentifier = null,
                    @ACTIONTYPECODE tinyint = 0,
                    @DATETYPE tinyint = null,
                    @DATERANGEDISPLAY nvarchar(100) = '',
                    @STARTDATE datetime = null, 
                    @ENDDATE datetime = null,
                    @RECORDTYPECODE tinyint = 0
                )
                with execute as owner
                as
                    set nocount on;

                    exec dbo.USP_CONSTITUENT_GETHISTORY @CONSTITUENTID, @USERID, @ACTIONTYPECODE, @STARTDATE, @ENDDATE, @RECORDTYPECODE;