sa39-00

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
sa39-00 [2015/08/07 17:01] – Justin Willeysa39-00 [2015/08/07 17:02] – Justin Willey
Line 29: Line 29:
 returns double returns double
 begin begin
-  --  declare rv double; +rates
-  --  function modified for Geneva Healthcare by GJW 2015-08-07 to apply rules for care workers with own contracted rates+
   declare @UserID char(50);   declare @UserID char(50);
   declare @TempBaseRate double;   declare @TempBaseRate double;
Line 61: Line 60:
     when @PayrollFlag = '02' then return round(@TempBaseRate*1.5,2) //Time + one half     when @PayrollFlag = '02' then return round(@TempBaseRate*1.5,2) //Time + one half
     when @PayrollFlag = '16' then return round(@TempBaseRate*1.25,2) //Time + one quarter     when @PayrollFlag = '16' then return round(@TempBaseRate*1.25,2) //Time + one quarter
-    when @PayrollFlag = '75' then return round(@TempBaseRate+isnull(@TempEveningRate,0),2) //Employees evening uplift  +    when @PayrollFlag = '75' then return round(@TempBaseRate+isnull(@TempEveningRate,0),2) --Employees evening uplift  
-    when @PayrollFlag = '76' then return round(@TempBaseRate+isnull(@TempWeekEndRate,0),2) //Employees weekend uplift +    when @PayrollFlag = '76' then return round(@TempBaseRate+isnull(@TempWeekEndRate,0),2) --Employees weekend uplift 
-    when @PayrollFlag in( '45','46','47','48','990','PETALL','EXPEN','ONCALL','SLEEPO') then return BaseRate //Expenses and Holiday Pay etc excluded so use placement or vacancy rate+    when @PayrollFlag in( '45','46','47','48','990','PETALL','EXPEN','ONCALL','SLEEPO') then return BaseRate --Expenses and Holiday Pay etc excluded so use placement or vacancy rate
     else     else
-      return round(@TempBaseRate,2) //Employee base rate applies+      return round(@TempBaseRate,2) --Employee base rate applies
     end case     end case
   end if   end if
  • sa39-00.txt
  • Last modified: 2017/12/01 16:35
  • by 127.0.0.1