database:procedures:pears_notificationcustomfields



pears.NotificationCustomFields

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

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NotificationCustomFields" IS 
{CREATE FUNCTION NotificationCustomFields 
(IN pfieldname CHAR(30), 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/procedures/pears_notificationcustomfields.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1