USP_DATALIST_VOLUNTEERSCREENPLANSTEP

            create procedure dbo.USP_DATALIST_VOLUNTEERSCREENPLANSTEP (@SCREENPLANID uniqueidentifier)
            as
                set nocount on;


                select case VSPS.STATUSCODE
                        when 1 then 'RES:check'
                        when 2 then 'RES:x_16'
                        else 'RES:warning' end,
                        VSPS.ID, 
                        SCREENPLANSTEPCODE.DESCRIPTION,
                        VSPS.DUEDATE,
                        VSPS.STATUS,
                        VSPS.DATECOMPLETE,
                        VSPS.COMMENTS,
                        VSPS.STATUSCODE
                from dbo.VOLUNTEERSCREENPLANSTEP VSPS                
                inner join dbo.VOLUNTEERSCREENPLAN VSP
                    on VSP.ID = VSPS.SCREENPLANID
                inner join SCREENPLAN SP
                    on SP.ID = VSP.SCREENPLANID
                inner join dbo.SCREENPLANSTEPCODE
                    on SCREENPLANSTEPCODE.ID = VSPS.STEPCODEID
                where VSPS.SCREENPLANID = @SCREENPLANID
                order by VSPS.SEQUENCE