iqx - database:functions Recruitment software that liberates your business https://iqxusers.co.uk/iqxhelp/ 2026-08-07T22:46:35+00:00 iqx https://iqxusers.co.uk/iqxhelp/ https://iqxusers.co.uk/iqxhelp/lib/exe/fetch.php?media=wiki:logo.png text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AccordCompCode https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_accordcompcode&rev=1786130660  pears.AccordCompCode Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AccordCompCode"( in "payident" char(1) ) returns char(1) begin declare "rv" char(1); set "rv" = "payident"; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AccordEmployeeCode https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_accordemployeecode&rev=1786130660  pears.AccordEmployeeCode Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AccordEmployeeCode"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pid" char(20),in "payident" char(1) ) returns char(6) begin /* side effect updates payrollnumber */ declare "pn" integer; declare "rv" char(6); declare "LiveSys" integer; declare "ParaSys" int… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AccordERNITimesheet https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_accordernitimesheet&rev=1786130660  pears.AccordERNITimesheet Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AccordERNITimesheet"( in "tsid" char(20),in "tslineid" char(20) ) returns double begin declare "rv" double; set "rv" = 0.0; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AccordPayrollCode https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_accordpayrollcode&rev=1786130660  pears.AccordPayrollCode Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AccordPayrollCode"( in "PersID" char(20) ) returns varchar(6) begin -- Payroll codes must exist in Accord. declare "rv" varchar(6); declare "payfreq" integer; select "payfrequency" into "payfreq" from "pay_employee" where "personid" = "PersID"; if "payfreq" = 12 then set "rv" = 'MONTH'… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AddRecoveryHours https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_addrecoveryhours&rev=1786130660  pears.AddRecoveryHours Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AddRecoveryHours"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tfrom" time,in "tto" time,in "hrs" smallint ) returns time begin declare "rv" time; if "isnull"("hrs",0) <= 0 or "tfrom" is null or "tto" is null then return "tto" end if; if "hrs" > 23 then … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AddressValidation https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_addressvalidation&rev=1786130660  pears.AddressValidation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AddressValidation"( in @RecordType char(1),in @RecordID char(20),in @Addr1 char(100),in @Addr2 char(100),in @Addr3 char(100),in @Town char(100),in @County char(100),in @Country char(100),in @Postcode char(100) ) returns long varchar -- Non-Maintained Function -- -- @RecordType P - Person, C - Co… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AdjustPayForceNI https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_adjustpayforceni&rev=1786130660  pears.AdjustPayForceNI Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AdjustPayForceNI"( in "pay" double,in "pid" char(20) ) returns double begin return("pay") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AgencyIDForRateScript https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_agencyidforratescript&rev=1786130660  pears.AgencyIDForRateScript Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AgencyIDForRateScript"( in "vacid" char(20),in "persid" char(20) ) returns char(20) begin return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AutoMatchShiftMatchOrder https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_automatchshiftmatchorder&rev=1786130660  pears.AutoMatchShiftMatchOrder Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AutoMatchShiftMatchOrder"( in @PersonID char(20),in @TempShiftPlanID char(20),in @Score double,in @Custom double,in @OldOrNew char(3) ) returns double begin -- Will sort in DESCENDING order of the value returned. -- @Score (from MatchShifts) explicit availability being weighted hi… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWREntityGrade https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrentitygrade&rev=1786130660  pears.AWREntityGrade Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWREntityGrade"( in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns char(4) begin declare "rv" char(4); -- Grade for AWR purposes, not stored with shift or timesheet line set "rv" = "EntityGrade"("VacID","PersID","PlacID","ShiftID"); return "rv" en… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRGap https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrgap&rev=1786130660  pears.AWRGap Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRGap"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "jobmasterid" char(20),in "WeekNo" integer,in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns integer begin declare "rv" integer; declare "AWRStat" integer; declare "AWRLink" cha… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRPlacement https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrplacement&rev=1786130660  pears.AWRPlacement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRPlacement"( in "vacid" char(20),in "persid" char(20),in "shiftid" char(20) ) returns char(20) begin declare "rv" char(20); -- finds placementid for use in AWR set "rv" = null; if "shiftid" is not null then select "placementid" into "rv" from "tempshift" where "tempshiftid" = "shiftid"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRQualified https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrqualified&rev=1786130660  pears.AWRQualified Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRQualified"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "jobmasterid" char(20),in "WeekNo" integer,in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns integer not deterministic begin declare "pid" char(20); declare "vid" char… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRQualifiedCustomOverRide https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrqualifiedcustomoverride&rev=1786130660  pears.AWRQualifiedCustomOverRide Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRQualifiedCustomOverRide"( in @AWRQualifiedStatus integer,in @JobMasterID char(20),in @WeekNo integer,in @VacID char(20),in @PersID char(20),in @PlacID char(20),in @ShiftID char(20) ) returns integer not deterministic begin return @AWRQualifiedStatus end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrstatuschangeallowed&rev=1786130660  pears.AWRStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRStatusChangeAllowed"( in "id" char(20),in "oldstatus" char(1),in "newstatus" char(1),in "VorPorC" char(1) ) returns long varchar -- If change is disallowed you must set status back to oldstatus before returning an error message -- VorPorC V = vacancy P = placement (AWRJobMaster) C = comp… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.AWRWeeks https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_awrweeks&rev=1786130660  pears.AWRWeeks Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."AWRWeeks"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @JobMasterID char(20),in @WeekNo integer,in @VacID char(20),in @PersID char(20),in @PlacID char(20),in @ShiftID char(20) ) returns integer begin declare @AWRStat integer; declare @AWRLink char(20); declare @PersonID c… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.Base29Safe https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_base29safe&rev=1786130660  pears.Base29Safe Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."Base29Safe"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "seed" integer,in "digits" smallint ) returns char(20) begin declare "rv" char(20); declare "m" integer; declare "sdigits" char(29); -- Where the code must be handled by humans, letters O and I can be confused w… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.Base34 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_base34&rev=1786130660  pears.Base34 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."Base34"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "seed" integer,in "digits" smallint ) returns char(20) begin declare "rv" char(20); declare "m" integer; declare "sdigits" char(34); -- Where the code must be handled by humans, letters O and I can be confused with zero… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.Base36 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_base36&rev=1786130660  pears.Base36 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."Base36"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "seed" integer,in "digits" smallint ) returns char(20) begin declare "rv" char(20); declare "m" integer; set "rv" = ''; if(("digits" > 20) or("digits" < 1)) then set "digits" = 20 end if; while "seed" > 0 loop … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreCopy https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstorecopy&rev=1786130660  pears.BlobstoreCopy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreCopy"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "fromclass" char(1),in "fromid" char(20),in "toclass" char(1),in "toid" char(20),in "requestedby" char(15) ) returns integer not deterministic begin declare "z" integer; set "z" = "BlobstoreRead"("fromclass","… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreDbFolder https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstoredbfolder&rev=1786130660  pears.BlobstoreDbFolder Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreDbFolder"() returns char(250) not deterministic /* Application Maintained Function / Procedure - DO NOT EDIT*/ begin /* Return the full path of the database directory including trailing separator */ return "regexp_substr"("db_property"('file'),'^.+\\W(?=\\w+[.](db|DB)$)') end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreDeleteExternal https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstoredeleteexternal&rev=1786130660  pears.BlobstoreDeleteExternal Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreDeleteExternal"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "xpath" char(250) ) returns integer not deterministic begin declare "delcmd" char(10); if "isnull"("xpath",'') <> '' then if "right"("BlobstoreDbFolder"(),1) = '/' then -- sp_delete_fil… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreExtFolder https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstoreextfolder&rev=1786130660  pears.BlobstoreExtFolder Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreExtFolder"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "blobdate" date ) returns char(250) not deterministic begin declare "rv" char(250); declare "b" tinyint; declare "sep" char(1); select first "blobexternalstorage","trim"("blobexternalrootfolder")… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreFetch https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstorefetch&rev=1786130660  pears.BlobstoreFetch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreFetch"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "blobclass" char(1),in "blobid" char(20) ) returns long binary begin declare "xpath" char(250); declare "dat" long binary; select "externalfilepath","blob" into "xpath","dat" from "blobstore" where "class"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreFullPath https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstorefullpath&rev=1786130660  pears.BlobstoreFullPath Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreFullPath"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "xpath" char(250) ) returns char(250) not deterministic begin /* if xpath is relative then prepend with the database folder */ if "charindex"(':',"xpath") > 0 or "left"("xpath",1) = '/' or "left"("xpat… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreRead https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstoreread&rev=1786130660  pears.BlobstoreRead Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreRead"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "blobclass" char(1),in "blobid" char(20),in "requestedby" char(15) ) returns integer not deterministic begin declare "z" integer; declare "xpath" char(250); declare "dat" long binary; select "isnull"("zipp… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreRelocate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstorerelocate&rev=1786130660  pears.BlobstoreRelocate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreRelocate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "blobclass" char(1),in "blobid" char(20) ) returns integer not deterministic begin declare "z" integer; declare "xpath" char(250); declare "xfolder" char(250); declare "bAlreadyExists" integer; s… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BlobstoreWrite https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_blobstorewrite&rev=1786130660  pears.BlobstoreWrite Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BlobstoreWrite"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "blobclass" char(1),in "blobid" char(20),in "blobzipped" tinyint,in "requestedby" char(15) ) returns integer not deterministic begin declare "bAlreadyExists" integer; declare "bNewfilenameNeeded" integer; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BroadBeanCreatePost https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_broadbeancreatepost&rev=1786130660  pears.BroadBeanCreatePost Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BroadBeanCreatePost"( in @Instance char(20),in @JobTitle char(65),in @Industry char(100),in @JobType char(9),in @VacancyID char(20),in @BroadbeanLocationID integer,in @JobRef char(20),in @Duration char(30),in @StartDate char(30),in @Salary_From integer,in @Salary_To integer,in @Salary_per char(… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BulkDocPackCompanyAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_bulkdocpackcompanyallowed&rev=1786130660  pears.BulkDocPackCompanyAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BulkDocPackCompanyAllowed"( in "CompID" char(20) ) returns integer begin -- test on division, question, user return 1 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.BulkDocPackPackAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_bulkdocpackpackallowed&rev=1786130660  pears.BulkDocPackPackAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."BulkDocPackPackAllowed"( in "CompID" char(20),in "ContID" char(20) ) returns integer begin -- test on division, question, user return 1 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CanUploadVacancy https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_canuploadvacancy&rev=1786130660  pears.CanUploadVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CanUploadVacancy"( in "vacID" char(20) ) returns integer begin if exists(select "Vacancyid" from "vacancy" where "vacancyid" = "vacid" and "status" = 'C') then return 1 else return 0 end if end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CollectionDeleteAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_collectiondeleteallowed&rev=1786130660  pears.CollectionDeleteAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CollectionDeleteAllowed"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pCollectionid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "collectioncount" integer; set "rv" = ''; if not exists(select * from "collection" where "collec… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CollectionGetItemTypeName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_collectiongetitemtypename&rev=1786130660  pears.CollectionGetItemTypeName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CollectionGetItemTypeName"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ItemType" char(2) ) returns varchar(20) begin declare "rv" varchar(20); /* Item Types P -person, C -company, E -employment, L -placement, R -progress, T -timesheet, I -Invoice, V -vaca… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CollectionHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_collectionheadline&rev=1786130660  pears.CollectionHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CollectionHeadline"( in @CollectionID char(20) ) returns long varchar begin declare "rv" double; -- if has no parent then top level -- if a parent look at children?? return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CollectionItemDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_collectionitemdescription&rev=1786130660  pears.CollectionItemDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CollectionItemDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "CollectionID" char(20),in "ItemType" char(2),in "ItemID" char(20) ) returns varchar(250) begin declare "rv" varchar(250); -- DECLARE CNote LONG VARCHAR; /* Item Types P -person, C -… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.commathousands https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_commathousands&rev=1786130660  pears.commathousands Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."commathousands"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "d" double ) returns char(20) begin declare "rv" char(20); declare "s" char(20); declare "t" char(20); declare "i" integer; declare "c" char(1); if "d" is null then return null end if; if "d"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CommaThousandsDec https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_commathousandsdec&rev=1786130660  pears.CommaThousandsDec Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CommaThousandsDec"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "d" double ) returns char(40) begin declare "rv" char(40); declare "s" char(20); declare "t" char(20); declare "i" integer; declare "c" char(1); declare "fract" double; set "fract" = "abs"("r… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CompanyHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_companyheadline&rev=1786130660  pears.CompanyHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CompanyHeadline"( in "RecordID" char(20) ) returns long varchar begin declare "RV" long varchar; declare "Part" long varchar; declare "NewLine" char(2); set "rv" = ''; set "Part" = ''; set "NewLine" = "char"(13)+"Char"(10); select "list"(' '+"number") into "Part" from "phone" where "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CompanyKeyWordsCustom https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_companykeywordscustom&rev=1786130660  pears.CompanyKeyWordsCustom Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CompanyKeyWordsCustom"( in @CompanyID char(20) ) returns long varchar begin declare "rv" long varchar; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CompanyKeyWordsQuestion https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_companykeywordsquestion&rev=1786130660  pears.CompanyKeyWordsQuestion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CompanyKeyWordsQuestion"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @CompanyID char(20) ) returns long varchar begin declare "rv" long varchar; select "list"(distinct "GetQuestAnswer"("t"."TagLocation","t"."TagID",@CompanyID),' ') into "rv" from "Ta… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CompanySalesStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_companysalesstatuschangeallowed&rev=1786130660  pears.CompanySalesStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CompanySalesStatusChangeAllowed"( in "compid" char(20),in "oldstatus" char(20),in "newstatus" char(20) ) returns long varchar -- If change is disallowed you must set status back to oldstatus before returning an error message begin declare "rv" long varchar; set "rv" = ''; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CompanyStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_companystatuschangeallowed&rev=1786130660  pears.CompanyStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CompanyStatusChangeAllowed"( in "compid" char(20),in "oldstatus" char(1),in "newstatus" char(1) ) returns long varchar -- If change is disallowed you must set status back to oldstatus before returning an error message begin declare "rv" long varchar; set "rv" = ''; return("rv") en… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceScore https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancescore&rev=1786130660  pears.ComplianceScore Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceScore"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20),in "pVacancyID" char(20) default null ) returns double begin declare "act" double; declare "poss" double; declare "pComplianceDomainID" char(20); declare "pClientCode" char(12); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceSummary https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancesummary&rev=1786130660  pears.ComplianceSummary Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceSummary"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20) ) returns long varchar begin declare "errMsg" long varchar; declare "warnMsg" long varchar; declare "act" double; declare "poss" double; declare "xScore" char(20); set "act… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceValid https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancevalid&rev=1786130660  pears.ComplianceValid Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceValid"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20),in "pComplianceDomainID" char(20),in "AtDate" date,in "pClientCode" char(12) default null ) returns long varchar begin declare "errMsg" long varchar; declare "warnMsg" long varchar; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceValidforPlacement https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancevalidforplacement&rev=1786130660  pears.ComplianceValidforPlacement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceValidforPlacement"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20),in "pVacancyID" char(20) ) returns long varchar begin declare "pComplianceDomainID" char(20); declare "pClientCode" char(12); declare "pDate" date; declare … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceValidforTempShift https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancevalidfortempshift&rev=1786130660  pears.ComplianceValidforTempShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceValidforTempShift"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20),in "pTempShiftPlanID" char(20) ) returns long varchar begin declare "pComplianceDomainID" char(20); declare "pClientCode" char(12); declare "pDate" date; de… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ComplianceValidPerson https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_compliancevalidperson&rev=1786130660  pears.ComplianceValidPerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ComplianceValidPerson"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pPersonID" char(20),in "pIncludeWarnings" integer ) returns long varchar begin declare "errMsg" long varchar; declare "warnMsg" long varchar; for "PFOR" as "PCUR" no scroll cursor for se… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ConfirmationDepartmentAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_confirmationdepartmentallowed&rev=1786130660  pears.ConfirmationDepartmentAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ConfirmationDepartmentAllowed"( in @DeptID char(2) ) returns smallint begin return 1 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ConsentHidePerson https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_consenthideperson&rev=1786130660  pears.ConsentHidePerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ConsentHidePerson"( in "PersID" char(20),in "Source" char(4) ) returns smallint begin -- return 1 to hide 0 to show -- use userstaffid + role to decide if DPC -- Source - PSEL = person selector, VRES = vacancy search result, CEVE contact event (to hide details and disable new cont… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ConsentOptionChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_consentoptionchangeallowed&rev=1786130660  pears.ConsentOptionChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ConsentOptionChangeAllowed"( in "PersID" char(20),in "CTypeID" char(20),in "OldConsentTypeOptionID" char(20), in "NewConsentTypeOptionID" char(20) ) returns long varchar begin -- if not allowed return reason, change will be blocked end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ConsultantChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_consultantchangeallowed&rev=1786130660  pears.ConsultantChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ConsultantChangeAllowed"( in "recordtype" char(1),in "recordid" char(20),in "oldstaff" char(20),in "newstaff" char(20) ) returns long varchar -- If change is disallowed consultant change is blocked -- C - company, P - person, V - Vacancy, P - Placement, R - Progress begin declare "rv"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ContactEventHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_contacteventheadline&rev=1786130660  pears.ContactEventHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ContactEventHeadline"( in "recordid" char(20),in "PersID" char(20),in "EmpID" char(20),in "Vacid" char(20),in "PlacID" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.contactlink https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_contactlink&rev=1786130660  pears.contactlink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."contactlink"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sempid" char(20),in "spersid" char(20),in "sfromwho" char(1),in "stowho" char(1) ) returns char(50) begin declare "rv" char(50); if("sempid" is null or "spersid" is null) and not("sfromwho" = 'A' and "spersid" is… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.contresptran https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_contresptran&rev=1786130660  pears.contresptran Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."contresptran"( in "oldresp" char(1) ) returns char(2) begin declare "rv" char(2); case "oldresp" when 'n' then set "rv" = '1' when 'i' then set "rv" = '3' when 'a' then set "rv" = 'D' when 'm' then set "rv" = 'B' when 'e' then set "rv" = '2' when '1' then set "rv" = 'C' when '4' the… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CreateICSFile https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_createicsfile&rev=1786130660  pears.CreateICSFile Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CreateICSFile"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "puid" char(20),in "pLocation" char(200),in "pnotes" long varchar,in "pStartTime" timestamp, in "pEndTime" timestamp,in "pdescription" char(200),in "ppriority" smallint, in "precurrance" smallint,in "ppopup" sm… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CustomSMSHTTPRequest https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_customsmshttprequest&rev=1786130660  pears.CustomSMSHTTPRequest Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CustomSMSHTTPRequest"() returns long varchar begin end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.CVSendAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_cvsendallowed&rev=1786130660  pears.CVSendAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."CVSendAllowed"( in @personid char(20),in @contacteventid char(20),in @progressid char(20) ) returns long varchar begin declare @RV long varchar; return(@RV) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DataManagementErase https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_datamanagementerase&rev=1786130660  pears.DataManagementErase Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DataManagementErase"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @PersonID char(20),in "DeleteAll" char(1) default 'N',in "Anonymise" char(1) default 'N', in "RemoveContactEvents" char(1) default 'N',in "ContactEventDate" date default current date, in "RemoveDocs… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DataManagementEraseCustom https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_datamanagementerasecustom&rev=1786130660  pears.DataManagementEraseCustom Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DataManagementEraseCustom"( in @PersonID char(20) ) returns long varchar begin /* deal with any custom tables/views */ /* return blank if OK otherwise error message */ return '' end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DateAndTimeOverLap https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dateandtimeoverlap&rev=1786130660  pears.DateAndTimeOverLap Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DateAndTimeOverLap"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s1d" date,in "s1t1" time,in "s1t2" time,in "s2d" date,in "s2t1" time,in "s2t2" time ) returns tinyint begin declare "rv" tinyint; declare "s1f" timestamp; declare "s1t" timestamp; declare "s2f" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.dateToNearest https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_datetonearest&rev=1786130660  pears.dateToNearest Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."dateToNearest"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pDate" date,in "pUnit" char(1) ) returns date deterministic begin case "pUnit" when 'd' then return "pDate" when 'w' then while "dow"("pDate") <> 2 loop set "pDate" = "pDate"-1 end loop; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DAXTRACreate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_daxtracreate&rev=1786130660  pears.DAXTRACreate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DAXTRACreate"( in "paramsp" char(20) ) returns long varchar begin declare "RVal" long varchar; -- personid if successful -- failmessage= if fails return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DAXTRADeDuplicate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_daxtradeduplicate&rev=1786130660  pears.DAXTRADeDuplicate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DAXTRADeDuplicate"( in "paramsp" char(20) ) returns long varchar begin declare "RVal" long varchar; declare "fname" char(100); declare "lname" char(100); declare "filter" long varchar; declare "sel" long varchar; declare "maxrecs" integer; set "maxrecs" = 5; set "filter" = ' wher… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DAXTRADelete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_daxtradelete&rev=1786130660  pears.DAXTRADelete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DAXTRADelete"( in "paramsp" char(20) ) returns long varchar begin declare "RVal" long varchar; -- blank if successful -- failmessage= if fails return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DAXTRAGenerate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_daxtragenerate&rev=1786130660  pears.DAXTRAGenerate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DAXTRAGenerate"( in "paramsp" char(20) ) returns long varchar begin declare "RVal" long varchar; -- name_fo=John+Smith&name_ln=Smith&name_fn=John&same_sx=Male if successful -- blank if not found return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DAXTRAUpdate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_daxtraupdate&rev=1786130660  pears.DAXTRAUpdate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DAXTRAUpdate"( in "paramsp" char(20) ) returns long varchar begin declare "RVal" long varchar; -- personid if successful -- failmessage= if fails return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOldJRlog https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanupoldjrlog&rev=1786130660  pears.DBCleanupOldJRlog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOldJRlog"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "age" integer,in "countordo" char(1) ) returns integer begin declare @RC integer; select "count"() into @RC from "iqxjobrunnerlog" where "completiontime" <= current date-"age"; if "countordo" = '… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOldRecentObjects https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanupoldrecentobjects&rev=1786130660  pears.DBCleanupOldRecentObjects Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOldRecentObjects"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "age" integer,in "sid" char(20),in "countordo" char(1) ) returns integer begin declare @RC integer; declare @Staff char(20); select "count"() into @RC from "RecentObjects" where "staf… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOrphanBlobstore https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanuporphanblobstore&rev=1786130660  pears.DBCleanupOrphanBlobstore Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOrphanBlobstore"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "countordo" char(1) ) returns integer begin declare @RC integer; set @RC = 0; if "countordo" = 'C' then select "count"() into @RC from "Blobstore" where(((("class" = 'V') or("… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOrphanOLEDocument https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanuporphanoledocument&rev=1786130660  pears.DBCleanupOrphanOLEDocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOrphanOLEDocument"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "countordo" char(1) ) returns integer begin declare @RC integer; set @RC = 0; if "countordo" = 'C' then select "count"() into @RC from "OLEDocument" where((("ownertype" = … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOrphanPhone https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanuporphanphone&rev=1786130660  pears.DBCleanupOrphanPhone Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOrphanPhone"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "countordo" char(1) ) returns integer begin declare @RC integer; set @RC = 0; if "countordo" = 'C' then select "count"() into @RC from "phone" where((("who" = 'P') and not exists(sele… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOrphanRecentObjects https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanuporphanrecentobjects&rev=1786130660  pears.DBCleanupOrphanRecentObjects Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOrphanRecentObjects"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "countordo" char(1) ) returns integer begin declare @RC integer; set @RC = 0; if "countordo" = 'C' then select "count"() into @RC from "RecentObjects" where((not exist… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DBCleanupOrphanTagValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dbcleanuporphantagvalue&rev=1786130660  pears.DBCleanupOrphanTagValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DBCleanupOrphanTagValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "countordo" char(1) ) returns integer begin declare @RC integer; set @RC = 0; if "countordo" = 'C' then select "count"() into @RC from "tagvalue" where(((("taglocation" = 'P') o… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DeHead https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dehead&rev=1786130660  pears.DeHead Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DeHead"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s" long varchar ) returns long varchar begin declare "i" smallint; if "s" is null then return null end if; set "i" = "charindex"("char"(9),"s"); if "i" > 0 then set "s" = "stuff"("s",1,"i",'') end if; ret… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DeleteOldDatabaseLogs https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_deleteolddatabaselogs&rev=1786130660  pears.DeleteOldDatabaseLogs Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DeleteOldDatabaseLogs"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @DaysToKeep smallint ) returns smallint begin --Deletes all files log files with pattern 000000AA.LOG in current log folder over a given age. Read only flags are ignored. declare @Command char(… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.depttran https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_depttran&rev=1786130660  pears.depttran Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."depttran"( in "deptu" char(1) ) returns char(2) begin declare "rv" char(2); case "deptu" when '0' then set "rv" = '0' when 'B' then set "rv" = 'CN' when 'H' then set "rv" = 'CT' when 'J' then set "rv" = 'CU' when 'G' then set "rv" = 'DR' when 'A' then set "rv" = 'EN' when 'C' then set "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DescriptionForStagedInvoice https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_descriptionforstagedinvoice&rev=1786130660  pears.DescriptionForStagedInvoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DescriptionForStagedInvoice"( in "spaymentid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = null; select "string"("person"."name",' - ',"stagedpayments"."description") into "rv" from "stagedpayments" key join "placement" key join "employment"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DescriptionForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_descriptionfortimesheetline&rev=1786130660  pears.DescriptionForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DescriptionForTimesheetLine"( in "tslineid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = null; select "string"('W/e ',"dateformat"("weekmonthenddate"("temptimesheet"."period","temptimesheet"."periodlength"),'dd/mm/yy'),' ',"person"."name",' ',"tempp… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.dialable https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_dialable&rev=1786130660  pears.dialable Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."dialable"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s" char(100) ) returns char(100) begin declare "rv" char(100); declare "c" char(1); declare "i" smallint; set "rv" = ''; set "i" = 1; while "i" <= "length"("s") loop set "c" = "substr"("s","i",1); if "c… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.digitsonly https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_digitsonly&rev=1786130660  pears.digitsonly Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."digitsonly"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s" char(100) ) returns char(100) begin declare "rv" char(100); declare "c" char(1); declare "i" smallint; set "rv" = ''; set "i" = 1; while "i" <= "length"("s") loop set "c" = "substr"("s","i",1); i… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DistanceBetweenPostCodes https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_distancebetweenpostcodes&rev=1786130660  pears.DistanceBetweenPostCodes Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DistanceBetweenPostCodes"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @PostCodeA char(20),in @PostCodeB char(20),in @Unit char(2) ) returns numeric(11,3) begin declare @EastingA numeric(11,3); declare @EastingB numeric(11,3); declare @NorthingA numeric(11… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DocumentPackAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_documentpackallowed&rev=1786130660  pears.DocumentPackAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DocumentPackAllowed"( in "docpackid" char(20),in "persid" char(20),in "vacid" char(20),in "planid" char(20),in "shiftid" char(20),in "placid" char(20) ) returns long varchar begin -- function called BEFORE selecting who to send to -- persid, docpackid and vacid always populated) declare … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DocumentPackAttachName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_documentpackattachname&rev=1786130660  pears.DocumentPackAttachName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DocumentPackAttachName"( in "docpackid" char(20),in "doctypeid" char(20),in "persid" char(20),in "vacid" char(20),in "planid" char(20),in "shiftid" char(20),in "placid" char(20) ) returns long varchar begin -- persid, docpackid, doctypeid and vacid always populated declare "rv" long var… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DocumentPackEmailBody https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_documentpackemailbody&rev=1786130660  pears.DocumentPackEmailBody Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DocumentPackEmailBody"( in "persid" char(20),in "vacid" char(20),in "oldbody" long varchar ) returns long varchar begin declare "rv" long varchar; declare "CRLF" char(2); declare "deptid" char(2); select "departmentid" into "deptid" from "vacancy" where "vacancyid" = "vacid"; set "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DuplicateCheckCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_duplicatecheckcustomcolumn&rev=1786130660  pears.DuplicateCheckCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DuplicateCheckCustomColumn"( in "RecordType" char(2),in "RecordID" char(20),in "ColNo" tinyint ) returns char(100) begin -- RecordType P=Person c=Company -- RecordID=null means return column heading for RecordType P,C or null if custom column not wanted -- RecordID=personid, … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.DuplicateVacancyAndPlacement https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_duplicatevacancyandplacement&rev=1786130660  pears.DuplicateVacancyAndPlacement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."DuplicateVacancyAndPlacement"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @OldVacancyID char(20),in @NewVacancyID char(20),in @NewEmploymentID char(20),in @OldPlacementID char(20) default null,in @NewPlacementID char(20) default null,in @CloseOffOld char(1) … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EmailBody https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_emailbody&rev=1786130660  pears.EmailBody Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EmailBody"( in "docid" char(20) ) returns long varchar // // If you have General Setting group of Accounts number 420 'Allow users to modify invoice email body text' set to Y then the docid will not be used as a parameter as the function is not called. begin declare "rv" long varchar; declare "invno… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EmailCVFileName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_emailcvfilename&rev=1786130660  pears.EmailCVFileName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EmailCVFileName"( in "persid" char(20) ) returns long varchar begin declare "rv" long varchar; select "string"('CV - ',"appnumber") into "rv" from "person" where "personid" = "persid"; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EmailLetterAsAttachmentFileName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_emailletterasattachmentfilename&rev=1786130660  pears.EmailLetterAsAttachmentFileName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EmailLetterAsAttachmentFileName"( in "tempid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "coname" char(30); select "dbname" into "coname" from "params"; // select description into rv from templatestore where templateid = tempid; // if rv is … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EMailSubject https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_emailsubject&rev=1786130660  pears.EMailSubject Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EMailSubject"( in "docid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "invno" char(12); declare "coname" char(30); select "ourref" into "invno" from "iqacdocument" where "documentid" = "docid"; select "dbname" into "coname" from "params"; set "rv" = "string"("… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EmployeeAcceptable https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_employeeacceptable&rev=1786130660  pears.EmployeeAcceptable Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EmployeeAcceptable"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "persid" char(20),in "compid" char(20),in "iTemp" smallint,in "VacID" char(20) default null,in "IncludeWithheld" smallint default 0 ) returns char(1) begin declare "result" char(1); select if "Includ… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EntityGrade https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_entitygrade&rev=1786130660  pears.EntityGrade Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EntityGrade"( in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns char(4) begin declare "rv" char(4); -- Return Null to match all grades. Null grades are always matched, whatever is returned -- If Grades set up for minimum wage for Age range the AWR grad… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EntityRateFilter https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_entityratefilter&rev=1786130660  pears.EntityRateFilter Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EntityRateFilter"( in "FilterNo" smallint,in "WeekNo" integer,in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns char(4) begin declare "rv" char(4); declare "qual" integer; -- Used to filter the rate tables -- Return null if specified FilterNo is… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EntitySpeciality https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_entityspeciality&rev=1786130660  pears.EntitySpeciality Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EntitySpeciality"( in "VacID" char(20),in "PersID" char(20),in "PlacID" char(20),in "ShiftID" char(20) ) returns char(4) begin declare "rv" char(4); -- Speciality for AWR set "rv" = null; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EssentialSkillDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_essentialskilldescription&rev=1786130660  pears.EssentialSkillDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EssentialSkillDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "essentialskill" char(15),in "essentialskillchoicelist" char(100),in "departmentid" char(2) ) returns char(200) begin declare "rv" char(200); declare "tagdesc" char(25); declare "tloc… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.EssentialSkillGradeDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_essentialskillgradedescription&rev=1786130660  pears.EssentialSkillGradeDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."EssentialSkillGradeDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "essentialskill" char(15),in "essentialskillgradeid" char(4),in "departmentid" char(2) ) returns char(200) begin declare "rv" char(200); declare "tloc" char(3); declare "tid… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ExpiryAlertExtra https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_expiryalertextra&rev=1786130660  pears.ExpiryAlertExtra Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ExpiryAlertExtra"( in "persID" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = null; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FirstWord https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_firstword&rev=1786130660  pears.FirstWord Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FirstWord"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sWords" char(50) ) returns char(50) begin declare "i" integer; set "swords" = "trim"("swords"); set "i" = "charindex"(' ',"swords"); if "i" = 0 then return "swords" else return("left"("swords","i"-1)) … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formataddress&rev=1786130660  pears.FormatAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "name" char(100),in "addr1" char(50),in "addr2" char(50),in "addr3" char(50),in "town" char(50),in "county" char(50),in "country" char(50),in "postcode" char(50), in "Capitalise" smallint,in "Style" char(1) ) /*… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatCompanyAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatcompanyaddress&rev=1786130660  pears.FormatCompanyAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatCompanyAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ReqCompanyID" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns long varchar begin declare "FormattedAddress" char(300); set "FormattedAddress" = "FormatCompanyAddress1_0"("ReqCompa… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatCompanyAddress1_0 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatcompanyaddress1_0&rev=1786130660  pears.FormatCompanyAddress1_0 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatCompanyAddress1_0"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqcompanyid" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns char(300) begin declare "FormattedAddress" char(300); declare "addr1" char(40); declare "addr2" char(40); d… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatCompanyPersonAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatcompanypersonaddress&rev=1786130660  pears.FormatCompanyPersonAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatCompanyPersonAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ReqEmploymentID" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns char(400) begin declare "FormattedAddress" char(400); declare "IncPosition" smallint; declare "IncDe… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatPersonAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatpersonaddress&rev=1786130660  pears.FormatPersonAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatPersonAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ReqPersonID" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns long varchar begin declare "FormattedAddress" char(300); set "FormattedAddress" = "FormatPersonAddress1_0"("ReqPersonID"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatPersonAddress1_0 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatpersonaddress1_0&rev=1786130660  pears.FormatPersonAddress1_0 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatPersonAddress1_0"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqpersonid" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns char(300) begin declare "FormattedAddress" char(300); declare "addr1" char(40); declare "addr2" char(40); decl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatSelfBillAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatselfbilladdress&rev=1786130660  pears.FormatSelfBillAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatSelfBillAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqAccountCode" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns char(300) begin declare "FormattedAddress" char(300); declare "addr1" char(40); declare "addr2" char(40); dec… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.FormatSiteAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_formatsiteaddress&rev=1786130660  pears.FormatSiteAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."FormatSiteAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqVacancyid" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns char(300) begin declare "FormattedAddress" char(380); declare "addr1" char(40); declare "addr2" char(40); declare "addr… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GenerateKeyname https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_generatekeyname&rev=1786130660  pears.GenerateKeyname Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GenerateKeyname"( in "x" char(100) ) returns char(100) begin declare "w1" char(100); declare "wn" char(100); declare "c" char(1); declare "i" integer; set "x" = "trim"("x"); set "i" = "charindex"("char"(32),"x"); if "i" > 0 then set "w1" = "left"("x","i"-1); if "w1" in( 'mr',… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GenerateWEBDialURL https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_generatewebdialurl&rev=1786130660  pears.GenerateWEBDialURL Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GenerateWEBDialURL"( in "number" char(100) ) returns long varchar begin end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetBrand https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getbrand&rev=1786130660  pears.GetBrand Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetBrand"( in "persid" char(20),in "vacid" char(20),in "ClientOrTemp" char(1),in "Use" char(20) ) returns char(2) begin declare "RVal" char(2); if "Use" = 'NOTIFY' then -- ClientOrTemp C - client T - temp end if; -- return visibleID of brand return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCascadeTime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcascadetime&rev=1786130660  pears.GetCascadeTime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCascadeTime"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "compid" char(20),in "vacid" char(20),in "entrytime" timestamp,in "shifttime" timestamp,in "casctime" timestamp,in "requestlevel" smallint ) returns timestamp begin declare "rv" timestamp; declare "frm" char… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCompanyAddressOnLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcompanyaddressonline&rev=1786130660  pears.GetCompanyAddressOnLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCompanyAddressOnLine"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqcompanyid" char(20) ) returns char(250) begin declare "AddressOnLine" char(250); declare "addr1" char(40); declare "addr2" char(40); declare "addr3" char(40); declare "town" char(… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCompanyGroup https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcompanygroup&rev=1786130660  pears.GetCompanyGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCompanyGroup"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "coid" char(20) ) returns long varchar begin declare "res" long varchar; declare "pid" char(20); declare "I" integer; set "I" = 1; select "GetCompanyMainParent"("coid") into "pid"; if "pid" is not … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCompanyGroupHead https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcompanygrouphead&rev=1786130660  pears.GetCompanyGroupHead Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCompanyGroupHead"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "CompID" char(20) ) returns char(20) begin declare "coid" char(20); declare "oldcoid" char(20); declare "lc" integer; select "parentcompanyid" into "coid" from "company" where "companyid" = "co… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCompanyMainParent https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcompanymainparent&rev=1786130660  pears.GetCompanyMainParent Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCompanyMainParent"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "CompID" char(20) ) returns char(20) begin declare "coid" char(20); declare "oldcoid" char(20); declare "lc" integer; select "parentcompanyid" into "coid" from "company" where "companyid" = "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetCompanyPhoneInBlock https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcompanyphoneinblock&rev=1786130660  pears.GetCompanyPhoneInBlock Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetCompanyPhoneInBlock"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqcompanyid" char(20) ) returns long varchar begin declare "phones" long varchar; declare "newline" char(2); declare "loopcounter" tinyint; declare "tab" char(1); declare "TabString" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetContactEventCaption https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcontacteventcaption&rev=1786130660  pears.GetContactEventCaption Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetContactEventCaption"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @ContactEventID char(20) ) returns char(250) begin declare @Caption char(250); declare @PersonID char(20); declare @VacancyID char(20); declare @PlacementID char(20); declare @ProgressI… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.getcontactposition https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getcontactposition&rev=1786130660  pears.getcontactposition Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."getcontactposition"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "svacancyid" char(20),in "sprogressid" char(20),in "splacementid" char(20) ) returns char(50) begin declare "rv" char(50); if "svacancyid" is not null then select "position" into "rv" from "vacan… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetDatabaseServerInfo https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getdatabaseserverinfo&rev=1786130660  pears.GetDatabaseServerInfo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetDatabaseServerInfo"() returns long varchar /* Application Maintained Function / Procedure - DO NOT EDIT*/ begin declare "FileName" char(200); declare "rv" long varchar; declare @Platform char(100); set @Platform = (select "property"('platform')); if @Platform like '%UNIX%' or @Pl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetEmployeePhoneInBlock https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getemployeephoneinblock&rev=1786130660  pears.GetEmployeePhoneInBlock Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetEmployeePhoneInBlock"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqemploymentid" char(20) ) returns long varchar begin declare "phones" long varchar; declare "newline" char(2); declare "loopcounter" tinyint; declare "tab" char(1); declare "TabStr… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetExtraRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getextrarate&rev=1786130660  pears.GetExtraRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetExtraRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pExtraRateNumber" smallint,in "pPlacOrVac" char(1),in "pID" char(20),in "pBandID" char(20),in "pEffectiveDate" date,in "pGrade" char(4),in "pFilter1" char(4),in "pFilter2" char(4),in "pFilter3" char(4) ) returns do… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetHolidayYear https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getholidayyear&rev=1786130660  pears.GetHolidayYear Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetHolidayYear"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "startdate" date,in "calcdate" date ) returns date begin /*More than a year ago?*/ "SetCurrentYear": loop if "days"("startdate","calcdate") >= 365 then set "startdate" = "years"("startdate",1) … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetInvoiceCompanyID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getinvoicecompanyid&rev=1786130660  pears.GetInvoiceCompanyID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetInvoiceCompanyID"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sclientcode" char(12) ) returns char(20) begin declare "rv" char(20); select first "companyid" into "rv" from "company" where "sclientcode" is not null and "clientcode" = "sclientcode" order by "i… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetInvoicePDF https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getinvoicepdf&rev=1786130660  pears.GetInvoicePDF Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetInvoicePDF"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @InvoiceNumber char(20),in @DocumentID char(20) ) returns long varchar begin declare @rootpath char(250); declare @AccountCode char(12); declare @InvoiceDate date; if "isnull"(@InvoiceNumber,'') = '' and "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetKeyShiftPlanState https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getkeyshiftplanstate&rev=1786130660  pears.GetKeyShiftPlanState Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetKeyShiftPlanState"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "ddate" date,in "bperson" smallint ) returns char(21) begin declare "rv" char(21); if "bperson" = 1 then return null else set "rv" = "isnull"( (select fir… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetKeyShiftState https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getkeyshiftstate&rev=1786130660  pears.GetKeyShiftState Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetKeyShiftState"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "ddate" date,in "bperson" smallint ) returns char(21) begin declare "rv" char(21); declare "id" char(20); declare "empid" char(20); declare "so" smallint; declare "wrkd" smallint;… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.getline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getline&rev=1786130660  pears.getline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."getline"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s1" long varchar,in "ln1" smallint ) returns long varchar begin declare "i" smallint; declare "ln" smallint; declare "s" long varchar; set "ln" = "ln1"; set "s" = "s1"; "loop1": loop set "ln" = "ln"-1; if… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetMinWage https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getminwage&rev=1786130660  pears.GetMinWage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetMinWage"( in "persid" char(20),in @period integer ) returns double begin declare "rv" double; declare "myage" integer; set "rv" = 0; select "truncnum"("datediff"("day","dob","weekmonthenddate"(@period,'W'))/365.25,0) into "myage" from "person" where "personid" = "persid"; if "isnull"("GetQ… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetNotifyBehaviour https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getnotifybehaviour&rev=1786130660  pears.GetNotifyBehaviour Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetNotifyBehaviour"( in "persid" char(20),in "vacid" char(20),in "ClientOrTemp" char(1) ) returns char(10) begin declare "RVal" char(10); -- return values set of E - email P - print S - SMS -- blank/null do nothing -- ClientOrTemp C - client T - temp return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetNotifyClientEmail https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getnotifyclientemail&rev=1786130660  pears.GetNotifyClientEmail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetNotifyClientEmail"( in "persid" char(20),in "vacid" char(20) ) returns long varchar begin declare "RVal" long varchar; -- 1/more email address, can be edited later if switch on return "RVal" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPayOrCharge https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpayorcharge&rev=1786130660  pears.GetPayOrCharge Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPayOrCharge"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20) ) returns char(20) begin declare "pay" double; declare "istemp" smallint; if "placorvac" = 'P' then select "isnull"("temp",0),"salary" into… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPersonAddressOnLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpersonaddressonline&rev=1786130660  pears.GetPersonAddressOnLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPersonAddressOnLine"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqpersonid" char(20) ) returns char(250) begin declare "AddressOnLine" char(250); declare "addr1" char(40); declare "addr2" char(40); declare "addr3" char(40); declare "town" char(30)… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPersonAvailPercentage https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpersonavailpercentage&rev=1786130660  pears.GetPersonAvailPercentage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPersonAvailPercentage"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "frdate" date,in "todate" date ) returns double begin declare "rv" double; declare "bonly" smallint; declare "cavail" char(1); declare "ndays" double; declare "nav… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPersonAvailState https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpersonavailstate&rev=1786130660  pears.GetPersonAvailState Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPersonAvailState"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "ddate" date ) returns char(1) begin declare "rv" char(1); declare "empid" char(20); declare "so" smallint; declare "dw" smallint; declare "Temp" tinyint; declare "Wsun" t… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPersonEmploymentHistory https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpersonemploymenthistory&rev=1786130660  pears.GetPersonEmploymentHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPersonEmploymentHistory"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "InPersonID" char(20),in "Word" char(3) ) returns long varchar begin declare "EmploymentHistory" long varchar; declare "Tab" char(1); declare "NewLine" char(2); declare "LoopCount… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPersonPhoneInBlock https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpersonphoneinblock&rev=1786130660  pears.GetPersonPhoneInBlock Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPersonPhoneInBlock"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "reqpersonid" char(20) ) returns long varchar begin declare "phones" long varchar; declare "newline" char(2); declare "loopcounter" tinyint; declare "tab" char(1); declare "TabString" cha… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPhone https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getphone&rev=1786130660  pears.GetPhone Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPhone"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "cpe" char(2),in "ptype" char(25),in "recid" char(20) ) returns char(250) begin declare "rv" char(250); select "list"("phone"."number",'; ') into "rv" from "phone" key join "phonetype" where "phone"."whoid" = "recid" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPlacementID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getplacementid&rev=1786130660  pears.GetPlacementID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPlacementID"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "persid" char(20),in "vacid" char(20) ) returns char(20) begin for "forlab" as "curs" dynamic scroll cursor for select "placement"."placementid" from "placement" key join "employment" where "placemen… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPlacementTheirRef https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getplacementtheirref&rev=1786130660  pears.GetPlacementTheirRef Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPlacementTheirRef"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "persid" char(20),in "vacid" char(20) ) returns char(50) begin declare "rv" char(50); set "rv" = null; "forstat": for "forlab" as "curs" no scroll cursor for select "placement"."theirref" f… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetPropertiesText https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getpropertiestext&rev=1786130660  pears.GetPropertiesText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetPropertiesText"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "PropertyType" char(1),in "HeaderText" long varchar,in "ConID" integer ) returns long varchar begin -- PropertyType - C for connection (requires connectionid), D for database, E for engine / server, W en… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestAnswer https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestanswer&rev=1786130660  pears.GetQuestAnswer Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestAnswer"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "tagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "i" integer; set "rv" = "getquesttext"("tagloc","tagid","parentid"); if "rv" is … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestAnswerLong https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestanswerlong&rev=1786130660  pears.GetQuestAnswerLong Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestAnswerLong"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "tagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "i" integer; set "rv" = "getquesttextLong"("tagloc","tagid","parentid"); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestAnswerNull https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestanswernull&rev=1786130660  pears.GetQuestAnswerNull Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestAnswerNull"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "tagid" char(3),in "parentid" char(20) ) returns long varchar begin return "nullif"("trim"("getquestanswer"("tagloc","tagid","parentid")),'') end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestdate&rev=1786130660  pears.GetQuestDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns date begin declare "rv" date; declare "tagval" double; set "rv" = null; select "max"("value") into "tagval" from "tagvalue" where "tagl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestGroup https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestgroup&rev=1786130660  pears.GetQuestGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestGroup"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(10),in "sparentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "prevtag" char(3); declare "multidesc" long varchar; declare "comma" char(2); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestLongWebText https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestlongwebtext&rev=1786130660  pears.GetQuestLongWebText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestLongWebText"( in "tagloc" char(3),in "wildtagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "tagval" double; declare "textval" long varchar; declare "x" char(4); declare "y" integer; declare "xunits" char(11); declare "x… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestMultiSelection https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestmultiselection&rev=1786130660  pears.GetQuestMultiSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestMultiSelection"( in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; for "fetchfor" as "fetchcursor" dynamic scroll cursor for select "string"("tagvalue"."tagchoiceid","char"(9),"tagvalue".… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestNumber https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestnumber&rev=1786130660  pears.GetQuestNumber Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestNumber"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns double begin declare "rv" double; declare "tagval" double; set "rv" = null; select "max"("value") into "tagval" from "tagvalue" whe… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestSingleSelection https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestsingleselection&rev=1786130660  pears.GetQuestSingleSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestSingleSelection"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns char(4) begin declare "rv" char(4); set "rv" = null; select "max"("tagchoiceid") into "rv" from "tagvalue" where "t… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestSingleText https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestsingletext&rev=1786130660  pears.GetQuestSingleText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestSingleText"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns char(255) begin declare "rv" char(255); set "rv" = null; select first "textvalue" into "rv" from "tagvalue" where "taglocatio… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestSingleTextPlus https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestsingletextplus&rev=1786130660  pears.GetQuestSingleTextPlus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestSingleTextPlus"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = null; select first "textvalue" into "rv" from "tagvalue" whe… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestString https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getqueststring&rev=1786130660  pears.GetQuestString Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestString"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "tagid" char(3),in "parentid" char(20) ) returns char(255) begin return "GetQuestAnswer"("tagloc","tagid","parentid") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestSubMenuSelection https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquestsubmenuselection&rev=1786130660  pears.GetQuestSubMenuSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestSubMenuSelection"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; for "fetchfor" as "fetchcursor" dynamic scroll curso… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestText https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquesttext&rev=1786130660  pears.GetQuestText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestText"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "wildtagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "tagval" double; declare "textval" long varchar; declare "x" char(4); declare … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetQuestTextLong https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getquesttextlong&rev=1786130660  pears.GetQuestTextLong Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetQuestTextLong"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tagloc" char(3),in "wildtagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "tagval" double; declare "textval" long varchar; declare "x" char(4); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftBookedDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftbookeddescription&rev=1786130660  pears.GetShiftBookedDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftBookedDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "vid" char(20),in "pid" char(20),in "edate" date ) returns char(250) begin declare "rv" char(250); for "fetchfor" as "fetchcursor" no scroll cursor for select "string"("GetTempName"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftIndicatorColour https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftindicatorcolour&rev=1786130660  pears.GetShiftIndicatorColour Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftIndicatorColour"( in "sid" char(20),in "ddate" date ) returns integer begin -- Return 0 to indicate that colour choice is to be ignored return 0 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftLength https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftlength&rev=1786130660  pears.GetShiftLength Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftLength"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @TimeFrom time,in @TimeTo time, in @BreakMinutes smallint default 0 ) returns double begin declare "ShiftLength" double; if @TimeTo > @TimeFrom then set "ShiftLength" = (cast("datediff"("minute",@TimeF… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftStateBookedDescriptionPlus https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftstatebookeddescriptionplus&rev=1786130660  pears.GetShiftStateBookedDescriptionPlus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftStateBookedDescriptionPlus"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "pid" char(20),in "ddate" date ) returns char(70) begin declare "rv" char(70); declare "s1" char(1); declare "p1" smallint; declare "px" smallint… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftStateDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftstatedescription&rev=1786130660  pears.GetShiftStateDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftStateDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "ddate" date,in "bperson" smallint ) returns char(70) begin declare "rv" char(70); declare "t" char(70); declare "tt" char(70); declare "s" char(20); declare "s1" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetShiftStateDescriptionPlus https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getshiftstatedescriptionplus&rev=1786130660  pears.GetShiftStateDescriptionPlus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetShiftStateDescriptionPlus"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sid" char(20),in "ddate" date ) returns char(70) begin declare "rv" char(70); declare "s1" char(1); declare "p1" smallint; declare "px" smallint; declare "punf" smallint; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempAWRRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempawrrate&rev=1786130660  pears.GetTempAWRRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempAWRRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20) ) returns double begin declare "rv" double; declare "pvacid" char(20); declare "ppersid" char(20); declare "pplacid" char(20); declare "pjo… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempMargin https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempmargin&rev=1786130660  pears.GetTempMargin Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempMargin"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "chargerate" double,in "payrate" double,in "temp" smallint,in "taxmethod" smallint,in "directengagement" smallint, in "actualNotPercent" smallint,in "holpayPercent" double,in "NIPercent" double,in "NIonHolpay" sm… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempname&rev=1786130660  pears.GetTempName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempName"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "persid" char(20) ) returns char(60) begin declare "rv" char(60); select "string"(if exists(select * from "wpkglobalswitchsetting" where "wpkglobalswitchid" = 'USEFULLNAME' and "location" = 'Global' and "value" = … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettemprate&rev=1786130660  pears.GetTempRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20) ) returns double begin declare "rv" double; declare "pvacid" char(20); declare "ppersid" char(20); declare "pplacid" char(20); declare "pjobtypei… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempRateByDesc https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempratebydesc&rev=1786130660  pears.GetTempRateByDesc Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempRateByDesc"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20),in "descrp" char(50),in @awr tinyint,in @grade char(4),in @ltd char(4) ) returns double begin declare "rv" double; declare "pvacid" char(20… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempRateByFlag https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempratebyflag&rev=1786130660  pears.GetTempRateByFlag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempRateByFlag"( in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20),in "flag" char(20) ) returns double begin declare "pay" double; declare "chg" double; declare "disc" double; declare "bandid" char(20); declare "vid" char(20); set "vid" = "id"; set "pay" = null; … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempRateCustom https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettempratecustom&rev=1786130660  pears.GetTempRateCustom Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempRateCustom"( in "PayOrCharge" char(1),in "PlacOrVac" char(1),in "ID" char(20) ) returns double begin return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTempRateExtra https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettemprateextra&rev=1786130660  pears.GetTempRateExtra Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTempRateExtra"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "FName" char(20),in "PlacOrVac" char(1),in "ID" char(20) ) returns double begin declare "rv" double; declare "pvacid" char(20); declare "ppersid" char(20); declare "pplacid" char(20); declare "pjob… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTextFromHTML https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettextfromhtml&rev=1786130660  pears.GetTextFromHTML Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTextFromHTML"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "htmlText" long varchar ) returns long varchar begin declare "plainText" long varchar; declare "tagStart" integer; declare "tagEnd" integer; declare "tagLength" integer; declare "tagType" char(20); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetTimeSheetDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_gettimesheetdescription&rev=1786130660  pears.GetTimeSheetDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetTimeSheetDescription"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "usesecags" tinyint,in "persid" char(20),in "secagid" char(20),in "sdescrip" long varchar ) returns long varchar begin if "isnull"("usesecags",0) = 0 or "persid" is null then return "isnu… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetVacancyCascadeTime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getvacancycascadetime&rev=1786130660  pears.GetVacancyCascadeTime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetVacancyCascadeTime"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "compid" char(20),in "vacid" char(20),in "entrytime" timestamp,in "starttime" timestamp,in "casctime" timestamp,in "requestlevel" smallint ) returns timestamp begin declare "rv" timestamp; decl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.getword https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getword&rev=1786130660  pears.getword Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."getword"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s1" long varchar,in "ln1" smallint ) returns char(200) begin declare "i" smallint; declare "ln" smallint; declare "s" char(200); set "ln" = "ln1"; set "s" = "s1"; "loop1": loop set "ln" = "ln"-1; if "ln" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.getwordex https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getwordex&rev=1786130660  pears.getwordex Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."getwordex"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s1" long varchar,in "ln1" smallint,in "sep" char(10) ) returns char(200) begin declare "i" smallint; declare "ln" smallint; declare "s" char(200); set "ln" = "ln1"; set "s" = "s1"; "loop1": loop set "ln" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GetWorkPatternWeeklyHours https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_getworkpatternweeklyhours&rev=1786130660  pears.GetWorkPatternWeeklyHours Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GetWorkPatternWeeklyHours"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "placid" char(20),in "pstartdate" date,in "penddate" date ) returns double begin declare "Absense" integer; declare "Hours" double; declare "Days" integer; declare "WeekHours" doubl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GlobalDocumentSelect https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_globaldocumentselect&rev=1786130660  pears.GlobalDocumentSelect Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GlobalDocumentSelect"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pDescription" char(50) default null,in "pDocumentTypeID" char(20) default null,in "pAgencyID" char(20) default null,in "pDivisionID" char(20) default null, in "pDepartmentID" char(2) default null,i… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.GreatestDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_greatestdate&rev=1786130660  pears.GreatestDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."GreatestDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "Date1" date,in "Date2" date ) returns date begin set "Date1" = "isnull"("Date1","Date2"); set "Date2" = "isnull"("Date2","Date1"); if "Date1" > "Date2" then return("Date1") else return("Date2") end if end… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.hashToIqxId https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_hashtoiqxid&rev=1786130660  pears.hashToIqxId Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."hashToIqxId"( in "source" char(255) ) returns char(20) deterministic begin return "upper"("left"("IQXDBID"+"hash"("source"),20)) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.HexCriterionID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_hexcriterionid&rev=1786130660  pears.HexCriterionID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."HexCriterionID"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "CriterionID" binary(20) ) returns char(40) begin declare "rv" char(40); declare "i" smallint; set "rv" = ''; set "i" = 1; while "i" <= "byte_length"("criterionid") loop set "rv" = "rv"+"right"("in… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.HideFromCombo https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_hidefromcombo&rev=1786130660  pears.HideFromCombo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."HideFromCombo"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "combovis" char(25) ) returns integer begin declare "staffcombovis" char(25); declare "i" integer; declare "c" char(1); set "combovis" = "trim"("combovis"); if "isnull"("combovis",'') = '' then retur… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.HMRC_CheckPostCode https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_hmrc_checkpostcode&rev=1786130660  pears.HMRC_CheckPostCode Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."HMRC_CheckPostCode"( in @addr1 varchar(100) ) returns char(100) begin declare @postcode char(30); declare @pos1 smallint; declare @pos2 smallint; declare @pos3 smallint; declare @pos4 smallint; declare @pos5 smallint; declare @pos6 smallint; declare @pos smallint; declare @len… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InsertDiary https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_insertdiary&rev=1786130660  pears.InsertDiary Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InsertDiary"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @StaffID char(20),in @DiaryFrom timestamp,in @DurationType char(1),in @Duration double, in @PopupMinutes smallint default null,in @WhoEntered char(20), in @PersonID char(20) default null, in @VacancyID char(20) d… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvBatchComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invbatchcomplete&rev=1786130660  pears.InvBatchComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvBatchComplete"( in "docid" char(20) ) returns long varchar begin -- This function will block with no message; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invcomplete&rev=1786130660  pears.InvComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvComplete"( in "docid" char(20) ) returns long varchar begin -- This function will block with no message; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvOB10Allowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invob10allowed&rev=1786130660  pears.InvOB10Allowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvOB10Allowed"( in "docid" char(20) ) returns long varchar begin -- This function will block with no message; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvoiceCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invoicecustomcolumn&rev=1786130660  pears.InvoiceCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvoiceCustomColumn"( in "RecordType" char(2),in "RecordID" char(20),in "ColNo" tinyint ) returns char(100) begin -- RecordType T=Timesheets, I=Invoice -- RecordID=null means return column heading for RecordType T or I or null if custom column not wanted -- RecordID=Temptimesheetid … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvoiceFilenameInZip https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invoicefilenameinzip&rev=1786130660  pears.InvoiceFilenameInZip Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvoiceFilenameInZip"( in "docid" char(20) ) returns long varchar begin declare "rv" long varchar; select "string"('Invoice_',"ourref") into "rv" from "iqacdocument" where "documentid" = "docid"; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvPDFAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invpdfallowed&rev=1786130660  pears.InvPDFAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvPDFAllowed"( in "docid" char(20) ) returns long varchar begin -- This function will block with no message; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvPDFAllowedWarning https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invpdfallowedwarning&rev=1786130660  pears.InvPDFAllowedWarning Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvPDFAllowedWarning"( in "docid" char(20) ) returns long varchar begin -- This function can warn or block; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvSendAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invsendallowed&rev=1786130660  pears.InvSendAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvSendAllowed"( in "docid" char(20),in "sendmethod" char(1) ) returns long varchar begin -- This function will block with no message; -- sendmethod E - email P - printer; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.InvSendAllowedWarning https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_invsendallowedwarning&rev=1786130660  pears.InvSendAllowedWarning Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."InvSendAllowedWarning"( in "docid" char(20),in "sendmethod" char(1) ) returns long varchar begin -- This function can warn or block; -- sendmethod E - email P - printer; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQacDocumentOutstandingAmount https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqacdocumentoutstandingamount&rev=1786130660  pears.IQacDocumentOutstandingAmount Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQacDocumentOutstandingAmount"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "DocID" char(8),in "CutoffDate" date ) returns decimal(12,2) begin declare "rv" decimal(12,2); declare "amt" decimal(12,2); declare "fuldate" date; set "amt" = 0.0; set "r… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQacJournalDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqacjournaldescription&rev=1786130660  pears.IQacJournalDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQacJournalDescription"( in "DocID" char(8),in "LineNo" smallint ) returns long varchar begin declare "rv" long varchar; select first "description" into "rv" from "iqacjournal" where "documentid" = "docid" and "linenumber" = "lineno"; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQacJournalOutstandingAmount https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqacjournaloutstandingamount&rev=1786130660  pears.IQacJournalOutstandingAmount Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQacJournalOutstandingAmount"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "DocID" char(8),in "LineNo" smallint ) returns decimal(12,2) begin declare "rv" decimal(12,2); declare "amt" decimal(12,2); set "amt" = 0.0; set "rv" = 0.0; // Only makes se… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.iqmoneynumeric https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqmoneynumeric&rev=1786130660  pears.iqmoneynumeric Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."iqmoneynumeric"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "val" numeric ) returns numeric begin declare "c" numeric; declare "neg" tinyint; set "neg" = 0; if "val" < 0 then set "neg" = 1 end if; set "c" = ("truncate"("abs"("val"*1000)+.5,0)/1000); if … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.iqmoneyround https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqmoneyround&rev=1786130660  pears.iqmoneyround Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."iqmoneyround"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "val" numeric ) returns numeric begin declare "c" numeric; declare "neg" tinyint; set "neg" = 0; if "val" < 0 then set "neg" = 1 end if; set "c" = ("truncate"("abs"("val"*1000)+.5,0)/1000); if "neg… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetallowed&rev=1786130660  pears.IQXNetAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetAllowed"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ProcName" char(100),in "AllowedProcs" long varchar ) returns tinyint begin declare "i" integer; declare "s" char(100); set "i" = 1; loop set "s" = "isnull"("trim"("getline"("AllowedProcs","i")),''); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetAuth2 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetauth2&rev=1786130660  pears.IQXNetAuth2 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetAuth2"( in "pWebUserID" char(20),in "pSessionID" char(20),in "pPhase" char(20),in "pProcType" char(1),in "pProcName" char(100),in "pParams" long varchar,in "pLicensedUserCount" integer default 0 ) returns long varchar begin return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetCompanyStartDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetcompanystartdate&rev=1786130660  pears.IQXNetCompanyStartDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetCompanyStartDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pCompanyID" char(20) ) returns date begin declare "nrv" double; set "nrv" = null; select first "value" into "nrv" from "tagvalue" where "taglocation" = 'C' and "tagid" = '9X0' and "id" = "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetDecodePostValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetdecodepostvalue&rev=1786130660  pears.IQXNetDecodePostValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetDecodePostValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pdata" char(250) ) returns char(250) begin declare "rv" char(250); declare "i" smallint; declare "l" smallint; declare "c" smallint; declare "s" char(3); set "rv" = ''; set "l" = "le… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetExtractParam https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetextractparam&rev=1786130660  pears.IQXNetExtractParam Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetExtractParam"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pParams" long varchar,in "pParamName" char(100) ) returns long varchar deterministic begin declare "v" long varchar; declare "n" char(100); declare "i" integer; set "pParams" = "replace"("pParam… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetHasPermission https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnethaspermission&rev=1786130660  pears.IQXNetHasPermission Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetHasPermission"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pWebUserID" char(20),in "pRightID" char(20) ) returns smallint not deterministic begin declare "rv" smallint; set "rv" = 0; if(select first "isnull"((select first "Assigned" from "IQXNetRightAss… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetOverrideSwitchTextValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetoverrideswitchtextvalue&rev=1786130660  pears.IQXNetOverrideSwitchTextValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetOverrideSwitchTextValue"( in "pIQXNetUserClassID" char(20),in "pIQXNetUserID" char(20),in "pIQXNetSwitchID" char(50),in "pDefaultValue" char(250) ) returns char(250) begin return "pDefaultValue" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetOverrideSwitchValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetoverrideswitchvalue&rev=1786130660  pears.IQXNetOverrideSwitchValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetOverrideSwitchValue"( in "pIQXNetUserClassID" char(20),in "pIQXNetUserID" char(20),in "pIQXNetSwitchID" char(50),in "pDefaultValue" integer ) returns integer begin return "pDefaultValue" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetStringToDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetstringtodate&rev=1786130660  pears.IQXNetStringToDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetStringToDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sdate" char(20) ) returns date begin declare "rv" date; declare "i" smallint; declare "d" smallint; declare "m" smallint; declare "y" smallint; set "sdate" = "trim"("sdate"); if "sdate" re… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetStringToDouble https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetstringtodouble&rev=1786130660  pears.IQXNetStringToDouble Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetStringToDouble"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sval" char(20) ) returns double begin declare "rv" double; set "rv" = cast("sval" as double); return "rv" exception when others then return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetStringToInteger https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetstringtointeger&rev=1786130660  pears.IQXNetStringToInteger Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetStringToInteger"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sval" char(20) ) returns integer begin declare "rv" integer; set "rv" = cast("sval" as integer); return "rv" exception when others then return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetStringToTime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetstringtotime&rev=1786130660  pears.IQXNetStringToTime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetStringToTime"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "stime" char(20) ) returns time begin declare "rv" time; set "rv" = cast("stime" as time); return "rv" exception when others then return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetSwitchValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetswitchvalue&rev=1786130660  pears.IQXNetSwitchValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetSwitchValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pWebUserID" char(20),in "pIQXNetSwitchID" char(50) ) returns char(250) not deterministic begin declare "irv" integer; declare "rv" char(250); declare "xIQXNetUserClassID" char(20); select "IQXNetU… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetTemplateChoiceList https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnettemplatechoicelist&rev=1786130660  pears.IQXNetTemplateChoiceList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetTemplateChoiceList"( in "templateid" char(20),in "deptid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "xtagid" char(20); declare "xchoiceid" char(20); declare "xlocation" char(20); select first "trim"("isnull"("tagid",'')),"trim"("isnull"("t… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetTemplateGradeList https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnettemplategradelist&rev=1786130660  pears.IQXNetTemplateGradeList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetTemplateGradeList"( in "templateid" char(20),in "deptid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "xtagid" char(20); declare "xchoiceid" char(20); declare "xlocation" char(20); declare "xgradetagid" char(20); declare "xgradeid" char(20);… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IQXNetUserHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_iqxnetuserheadline&rev=1786130660  pears.IQXNetUserHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IQXNetUserHeadline"( in "pWebUserID" char(20) ) returns long varchar begin declare "userClass" char(20); declare "personName" char(200); set "userClass" = (select first "iqxnetuserclassid" from "iqxnetuser" where "iqxnetuserid" = "pWebUserID"); set "personName" = (select "person"."fo… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.IsFuzeUser https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_isfuzeuser&rev=1786130660  pears.IsFuzeUser Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."IsFuzeUser"() returns smallint begin -- userstaffid + question return 0 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.KeyWordSearchAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_keywordsearchallowed&rev=1786130660  pears.KeyWordSearchAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."KeyWordSearchAllowed"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SearchString" long varchar ) returns long varchar begin if "trim"("SearchString") = '' then return 'Search string cannot be empty, please review criteria and search again' else if "trim"("re… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.LeastDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_leastdate&rev=1786130660  pears.LeastDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."LeastDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "Date1" date,in "Date2" date ) returns date begin set "Date1" = "isnull"("Date1","Date2"); set "Date2" = "isnull"("Date2","Date1"); if "Date1" < "Date2" then return("Date1") else return("Date2") end if end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.LSMLuserValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_lsmluservalue&rev=1786130660  pears.LSMLuserValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."LSMLuserValue"( in "stype" char(1),in "sid" char(20) ) returns char(20) begin declare "rv" char(20); declare "branch" char(20); declare "depart" char(20); declare "divis" char(20); declare "consult" char(20); declare "consultid" char(20); declare "desk" char(20); declare "lv" long va… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MailMergeSMTPCredentials https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_mailmergesmtpcredentials&rev=1786130660  pears.MailMergeSMTPCredentials Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MailMergeSMTPCredentials"( in "PersID" char(20),in "EmpID" char(20),in "VacID" char(20),in "PlacID" char(20),in "ProgID" char(20) ) returns char(20) begin declare "rv" char(20); return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MakeHTMLReadable https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_makehtmlreadable&rev=1786130660  pears.MakeHTMLReadable Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MakeHTMLReadable"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ @HTMLText long varchar,@ReplaceBR smallint ) returns long varchar as begin declare @Start integer declare @End integer declare @Length integer -- ReplaceBR with CRLF 0 - No 1 - Yes -- Replace the HTML… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MakeKeyName https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_makekeyname&rev=1786130660  pears.MakeKeyName Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MakeKeyName"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sSource" char(60) ) returns char(60) begin declare "rv" char(60); declare "isin" char(50); declare "c" char(1); set "rv" = ''; set "isin" = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ&0123456789'; set "isin" = "isin"+"ch… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MasterRosterLimitColour https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_masterrosterlimitcolour&rev=1786130660  pears.MasterRosterLimitColour Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MasterRosterLimitColour"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "VacID" char(20) ) returns char(1) begin -- return G - OK, O - warning, R - problem -- R means over limit -- O means within 10% declare "ShiftsTot" integer; declare "RV" char(1); if… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MasterRosterMakeDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_masterrostermakedate&rev=1786130660  pears.MasterRosterMakeDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MasterRosterMakeDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pstartdate" date,in "pdays" integer,in "pgedate" date ) returns date deterministic begin if "pstartdate" is null or "pdays" is null or "pgedate" is null then return null end if; set "pdays… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MasterRosterStartDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_masterrosterstartdate&rev=1786130660  pears.MasterRosterStartDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MasterRosterStartDate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "MRID" char(20),in "VacID" char(20) ) returns char(20) begin declare "MaxDays" integer; declare "SDate" date; if "isnull"("MRID",'') = '' then select "Max"("daysincycle") into "MaxDays" f… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MasterRosterTempAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_masterrostertempallowed&rev=1786130660  pears.MasterRosterTempAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MasterRosterTempAllowed"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ppersid" char(20),in "pmastershiftid" char(20) ) returns integer begin declare "ionly" integer; declare "iactive" integer; if "pmastershiftid" is null then return 1 end if; if "p… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.MasterTempRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_mastertemprate&rev=1786130660  pears.MasterTempRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."MasterTempRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SchemeID" char(20),in "BandID" char(20),in "GradeID" char(4),in "pFilter1" char(4),in "pFilter2" char(4),in "pFilter3" char(4),in "dFrom" date,in "dTo" date ) returns char(20) begin declare "rv" char(20); s… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ModifiedTempRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_modifiedtemprate&rev=1786130660  pears.ModifiedTempRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ModifiedTempRate"( in "PayOrChar" char(1),in "vacid" char(20),in "persid" char(20),in "placid" char(20),in "bandid" char(20),in "BaseRate" double ) returns double begin declare "rv" double; set "rv" = "BaseRate"; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetBlobPermitted https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netblobpermitted&rev=1786130660  pears.NetBlobPermitted Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetBlobPermitted"( in "pWebUserID" char(20),in "pBlobClass" char(1),in "pBlobID" char(20),in "pUpOrDown" char(1) ) returns integer begin if "pBlobClass" = 'G' and "pUpOrDown" = 'D' then return 1 else return 0 end if end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetCandidateValidPersonID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netcandidatevalidpersonid&rev=1786130660  pears.NetCandidateValidPersonID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetCandidateValidPersonID"( in "pWebUserID" char(20),in "pPersonID" char(20) default null ) returns char(20) begin declare "rv" char(20); set "pPersonID" = "nullif"("trim"("pPersonID"),''); if "pPersonID" is null then -- Return a valid personid only if a unique one is available … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetCanUploadVacancy https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netcanuploadvacancy&rev=1786130660  pears.NetCanUploadVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetCanUploadVacancy"( in "vacID" char(20) ) returns integer begin if exists (select "Vacancyid", "isnull"((if "v"."temp" = 1 then "v"."finishdate" else "v"."expiry" endif),current date) as "LD" from "vacancy" as "v" where "vacancyid" = "vacid" and "status" = 'C' … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetClientShiftCancelReasons https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netclientshiftcancelreasons&rev=1786130660  pears.NetClientShiftCancelReasons Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetClientShiftCancelReasons"( in "WebUser" char(20),in "NeedsRefill" integer default 0 ) returns long varchar -- 20111012 create ComboBox option list for cancel reasons on Client -> Current Shift Status status box -- 20111128 modify to allow filter on reject or cancel reasons where ref… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetDebtorsDaySalesOutstanding https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netdebtorsdaysalesoutstanding&rev=1786130660  pears.NetDebtorsDaySalesOutstanding Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetDebtorsDaySalesOutstanding"( in "pAccountCode" char(12),in "DaysInPeriod" integer,in "CutoffDate" date ) returns decimal(10,2) begin declare "Outst" decimal(10,2); declare "Sales" decimal(10,2); declare "dStart" date; set "dStart" = "dateadd"("dd",-1*("daysinperiod"-1),"Cu… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetErrorHandler https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_neterrorhandler&rev=1786130660  pears.NetErrorHandler Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetErrorHandler"( in "pErrorCode" integer,in "UID" char(20) default null,in "pRecordID" char(20) default null,in "pActionDetails" char(255) default null ) returns char(255) deterministic // IQXWeb begin declare "retval" char(255); declare "ErrorMessage" char(250); declare "ErrorAnalysisText"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetFavouriteTitle https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netfavouritetitle&rev=1786130660  pears.NetFavouriteTitle Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetFavouriteTitle"( in "pNodeID" char(20) ) returns char(250) begin declare "rv" char(250); select(case "type" when 'C' then(select "string"("name",', ',"addr1",', ',"postcode") from "company" where "companyid" = "favourites"."id") when 'E' then(select "string"("p"."name",', ',"c"."n… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetFilePermitted https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netfilepermitted&rev=1786130660  pears.NetFilePermitted Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetFilePermitted"( in "pWebUserID" char(20),in "pFilePath" char(250) ) returns integer begin // IQXWeb declare "pPersonID" char(20); declare "pClassID" char(20); declare "EmployeeCodeList" char(254); declare "pClientCode" char(20); declare "DocPathRoot" char(254); declare "StartDate… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetGetEmail https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netgetemail&rev=1786130660  pears.NetGetEmail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetGetEmail"( in "cpe" char(2),in "recid" char(20) ) returns char(250) //IQXWeb begin declare "rv" char(250); select first "replace"("phone"."number",'*','') into "rv" from "phone" key join "phonetype" where "phone"."whoid" = "recid" and "phone"."who" = (if "cpe" = 'E' then 'CP' else "cpe" endif) … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetGetPlacementid https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netgetplacementid&rev=1786130660  pears.NetGetPlacementid Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetGetPlacementid"( in "vacid" char(20),in "persid" char(20),in "pweekstartdate" date ) returns integer not deterministic begin declare "placid" char(20); set "placid" = (select first "placement"."placementid" from "placement" key join "employment" where "placement"."vacancyid" = "vacid" and… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetGetVacancySiteDetails https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netgetvacancysitedetails&rev=1786130660  pears.NetGetVacancySiteDetails Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetGetVacancySiteDetails"( in "pVacancyID" char(20) default null ) returns long varchar deterministic begin declare "siteAddress" long varchar; declare "siteName" char(50); declare "addr1" char(40); declare "addr2" char(40); declare "addr3" char(40); declare "town" char(30); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetHasPermission https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_nethaspermission&rev=1786130660  pears.NetHasPermission Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetHasPermission"( in "pWebUserID" char(20),in "pPersonID" char(20),in "pCompanyID" char(20) ) returns integer // IQXWeb begin declare "rv" integer; declare "userclass" char(20); declare "divid" char(20); set "rv" = 0; select "iqxnetuserclassid" into "userclass" from "iqxnetuser" where … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetJSString https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netjsstring&rev=1786130660  pears.NetJSString Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetJSString"( in "s" char(255) ) returns char(255) begin set "s" = "replace"("s",'\\','\\\\'); set "s" = "replace"("s",'"','\\"'); return "string"('"',"s",'"') end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetLongQuestAnswer https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netlongquestanswer&rev=1786130660  pears.NetLongQuestAnswer Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetLongQuestAnswer"( in "ptagloc" char(3),in "ptagid" char(3),in "parentid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "tagval" double; declare "textval" long varchar; declare "x" char(4); declare "y" integer; declare "xunits" char(11); declare "xd… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetOrderReasonList https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netorderreasonlist&rev=1786130660  pears.NetOrderReasonList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetOrderReasonList"() returns long varchar //IQXWeb begin declare "rv" long varchar; select "list"("string"("tempshiftorderreasonid",']~[',"description"),']~[' order by "sortorder" asc,"description" asc) into "rv" from "tempshiftorderreason"; return "rv" end /* DOC 2016-10-20 PC modify to … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetOwnerJobRateList https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netownerjobratelist&rev=1786130660  pears.NetOwnerJobRateList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetOwnerJobRateList"() returns long varchar begin declare "rv" long varchar; select "list"("string"("TempPayBandID",']~[',"TempPayBand"."Description"+' - '+"TempPayBand"."Unit"),']~[' order by "Description" asc) into "rv" from "TempPayBand"; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetOwnerTimesheetLists https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netownertimesheetlists&rev=1786130660  pears.NetOwnerTimesheetLists Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetOwnerTimesheetLists"( in "WebUser" char(20),in "ListType" char(23) ) returns long varchar begin declare "rv" long varchar; select "list"("string"('<option value="',"ObjectID",'">',"ObjectName"),'</option>' order by "ObjectName" asc) into "rv" from "NetOwnerTreeSource"("WebUser","List… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetPopulateComplianceTable https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netpopulatecompliancetable&rev=1786130660  pears.NetPopulateComplianceTable Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetPopulateComplianceTable"( in "personid" char(20),in "oldstatus" char(1),in "newstatus" char(1),in "datetocheck" date,in "vacancyid" char(20),in "tempshiftplanid" char(20),in "departmentid" char(2) ) returns char(20) begin declare @instanceid char(20); set @instanceid = "uniquekey… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetQuestionOwnerID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netquestionownerid&rev=1786130660  pears.NetQuestionOwnerID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetQuestionOwnerID"( in "pBaseTagLocation" char(3),in "pBaseID" char(20),in "pRequiredTagLocation" char(3) ) returns char(20) deterministic // IQXWeb begin declare "placid" char(20); declare "persid" char(20); declare "vacid" char(20); declare "empid" char(20); declare "compid" char(2… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetShiftDateTime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netshiftdatetime&rev=1786130660  pears.NetShiftDateTime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetShiftDateTime"( in "pDate" date,in "pTimeFrom" time,in "pTimeTo" time,in "pFromOrTo" char(1) ) returns timestamp deterministic begin declare "rv" timestamp; if "ptimefrom" is null or "ptimeto" is null then if "pFromOrTo" = 'F' then set "rv" = "pdate" else set "rv" = "pd… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetStringToTimestamp https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netstringtotimestamp&rev=1786130660  pears.NetStringToTimestamp Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetStringToTimestamp"( in "sDateTime" char(25) ) returns timestamp begin set "sDateTime" = "trim"("sDateTime"); -- remove trailing and leading white space if "sDateTime" regexp '^\\d{4}\\-\\d{2}\\-\\d{2}(T|\\040)\\d{2}:\\d{2}($|Z$|\\+00:00$|:\\d{2}($|Z$|\\+00:00$))' then -- check to make … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetTempShiftStatusString https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_nettempshiftstatusstring&rev=1786130660  pears.NetTempShiftStatusString Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetTempShiftStatusString"( in "pShiftStatus" char(30),in "pTempConfirmed" integer default null,in "pClientConfirmed" integer default null,in "pCancelReason" char(255) default null ) returns char(200) deterministic begin if "pShiftStatus" = 'B' then return 'Confirmed' end if; if … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetTimesheetEndDate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_nettimesheetenddate&rev=1786130660  pears.NetTimesheetEndDate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetTimesheetEndDate"( in "isProvisional" tinyint,in "byShift" tinyint,in "id" char(20) ) returns date begin declare "lastShiftdate" date; declare "Weekenddate" date; declare "DeskType" char(1); declare "ExtNo" integer; -- 2 denotes completed provisonal - can look up tempprovtimesheetsh… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetVacancyHasRateScript https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netvacancyhasratescript&rev=1786130660  pears.NetVacancyHasRateScript Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetVacancyHasRateScript"( in "jtypeid" char(20),in "vacid" char(20) ) returns integer begin if "jtypeid" is not null then if exists(select * from "tempjobtype" where "tempjobtypeid" = "jtypeid" and "tempratescriptid" is not null) then return 1 else return 0 end if… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetVacancyRoleAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netvacancyroleallowed&rev=1786130660  pears.NetVacancyRoleAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetVacancyRoleAllowed"( in "pWebUserID" char(20),in "pVacancyID" char(20),in "pVacancyRoleExternalCode" char(20) ) returns smallint begin if not exists(select * from "VacancyRoleAllocation" as "a" key join "VacancyRole" as "r" where "a"."VacancyID" = "pVacancyID" and "r"."ExternalCode" = "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NetValidateEmailAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_netvalidateemailaddress&rev=1786130660  pears.NetValidateEmailAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NetValidateEmailAddress"( in @email varchar(200) ) returns long varchar begin declare "RV" long varchar; set "RV" = if "isnull"((select 1 where @email regexp '^[a-zA-Z0-9.!#$%&''*+/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?(?:\\.[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?)*\… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NominalForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_nominalfortimesheetline&rev=1786130660  pears.NominalForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NominalForTimesheetLine"( in "tslineid" char(20) ) returns char(20) begin return '4001' end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationAttachments https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationattachments&rev=1786130660  pears.NotificationAttachments Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationAttachments"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20),in "pSubjectType" char(20) default null,in "pSubjectIDs" char(100) default null ) returns char(255) begin -… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationcomplete&rev=1786130660  pears.NotificationComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationComplete"( in "pTemplateID" char(50) default null,in "pRecipientType" char(20) default null,in "pPersonID" char(20) default null,in "pVacancyID" char(20) default null,in "pCompanyID" char(20) default null,in "pProgressid" char(20) default null,in "pPlacementid" char(20) default … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationContactEventClass https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationcontacteventclass&rev=1786130660  pears.NotificationContactEventClass Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationContactEventClass"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(2) begin -- If no value returned will use General Setting end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationCustomFields https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationcustomfields&rev=1786130660  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 … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationDeeplinkComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationdeeplinkcomplete&rev=1786130660  pears.NotificationDeeplinkComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationDeeplinkComplete"( in "pTemplateID" char(50) default null,in "pPersonID" char(20) default null, in "pVacancyID" char(20) default null,in "pCompanyID" char(20) default null, in "pProgressid" char(20) default null,in "pPlacementid" char(20) default null,in "pDivisionID… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationEmailSubject https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationemailsubject&rev=1786130660  pears.NotificationEmailSubject Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationEmailSubject"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(100) begin -- If no value returned will use template description end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationEmploymentID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationemploymentid&rev=1786130660  pears.NotificationEmploymentID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationEmploymentID"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(20) begin -- Return an EmploymentID for the recipient. If no value returned will use defau… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationHTMLWrapID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationhtmlwrapid&rev=1786130660  pears.NotificationHTMLWrapID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationHTMLWrapID"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(20) begin -- Will use HTML_WRAP if no value returned end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationICS https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationics&rev=1786130660  pears.NotificationICS Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationICS"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20),in "pProgressID" char(20),in "pDiaryID" char(20) ) returns long varchar begin declare "rv" long varchar; declare @clie… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationRecipients https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationrecipients&rev=1786130660  pears.NotificationRecipients Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationRecipients"( in "pTransportType" char(20),in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(255) begin -- pTransportType is EMAIL or SMS -- pRecipientType … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationsExist https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationsexist&rev=1786130660  pears.NotificationsExist Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationsExist"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pTemplateid" char(50),in "pDeptid" char(2),in "pNotificationType" char(20),in "pRecipientType" char(20) ) returns tinyint begin if exists(select * from "NotificationTemplate" where "isnull"("Def… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationSignatureID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationsignatureid&rev=1786130660  pears.NotificationSignatureID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationSignatureID"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(20) begin -- Will use DEFAULT if no value returned end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationStaffID https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationstaffid&rev=1786130660  pears.NotificationStaffID Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationStaffID"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(20) begin -- Return a StaffID for the sender. If no value returned will use userstaffid end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.NotificationTemplateSelector https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_notificationtemplateselector&rev=1786130660  pears.NotificationTemplateSelector Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."NotificationTemplateSelector"( in "pTemplateID" char(50),in "pSubjectType" char(20),in "pSubjectIDs" char(100),in "pNotificationType" char(20),in "pRecipientType" char(20),in "pGroupCode" char(20) ) returns smallint begin -- Used for filtering the dropdown list of templates -- Ret… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.numtotime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_numtotime&rev=1786130660  pears.numtotime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."numtotime"( in "thenum" decimal(5,2) ) returns time begin declare "rv" time; declare "ss" char(5); declare "ii" smallint; declare "num1" decimal(5,2); declare "num2" decimal(5,2); set "num1" = "floor"("thenum"); set "num2" = "thenum"-"num1"; if "thenum" >= 24 or "thenum" < 0 then set… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.OverrideTempRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_overridetemprate&rev=1786130660  pears.OverrideTempRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."OverrideTempRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "VacID" char(20),in "PlacID" char(20),in "BandID" char(20),in "GradeID" char(4),in "pFilter1" char(4),in "pFilter2" char(4),in "pFilter3" char(4),in "dFrom" date,in "dTo" date ) returns char(20) // Purpose i… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PadStr https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_padstr&rev=1786130660  pears.PadStr Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PadStr"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "TheStr" char(50),in "TargetLength" tinyint,in "PadChar" char(1) ) returns char(50) begin declare "rv" char(50); set "rv" = "left"("isnull"("thestr",''),"targetlength"); if "isnull"("PadChar",'') = '' then set "PadCha… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.pay_weeklyemployerNI https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pay_weeklyemployerni&rev=1786130660  pears.pay_weeklyemployerNI Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."pay_weeklyemployerNI"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pay" real,in "paydate" date,in "pid" char(20) ) returns real begin declare "tmethod" smallint; select "isnull"("taxmethod",1) into "tmethod" from "pay_employee" where "personid" = "pid"; if "t… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PDFDisplayContent https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pdfdisplaycontent&rev=1786130660  pears.PDFDisplayContent Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PDFDisplayContent"( in "formid" char(50),in "viewid" char(50),in "recordid" char(20) ) returns long varchar -- formid - recordid, PERSON - personid, COMPANY, companyID, VACANCY - vacancyid, PLACEMENT, placementid -- rv is either -- PATH UNCpath (space separator optional) -- BLOB blobid|blobclass… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonAvailableAtTime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personavailableattime&rev=1786130660  pears.PersonAvailableAtTime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonAvailableAtTime"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sPersonid" char(20),in "dShiftDate" date,in "tShiftFrom" time,in "tShiftTo" time,in "iCheckExplicitlyAvailable" smallint ) returns char(1) begin declare "foundState" char(1); set "foundstate" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonAvailableforPlan https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personavailableforplan&rev=1786130660  pears.PersonAvailableforPlan Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonAvailableforPlan"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sPersonid" char(20),in "dShiftDate" date,in "tShiftFrom" time,in "tShiftTo" time,in "iRecovery" smallint,in "iMinutes" smallint, in "iCheckExplicitlyAvailable" smallint,in "departmentid" char(2… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonAvailableforPlanIterate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personavailableforplaniterate&rev=1786130660  pears.PersonAvailableforPlanIterate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonAvailableforPlanIterate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sPersonid" char(20),in "dShiftDate" date,in "tShiftFrom" time,in "tShiftTo" time,in "iCheckExplicitlyAvailable" smallint,in "MovingShiftID" char(20) ) returns char(1) begin decla… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonAvailableForRecovery https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personavailableforrecovery&rev=1786130660  pears.PersonAvailableForRecovery Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonAvailableForRecovery"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sFoundDigit" char(1),in "sPersonid" char(20),in "dShiftDate" date,in "tShiftFrom" time,in "tShiftTo" time,in "iRecovery" smallint,in "MovingShiftID" char(20) ) returns char(1) begin de… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonBasedTimesheetCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personbasedtimesheetcustomcolumn&rev=1786130660  pears.PersonBasedTimesheetCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonBasedTimesheetCustomColumn"( in "RecordType" char(2),in "RecordID" char(20),in "colNo" tinyint ) returns char(100) begin -- RecordType C=Caption, D=Data, L=Location, RecordID only valid for Data, max 3 columns return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonDepartmentalAlert https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_persondepartmentalalert&rev=1786130660  pears.PersonDepartmentalAlert Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonDepartmentalAlert"( in "persid" char(20),in "deptid" char(2),in "appendage" char(100) ) returns long varchar begin declare "rv" long varchar; set "rv" = "appendage"; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personheadline&rev=1786130660  pears.PersonHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonHeadline"( in "RecordID" char(20) ) returns long varchar begin declare "RV" long varchar; declare "RS" long varchar; declare "Part" long varchar; declare "Shift" long varchar; declare "NewLine" char(2); declare "FRG" decimal(10,1); set "rv" = ''; set "rs" = ''; set "Part" = … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonKeyWordsCustom https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personkeywordscustom&rev=1786130660  pears.PersonKeyWordsCustom Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonKeyWordsCustom"( in @PersonID char(20) ) returns long varchar begin declare "rv" long varchar; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonKeyWordsQuestion https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personkeywordsquestion&rev=1786130660  pears.PersonKeyWordsQuestion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonKeyWordsQuestion"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @PersonID char(20) ) returns long varchar begin declare "rv" long varchar; select "nullif"( "trim"( (select "list"("GetQuestAnswer"("t"."TagLocation","t"."TagID",@PersonID),' ') … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personstatuschangeallowed&rev=1786130660  pears.PersonStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonStatusChangeAllowed"( in "persid" char(20),in "oldstatus" char(1),in "newstatus" char(1) ) returns long varchar -- If change is disallowed you must set status back to oldstatus before returning an error message begin declare "rv" long varchar; set "rv" = ''; return("rv") end… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonTempColour https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_persontempcolour&rev=1786130660  pears.PersonTempColour Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonTempColour"( in @PersonID char(20),in @TempDeskID char(20) ) returns integer begin declare "rv" integer; set "rv" = null; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonUnavailability https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personunavailability&rev=1786130660  pears.PersonUnavailability Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonUnavailability"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pid" char(20),in "PorT" char(1),in "dfrom" date,in "dto" date ) returns char(100) begin declare "rv" char(100); declare "ss" char(1); declare "so" smallint; set "rv" = ''; if "pid" is null… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonUnavailabilityAlert https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personunavailabilityalert&rev=1786130660  pears.PersonUnavailabilityAlert Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonUnavailabilityAlert"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pid" char(20),in "PorT" char(1),in "dfrom" date,in "dto" date ) returns char(200) begin declare "ua" char(100); declare "al" char(100); select "personunavailability"("pid","port","df… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonUnavailabilityTimesheet https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personunavailabilitytimesheet&rev=1786130660  pears.PersonUnavailabilityTimesheet Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonUnavailabilityTimesheet"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pid" char(20),in "WorM" char(1),in "pPeriod" integer,in "dfrom" date,in "dto" date ) returns char(200) begin declare "ua" char(100); select "personunavailability"("pid",'T',"df… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonVacancyShiftMatch https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personvacancyshiftmatch&rev=1786130660  pears.PersonVacancyShiftMatch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonVacancyShiftMatch"( in @PersonID char(20),in @VacancyID char(20) ) returns double begin declare "rv" double; set "rv" = "DistanceBetweenPostCodes"( (select "Person"."PostCode" from "Person" where "Person"."PersonID" = @PersonID), (select "isnull"("vacancy"."postcode"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PersonVacancyShiftMatch2 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_personvacancyshiftmatch2&rev=1786130660  pears.PersonVacancyShiftMatch2 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PersonVacancyShiftMatch2"( in @PersonID char(20),in @VacancyID char(20) ) returns char(50) begin declare "rv" char(50); set "rv" = (select first "sitename" from "vacancy" where "vacancyid" = @VacancyID); return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PhoneUpdate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_phoneupdate&rev=1786130660  pears.PhoneUpdate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PhoneUpdate"( in "Number" char(50) ) returns char(50) begin declare "WorkNum" char(50); //// Tidy up the number set "WorkNum" = "replacestr"("trim"("Number"),'-','',0); set "WorkNum" = "replacestr"("WorkNum",' ','',0); set "WorkNum" = "replacestr"("WorkNum",'(','',0); set "WorkNum" = "repl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PlacementAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementallowed&rev=1786130660  pears.PlacementAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PlacementAllowed"( in "TemporPerm" char(1),in "persid" char(20),in "vacid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PlacementDayHours https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementdayhours&rev=1786130660  pears.PlacementDayHours Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PlacementDayHours"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "bProcess" tinyint,in "placid" char(20),in "pdate" date,in "startdate" date,in "enddate" date ) returns char(10) begin declare "bcanc" tinyint; declare "scancid" char(10); declare "nhrs" real; decl… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PlacementDayWorked https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementdayworked&rev=1786130660  pears.PlacementDayWorked Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PlacementDayWorked"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "placid" char(20),in "pdate" date ) returns smallint begin declare "bcanc" tinyint; declare "nhrs" real; declare "d" smallint; declare "bdayticked" tinyint; declare "banyticked" tinyint; if "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.placementelementvalid https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementelementvalid&rev=1786130660  pears.placementelementvalid Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."placementelementvalid"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "bvalid" smallint,in "splacid" char(20),in "selementname" char(20),in "ismanager" smallint,in "isaccounts" smallint ) returns smallint begin -- V1 Legacy function return("placementelementvalidV2"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.placementelementvalidV2 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementelementvalidv2&rev=1786130660  pears.placementelementvalidV2 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."placementelementvalidV2"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "bvalid" smallint,in "splacid" char(20),in "spersid" char(20),in "svacid" char(20),in "selementname" char(20),in "ismanager" smallint,in "isaccounts" smallint ) returns smallint begin declare… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.placementelementvalue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementelementvalue&rev=1786130660  pears.placementelementvalue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."placementelementvalue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "splacid" char(20),in "selementname" char(20) ) returns long varchar begin -- V1 Legacy function return("placementelementvalueV2"("splacid",null,null,"selementname")) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.placementelementvalueV2 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_placementelementvaluev2&rev=1786130660  pears.placementelementvalueV2 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."placementelementvalueV2"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "splacid" char(20),in "spersid" char(20),in "svacid" char(20),in "selementname" char(20) ) returns long varchar begin declare "rv" long varchar; declare "l" long varchar; declare "n" real… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PopulateComplianceTable https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_populatecompliancetable&rev=1786130660  pears.PopulateComplianceTable Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PopulateComplianceTable"( in "persid" char(20),in "oldstatus" char(1),in "newstatus" char(1),in "datetocheck" date,in "vacid" char(20),in "shiftplanid" char(20),in "deptid" char(2) ) returns char(20) begin -- returns a instance id for later use -- will need to allow for null inputs -… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.PostCodePart https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_postcodepart&rev=1786130660  pears.PostCodePart Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."PostCodePart"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "postcode" char(20),in "part" char(20) ) returns char(20) deterministic begin declare "i" integer; declare "area" char(20); set "postcode" = "trim"("postcode"); set "i" = "patindex"('%[0-9]%',"postcode"); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.proper https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_proper&rev=1786130660  pears.proper Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."proper"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "OldString" char(255) ) returns char(255) begin declare "NewString" char(255); declare "StringLength" smallint; declare "CurrentChar" char(1); declare "LastChar" char(1); declare "CurrentPos" smallint; if "OldString… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthBranch https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthbranch&rev=1786130660  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 text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthCanSendPerson https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthcansendperson&rev=1786130660  pears.psHealthCanSendPerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."psHealthCanSendPerson"( in "persid" char(20),in "RecipientOrCarer" char(1) ) returns smallint begin -- check divisions, status etc -- 1 to send, anything else won't -- RecipientOrCarer R - Recip, C - Carer, U - User ( if needed ) return 1 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthCanSendShift https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthcansendshift&rev=1786130660  pears.psHealthCanSendShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."psHealthCanSendShift"( in "ShiftID" char(20),in "ShiftPlanID" char(20) ) returns smallint begin -- check divisions etc -- 1 to send, anything else won't -- plan possible future use if "ShiftID" is not null then return 1 end if end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthCanSendVacancy https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthcansendvacancy&rev=1786130660  pears.psHealthCanSendVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."psHealthCanSendVacancy"( in "vacid" char(20) ) returns smallint begin -- check divisions, status etc -- 1 to send, anything else won't return 1 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthShowButton https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthshowbutton&rev=1786130660  pears.psHealthShowButton Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."psHealthShowButton"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SourceID" char(20),in "IDType" char(2) ) returns integer begin if "sourceid" is null then return 0 end if; /* IDType R = recipient, S = temp shift, P = temp shift plan C = carer, V = vacancy *… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthTaskType https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthtasktype&rev=1786130660  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 text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.psHealthUniqueUsername https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_pshealthuniqueusername&rev=1786130660  pears.psHealthUniqueUsername Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."psHealthUniqueUsername"( in "StartName" char(100) ) returns char(100) begin declare "UName" char(100); declare "Inc" integer; set "UName" = "StartName"; set "Inc" = 0; while exists(select * from "psHealthPerson" where "username" = "UName") loop set "Inc" = "Inc"+1; set … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.rejectstate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_rejectstate&rev=1786130660  pears.rejectstate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."rejectstate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sstatuscode" char(1) ) returns char(1) begin declare "rejcode" char(1); select "rejectstatus" into "rejcode" from "status" where "status" = "sstatuscode" and "type" = 'R'; if "isnull"("rejcode",'') = '' the… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ReplaceStr https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_replacestr&rev=1786130660  pears.ReplaceStr Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ReplaceStr"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "mainstring" char(255),in "replacestring" char(255),in "withwhat" char(255),in "times" tinyint ) returns varchar(255) begin // // Variable declarations // declare "newstring" varchar(255); declare "togo" tinyi… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ReportImageFetch https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_reportimagefetch&rev=1786130660  pears.ReportImageFetch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ReportImageFetch"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ReportImageName" char(50) ) returns long binary begin return "blobstorefetch"('R',(select first "reportid" from "report" where "filename" = "ReportImageName" order by 1 asc)) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.RSCalcMargin https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_rscalcmargin&rev=1786130660  pears.RSCalcMargin Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."RSCalcMargin"( in @RSMasterID char(20),in @Instance char(20),in @Holpay double,in @NI double,in @Levy double ) returns double begin /* deal with any custom tables/views */ /* return blank if OK otherwise error message */ return 10 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.safedate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_safedate&rev=1786130660  pears.safedate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."safedate"( in "dd" char(30) ) returns char(30) begin declare "i" smallint; declare "t","d","m" char(20); if "dd" is null then return null end if; set "dd" = "replace"("dd",'T',' '); if "trim"("dd") = '' then return null end if; if "charindex"('/',"dd") = 0 then return "dd" … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.safetime https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_safetime&rev=1786130660  pears.safetime Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."safetime"( in "stime" char(5) ) returns time begin declare "rv" time; set "rv" = "stime"; return("rv") exception when others then return('00:00') end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ScannedImageLinkAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_scannedimagelinkallowed&rev=1786130660  pears.ScannedImageLinkAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ScannedImageLinkAllowed"( in "persid" char(20),in "vacid" char(20),in "placid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SDSRequired https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_sdsrequired&rev=1786130660  pears.SDSRequired Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SDSRequired"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "COID" char(20),in "PID" char(20) ) returns smallint not deterministic begin if "WPKMaintainGetSwitchValue"('IR35SDSON','','L') = 'N' then return 0 end if; -- if exists (select 1 from company where PrivateSecto… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SecAgencyStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_secagencystatuschangeallowed&rev=1786130660  pears.SecAgencyStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SecAgencyStatusChangeAllowed"( in "persid" char(20),in "oldstatus" char(1),in "newstatus" char(1) ) returns long varchar -- If disallowed status change is blocked begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfbillBatchComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbillbatchcomplete&rev=1786130660  pears.SelfbillBatchComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfbillBatchComplete"( in "docid" char(20) ) returns long varchar begin -- This function will block with no message; declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfBillCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbillcustomcolumn&rev=1786130660  pears.SelfBillCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfBillCustomColumn"( in "SupplierCode" char(20),in "RecordType" char(2) ) returns char(100) begin -- RecordType M= Supplier Code Maint (this is for potential future expansion) -- SupplierCode=null means return column heading for RecordType -- usual use is to show Self Bill Agreeme… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfbillDescriptionForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbilldescriptionfortimesheetline&rev=1786130660  pears.SelfbillDescriptionForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfbillDescriptionForTimesheetLine"( in "tslineid" char(20),in "suppliercode" char(12) ) returns long varchar begin declare "rv" long varchar; set "rv" = null; select "string"("person"."name",' - ',"temppayband"."description",': ',"isnull"("temptimesheetline"."descrip… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfbillEMailBodyandSubject https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbillemailbodyandsubject&rev=1786130660  pears.SelfbillEMailBodyandSubject Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfbillEMailBodyandSubject"( in "docid" char(20),in "BodyorSubject" char(1) ) returns long varchar begin declare "rv" long varchar; declare "invno" char(12); declare "coname" char(30); declare "crlf" char(2); select "ourref" into "invno" from "iqacdocument" where "documen… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfbillNominalForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbillnominalfortimesheetline&rev=1786130660  pears.SelfbillNominalForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfbillNominalForTimesheetLine"( in "tslineid" char(20),in "suppliercode" char(12) ) returns char(20) begin declare "rv" char(20); set "rv" = null; select "staff"."analysiscode" into "rv" from "temptimesheetline" key join "temptimesheet" key join "placement" key joi… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SelfbillVATCodeForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_selfbillvatcodefortimesheetline&rev=1786130660  pears.SelfbillVATCodeForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SelfbillVATCodeForTimesheetLine"( in "tslineid" char(20),in "suppliercode" char(12) ) returns char(3) begin declare "rv" char(3); select "vatstatus" into "rv" from "iqacaccountsettings" where "accountcode" = "suppliercode" and "ledgerid" = 'Purchase'; return "isnull"("rv",… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SetPersonWillingness https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_setpersonwillingness&rev=1786130660  pears.SetPersonWillingness Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SetPersonWillingness"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @PersonID char(20),in @Willingness smallint default null ) returns smallint begin -- return codes: 0 = success, 1 = no such PersonID, 2 = no Willingness record for PersonID, 3 = other error -- ca… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SetTempProvTimeSheetStatus https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_settempprovtimesheetstatus&rev=1786130660  pears.SetTempProvTimeSheetStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SetTempProvTimeSheetStatus"( in @TempProvTimeSheetID char(20),in @NewStatus integer,in @Description char(250),in @StaffID char(20),in @ExternalUserID char(40) ) returns char(250) begin declare @OldStatus integer; declare @NewTempProvTimesheetHistoryID char(20); declare @SerialNumb… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ShiftBackColourOverride https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_shiftbackcolouroverride&rev=1786130660  pears.ShiftBackColourOverride Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ShiftBackColourOverride"( in "shiftid" char(20),in "planid" char(20) ) returns integer begin -- return 1 to apply colour if "isnull"("shiftid",'') > '' then -- shift logic end if; if "isnull"("planid",'') > '' then -- shiftplan logic end if; return 0 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ShiftColourOverride https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_shiftcolouroverride&rev=1786130660  pears.ShiftColourOverride Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ShiftColourOverride"( in "shiftid" char(20),in "planid" char(20) ) returns integer begin -- return 1 to apply colour if "isnull"("shiftid",'') > '' then -- shift logic end if; if "isnull"("planid",'') > '' then -- shiftplan logic end if; return 0 end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ShiftConsultants https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_shiftconsultants&rev=1786130660  pears.ShiftConsultants Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ShiftConsultants"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "entby" char(20),in "entat" timestamp,in "fillby" char(20),in "fillat" timestamp ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; if "entby" is not null then set "rv" = "strin… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ShiftMatchCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_shiftmatchcustomcolumn&rev=1786130660  pears.ShiftMatchCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ShiftMatchCustomColumn"( in "RecordType" char(2),in "RecordID" char(20),in "ColNo" tinyint ) returns char(100) begin -- RecordType PR=Person Results, WP=Wizard Person, WR=Wizard Results -- RecordID=null means return column heading for RecordType PR, WP, WR or null if custom column n… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SocialCareRecipientVacancy https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_socialcarerecipientvacancy&rev=1786130660  pears.SocialCareRecipientVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SocialCareRecipientVacancy"( in @recipientID char(20) ) returns long varchar begin declare "rv" long varchar; -- shown on recipient vacancies view set "rv" = ''; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SocialMediaResolve https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_socialmediaresolve&rev=1786130660  pears.SocialMediaResolve Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SocialMediaResolve"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "MediaName" char(2),in "Number" char(100) ) returns char(100) begin /* MediaName LI - LinkedIn TW - Twitter SK - Skype FB - Facebook */ case "MediaName" when 'TW' then case when "Number" li… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SoftWizardController https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_softwizardcontroller&rev=1786130660  pears.SoftWizardController Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SoftWizardController"( in "pWizardID" char(20),in "pPageID" char(50),in "pItem" char(20) ) returns char(250) deterministic begin declare "rv" char(250); case "pWizardID" when 'DEFAULT' then case "pItem" when 'nextPageID' then case "pPageID" when null then … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.SpecialityLookup https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_specialitylookup&rev=1786130660  pears.SpecialityLookup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."SpecialityLookup"( in "VacID" char(20),in "ChoiceID" char(4) ) returns char(255) begin declare "rv" char(255); set "rv" = null; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.StatementEmailBody https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_statementemailbody&rev=1786130660  pears.StatementEmailBody Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."StatementEmailBody"( in "accountcode" char(12) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.StripLineFeeds https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_striplinefeeds&rev=1786130660  pears.StripLineFeeds Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."StripLineFeeds"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "s" long varchar ) returns long varchar begin return("replace"("s","char"(10),'')) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TableExists https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tableexists&rev=1786130660  pears.TableExists Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TableExists"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @Creator char(128),in @TableName char(128) ) returns smallint deterministic begin /* If @Creator is null (NOT empty string) = all creators Works for tables, views, global temporary but not local temporary */ if ex… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempaidTempEmaill https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempaidtempemaill&rev=1786130660  pears.TempaidTempEmaill Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempaidTempEmaill"( in "pid" char(20) ) returns varchar(100) begin declare "rv" varchar(100); select "isnull"("person"."payrollemailaddress",(select first "phone"."number" from "phone" key join "phonetype" where "phone"."who" = 'P' and "phone"."whoid" = "pid" and "phonetype"."name" lik… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempCustomRateGenerator https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempcustomrategenerator&rev=1786130660  pears.TempCustomRateGenerator Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempCustomRateGenerator"( in "ID" char(20),in "YearNo" integer,in "PeriodNo" integer,in "PeriodLength" char(20),in "PeriodStartDate" date,in "PeriodEndDate" date,in "PersID" char(20),in "VacID" char(20),in "PlacID" char(20),in "ProvTSID" char(20),in "BehaviourFlag" smallint ) returns integ… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.tempdepttran https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempdepttran&rev=1786130660  pears.tempdepttran Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."tempdepttran"( in "deptu" char(1) ) returns char(20) begin declare "rv" char(20); case "deptu" when 'D' then set "rv" = 'TCT' when 'G' then set "rv" = 'TDR' when 'I' then set "rv" = 'TNP' when 'Z' then set "rv" = 'TLS' else set "rv" = 'TIZ' end case; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempDeskCustomColumn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempdeskcustomcolumn&rev=1786130660  pears.TempDeskCustomColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempDeskCustomColumn"( in "DeskID" char(20),in "RecordType" char(2),in "RecordID" char(20),in "ColNo" tinyint,in "DeptID" char(2) default null ) returns char(100) begin -- DeskID will be % if Temp Desk selection = All -- RecordType P=Person V=Vacancy L=Placement T=Timesheet TP=Provisional… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempGetWeekAgo https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempgetweekago&rev=1786130660  pears.TempGetWeekAgo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempGetWeekAgo"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "StartYear" integer,in "StartWeek" integer,in "WeeksAgo" smallint ) returns integer /* Function returns year and week in format: yyyyww */ begin declare "MaxWeek" smallint; if "WeeksAgo" > 52 then return… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempHolidayCalcItem https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempholidaycalcitem&rev=1786130660  pears.TempHolidayCalcItem Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempHolidayCalcItem"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ValString" long varchar,in "Stat" integer ) returns char(200) begin return "regexp_substr"('"'+"Valstring","string"('(?<="',"Stat",'=)[^"]*')) end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempProvTimesheetDeleteAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempprovtimesheetdeleteallowed&rev=1786130660  pears.TempProvTimesheetDeleteAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempProvTimesheetDeleteAllowed"( in "Provid" char(20) ) returns long varchar begin declare "rv" long varchar; -- usual warn or block; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempRatePrecision https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temprateprecision&rev=1786130660  pears.TempRatePrecision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempRatePrecision"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "TempUnits" numeric ) returns numeric begin declare "rv" numeric; select if "isnull"("TmpRatePrecision",0) = 2 then "iqmoneyround"("TempUnits") else "round"("TempUnits","TmpRatePrecision") endif into "… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftallowed&rev=1786130660  pears.TempShiftAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftAllowed"( in "planid" char(20),in "persid" char(20),in "vacid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftChangeOfHoursAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftchangeofhoursallowed&rev=1786130660  pears.TempShiftChangeOfHoursAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftChangeOfHoursAllowed"( in "shiftid" char(20),in "persid" char(20),in "vacid" char(20),in "timefrom" time,in "timeto" time,in "recoveryhours" integer ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftConfirmationAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftconfirmationallowed&rev=1786130660  pears.TempShiftConfirmationAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftConfirmationAllowed"( in "shiftid" char(20),in "TempOrClient" char(1),in "NewVal" smallint ) returns long varchar begin declare "rv" long varchar; if "NewVal" = 1 then set "rv" = ''; -- Return nothing if allowed -- TempOrClient T - Temp C - Client -- NewVa… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftEditingAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshifteditingallowed&rev=1786130660  pears.TempShiftEditingAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftEditingAllowed"( in "planid" char(20),in "shiftid" char(20),in "EditOrCancel" char(1),in "Source" char(3) ) returns long varchar begin -- return nothing if allowed -- EditOrCancel E - Edit C - Cancel -- Source -- TS - Tempdesk Shifts -- VDD - Vacancy Diary Drag return… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftMatchDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftmatchdescription&rev=1786130660  pears.TempShiftMatchDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftMatchDescription"( in "planid" char(20) ) returns char(200) begin return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftMatchSkillDescription https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftmatchskilldescription&rev=1786130660  pears.TempShiftMatchSkillDescription Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftMatchSkillDescription"( in "planid" char(20) ) returns char(200) begin declare "rv" char(200); set "rv" = (select "referencecode" from "tempshiftplan" where "tempshiftplanid" = "planid"); return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempShiftPlanAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempshiftplanallowed&rev=1786130660  pears.TempShiftPlanAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempShiftPlanAllowed"( in "vacid" char(20),in "shiftdate" date,in "timefrom" time,in "timeto" time,in "templateid" char(20) ) returns long varchar -- If date critical, date should be shown in return message for bulk shift adding begin declare "rv" long varchar; set "rv" = ''; return("r… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.tempslotstartdate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempslotstartdate&rev=1786130660  pears.tempslotstartdate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."tempslotstartdate"( in "tsid" char(20) ) returns date begin declare "rv" date; select "employment"."startdate" into "rv" from "tempslot" key join "placement" key join "employment" where "tempslot"."tempslotid" = "tsid"; if "rv" is null then select "weekenddate"("tempslot"."yearnumb… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempTimesheetCancel https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temptimesheetcancel&rev=1786130660  pears.TempTimesheetCancel Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempTimesheetCancel"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "tscancelid" char(20),in "tsid" char(20),in "shiftcancreasonid" char(1),in "irecreate" smallint,in @CorrectionType char(20) default 'BOTH' ) returns char(20) begin atomic declare "newid" char(20); … text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempTimesheetComplete https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temptimesheetcomplete&rev=1786130660  pears.TempTimesheetComplete Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempTimesheetComplete"( in @TempTimeSheetID char(20) ) returns char(250) begin declare "jobmasterid" char(20); declare "placeid" char(20); declare "persid" char(20); declare "vacid" char(20); declare @period integer; declare "maxdate" date; declare "mindate" date; declare "TS… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempTimesheetCompleteWarning https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temptimesheetcompletewarning&rev=1786130660  pears.TempTimesheetCompleteWarning Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempTimesheetCompleteWarning"( in @TempTimeSheetID char(20) ) returns char(250) begin return null end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempTimesheetInvoice https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temptimesheetinvoice&rev=1786130660  pears.TempTimesheetInvoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempTimesheetInvoice"( in @TempTimeSheetID char(20) ) returns char(250) begin -- anything other than '' will block invoicing this timesheet silently return '' end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempTimesheetSelfBill https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_temptimesheetselfbill&rev=1786130660  pears.TempTimesheetSelfBill Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempTimesheetSelfBill"( in @TempTimeSheetID char(20) ) returns char(250) begin -- anything other than '' will block invoicing this timesheet silently return '' end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempVacancyShiftMatch https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempvacancyshiftmatch&rev=1786130660  pears.TempVacancyShiftMatch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempVacancyShiftMatch"( in @PersonID char(20),in @VacancyID char(20) ) returns double begin declare "rv" double; set "rv" = "DistanceBetweenPostCodes"( (select "Person"."PostCode" from "Person" where "Person"."PersonID" = @PersonID), (select "isnull"("vacancy"."postcode","co… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempVacancyShiftMatch2 https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempvacancyshiftmatch2&rev=1786130660  pears.TempVacancyShiftMatch2 Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempVacancyShiftMatch2"( in @PersonID char(20),in @VacancyID char(20) ) returns char(50) begin -- Not passed to TempVacancyShiftMatchOrder needs to be looked up, if used declare "rv" char(50); set "rv" = null; return "rv" end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TempVacancyShiftMatchOrder https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_tempvacancyshiftmatchorder&rev=1786130660  pears.TempVacancyShiftMatchOrder Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TempVacancyShiftMatchOrder"( in "pScore" double,in "pCustom" double,in "pHighlight" smallint,in "Persid" char(20),in "Vacid" char(20) ) returns double begin -- Will sort in DESCENDING order of the value returned. -- pScore (the default) is the number of the shifts they can do with e… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TimesheetAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_timesheetallowed&rev=1786130660  pears.TimesheetAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TimesheetAllowed"( in "persid" char(20),in "vacid" char(20),in "placid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.TimesheetDayHours https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_timesheetdayhours&rev=1786130660  pears.TimesheetDayHours Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."TimesheetDayHours"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "bprocess" tinyint,in "bprovisional" tinyint,in "tsid" char(20),in "pdate" date ) returns double begin declare "rv" double; declare "placid" char(20); declare "vacid" char(20); declare "persid" cha… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) pears.UniqueKey https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_uniquekey&rev=1786130660  pears.UniqueKey Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."UniqueKey"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "x" char(50) default null ) returns char(20) not deterministic begin return "string"("IQXDBID","upper"("right"("inttohex"("UniqSeq"."NextVal"),7)),"right"("dateformat"(current timestamp,'yyyymmddhhnn'),11)) end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.URLSafe https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_urlsafe&rev=1786130662  pears.URLSafe Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."URLSafe"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "OldString" long varchar ) returns long varchar begin -- Partial solution. £ is the only multi-byte utf-8 char handled. If possible use the Delphi or jobrunner httpsafe implementations declare "NewString" long varchar; … text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancyallowed&rev=1786130662  pears.VacancyAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyAllowed"( in "empid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyDetailsContents https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancydetailscontents&rev=1786130662  pears.VacancyDetailsContents Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyDetailsContents"( in @SMSOrEmail char(1),in @CandidateOrVacancy char(1),in @ProgressIDs long varchar ) returns long varchar begin -- @SMSorEmail S or E, @CandidateOrVacancy C or V, @ProgressIDs ID1,ID2... for sa_split_list(@ProgressIDs) -- sample for candidate -- select firs… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyExtraHols https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancyextrahols&rev=1786130662  pears.VacancyExtraHols Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyExtraHols"( in @TempTimeSheetID char(20) ) returns double begin declare "rv" double; -- check earns hol pay if exists(select * from "temptimesheetline" key join "temppayband" where "temptimesheetid" = @temptimesheetid and "includeinholidaypay" = 1) then select "vacancy"."ExtraHol… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancyheadline&rev=1786130662  pears.VacancyHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyHeadline"( in "recordid" char(20) ) returns long varchar begin declare "rv" long varchar; set "rv" = ''; return("rv") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyKeyWordsCustom https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancykeywordscustom&rev=1786130662  pears.VacancyKeyWordsCustom Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyKeyWordsCustom"( in @VacancyID char(20) ) returns long varchar begin declare "rv" long varchar; return "rv" end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyKeyWordsQuestion https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancykeywordsquestion&rev=1786130662  pears.VacancyKeyWordsQuestion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyKeyWordsQuestion"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @VacancyID char(20) ) returns long varchar begin declare "rv" long varchar; select "list"(distinct "GetQuestAnswer"("t"."TagLocation","t"."TagID",@VacancyID),' ') into "rv" from "Ta… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyRecipientHeadline https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancyrecipientheadline&rev=1786130662  pears.VacancyRecipientHeadline Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyRecipientHeadline"( in "vacid" char(20),in "recipid" char(20) ) returns long varchar begin declare "rv" long varchar; declare "Part" long varchar; declare "Ref" long varchar; declare "NewLine" char(2); set "NewLine" = "char"(13)+"Char"(10); if "recipid" is null then … text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyRoleAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancyroleallowed&rev=1786130662  pears.VacancyRoleAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyRoleAllowed"( in @EmploymentID char(20),in @VacancyID char(20),in @VacancyRoleID char(20) ) returns long varchar begin declare "RV" long varchar; set "RV" = ''; return "RV" end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyStatusChangeAllowed https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancystatuschangeallowed&rev=1786130662  pears.VacancyStatusChangeAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyStatusChangeAllowed"( in "vacid" char(20),in "oldstatus" char(1),in "newstatus" char(1) ) returns long varchar -- If change is disallowed you must set status back to oldstatus before returning an error message begin declare "rv" long varchar; set "rv" = ''; return("rv") end… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VacancyTempRate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vacancytemprate&rev=1786130662  pears.VacancyTempRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VacancyTempRate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "VacID" char(20),in "BandID" char(20),in "GradeID" char(4),in "pFilter1" char(4),in "pFilter2" char(4),in "pFilter3" char(4),in "dFrom" date,in "dTo" date ) returns char(20) begin declare "rv" char(20); se… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidateDateOfBirth https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validatedateofbirth&rev=1786130662  pears.ValidateDateOfBirth Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidateDateOfBirth"( in @DOB date,in @status char(1),in @persid char(20) ) returns long varchar begin declare "RV" long varchar; set "rv" = ''; return("RV") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidateEmailAddress https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validateemailaddress&rev=1786130662  pears.ValidateEmailAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidateEmailAddress"( in @email varchar(200) ) returns long varchar begin declare "RV" long varchar; select if("ISNULL"(@email,'') <> '' and @email like '%@%._%') or("ISNULL"(@email,'') = '') then '' else 'Invalid Email Address' endif into "rv"; return("RV") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidateEmailAddressStd https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validateemailaddressstd&rev=1786130662  pears.ValidateEmailAddressStd Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidateEmailAddressStd"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in @email varchar(200) ) returns long varchar begin declare "RV" long varchar; set "rv" = if exists(select 1 from "sa_split_list"(@email,';') where "trim"("row_value") not regexp "… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidateLinkedIn https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validatelinkedin&rev=1786130662  pears.ValidateLinkedIn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidateLinkedIn"( in @LinkedIn varchar(200) ) returns long varchar begin declare "RV" long varchar; set "rv" = ''; return("RV") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidateNINumber https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validateninumber&rev=1786130662  pears.ValidateNINumber Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidateNINumber"( in @NI char(10) ) returns char(250) begin // based on IR Quality Standard Validation Specification From April 2005 Version 2.0 // Sep 2020 HMRC Rules advice // The characters D, F, I, Q, U, and V are not used as either the first or second letter of a NINO prefix. // T… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidatePayroll https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validatepayroll&rev=1786130662  pears.ValidatePayroll Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidatePayroll"( in "recordid" varchar(20),in @BankName varchar(30),in @BankAddr1 varchar(30),in @BankAddr2 varchar(30),in @BankSortCode varchar(8),in @BankAcName varchar(50),in @BankAcNo varchar(15),in @BankRef varchar(20),in @PayMethod tinyint,in @PayFrequency tinyint,in @TaxMethod tinyint,in @C… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidatePlacement https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validateplacement&rev=1786130662  pears.ValidatePlacement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidatePlacement"( in "Placid" varchar(20),in "Vacid" varchar(20),in "persid" varchar(20),in "jobtitle" varchar(50) ) returns long varchar begin declare "RV" long varchar; set "rv" = ''; return("RV") end text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValidationResults https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_validationresults&rev=1786130662  pears.ValidationResults Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValidationResults"() returns long varchar begin declare "ValidationText" long varchar; declare "LoopCounter" integer; declare "NewLine" char(2); set "NewLine" = "char"(13)+"char"(10); set "LoopCounter" = 0; for "GetText" as "TextCursor" dynamic scroll cursor for call "sa_validate"() d… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValuesForAWRInvoiceFixedNIWTRLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_valuesforawrinvoicefixedniwtrline&rev=1786130662  pears.ValuesForAWRInvoiceFixedNIWTRLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValuesForAWRInvoiceFixedNIWTRLine"( in "tsid" char(20),in "tslineid" char(20),in "RecordType" char(1) ) returns double begin -- RecordType W - WTR N - NI declare "vid" char(20); declare "cid" char(20); declare "rv" double; set "rv" = 0; select "companyid","vacancyid" … text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValuesForInvoiceFixedNILine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_valuesforinvoicefixedniline&rev=1786130662  pears.ValuesForInvoiceFixedNILine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValuesForInvoiceFixedNILine"( in "tsid" char(20),in "tslineid" char(20),in "RecordType" char(1) ) returns long varchar -- can do line specific stuff with timesheet line id begin declare "rv" long varchar; declare "vex" integer; set "rv" = null; case "RecordType" when 'D' then… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValuesForInvoiceFixedWTRLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_valuesforinvoicefixedwtrline&rev=1786130662  pears.ValuesForInvoiceFixedWTRLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValuesForInvoiceFixedWTRLine"( in "tsid" char(20),in "tslineid" char(20),in "RecordType" char(1) ) returns long varchar -- can do line specific stuff with timesheet line id begin declare "rv" long varchar; declare "vex" integer; set "rv" = null; case "RecordType" when 'D' th… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.ValuesForInvoiceNIRechargeLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_valuesforinvoicenirechargeline&rev=1786130662  pears.ValuesForInvoiceNIRechargeLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."ValuesForInvoiceNIRechargeLine"( in "tsid" char(20),in "tslineid" char(20),in "RecordType" char(1) ) returns long varchar -- can do line specific stuff with timesheet line id begin declare "rv" long varchar; declare "vex" integer; set "rv" = null; case "RecordType" when 'D… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.VATCodeForTimesheetLine https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_vatcodefortimesheetline&rev=1786130662  pears.VATCodeForTimesheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."VATCodeForTimesheetLine"( in "tslineid" char(20) ) returns char(3) begin declare "rv" char(3); declare "flg" char(20); declare "vex" smallint; declare "vmrg" smallint; return ''; select "companyaccount"."vatexempt","companyaccount"."vatontempmargin" into "vex","vmrg" from "temp… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.WeekContaining https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_weekcontaining&rev=1786130662  pears.WeekContaining Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."WeekContaining"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "d" date ) returns integer begin declare "yr" integer; declare "wk" integer; declare "dt" date; select "max"("yearnumber") into "yr" from "payrollyear" where("week1friday"-7) < "d"; select "week1friday… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.weekenddate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_weekenddate&rev=1786130662  pears.weekenddate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."weekenddate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pyearno" integer,in "pweekno" integer ) returns date begin declare "rv" date; select "week1friday" into "rv" from "payrollyear" where "yearnumber" = "pyearno"; if "rv" is null then select "week1friday"+("nu… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.weekmonthenddate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_weekmonthenddate&rev=1786130662  pears.weekmonthenddate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."weekmonthenddate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "perd" integer,in "worm" char(1) ) returns date begin declare "rv" date; declare "w" integer; declare "y" integer; set "y" = "truncnum"("perd",-2); set "w" = "perd"-"y"; set "y" = "y"/100; if "… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.weekmonthstartdate https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_weekmonthstartdate&rev=1786130662  pears.weekmonthstartdate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."weekmonthstartdate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "perd" integer,in "worm" char(1) ) returns date begin declare "rv" date; declare "w" integer; declare "y" integer; set "y" = "truncnum"("perd",-2); set "w" = "perd"-"y"; set "y" = "y"/100; … text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.WPKGetSwitchValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wpkgetswitchvalue&rev=1786130662  pears.WPKGetSwitchValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."WPKGetSwitchValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SwitchID" char(20),in "SwitchLocation" char(20) ) returns long varchar begin declare "srce" char(1); declare "rv" long varchar; select "source" into "srce" from "wpkglobalswitch" where "wpkglobalswi… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.WPKLocalSwitchValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wpklocalswitchvalue&rev=1786130662  pears.WPKLocalSwitchValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."WPKLocalSwitchValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SwitchID" char(20),in "SwitchLocation" char(20),in "SwitchSource" char(1),in "SwitchLocked" smallint,in "SwitchLocalisable" smallint ) returns long varchar begin declare "rv" long varchar; set "rv… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.WPKMaintainGetSwitchValue https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wpkmaintaingetswitchvalue&rev=1786130662  pears.WPKMaintainGetSwitchValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."WPKMaintainGetSwitchValue"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "SwitchID" char(20),in "SwitchLocation" char(20),in "SwitchSource" char(1) ) returns long varchar begin declare "rv" long varchar; declare "param" char(100); declare "def" long varcha… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.WPKUserPerformsRole https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wpkuserperformsrole&rev=1786130662  pears.WPKUserPerformsRole Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."WPKUserPerformsRole"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sStaffID" char(20),in "sRole" char(31) ) returns integer begin if "sRole" = any(select "WPKRoleID" from "WPKAssignedRole" where "OwnerID" = "sStaffID" and "isnull"("Expires",current date) >= current… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.wtd_holiday_stat https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wtd_holiday_stat&rev=1786130662  pears.wtd_holiday_stat Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."wtd_holiday_stat"( in "pid" char(20),in "yr" integer,in "wk" integer,in "Stat" integer ) returns real /* Stat parameter values- 0: 1=qualifies for hol pay (i.e. Stat 1 >= 13), 0=does not qualify 1: Weeks worked this holiday year (if still working or stopped >= last week) 2: As 1 but pre 23/11/… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) pears.wtd_start_of_hol_year https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:pears_wtd_start_of_hol_year&rev=1786130662  pears.wtd_start_of_hol_year Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create function "pears"."wtd_start_of_hol_year"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pid" char(20),in "yr" integer,in "wk" integer ) returns date begin declare "sdate" date; declare "wedate" date; set "wedate" = "date"("weekenddate"("yr","wk")); if "wedate" is null then --… text/html 2026-08-07T19:24:22+00:00 Anonymous (anonymous@undisclosed.example.com) Functions https://iqxusers.co.uk/iqxhelp/doku.php?id=database:functions:start&rev=1786130662  Functions Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.AccordCompCode * pears.AccordEmployeeCode * pears.AccordERNITimesheet * pears.AccordPayrollCode * pears.AddRecoveryHours * pears.AddressValidation * pears.AdjustPayForceNI * pears.AgencyIDForRateScript * pears.AutoMatchShiftMatchOrder * pears.AWREntityGrade * pears.AWRGap * pears.AWRPlacement * pears.AWRQualified *…