USP_DATALIST_TIMESHEETS

Lists the timesheets for a volunteer.

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_TIMESHEETS
                (
                    @VOLUNTEERID uniqueidentifier
                )
                as 
                set nocount on;

                select
                    TIMESHEET.ID,
                    JOB.NAME as [JOBNAME],
                    dbo.UFN_JOBOCCURRENCE_GETDESCRIPTION(TIMESHEET.JOBOCCURRENCEID) as [JOBOCCURRENCE],
                    TIMESHEET.HOURSWORKED,
                    TIMESHEET.STARTDATE,
                    TIMESHEET.ENDDATE
                from dbo.TIMESHEET
                inner join dbo.JOBOCCURRENCE on JOBOCCURRENCE.ID = TIMESHEET.JOBOCCURRENCEID
                inner join dbo.JOB on JOB.ID = JOBOCCURRENCE.JOBID
                where VOLUNTEERID = @VOLUNTEERID
                order by STARTDATE desc, JOBNAME, JOBOCCURRENCE, HOURSWORKED;