USP_DATALIST_CONSTITUENTHISTORY

Displays historic audit information for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@USERID	uniqueidentifier	IN	User
@ACTIONTYPECODE	tinyint	IN	Actions
@DATE	datetime	IN	Date

Definition

Copy



                create procedure dbo.USP_DATALIST_CONSTITUENTHISTORY
                (
                    @CONSTITUENTID uniqueidentifier,
                    @USERID uniqueidentifier = null,
                    @ACTIONTYPECODE tinyint = 0,
                    @DATE datetime = null
                ) as
                    set nocount on;

                    declare @STARTDATE datetime;
                    set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@DATE);

                    declare @ENDDATE datetime;
                    set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@DATE);

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