USP_DATALIST_CONSTITUENTHISTORY_1_1

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	Action
@SHOWCODE	smallint	IN	Show
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@RECORDTYPECODE	tinyint	IN	Field type

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTHISTORY_1_1
                (
                    @CONSTITUENTID uniqueidentifier,
                    @USERID uniqueidentifier = null,
                    @ACTIONTYPECODE tinyint = 0,
                    @SHOWCODE smallint = 1,
                    @STARTDATE datetime = null,
                    @ENDDATE datetime = null,
                    @RECORDTYPECODE tinyint = 0
                ) as
                    set nocount on;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    if @SHOWCODE in (1,2,3,4,5,6) begin
                        set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@CURRENTDATE);

                        if @SHOWCODE = 1 --Last 30 days

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-29,@CURRENTDATE));
                        else if @SHOWCODE = 2 --Last 60 days

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-59,@CURRENTDATE));
                        else if @SHOWCODE = 3 --Last 90 days

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-89,@CURRENTDATE));
                        else if @SHOWCODE = 4 --Last 6 months

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(month,-6,@CURRENTDATE)));
                        else if @SHOWCODE = 5 --Last year

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(year,-1,@CURRENTDATE)));
                        else if @SHOWCODE = 6 --Last 5 years

                            set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(year,-5,@CURRENTDATE)));
                    end
                    else if @SHOWCODE = 0 begin
                        set @STARTDATE = null;
                        set @ENDDATE = null;
                    end
                    else if @SHOWCODE = 99 begin
                        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE);
                        set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@ENDDATE);
                    end

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