USP_DATALIST_CONTACTREPORT_NEXTSTEP

Returns the next step of the prospect plan according to date.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DATE	datetime	IN	Date

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONTACTREPORT_NEXTSTEP(
                    @PROSPECTPLANID uniqueidentifier,
                    @DATE datetime
                )
                as begin
                    set nocount on;

                    select top 1
                        INTERACTION.ID as NEXTSTEPID,
                        INTERACTION.OBJECTIVE,
                        INTERACTION.FUNDRAISERID as FUNDRAISER,
                        INTERACTION.EXPECTEDDATE,
                        INTERACTION.ACTUALDATE,
                        INTERACTION.STATUSCODE
                    from dbo.INTERACTION
                    where 
                        INTERACTION.PROSPECTPLANID = @PROSPECTPLANID
                        and INTERACTION.COMPLETED = 0
                        and (INTERACTION.STATUSCODE = 0 or INTERACTION.STATUSCODE = 1)
                        and (@DATE is null or INTERACTION.EXPECTEDDATE > @DATE)
                    order by
                        INTERACTION.STATUSCODE desc, --TommyVe 2009-10-26 Pull the first Planned step if no Pending steps exist

                        INTERACTION.EXPECTEDDATE,
                        INTERACTION.DATEADDED,
                        INTERACTION.ID

                end