USP_DATALIST_JOBOCCURRENCEMATCHEDETAIL

This datalist returns all details for parity between a job occurrence and a volunteer.

Parameters

Parameter	Parameter Type	Mode	Description
@JOBOCCURRENCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@VOLUNTEERID	uniqueidentifier	IN	Volunteer
@DAYLIST	nvarchar(max)	IN	Days

Definition

Copy



            create procedure dbo.USP_DATALIST_JOBOCCURRENCEMATCHEDETAIL (@JOBOCCURRENCEID uniqueidentifier = null, @VOLUNTEERID uniqueidentifier = null, @DAYLIST nvarchar(max) = null)
            as
                set nocount on;
                declare    @VOLNAME nvarchar(100);

                declare    @JOBID uniqueidentifier;

                --Vol Info

                select @VOLNAME = NAME
                from dbo.CONSTITUENT 
                where ID = @VOLUNTEERID

                --Get info from joboccurrence

                select JOBOCCURRENCE.JOBID ,
                    dbo.UFN_JOB_DISPLAYTIME(JOBOCCURRENCE.STARTTIME, JOBOCCURRENCE.ENDTIME),
                    JOB.NAME,
                    @VOLNAME,
                    coalesce(VOLUNTEERTYPE.NAME, 'N/A') JOBVOLUNTEERTYPE,
                    coalesce(VOLUNTEERLOCATIONCODE.DESCRIPTION, 'N/A') JOBLOCATION,
                    JOBOCCURRENCE.STARTTIME,
                    JOBOCCURRENCE.ENDTIME
                from dbo.JOBOCCURRENCE 
                inner join dbo.JOB
                    on dbo.JOBOCCURRENCE.JOBID = dbo.JOB.ID
                left outer join dbo.VOLUNTEERTYPE
                    on JOB.VOLUNTEERTYPEID = dbo.VOLUNTEERTYPE.ID
                left outer join VOLUNTEERLOCATIONCODE
                    on JOBOCCURRENCE.LOCATIONCODEID = VOLUNTEERLOCATIONCODE.ID
                where JOBOCCURRENCE.ID = @JOBOCCURRENCEID
                order by JOBVOLUNTEERTYPE, JOBLOCATION;