UFN_PROGRAMSTAFFRESOURCE_GETRESOURCESWITHJOBS

Returns the staff resources for a program.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_PROGRAMSTAFFRESOURCE_GETRESOURCESWITHJOBS
        (
            @PROGRAMID uniqueidentifier
        )
        returns table
        as return
            select ID,
                VOLUNTEERTYPEID,
                QUANTITYNEEDED,
                FILLEDBYCODE,
                JOBID
            from PROGRAMSTAFFRESOURCE
            where PROGRAMID = @PROGRAMID