pears.TempVacancyShiftMatchOrder [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.TempVacancyShiftMatchOrder ======
<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"."TempVacancyShiftMatchOrder"( in "pScore" double,in "pCustom" double,in "pHighlight" smallint,in "Persid" char(20),in "Vacid" char(20) ) 
returns double
begin
  -- Will sort in DESCENDING order of the value returned.
  -- pScore (the default) is the number of the shifts they can do with explicit availability being weighted higher.
  -- pCustom is the custom column value.
  -- pHighlight is the previous usage flag - 2 for same vacancy, 1 for same company, 0 for neither.
  declare "rv" double;
  set "rv" = "pScore";
  return "rv"
end
</code>