UFN_RATESCALE_GETRATESCALESTAFFRESOURCES

Returns the included staffing resources for a rate scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RATESCALEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_RATESCALE_GETRATESCALESTAFFRESOURCES
        (
            @RATESCALEID uniqueidentifier
        ) returns table
        as
            return
            select
                RATESCALESTAFFRESOURCE.ID,
                RATESCALESTAFFRESOURCE.VOLUNTEERTYPEID,
                VOLUNTEERTYPE.NAME
            from
                dbo.RATESCALESTAFFRESOURCE
                inner join dbo.VOLUNTEERTYPE on dbo.RATESCALESTAFFRESOURCE.VOLUNTEERTYPEID = dbo.VOLUNTEERTYPE.ID
            where
                RATESCALEID = @RATESCALEID