database:functions:pears_pshealthbranch



pears.psHealthBranch

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

Original SQL

CREATE FUNCTION "pears"."psHealthBranch"( 
  IN "ShiftID" CHAR(20),IN "ShiftPlanID" CHAR(20),IN "persid" CHAR(20),IN "RecipientOrCarer" CHAR(1) ) 
RETURNS CHAR(100) -- not sure where branch will come from
BEGIN
  -- hard code translation table here
  RETURN '1'
-- this is "Branch ICS"
END
  • database/functions/pears_pshealthbranch.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1