pears.AutoMatchShiftMatchOrder [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.AutoMatchShiftMatchOrder ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."AutoMatchShiftMatchOrder"( 
  in @PersonID char(20),in @TempShiftPlanID char(20),in @Score double,in @Custom double,in @OldOrNew char(3) ) 
returns double
begin
  -- Will sort in DESCENDING order of the value returned.
  -- @Score (from MatchShifts)  explicit availability being weighted higher.
  -- return 0 to exclude from  notification
  declare "rv" double;
  if @OldOrNew = 'Old' then
    -- select ... from AutoMatchOldTempWeightingConfig 
    -- do the calcs 
  else
    -- select ... from AutoMatchNewTempWeightingConfig 
  end if;
  set "rv" = 1000*@Score;
  return "rv"
end
</code>