database:functions:pears_pshealthtasktype



pears.psHealthTaskType

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

Original SQL

CREATE FUNCTION "pears"."psHealthTaskType"( 
  IN "ShiftID" CHAR(20),IN "ShiftPlanID" CHAR(20) ) 
RETURNS CHAR(100)
BEGIN
  -- lookup template, hard code translation table here
  RETURN '29'
-- this is task type ics
-- the task type ids are autogenerated, not visible on the website but can be read from browser URL
END
  • database/functions/pears_pshealthtasktype.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1