====== Functions ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * [[database:functions:pears_accordcompcode|pears.AccordCompCode]] * [[database:functions:pears_accordemployeecode|pears.AccordEmployeeCode]] * [[database:functions:pears_accordernitimesheet|pears.AccordERNITimesheet]] * [[database:functions:pears_accordpayrollcode|pears.AccordPayrollCode]] * [[database:functions:pears_addrecoveryhours|pears.AddRecoveryHours]] * [[database:functions:pears_addressvalidation|pears.AddressValidation]] * [[database:functions:pears_adjustpayforceni|pears.AdjustPayForceNI]] * [[database:functions:pears_agencyidforratescript|pears.AgencyIDForRateScript]] * [[database:functions:pears_automatchshiftmatchorder|pears.AutoMatchShiftMatchOrder]] * [[database:functions:pears_awrentitygrade|pears.AWREntityGrade]] * [[database:functions:pears_awrgap|pears.AWRGap]] * [[database:functions:pears_awrplacement|pears.AWRPlacement]] * [[database:functions:pears_awrqualified|pears.AWRQualified]] * [[database:functions:pears_awrqualifiedcustomoverride|pears.AWRQualifiedCustomOverRide]] * [[database:functions:pears_awrstatuschangeallowed|pears.AWRStatusChangeAllowed]] * [[database:functions:pears_awrweeks|pears.AWRWeeks]] * [[database:functions:pears_base29safe|pears.Base29Safe]] * [[database:functions:pears_base34|pears.Base34]] * [[database:functions:pears_base36|pears.Base36]] * [[database:functions:pears_blobstorecopy|pears.BlobstoreCopy]] * [[database:functions:pears_blobstoredbfolder|pears.BlobstoreDbFolder]] * [[database:functions:pears_blobstoredeleteexternal|pears.BlobstoreDeleteExternal]] * [[database:functions:pears_blobstoreextfolder|pears.BlobstoreExtFolder]] * [[database:functions:pears_blobstorefetch|pears.BlobstoreFetch]] * [[database:functions:pears_blobstorefullpath|pears.BlobstoreFullPath]] * [[database:functions:pears_blobstoreread|pears.BlobstoreRead]] * [[database:functions:pears_blobstorerelocate|pears.BlobstoreRelocate]] * [[database:functions:pears_blobstorewrite|pears.BlobstoreWrite]] * [[database:functions:pears_broadbeancreatepost|pears.BroadBeanCreatePost]] * [[database:functions:pears_bulkdocpackcompanyallowed|pears.BulkDocPackCompanyAllowed]] * [[database:functions:pears_bulkdocpackpackallowed|pears.BulkDocPackPackAllowed]] * [[database:functions:pears_canuploadvacancy|pears.CanUploadVacancy]] * [[database:functions:pears_collectiondeleteallowed|pears.CollectionDeleteAllowed]] * [[database:functions:pears_collectiongetitemtypename|pears.CollectionGetItemTypeName]] * [[database:functions:pears_collectionheadline|pears.CollectionHeadline]] * [[database:functions:pears_collectionitemdescription|pears.CollectionItemDescription]] * [[database:functions:pears_commathousands|pears.commathousands]] * [[database:functions:pears_commathousandsdec|pears.CommaThousandsDec]] * [[database:functions:pears_companyheadline|pears.CompanyHeadline]] * [[database:functions:pears_companykeywordscustom|pears.CompanyKeyWordsCustom]] * [[database:functions:pears_companykeywordsquestion|pears.CompanyKeyWordsQuestion]] * [[database:functions:pears_companysalesstatuschangeallowed|pears.CompanySalesStatusChangeAllowed]] * [[database:functions:pears_companystatuschangeallowed|pears.CompanyStatusChangeAllowed]] * [[database:functions:pears_compliancescore|pears.ComplianceScore]] * [[database:functions:pears_compliancesummary|pears.ComplianceSummary]] * [[database:functions:pears_compliancevalid|pears.ComplianceValid]] * [[database:functions:pears_compliancevalidforplacement|pears.ComplianceValidforPlacement]] * [[database:functions:pears_compliancevalidfortempshift|pears.ComplianceValidforTempShift]] * [[database:functions:pears_compliancevalidperson|pears.ComplianceValidPerson]] * [[database:functions:pears_confirmationdepartmentallowed|pears.ConfirmationDepartmentAllowed]] * [[database:functions:pears_consenthideperson|pears.ConsentHidePerson]] * [[database:functions:pears_consentoptionchangeallowed|pears.ConsentOptionChangeAllowed]] * [[database:functions:pears_consultantchangeallowed|pears.ConsultantChangeAllowed]] * [[database:functions:pears_contacteventheadline|pears.ContactEventHeadline]] * [[database:functions:pears_contactlink|pears.contactlink]] * [[database:functions:pears_contresptran|pears.contresptran]] * [[database:functions:pears_createicsfile|pears.CreateICSFile]] * [[database:functions:pears_customsmshttprequest|pears.CustomSMSHTTPRequest]] * [[database:functions:pears_cvsendallowed|pears.CVSendAllowed]] * [[database:functions:pears_datamanagementerase|pears.DataManagementErase]] * [[database:functions:pears_datamanagementerasecustom|pears.DataManagementEraseCustom]] * [[database:functions:pears_dateandtimeoverlap|pears.DateAndTimeOverLap]] * [[database:functions:pears_datetonearest|pears.dateToNearest]] * [[database:functions:pears_daxtracreate|pears.DAXTRACreate]] * [[database:functions:pears_daxtradeduplicate|pears.DAXTRADeDuplicate]] * [[database:functions:pears_daxtradelete|pears.DAXTRADelete]] * [[database:functions:pears_daxtragenerate|pears.DAXTRAGenerate]] * [[database:functions:pears_daxtraupdate|pears.DAXTRAUpdate]] * [[database:functions:pears_dbcleanupoldjrlog|pears.DBCleanupOldJRlog]] * [[database:functions:pears_dbcleanupoldrecentobjects|pears.DBCleanupOldRecentObjects]] * [[database:functions:pears_dbcleanuporphanblobstore|pears.DBCleanupOrphanBlobstore]] * [[database:functions:pears_dbcleanuporphanoledocument|pears.DBCleanupOrphanOLEDocument]] * [[database:functions:pears_dbcleanuporphanphone|pears.DBCleanupOrphanPhone]] * [[database:functions:pears_dbcleanuporphanrecentobjects|pears.DBCleanupOrphanRecentObjects]] * [[database:functions:pears_dbcleanuporphantagvalue|pears.DBCleanupOrphanTagValue]] * [[database:functions:pears_dehead|pears.DeHead]] * [[database:functions:pears_deleteolddatabaselogs|pears.DeleteOldDatabaseLogs]] * [[database:functions:pears_depttran|pears.depttran]] * [[database:functions:pears_descriptionforstagedinvoice|pears.DescriptionForStagedInvoice]] * [[database:functions:pears_descriptionfortimesheetline|pears.DescriptionForTimesheetLine]] * [[database:functions:pears_dialable|pears.dialable]] * [[database:functions:pears_digitsonly|pears.digitsonly]] * [[database:functions:pears_distancebetweenpostcodes|pears.DistanceBetweenPostCodes]] * [[database:functions:pears_documentpackallowed|pears.DocumentPackAllowed]] * [[database:functions:pears_documentpackattachname|pears.DocumentPackAttachName]] * [[database:functions:pears_documentpackemailbody|pears.DocumentPackEmailBody]] * [[database:functions:pears_duplicatecheckcustomcolumn|pears.DuplicateCheckCustomColumn]] * [[database:functions:pears_duplicatevacancyandplacement|pears.DuplicateVacancyAndPlacement]] * [[database:functions:pears_emailbody|pears.EmailBody]] * [[database:functions:pears_emailcvfilename|pears.EmailCVFileName]] * [[database:functions:pears_emailletterasattachmentfilename|pears.EmailLetterAsAttachmentFileName]] * [[database:functions:pears_emailsubject|pears.EMailSubject]] * [[database:functions:pears_employeeacceptable|pears.EmployeeAcceptable]] * [[database:functions:pears_entitygrade|pears.EntityGrade]] * [[database:functions:pears_entityratefilter|pears.EntityRateFilter]] * [[database:functions:pears_entityspeciality|pears.EntitySpeciality]] * [[database:functions:pears_essentialskilldescription|pears.EssentialSkillDescription]] * [[database:functions:pears_essentialskillgradedescription|pears.EssentialSkillGradeDescription]] * [[database:functions:pears_expiryalertextra|pears.ExpiryAlertExtra]] * [[database:functions:pears_firstword|pears.FirstWord]] * [[database:functions:pears_formataddress|pears.FormatAddress]] * [[database:functions:pears_formatcompanyaddress|pears.FormatCompanyAddress]] * [[database:functions:pears_formatcompanyaddress1_0|pears.FormatCompanyAddress1_0]] * [[database:functions:pears_formatcompanypersonaddress|pears.FormatCompanyPersonAddress]] * [[database:functions:pears_formatpersonaddress|pears.FormatPersonAddress]] * [[database:functions:pears_formatpersonaddress1_0|pears.FormatPersonAddress1_0]] * [[database:functions:pears_formatselfbilladdress|pears.FormatSelfBillAddress]] * [[database:functions:pears_formatsiteaddress|pears.FormatSiteAddress]] * [[database:functions:pears_generatekeyname|pears.GenerateKeyname]] * [[database:functions:pears_generatewebdialurl|pears.GenerateWEBDialURL]] * [[database:functions:pears_getbrand|pears.GetBrand]] * [[database:functions:pears_getcascadetime|pears.GetCascadeTime]] * [[database:functions:pears_getcompanyaddressonline|pears.GetCompanyAddressOnLine]] * [[database:functions:pears_getcompanygroup|pears.GetCompanyGroup]] * [[database:functions:pears_getcompanygrouphead|pears.GetCompanyGroupHead]] * [[database:functions:pears_getcompanymainparent|pears.GetCompanyMainParent]] * [[database:functions:pears_getcompanyphoneinblock|pears.GetCompanyPhoneInBlock]] * [[database:functions:pears_getcontacteventcaption|pears.GetContactEventCaption]] * [[database:functions:pears_getcontactposition|pears.getcontactposition]] * [[database:functions:pears_getdatabaseserverinfo|pears.GetDatabaseServerInfo]] * [[database:functions:pears_getemployeephoneinblock|pears.GetEmployeePhoneInBlock]] * [[database:functions:pears_getextrarate|pears.GetExtraRate]] * [[database:functions:pears_getholidayyear|pears.GetHolidayYear]] * [[database:functions:pears_getinvoicecompanyid|pears.GetInvoiceCompanyID]] * [[database:functions:pears_getinvoicepdf|pears.GetInvoicePDF]] * [[database:functions:pears_getkeyshiftplanstate|pears.GetKeyShiftPlanState]] * [[database:functions:pears_getkeyshiftstate|pears.GetKeyShiftState]] * [[database:functions:pears_getline|pears.getline]] * [[database:functions:pears_getminwage|pears.GetMinWage]] * [[database:functions:pears_getnotifybehaviour|pears.GetNotifyBehaviour]] * [[database:functions:pears_getnotifyclientemail|pears.GetNotifyClientEmail]] * [[database:functions:pears_getpayorcharge|pears.GetPayOrCharge]] * [[database:functions:pears_getpersonaddressonline|pears.GetPersonAddressOnLine]] * [[database:functions:pears_getpersonavailpercentage|pears.GetPersonAvailPercentage]] * [[database:functions:pears_getpersonavailstate|pears.GetPersonAvailState]] * [[database:functions:pears_getpersonemploymenthistory|pears.GetPersonEmploymentHistory]] * [[database:functions:pears_getpersonphoneinblock|pears.GetPersonPhoneInBlock]] * [[database:functions:pears_getphone|pears.GetPhone]] * [[database:functions:pears_getplacementid|pears.GetPlacementID]] * [[database:functions:pears_getplacementtheirref|pears.GetPlacementTheirRef]] * [[database:functions:pears_getpropertiestext|pears.GetPropertiesText]] * [[database:functions:pears_getquestanswer|pears.GetQuestAnswer]] * [[database:functions:pears_getquestanswerlong|pears.GetQuestAnswerLong]] * [[database:functions:pears_getquestanswernull|pears.GetQuestAnswerNull]] * [[database:functions:pears_getquestdate|pears.GetQuestDate]] * [[database:functions:pears_getquestgroup|pears.GetQuestGroup]] * [[database:functions:pears_getquestlongwebtext|pears.GetQuestLongWebText]] * [[database:functions:pears_getquestmultiselection|pears.GetQuestMultiSelection]] * [[database:functions:pears_getquestnumber|pears.GetQuestNumber]] * [[database:functions:pears_getquestsingleselection|pears.GetQuestSingleSelection]] * [[database:functions:pears_getquestsingletext|pears.GetQuestSingleText]] * [[database:functions:pears_getquestsingletextplus|pears.GetQuestSingleTextPlus]] * [[database:functions:pears_getqueststring|pears.GetQuestString]] * [[database:functions:pears_getquestsubmenuselection|pears.GetQuestSubMenuSelection]] * [[database:functions:pears_getquesttext|pears.GetQuestText]] * [[database:functions:pears_getquesttextlong|pears.GetQuestTextLong]] * [[database:functions:pears_getshiftbookeddescription|pears.GetShiftBookedDescription]] * [[database:functions:pears_getshiftindicatorcolour|pears.GetShiftIndicatorColour]] * [[database:functions:pears_getshiftlength|pears.GetShiftLength]] * [[database:functions:pears_getshiftstatebookeddescriptionplus|pears.GetShiftStateBookedDescriptionPlus]] * [[database:functions:pears_getshiftstatedescription|pears.GetShiftStateDescription]] * [[database:functions:pears_getshiftstatedescriptionplus|pears.GetShiftStateDescriptionPlus]] * [[database:functions:pears_gettempawrrate|pears.GetTempAWRRate]] * [[database:functions:pears_gettempmargin|pears.GetTempMargin]] * [[database:functions:pears_gettempname|pears.GetTempName]] * [[database:functions:pears_gettemprate|pears.GetTempRate]] * [[database:functions:pears_gettempratebydesc|pears.GetTempRateByDesc]] * [[database:functions:pears_gettempratebyflag|pears.GetTempRateByFlag]] * [[database:functions:pears_gettempratecustom|pears.GetTempRateCustom]] * [[database:functions:pears_gettemprateextra|pears.GetTempRateExtra]] * [[database:functions:pears_gettextfromhtml|pears.GetTextFromHTML]] * [[database:functions:pears_gettimesheetdescription|pears.GetTimeSheetDescription]] * [[database:functions:pears_getvacancycascadetime|pears.GetVacancyCascadeTime]] * [[database:functions:pears_getword|pears.getword]] * [[database:functions:pears_getwordex|pears.getwordex]] * [[database:functions:pears_getworkpatternweeklyhours|pears.GetWorkPatternWeeklyHours]] * [[database:functions:pears_globaldocumentselect|pears.GlobalDocumentSelect]] * [[database:functions:pears_greatestdate|pears.GreatestDate]] * [[database:functions:pears_hashtoiqxid|pears.hashToIqxId]] * [[database:functions:pears_hexcriterionid|pears.HexCriterionID]] * [[database:functions:pears_hidefromcombo|pears.HideFromCombo]] * [[database:functions:pears_hmrc_checkpostcode|pears.HMRC_CheckPostCode]] * [[database:functions:pears_insertdiary|pears.InsertDiary]] * [[database:functions:pears_invbatchcomplete|pears.InvBatchComplete]] * [[database:functions:pears_invcomplete|pears.InvComplete]] * [[database:functions:pears_invob10allowed|pears.InvOB10Allowed]] * [[database:functions:pears_invoicecustomcolumn|pears.InvoiceCustomColumn]] * [[database:functions:pears_invoicefilenameinzip|pears.InvoiceFilenameInZip]] * [[database:functions:pears_invpdfallowed|pears.InvPDFAllowed]] * [[database:functions:pears_invpdfallowedwarning|pears.InvPDFAllowedWarning]] * [[database:functions:pears_invsendallowed|pears.InvSendAllowed]] * [[database:functions:pears_invsendallowedwarning|pears.InvSendAllowedWarning]] * [[database:functions:pears_iqacdocumentoutstandingamount|pears.IQacDocumentOutstandingAmount]] * [[database:functions:pears_iqacjournaldescription|pears.IQacJournalDescription]] * [[database:functions:pears_iqacjournaloutstandingamount|pears.IQacJournalOutstandingAmount]] * [[database:functions:pears_iqmoneynumeric|pears.iqmoneynumeric]] * [[database:functions:pears_iqmoneyround|pears.iqmoneyround]] * [[database:functions:pears_iqxnetallowed|pears.IQXNetAllowed]] * [[database:functions:pears_iqxnetauth2|pears.IQXNetAuth2]] * [[database:functions:pears_iqxnetcompanystartdate|pears.IQXNetCompanyStartDate]] * [[database:functions:pears_iqxnetdecodepostvalue|pears.IQXNetDecodePostValue]] * [[database:functions:pears_iqxnetextractparam|pears.IQXNetExtractParam]] * [[database:functions:pears_iqxnethaspermission|pears.IQXNetHasPermission]] * [[database:functions:pears_iqxnetoverrideswitchtextvalue|pears.IQXNetOverrideSwitchTextValue]] * [[database:functions:pears_iqxnetoverrideswitchvalue|pears.IQXNetOverrideSwitchValue]] * [[database:functions:pears_iqxnetstringtodate|pears.IQXNetStringToDate]] * [[database:functions:pears_iqxnetstringtodouble|pears.IQXNetStringToDouble]] * [[database:functions:pears_iqxnetstringtointeger|pears.IQXNetStringToInteger]] * [[database:functions:pears_iqxnetstringtotime|pears.IQXNetStringToTime]] * [[database:functions:pears_iqxnetswitchvalue|pears.IQXNetSwitchValue]] * [[database:functions:pears_iqxnettemplatechoicelist|pears.IQXNetTemplateChoiceList]] * [[database:functions:pears_iqxnettemplategradelist|pears.IQXNetTemplateGradeList]] * [[database:functions:pears_iqxnetuserheadline|pears.IQXNetUserHeadline]] * [[database:functions:pears_isfuzeuser|pears.IsFuzeUser]] * [[database:functions:pears_keywordsearchallowed|pears.KeyWordSearchAllowed]] * [[database:functions:pears_leastdate|pears.LeastDate]] * [[database:functions:pears_lsmluservalue|pears.LSMLuserValue]] * [[database:functions:pears_mailmergesmtpcredentials|pears.MailMergeSMTPCredentials]] * [[database:functions:pears_makehtmlreadable|pears.MakeHTMLReadable]] * [[database:functions:pears_makekeyname|pears.MakeKeyName]] * [[database:functions:pears_masterrosterlimitcolour|pears.MasterRosterLimitColour]] * [[database:functions:pears_masterrostermakedate|pears.MasterRosterMakeDate]] * [[database:functions:pears_masterrosterstartdate|pears.MasterRosterStartDate]] * [[database:functions:pears_masterrostertempallowed|pears.MasterRosterTempAllowed]] * [[database:functions:pears_mastertemprate|pears.MasterTempRate]] * [[database:functions:pears_modifiedtemprate|pears.ModifiedTempRate]] * [[database:functions:pears_netblobpermitted|pears.NetBlobPermitted]] * [[database:functions:pears_netcandidatevalidpersonid|pears.NetCandidateValidPersonID]] * [[database:functions:pears_netcanuploadvacancy|pears.NetCanUploadVacancy]] * [[database:functions:pears_netclientshiftcancelreasons|pears.NetClientShiftCancelReasons]] * [[database:functions:pears_netdebtorsdaysalesoutstanding|pears.NetDebtorsDaySalesOutstanding]] * [[database:functions:pears_neterrorhandler|pears.NetErrorHandler]] * [[database:functions:pears_netfavouritetitle|pears.NetFavouriteTitle]] * [[database:functions:pears_netfilepermitted|pears.NetFilePermitted]] * [[database:functions:pears_netgetemail|pears.NetGetEmail]] * [[database:functions:pears_netgetplacementid|pears.NetGetPlacementid]] * [[database:functions:pears_netgetvacancysitedetails|pears.NetGetVacancySiteDetails]] * [[database:functions:pears_nethaspermission|pears.NetHasPermission]] * [[database:functions:pears_netjsstring|pears.NetJSString]] * [[database:functions:pears_netlongquestanswer|pears.NetLongQuestAnswer]] * [[database:functions:pears_netorderreasonlist|pears.NetOrderReasonList]] * [[database:functions:pears_netownerjobratelist|pears.NetOwnerJobRateList]] * [[database:functions:pears_netownertimesheetlists|pears.NetOwnerTimesheetLists]] * [[database:functions:pears_netpopulatecompliancetable|pears.NetPopulateComplianceTable]] * [[database:functions:pears_netquestionownerid|pears.NetQuestionOwnerID]] * [[database:functions:pears_netshiftdatetime|pears.NetShiftDateTime]] * [[database:functions:pears_netstringtotimestamp|pears.NetStringToTimestamp]] * [[database:functions:pears_nettempshiftstatusstring|pears.NetTempShiftStatusString]] * [[database:functions:pears_nettimesheetenddate|pears.NetTimesheetEndDate]] * [[database:functions:pears_netvacancyhasratescript|pears.NetVacancyHasRateScript]] * [[database:functions:pears_netvacancyroleallowed|pears.NetVacancyRoleAllowed]] * [[database:functions:pears_netvalidateemailaddress|pears.NetValidateEmailAddress]] * [[database:functions:pears_nominalfortimesheetline|pears.NominalForTimesheetLine]] * [[database:functions:pears_notificationattachments|pears.NotificationAttachments]] * [[database:functions:pears_notificationcomplete|pears.NotificationComplete]] * [[database:functions:pears_notificationcontacteventclass|pears.NotificationContactEventClass]] * [[database:functions:pears_notificationcustomfields|pears.NotificationCustomFields]] * [[database:functions:pears_notificationdeeplinkcomplete|pears.NotificationDeeplinkComplete]] * [[database:functions:pears_notificationemailsubject|pears.NotificationEmailSubject]] * [[database:functions:pears_notificationemploymentid|pears.NotificationEmploymentID]] * [[database:functions:pears_notificationhtmlwrapid|pears.NotificationHTMLWrapID]] * [[database:functions:pears_notificationics|pears.NotificationICS]] * [[database:functions:pears_notificationrecipients|pears.NotificationRecipients]] * [[database:functions:pears_notificationsexist|pears.NotificationsExist]] * [[database:functions:pears_notificationsignatureid|pears.NotificationSignatureID]] * [[database:functions:pears_notificationstaffid|pears.NotificationStaffID]] * [[database:functions:pears_notificationtemplateselector|pears.NotificationTemplateSelector]] * [[database:functions:pears_numtotime|pears.numtotime]] * [[database:functions:pears_overridetemprate|pears.OverrideTempRate]] * [[database:functions:pears_padstr|pears.PadStr]] * [[database:functions:pears_pay_weeklyemployerni|pears.pay_weeklyemployerNI]] * [[database:functions:pears_pdfdisplaycontent|pears.PDFDisplayContent]] * [[database:functions:pears_personavailableattime|pears.PersonAvailableAtTime]] * [[database:functions:pears_personavailableforplan|pears.PersonAvailableforPlan]] * [[database:functions:pears_personavailableforplaniterate|pears.PersonAvailableforPlanIterate]] * [[database:functions:pears_personavailableforrecovery|pears.PersonAvailableForRecovery]] * [[database:functions:pears_personbasedtimesheetcustomcolumn|pears.PersonBasedTimesheetCustomColumn]] * [[database:functions:pears_persondepartmentalalert|pears.PersonDepartmentalAlert]] * [[database:functions:pears_personheadline|pears.PersonHeadline]] * [[database:functions:pears_personkeywordscustom|pears.PersonKeyWordsCustom]] * [[database:functions:pears_personkeywordsquestion|pears.PersonKeyWordsQuestion]] * [[database:functions:pears_personstatuschangeallowed|pears.PersonStatusChangeAllowed]] * [[database:functions:pears_persontempcolour|pears.PersonTempColour]] * [[database:functions:pears_personunavailability|pears.PersonUnavailability]] * [[database:functions:pears_personunavailabilityalert|pears.PersonUnavailabilityAlert]] * [[database:functions:pears_personunavailabilitytimesheet|pears.PersonUnavailabilityTimesheet]] * [[database:functions:pears_personvacancyshiftmatch|pears.PersonVacancyShiftMatch]] * [[database:functions:pears_personvacancyshiftmatch2|pears.PersonVacancyShiftMatch2]] * [[database:functions:pears_phoneupdate|pears.PhoneUpdate]] * [[database:functions:pears_placementallowed|pears.PlacementAllowed]] * [[database:functions:pears_placementdayhours|pears.PlacementDayHours]] * [[database:functions:pears_placementdayworked|pears.PlacementDayWorked]] * [[database:functions:pears_placementelementvalid|pears.placementelementvalid]] * [[database:functions:pears_placementelementvalidv2|pears.placementelementvalidV2]] * [[database:functions:pears_placementelementvalue|pears.placementelementvalue]] * [[database:functions:pears_placementelementvaluev2|pears.placementelementvalueV2]] * [[database:functions:pears_populatecompliancetable|pears.PopulateComplianceTable]] * [[database:functions:pears_postcodepart|pears.PostCodePart]] * [[database:functions:pears_proper|pears.proper]] * [[database:functions:pears_pshealthbranch|pears.psHealthBranch]] * [[database:functions:pears_pshealthcansendperson|pears.psHealthCanSendPerson]] * [[database:functions:pears_pshealthcansendshift|pears.psHealthCanSendShift]] * [[database:functions:pears_pshealthcansendvacancy|pears.psHealthCanSendVacancy]] * [[database:functions:pears_pshealthshowbutton|pears.psHealthShowButton]] * [[database:functions:pears_pshealthtasktype|pears.psHealthTaskType]] * [[database:functions:pears_pshealthuniqueusername|pears.psHealthUniqueUsername]] * [[database:functions:pears_rejectstate|pears.rejectstate]] * [[database:functions:pears_replacestr|pears.ReplaceStr]] * [[database:functions:pears_reportimagefetch|pears.ReportImageFetch]] * [[database:functions:pears_rscalcmargin|pears.RSCalcMargin]] * [[database:functions:pears_safedate|pears.safedate]] * [[database:functions:pears_safetime|pears.safetime]] * [[database:functions:pears_scannedimagelinkallowed|pears.ScannedImageLinkAllowed]] * [[database:functions:pears_sdsrequired|pears.SDSRequired]] * [[database:functions:pears_secagencystatuschangeallowed|pears.SecAgencyStatusChangeAllowed]] * [[database:functions:pears_selfbillbatchcomplete|pears.SelfbillBatchComplete]] * [[database:functions:pears_selfbillcustomcolumn|pears.SelfBillCustomColumn]] * [[database:functions:pears_selfbilldescriptionfortimesheetline|pears.SelfbillDescriptionForTimesheetLine]] * [[database:functions:pears_selfbillemailbodyandsubject|pears.SelfbillEMailBodyandSubject]] * [[database:functions:pears_selfbillnominalfortimesheetline|pears.SelfbillNominalForTimesheetLine]] * [[database:functions:pears_selfbillvatcodefortimesheetline|pears.SelfbillVATCodeForTimesheetLine]] * [[database:functions:pears_setpersonwillingness|pears.SetPersonWillingness]] * [[database:functions:pears_settempprovtimesheetstatus|pears.SetTempProvTimeSheetStatus]] * [[database:functions:pears_shiftbackcolouroverride|pears.ShiftBackColourOverride]] * [[database:functions:pears_shiftcolouroverride|pears.ShiftColourOverride]] * [[database:functions:pears_shiftconsultants|pears.ShiftConsultants]] * [[database:functions:pears_shiftmatchcustomcolumn|pears.ShiftMatchCustomColumn]] * [[database:functions:pears_socialcarerecipientvacancy|pears.SocialCareRecipientVacancy]] * [[database:functions:pears_socialmediaresolve|pears.SocialMediaResolve]] * [[database:functions:pears_softwizardcontroller|pears.SoftWizardController]] * [[database:functions:pears_specialitylookup|pears.SpecialityLookup]] * [[database:functions:pears_statementemailbody|pears.StatementEmailBody]] * [[database:functions:pears_striplinefeeds|pears.StripLineFeeds]] * [[database:functions:pears_tableexists|pears.TableExists]] * [[database:functions:pears_tempaidtempemaill|pears.TempaidTempEmaill]] * [[database:functions:pears_tempcustomrategenerator|pears.TempCustomRateGenerator]] * [[database:functions:pears_tempdepttran|pears.tempdepttran]] * [[database:functions:pears_tempdeskcustomcolumn|pears.TempDeskCustomColumn]] * [[database:functions:pears_tempgetweekago|pears.TempGetWeekAgo]] * [[database:functions:pears_tempholidaycalcitem|pears.TempHolidayCalcItem]] * [[database:functions:pears_tempprovtimesheetdeleteallowed|pears.TempProvTimesheetDeleteAllowed]] * [[database:functions:pears_temprateprecision|pears.TempRatePrecision]] * [[database:functions:pears_tempshiftallowed|pears.TempShiftAllowed]] * [[database:functions:pears_tempshiftchangeofhoursallowed|pears.TempShiftChangeOfHoursAllowed]] * [[database:functions:pears_tempshiftconfirmationallowed|pears.TempShiftConfirmationAllowed]] * [[database:functions:pears_tempshifteditingallowed|pears.TempShiftEditingAllowed]] * [[database:functions:pears_tempshiftmatchdescription|pears.TempShiftMatchDescription]] * [[database:functions:pears_tempshiftmatchskilldescription|pears.TempShiftMatchSkillDescription]] * [[database:functions:pears_tempshiftplanallowed|pears.TempShiftPlanAllowed]] * [[database:functions:pears_tempslotstartdate|pears.tempslotstartdate]] * [[database:functions:pears_temptimesheetcancel|pears.TempTimesheetCancel]] * [[database:functions:pears_temptimesheetcomplete|pears.TempTimesheetComplete]] * [[database:functions:pears_temptimesheetcompletewarning|pears.TempTimesheetCompleteWarning]] * [[database:functions:pears_temptimesheetinvoice|pears.TempTimesheetInvoice]] * [[database:functions:pears_temptimesheetselfbill|pears.TempTimesheetSelfBill]] * [[database:functions:pears_tempvacancyshiftmatch|pears.TempVacancyShiftMatch]] * [[database:functions:pears_tempvacancyshiftmatch2|pears.TempVacancyShiftMatch2]] * [[database:functions:pears_tempvacancyshiftmatchorder|pears.TempVacancyShiftMatchOrder]] * [[database:functions:pears_timesheetallowed|pears.TimesheetAllowed]] * [[database:functions:pears_timesheetdayhours|pears.TimesheetDayHours]] * [[database:functions:pears_uniquekey|pears.UniqueKey]] * [[database:functions:pears_urlsafe|pears.URLSafe]] * [[database:functions:pears_vacancyallowed|pears.VacancyAllowed]] * [[database:functions:pears_vacancydetailscontents|pears.VacancyDetailsContents]] * [[database:functions:pears_vacancyextrahols|pears.VacancyExtraHols]] * [[database:functions:pears_vacancyheadline|pears.VacancyHeadline]] * [[database:functions:pears_vacancykeywordscustom|pears.VacancyKeyWordsCustom]] * [[database:functions:pears_vacancykeywordsquestion|pears.VacancyKeyWordsQuestion]] * [[database:functions:pears_vacancyrecipientheadline|pears.VacancyRecipientHeadline]] * [[database:functions:pears_vacancyroleallowed|pears.VacancyRoleAllowed]] * [[database:functions:pears_vacancystatuschangeallowed|pears.VacancyStatusChangeAllowed]] * [[database:functions:pears_vacancytemprate|pears.VacancyTempRate]] * [[database:functions:pears_validatedateofbirth|pears.ValidateDateOfBirth]] * [[database:functions:pears_validateemailaddress|pears.ValidateEmailAddress]] * [[database:functions:pears_validateemailaddressstd|pears.ValidateEmailAddressStd]] * [[database:functions:pears_validatelinkedin|pears.ValidateLinkedIn]] * [[database:functions:pears_validateninumber|pears.ValidateNINumber]] * [[database:functions:pears_validatepayroll|pears.ValidatePayroll]] * [[database:functions:pears_validateplacement|pears.ValidatePlacement]] * [[database:functions:pears_validationresults|pears.ValidationResults]] * [[database:functions:pears_valuesforawrinvoicefixedniwtrline|pears.ValuesForAWRInvoiceFixedNIWTRLine]] * [[database:functions:pears_valuesforinvoicefixedniline|pears.ValuesForInvoiceFixedNILine]] * [[database:functions:pears_valuesforinvoicefixedwtrline|pears.ValuesForInvoiceFixedWTRLine]] * [[database:functions:pears_valuesforinvoicenirechargeline|pears.ValuesForInvoiceNIRechargeLine]] * [[database:functions:pears_vatcodefortimesheetline|pears.VATCodeForTimesheetLine]] * [[database:functions:pears_weekcontaining|pears.WeekContaining]] * [[database:functions:pears_weekenddate|pears.weekenddate]] * [[database:functions:pears_weekmonthenddate|pears.weekmonthenddate]] * [[database:functions:pears_weekmonthstartdate|pears.weekmonthstartdate]] * [[database:functions:pears_wpkgetswitchvalue|pears.WPKGetSwitchValue]] * [[database:functions:pears_wpklocalswitchvalue|pears.WPKLocalSwitchValue]] * [[database:functions:pears_wpkmaintaingetswitchvalue|pears.WPKMaintainGetSwitchValue]] * [[database:functions:pears_wpkuserperformsrole|pears.WPKUserPerformsRole]] * [[database:functions:pears_wtd_holiday_stat|pears.wtd_holiday_stat]] * [[database:functions:pears_wtd_start_of_hol_year|pears.wtd_start_of_hol_year]]