database:functions:pears_notificationcustomfields



pears.NotificationCustomFields

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

Original SQL

CREATE FUNCTION "pears"."NotificationCustomFields"( 
  IN "pfieldname" CHAR(30),IN "pTemplateID" CHAR(50) DEFAULT NULL,IN "pPersonID" CHAR(20) DEFAULT NULL,
  IN "pVacancyID" CHAR(20) DEFAULT NULL,IN "pEmploymentID" CHAR(20) DEFAULT NULL,
  IN "pProgressid" CHAR(20) DEFAULT NULL,IN "pPlacementid" CHAR(20) DEFAULT NULL,
  IN "pSubjectType" VARCHAR(40) DEFAULT NULL,IN "pSubjectIDs" long VARCHAR DEFAULT NULL ) 
RETURNS long VARCHAR
BEGIN
  -- complex custom fields
END
  • database/functions/pears_notificationcustomfields.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1