UFN_TRACK_GETSTAFFRESOURCES

Returns the staff resources associated with a given track.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRACKID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_TRACK_GETSTAFFRESOURCES
            (
                @TRACKID uniqueidentifier
            )
            returns table
            as return
                select TRACKSTAFFRESOURCE.ID AS ID,
                        TRACKSTAFFRESOURCE.VOLUNTEERTYPEID,
                        TRACKSTAFFRESOURCE.JOBID,
                        TRACKSTAFFRESOURCE.QUANTITYNEEDED,
                        TRACKSTAFFRESOURCE.FILLEDBYCODE,
                        coalesce(JOB.NAME, TRACKSTAFFRESOURCE.JOBNAME) as JOBNAME,
                        coalesce(JOB.DESCRIPTION, TRACKSTAFFRESOURCE.JOBDESCRIPTION) as JOBDESCRIPTION,
                        VOLUNTEERTYPE.CAPACITYPERRESOURCE
                from dbo.TRACKSTAFFRESOURCE
                    left outer join dbo.JOB
                        on TRACKSTAFFRESOURCE.JOBID = JOB.ID
                    inner join dbo.VOLUNTEERTYPE
                        on VOLUNTEERTYPE.ID = TRACKSTAFFRESOURCE.VOLUNTEERTYPEID
                where TRACKSTAFFRESOURCE.TRACKID = @TRACKID