database:procedures:pears_netownerjobratelist



pears.NetOwnerJobRateList

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerJobRateList" IS 
{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
}
  • database/procedures/pears_netownerjobratelist.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1