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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."AutoMatchShiftMatchOrder" IS 
{create FUNCTION 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>