pears.TempCustomRateGenerator [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.TempCustomRateGenerator ======
<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"."TempCustomRateGenerator"( in "ID" char(20),in "YearNo" integer,in "PeriodNo" integer,in "PeriodLength" char(20),in "PeriodStartDate" date,in "PeriodEndDate" date,in "PersID" char(20),in "VacID" char(20),in "PlacID" char(20),in "ProvTSID" char(20),in "BehaviourFlag" smallint ) 
returns integer
begin
  -- Return null if not using custom rates (default)
  -- Return 1 if custom rates inserted into TempCustomJobRate table with GroupID column = ID param value
  -- BehaviourFlag param will be non-zero if requested rate behaviour is other than the default
  -- e.g. a different scheme selected during timesheet completion or an override scheme for AWR or secondary agency
  return null
end
</code>