Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.NotificationCustomFields ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== Original SQL ===== <code sql> 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 } </code> database/procedures/pears_notificationcustomfields.txt Last modified: 2026/08/07 19:24by 127.0.0.1