USP_DATALIST_RATESCALESTAFFRESOURCE
Returns all staffing resources belonging to a rate scale.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_RATESCALESTAFFRESOURCE
(
@CONTEXTID uniqueidentifier
)
as
begin
set nocount on;
declare @INCLUDEALLSTAFFRESOURCES bit
select
@INCLUDEALLSTAFFRESOURCES = INCLUDEALLSTAFFRESOURCES
from dbo.RATESCALE
where ID = @CONTEXTID
if @INCLUDEALLSTAFFRESOURCES = 1
begin
select
null,
'All staffing resources included' as NAME
end
else
begin
select
VOLUNTEERTYPE.ID,
VOLUNTEERTYPE.NAME
from dbo.RATESCALESTAFFRESOURCE
inner join dbo.VOLUNTEERTYPE on RATESCALESTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
where RATESCALEID = @CONTEXTID
order by VOLUNTEERTYPE.NAME
end
end