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