Show pagesourceOld revisionsBacklinksExport to PDFFold/unfold allBack to top Share via Share via... Twitter LinkedIn Facebook Pinterest Telegram WhatsApp Yammer Reddit TeamsRecent ChangesSend via e-MailPrintPermalink × 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 pears.AWRQualifiedCustomOverRide pears.AWRStatusChangeAllowed pears.AWRWeeks pears.Base29Safe pears.Base34 pears.Base36 pears.BlobstoreCopy pears.BlobstoreDbFolder pears.BlobstoreDeleteExternal pears.BlobstoreExtFolder pears.BlobstoreFetch pears.BlobstoreFullPath pears.BlobstoreRead pears.BlobstoreRelocate pears.BlobstoreWrite pears.BroadBeanCreatePost pears.BulkDocPackCompanyAllowed pears.BulkDocPackPackAllowed pears.CanUploadVacancy pears.CollectionDeleteAllowed pears.CollectionGetItemTypeName pears.CollectionHeadline pears.CollectionItemDescription pears.commathousands pears.CommaThousandsDec pears.CompanyHeadline pears.CompanyKeyWordsCustom pears.CompanyKeyWordsQuestion pears.CompanySalesStatusChangeAllowed pears.CompanyStatusChangeAllowed pears.ComplianceScore pears.ComplianceSummary pears.ComplianceValid pears.ComplianceValidforPlacement pears.ComplianceValidforTempShift pears.ComplianceValidPerson pears.ConfirmationDepartmentAllowed pears.ConsentHidePerson pears.ConsentOptionChangeAllowed pears.ConsultantChangeAllowed pears.ContactEventHeadline pears.contactlink pears.contresptran pears.CreateICSFile pears.CustomSMSHTTPRequest pears.CVSendAllowed pears.DataManagementErase pears.DataManagementEraseCustom pears.DateAndTimeOverLap pears.dateToNearest pears.DAXTRACreate pears.DAXTRADeDuplicate pears.DAXTRADelete pears.DAXTRAGenerate pears.DAXTRAUpdate pears.DBCleanupOldJRlog pears.DBCleanupOldRecentObjects pears.DBCleanupOrphanBlobstore pears.DBCleanupOrphanOLEDocument pears.DBCleanupOrphanPhone pears.DBCleanupOrphanRecentObjects pears.DBCleanupOrphanTagValue pears.DeHead pears.DeleteOldDatabaseLogs pears.depttran pears.DescriptionForStagedInvoice pears.DescriptionForTimesheetLine pears.dialable pears.digitsonly pears.DistanceBetweenPostCodes pears.DocumentPackAllowed pears.DocumentPackAttachName pears.DocumentPackEmailBody pears.DuplicateCheckCustomColumn pears.DuplicateVacancyAndPlacement pears.EmailBody pears.EmailCVFileName pears.EmailLetterAsAttachmentFileName pears.EMailSubject pears.EmployeeAcceptable pears.EntityGrade pears.EntityRateFilter pears.EntitySpeciality pears.EssentialSkillDescription pears.EssentialSkillGradeDescription pears.ExpiryAlertExtra pears.FirstWord pears.FormatAddress pears.FormatCompanyAddress pears.FormatCompanyAddress1_0 pears.FormatCompanyPersonAddress pears.FormatPersonAddress pears.FormatPersonAddress1_0 pears.FormatSelfBillAddress pears.FormatSiteAddress pears.GenerateKeyname pears.GenerateWEBDialURL pears.GetBrand pears.GetCascadeTime pears.GetCompanyAddressOnLine pears.GetCompanyGroup pears.GetCompanyGroupHead pears.GetCompanyMainParent pears.GetCompanyPhoneInBlock pears.GetContactEventCaption pears.getcontactposition pears.GetDatabaseServerInfo pears.GetEmployeePhoneInBlock pears.GetExtraRate pears.GetHolidayYear pears.GetInvoiceCompanyID pears.GetInvoicePDF pears.GetKeyShiftPlanState pears.GetKeyShiftState pears.getline pears.GetMinWage pears.GetNotifyBehaviour pears.GetNotifyClientEmail pears.GetPayOrCharge pears.GetPersonAddressOnLine pears.GetPersonAvailPercentage pears.GetPersonAvailState pears.GetPersonEmploymentHistory pears.GetPersonPhoneInBlock pears.GetPhone pears.GetPlacementID pears.GetPlacementTheirRef pears.GetPropertiesText pears.GetQuestAnswer pears.GetQuestAnswerLong pears.GetQuestAnswerNull pears.GetQuestDate pears.GetQuestGroup pears.GetQuestLongWebText pears.GetQuestMultiSelection pears.GetQuestNumber pears.GetQuestSingleSelection pears.GetQuestSingleText pears.GetQuestSingleTextPlus pears.GetQuestString pears.GetQuestSubMenuSelection pears.GetQuestText pears.GetQuestTextLong pears.GetShiftBookedDescription pears.GetShiftIndicatorColour pears.GetShiftLength pears.GetShiftStateBookedDescriptionPlus pears.GetShiftStateDescription pears.GetShiftStateDescriptionPlus pears.GetTempAWRRate pears.GetTempMargin pears.GetTempName pears.GetTempRate pears.GetTempRateByDesc pears.GetTempRateByFlag pears.GetTempRateCustom pears.GetTempRateExtra pears.GetTextFromHTML pears.GetTimeSheetDescription pears.GetVacancyCascadeTime pears.getword pears.getwordex pears.GetWorkPatternWeeklyHours pears.GlobalDocumentSelect pears.GreatestDate pears.hashToIqxId pears.HexCriterionID pears.HideFromCombo pears.HMRC_CheckPostCode pears.InsertDiary pears.InvBatchComplete pears.InvComplete pears.InvOB10Allowed pears.InvoiceCustomColumn pears.InvoiceFilenameInZip pears.InvPDFAllowed pears.InvPDFAllowedWarning pears.InvSendAllowed pears.InvSendAllowedWarning pears.IQacDocumentOutstandingAmount pears.IQacJournalDescription pears.IQacJournalOutstandingAmount pears.iqmoneynumeric pears.iqmoneyround pears.IQXNetAllowed pears.IQXNetAuth2 pears.IQXNetCompanyStartDate pears.IQXNetDecodePostValue pears.IQXNetExtractParam pears.IQXNetHasPermission pears.IQXNetOverrideSwitchTextValue pears.IQXNetOverrideSwitchValue pears.IQXNetStringToDate pears.IQXNetStringToDouble pears.IQXNetStringToInteger pears.IQXNetStringToTime pears.IQXNetSwitchValue pears.IQXNetTemplateChoiceList pears.IQXNetTemplateGradeList pears.IQXNetUserHeadline pears.IsFuzeUser pears.KeyWordSearchAllowed pears.LeastDate pears.LSMLuserValue pears.MailMergeSMTPCredentials pears.MakeHTMLReadable pears.MakeKeyName pears.MasterRosterLimitColour pears.MasterRosterMakeDate pears.MasterRosterStartDate pears.MasterRosterTempAllowed pears.MasterTempRate pears.ModifiedTempRate pears.NetBlobPermitted pears.NetCandidateValidPersonID pears.NetCanUploadVacancy pears.NetClientShiftCancelReasons pears.NetDebtorsDaySalesOutstanding pears.NetErrorHandler pears.NetFavouriteTitle pears.NetFilePermitted pears.NetGetEmail pears.NetGetPlacementid pears.NetGetVacancySiteDetails pears.NetHasPermission pears.NetJSString pears.NetLongQuestAnswer pears.NetOrderReasonList pears.NetOwnerJobRateList pears.NetOwnerTimesheetLists pears.NetPopulateComplianceTable pears.NetQuestionOwnerID pears.NetShiftDateTime pears.NetStringToTimestamp pears.NetTempShiftStatusString pears.NetTimesheetEndDate pears.NetVacancyHasRateScript pears.NetVacancyRoleAllowed pears.NetValidateEmailAddress pears.NominalForTimesheetLine pears.NotificationAttachments pears.NotificationComplete pears.NotificationContactEventClass pears.NotificationCustomFields pears.NotificationDeeplinkComplete pears.NotificationEmailSubject pears.NotificationEmploymentID pears.NotificationHTMLWrapID pears.NotificationICS pears.NotificationRecipients pears.NotificationsExist pears.NotificationSignatureID pears.NotificationStaffID pears.NotificationTemplateSelector pears.numtotime pears.OverrideTempRate pears.PadStr pears.pay_weeklyemployerNI pears.PDFDisplayContent pears.PersonAvailableAtTime pears.PersonAvailableforPlan pears.PersonAvailableforPlanIterate pears.PersonAvailableForRecovery pears.PersonBasedTimesheetCustomColumn pears.PersonDepartmentalAlert pears.PersonHeadline pears.PersonKeyWordsCustom pears.PersonKeyWordsQuestion pears.PersonStatusChangeAllowed pears.PersonTempColour pears.PersonUnavailability pears.PersonUnavailabilityAlert pears.PersonUnavailabilityTimesheet pears.PersonVacancyShiftMatch pears.PersonVacancyShiftMatch2 pears.PhoneUpdate pears.PlacementAllowed pears.PlacementDayHours pears.PlacementDayWorked pears.placementelementvalid pears.placementelementvalidV2 pears.placementelementvalue pears.placementelementvalueV2 pears.PopulateComplianceTable pears.PostCodePart pears.proper pears.psHealthBranch pears.psHealthCanSendPerson pears.psHealthCanSendShift pears.psHealthCanSendVacancy pears.psHealthShowButton pears.psHealthTaskType pears.psHealthUniqueUsername pears.rejectstate pears.ReplaceStr pears.ReportImageFetch pears.RSCalcMargin pears.safedate pears.safetime pears.ScannedImageLinkAllowed pears.SDSRequired pears.SecAgencyStatusChangeAllowed pears.SelfbillBatchComplete pears.SelfBillCustomColumn pears.SelfbillDescriptionForTimesheetLine pears.SelfbillEMailBodyandSubject pears.SelfbillNominalForTimesheetLine pears.SelfbillVATCodeForTimesheetLine pears.SetPersonWillingness pears.SetTempProvTimeSheetStatus pears.ShiftBackColourOverride pears.ShiftColourOverride pears.ShiftConsultants pears.ShiftMatchCustomColumn pears.SocialCareRecipientVacancy pears.SocialMediaResolve pears.SoftWizardController pears.SpecialityLookup pears.StatementEmailBody pears.StripLineFeeds pears.TableExists pears.TempaidTempEmaill pears.TempCustomRateGenerator pears.tempdepttran pears.TempDeskCustomColumn pears.TempGetWeekAgo pears.TempHolidayCalcItem pears.TempProvTimesheetDeleteAllowed pears.TempRatePrecision pears.TempShiftAllowed pears.TempShiftChangeOfHoursAllowed pears.TempShiftConfirmationAllowed pears.TempShiftEditingAllowed pears.TempShiftMatchDescription pears.TempShiftMatchSkillDescription pears.TempShiftPlanAllowed pears.tempslotstartdate pears.TempTimesheetCancel pears.TempTimesheetComplete pears.TempTimesheetCompleteWarning pears.TempTimesheetInvoice pears.TempTimesheetSelfBill pears.TempVacancyShiftMatch pears.TempVacancyShiftMatch2 pears.TempVacancyShiftMatchOrder pears.TimesheetAllowed pears.TimesheetDayHours pears.UniqueKey pears.URLSafe pears.VacancyAllowed pears.VacancyDetailsContents pears.VacancyExtraHols pears.VacancyHeadline pears.VacancyKeyWordsCustom pears.VacancyKeyWordsQuestion pears.VacancyRecipientHeadline pears.VacancyRoleAllowed pears.VacancyStatusChangeAllowed pears.VacancyTempRate pears.ValidateDateOfBirth pears.ValidateEmailAddress pears.ValidateEmailAddressStd pears.ValidateLinkedIn pears.ValidateNINumber pears.ValidatePayroll pears.ValidatePlacement pears.ValidationResults pears.ValuesForAWRInvoiceFixedNIWTRLine pears.ValuesForInvoiceFixedNILine pears.ValuesForInvoiceFixedWTRLine pears.ValuesForInvoiceNIRechargeLine pears.VATCodeForTimesheetLine pears.WeekContaining pears.weekenddate pears.weekmonthenddate pears.weekmonthstartdate pears.WPKGetSwitchValue pears.WPKLocalSwitchValue pears.WPKMaintainGetSwitchValue pears.WPKUserPerformsRole pears.wtd_holiday_stat pears.wtd_start_of_hol_year database/functions/start.txt Last modified: 2026/08/07 19:24by 127.0.0.1
127.0.0.1