pears.TempCustomRateGenerator

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