pears.NetOwnerJobRateList

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."NetOwnerJobRateList"()
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT "list"("string"("TempPayBandID",']~[',"TempPayBand"."Description"+' - '+"TempPayBand"."Unit"),']~[' ORDER BY "Description" ASC) INTO "rv" FROM "TempPayBand";
  RETURN "rv"
END