Recruitment software that liberates your business https://iqxusers.co.uk/iqxhelp/ 2026-08-07T22:46:35+00:00 https://iqxusers.co.uk/iqxhelp/ https://iqxusers.co.uk/iqxhelp/lib/exe/fetch.php?media=wiki:logo.png text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_a&rev=1786130664  Tables: A Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.AccordEmployee - Links Person records to Accord employee records. Used to detect address changes that need to be passed to Accord. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_b&rev=1786130664  Tables: B Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.BankModulus - Contains list of valid sortcode ranges and which modulus check applies. * pears.BankModulusValidSortcodes - List of sort codes to be excluded from modulus checking. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_c&rev=1786130664  Tables: C Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.CardReaderCard - Current state (in or out) for each swipe card or equivalent. * pears.CardReaderImport - Import table for Time & Attendance data (eg card swipes etc). text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_d&rev=1786130664  Tables: D Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.DashboardDisplayedObject - Objects which actually appear on individuals IQXWeb dashboard * pears.DashboardObject - Objects which may appear on IQXWeb dashboard text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_e&rev=1786130664  Tables: E Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.EBPayBand - Expense Benefit payband * pears.EBTimeSheet - Expense Benefit timesheet * pears.EBTimeSheetLine - Expense Benefit timesheet line text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_f&rev=1786130664  Tables: F Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.Favourites - List of favourite records - links to company - person…. * pears.FuzeErrors * pears.FuzeUsers text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_g&rev=1786130664  Tables: G Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.globaldocument - List of standard documents for IQXWeb - contracts - terms of engagement - etc. * pears.GlobalDocumentLink text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_h&rev=1786130664  Tables: H Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.HolidayPayYear - Used in Configuring the Holiday Pay System. * pears.HTMLImage - Links to contactevent - 1 record per image. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_i&rev=1786130664  Tables: I Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.ImageStamping * pears.InterPersonLink - Defines links between people - used for NOK etc. * pears.InvoiceManagementGroup - Groups that control the processing of invoices. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_k&rev=1786130664  Tables: K Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.KMLBuffer text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_l&rev=1786130664  Tables: L Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.LeaveClasses - Contains list of types of leave (eg paid holiday - maternity leave etc) recorded in WeEmployLeave table. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_m&rev=1786130664  Tables: M Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.mailerselection - Mailchimp 'LISTS' * pears.mailerselectionmember - Candidate/client contacts on mailchimp list. * pears.mailmerge - Pointers to OLE documents in Blobstore (class M) which are individual users own Word mail merge templates. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_n&rev=1786130664  Tables: N Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.NominalSegment - Nominal Code segments used to build up the nominal code attached to placement income. * pears.NominalSegmentDivision * text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_o&rev=1786130664  Tables: O Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.OffLimits - Limits on approaching Companies or People during specfied period. * pears.oledocument - Pointers to documents belonging to People & Companies. Stored in the Blobstore (Class O) text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_p&rev=1786130664  Tables: P Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.params - System parameters. Only one record in table. * pears.Pay_Employee - Data related to a persons employment by the agency. One to one relationship with Person. Only created when required. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_r&rev=1786130664  Tables: R Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.RecentObjects - Record of user viewing of different database objects. * pears.ReferenceMaster - Template for online referencing. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_s&rev=1786130664  Tables: S Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.SageLine50Defaults - Defaults for exports to sage Line50 * pears.SalesBrand * pears.search - Details of Candidates registration for Temp or Perm work with departments. text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_t&rev=1786130664  Tables: T Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.tag - User defined field definitions (Questionnaires) * pears.tagchoice - Choices for picklist responses to User Defined fields text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_u&rev=1786130664  Tables: U Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.UnsubscribeToMarketing - Emails to send to mailchimp to unsubscribe * pears.UTRCheck text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_v&rev=1786130664  Tables: V Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.vacancy - Header record for Vacancies. * pears.vacancy_team - Allows additional Staff records to be linked to Vacancy records text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:index_w&rev=1786130664  Tables: W Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.WithHoldReason * pears.WithHolds - Stores witholds. When a worker is blocked from a vacancy or a company * pears.WPKAssignedRole - Link between Staff and WPKRoles. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_accordemployee&rev=1786130656  pears.AccordEmployee Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Person records to Accord employee records. Used to detect address changes that need to be passed to Accord. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_accordexpensebenefitexport&rev=1786130656  pears.AccordExpenseBenefitExport Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense benefit timesheets for Accord. Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_accordparams&rev=1786130656  pears.AccordParams Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Accord payroll settings. One row only. Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_accordpayrolldefinition&rev=1786130656  pears.ACCORDPAYROLLDEFINITION Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Translation between IQX & Accord field names. Used for providing meaningful messages. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_accountoverrideinvoiceaddress&rev=1786130656  pears.AccountOverrideInvoiceAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment AccountOverrideInvoiceAddressID text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_adhocinvoicetemplate&rev=1786130656  pears.AdhocInvoiceTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Save As Template button on AdHoc Invoice Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_adhocinvoicetemplateline&rev=1786130656  pears.AdhocInvoiceTemplateLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lines for AdHoc Invoice Templates Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_agencydetails&rev=1786130656  pears.agencydetails Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Branch details. A branch usually represents a physical location. Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_alternativeinvoiceaddressemail&rev=1786130656  pears.AlternativeInvoiceAddressEmail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment AlternativeInvoiceAddressEmailID text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_audititems&rev=1786130656  pears.AuditItems Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Controls which items are included in auditing. Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_audittrail&rev=1786130656  pears.AuditTrail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains audit records inserted by system and by audit triggers. Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchdivisionconfig&rev=1786130656  pears.AutoMatchDivisionConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchglobalconfig&rev=1786130656  pears.AutoMatchGlobalConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchnewtempweightingconfig&rev=1786130656  pears.AutoMatchNewTempWeightingConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchnotificationqueue&rev=1786130656  pears.AutoMatchNotificationQueue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatcholdtempweightingconfig&rev=1786130656  pears.AutoMatchOldTempWeightingConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchpersonconfig&rev=1786130656  pears.AutoMatchPersonConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchpersonpreferredshifttype&rev=1786130656  pears.AutoMatchPersonPreferredShiftType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Preferred shift template group Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_automatchshiftqueue&rev=1786130656  pears.AutoMatchShiftQueue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by Auto-matching procedures Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_availabilitytemplate&rev=1786130656  pears.AvailabilityTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined availability patterns. Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrcompany&rev=1786130656  pears.AWRcompany Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description AWR settings for Company records. One-to-one relationship with Company table. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrjobmaster&rev=1786130656  pears.AWRJobMaster Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Person records with Vacancies for AWR purposes. Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrvacancy&rev=1786130656  pears.AWRvacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description AWR settings for Vacancy records. One-to-one relationship with Vacancy table. Overrides AWRCompany. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrweekfind&rev=1786130656  pears.AWRWeekFind Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table. Used during calculation of AWR qualifying periods. Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrweeklydetail&rev=1786130656  pears.AWRWeeklyDetail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records indicate qualifying / pausing activity etc in given week for AWRJobMaster records. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_awrweeklyqualified&rev=1786130656  pears.AWRWeeklyQualified Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment AWRWeeklyQualifiedID text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_bankmodulus&rev=1786130656  pears.BankModulus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains list of valid sortcode ranges and which modulus check applies. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_bankmodulusvalidsortcodes&rev=1786130656  pears.BankModulusValidSortcodes Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of sort codes to be excluded from modulus checking. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_banknamesortcode&rev=1786130656  pears.BanknameSortcode Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SortCode char(8) NOT NULL BankName text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_batchtransfers&rev=1786130656  pears.BatchTransfers Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records of transfer jobs etc. Maintained by the individual processes. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_blobstore&rev=1786130656  pears.blobstore Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description OLE objects and other blob data eg pictures. If external Blob Store is in use the records are links to the relevant files. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_blobstoredeletequeue&rev=1786130656  pears.BlobStoreDeleteQueue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description External Blob files awaiting deletion Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_boilerplate&rev=1786130656  pears.BoilerPlate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains standard text which can be dropped into various types of note field. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_boilerplatedivision&rev=1786130656  pears.BoilerPlatedivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links BoilerPlate records with Divsions. Boiler Plates with no records are available to all. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_borough&rev=1786130656  pears.Borough Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment BoroughID char(20) NOT NULL Name char(30) text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeancandidate&rev=1786130656  pears.BroadbeanCandidate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean Candidate Columns Column Type Null Default Comment BroadbeanCandidateid text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanchannels&rev=1786130656  pears.BroadbeanChannels Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean Channels Columns Column Type Null Default Comment BroadbeanChannelid text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanhybridlocation&rev=1786130656  pears.BroadbeanHybridLocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean Locations - Standard Broadbean List Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanindustry&rev=1786130656  pears.BroadbeanIndustry Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean industries- Standard Broadbean List Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanjobboard&rev=1786130656  pears.BroadbeanJobBoard Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Old non-Hybrid tables. Contents not to be touched. Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanjobboardallocation&rev=1786130656  pears.BroadbeanJobBoardAllocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to staff records agains BB job board Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanlocation&rev=1786130656  pears.BroadbeanLocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Old non-Hybrid tables. Contents not to be touched. Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanrejectionreason&rev=1786130656  pears.BroadbeanRejectionReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of reasons candidates not imported from BB Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanuser&rev=1786130656  pears.BroadbeanUser Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean user login details Columns Column Type Null Default Comment text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_broadbeanvacancy&rev=1786130656  pears.BroadbeanVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to vacancy - which vacancy posted to BB Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreadercard&rev=1786130656  pears.CardReaderCard Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Current state (in or out) for each swipe card or equivalent. Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreaderimport&rev=1786130656  pears.CardReaderImport Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Import table for Time & Attendance data (eg card swipes etc). Columns Column text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreaderlog&rev=1786130656  pears.CardReaderLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description History of card swipes / activity / adjustments. Used for reporting. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreaderoverridesettings&rev=1786130656  pears.CardReaderOverrideSettings Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Company level override of Time & Attendance settings. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreadersettings&rev=1786130656  pears.CardReaderSettings Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Configuration for each individual Time & Attendance site / system. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cardreadershift&rev=1786130656  pears.CardReaderShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Shifts assembled from Time & Attendance data. Columns Column Type Null text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cascadedeliveryaddress&rev=1786130656  pears.CascadeDeliveryAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Seconday Agency delivery addresses and methods Columns Column Type text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cascadedshift&rev=1786130656  pears.CascadedShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of when and to whom Shifts have been cascaded. Including errors. Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cascadedvacancy&rev=1786130656  pears.CascadedVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of when and to whom Vacancies have been cascaded. Including errors. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cascaderule&rev=1786130656  pears.CascadeRule Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Settings determining when Shifts and Vacancies are cascaded to Secondary Agencies. text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_chat&rev=1786130656  pears.Chat Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of internal iqx chat messages Columns Column Type Null Default Comment ChatID text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_chatinvite&rev=1786130656  pears.ChatInvite Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to chatmessage Columns Column Type Null Default Comment ChatID char(20) text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_chatmessage&rev=1786130656  pears.ChatMessage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to staff Columns Column Type Null Default Comment ChatID char(20) text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cis07template&rev=1786130656  pears.CIS07Template Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Construction Industry Scheme Templates - post 2007 legislation change Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ciscard&rev=1786130656  pears.CISCard Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Construction Industry Scheme Contractor details Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cistemplate&rev=1786130656  pears.CISTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Pre 2007 legislation change - Construction Industry Scheme Templates Columns text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_collection&rev=1786130656  pears.Collection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links individual objects within a Collection. Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_collectionchat&rev=1786130656  pears.CollectionChat Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CollectionChatID char(20) NOT NULL text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_collectionchatread&rev=1786130656  pears.CollectionChatRead Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CollectionID char(20) NOT NULL text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_collectiontype&rev=1786130656  pears.CollectionType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined list of Collection types. Columns Column Type Null Default text/html 2026-08-07T19:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_collectionusers&rev=1786130656  pears.CollectionUsers Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CollectionUserID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_company&rev=1786130658  pears.Company Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Base Company / Client Record Columns Column Type Null Default Comment companyid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companyaccount&rev=1786130658  pears.CompanyAccount Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Holds details of Client Account - only exists for companies with allocated account code. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companydeptdoctype&rev=1786130658  pears.CompanyDeptDocType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to set standard Document Types to attach when sending CVs. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companykeywords&rev=1786130658  pears.CompanyKeyWords Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CompanyID char(20) NOT NULL RefreshRequired text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companysalesstatus&rev=1786130658  pears.CompanySalesStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Look-up of sales statuses for Company Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companysds&rev=1786130658  pears.CompanySDS Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CompanySDSID char(20) NOT NULL CompanyID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_companystatus&rev=1786130658  pears.CompanyStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Look-up of company statuses (both inbuilt and user defined) Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancedocumenttype&rev=1786130658  pears.ComplianceDocumentType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ComplianceDomainID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancedomain&rev=1786130658  pears.ComplianceDomain Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Compliance template for scoring a candidate Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancedomaintag&rev=1786130658  pears.ComplianceDomainTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Tags used in Compliance Domains Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancelinkeddomain&rev=1786130658  pears.ComplianceLinkedDomain Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Linkage between Domains so several can apply Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancepersondomain&rev=1786130658  pears.CompliancePersonDomain Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Linkage between Domains so several can apply Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancepersonstatus&rev=1786130658  pears.CompliancePersonStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compliancereferencetype&rev=1786130658  pears.ComplianceReferenceType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ComplianceDomainID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_complianceviewdata&rev=1786130658  pears.ComplianceViewData Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - Used to construct the Person compliance view. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_complianceviewhtml&rev=1786130658  pears.ComplianceViewHTML Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - Used to construct the Person compliance HTML view. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_composite&rev=1786130658  pears.Composite Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Composite Payroll Companies. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_compositetmp&rev=1786130658  pears.CompositeTmp Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - used by interface when working with Composite Payroll Companies. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_configlog&rev=1786130658  pears.ConfigLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Manually recorded changes to configuration. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_consentpersonoption&rev=1786130658  pears.ConsentPersonOption Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Consent (GDPR) settings per Person Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_consentpersonoptionhistory&rev=1786130658  pears.ConsentPersonOptionHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description History of changes to person consent (GDPR etc) settings Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_consenttype&rev=1786130658  pears.ConsentType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Master records for different types of Consent (GDPR) Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_consenttypeoption&rev=1786130658  pears.ConsentTypeOption Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Options for each Consent Type (GDPR) Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contactclass&rev=1786130658  pears.contactclass Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Types of Contact Event. Columns Column Type Null Default Comment classcode text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contactdepartment&rev=1786130658  pears.ContactDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Departments offered for Client Contacts (NOT linked to IQX Department records) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contactevent&rev=1786130658  pears.contactevent Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of Contacts with candidate & client contacts. Optional links to vacancies - progress etc etc. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contacteventemaillog&rev=1786130658  pears.ContactEventEmailLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records when contact events are sent Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contacteventspeciality&rev=1786130658  pears.ContactEventSpeciality Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Divisions (?) Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contactoutcome&rev=1786130658  pears.contactoutcome Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Possible Contact Event Outcomes and associated default call back days. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_contclasspersondivfilter&rev=1786130658  pears.ContClassPersonDivFilter Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Specifies which classes of contactevent should cause person.filteredlastcontactevent to be updated by division (?) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_country&rev=1786130658  pears.Country Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Countries used to speed address entry Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_county&rev=1786130658  pears.County Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CountyID char(20) NOT NULL Name char(30) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_criterion&rev=1786130658  pears.criterion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Individual instances of search criteria that make up Candidate & Vacancy Requirements. Stored Searches etc. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_criterionsqlfragment&rev=1786130658  pears.criterionSQLFragment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores sql of requirements so it can be used in jobs Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_customwpfields&rev=1786130658  pears.CustomWPFields Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains definitions of additional merge fields for Word. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_customwpfieldslink&rev=1786130658  pears.CustomWPFieldsLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment CustomWPFieldsLinkID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_cvsendextradocument&rev=1786130658  pears.CVSendExtraDocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For adding extra documents when sending cv's. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_dashboarddisplayedobject&rev=1786130658  pears.DashboardDisplayedObject Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Objects which actually appear on individuals IQXWeb dashboard Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_dashboardobject&rev=1786130658  pears.DashboardObject Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Objects which may appear on IQXWeb dashboard Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_databaseloginattempts&rev=1786130658  pears.DatabaseLoginAttempts Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details user login attempts Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_databaseupdatelog&rev=1786130658  pears.DatabaseUpdateLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Log of when an automated database update has been run & by whom. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_datamanagementlog&rev=1786130658  pears.DataManagementLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description GDPR - Records which records have been anonomised for GDPR - and what actions happened. Data cannot be recovered from here. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_dateformat&rev=1786130658  pears.DateFormat Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment pk integer NOT NULL fmt varchar(30) NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_daxtraparams&rev=1786130658  pears.DAXTRAParams Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used for Daxtra Document Imports. Populated from Daxtra Web Service. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_debtortext&rev=1786130658  pears.DebtorText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains text of different stages of severity of Debt Chasing letters. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedcriterion&rev=1786130658  pears.DeletedCriterion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted Criterion data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deleteddepartmenttag&rev=1786130658  pears.DeletedDepartmentTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deleteddocumenttag&rev=1786130658  pears.DeletedDocumentTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletediqxnettaggroupmember&rev=1786130658  pears.DeletedIQXNetTagGroupMember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedreferencemasterquestion&rev=1786130658  pears.DeletedReferenceMasterQuestion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedtag&rev=1786130658  pears.DeletedTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedtagchoice&rev=1786130658  pears.DeletedTagChoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment DeletedID integer NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedtagcompliance&rev=1786130658  pears.DeletedTagCompliance Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deletedtagvalue&rev=1786130658  pears.DeletedTagValue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_department&rev=1786130658  pears.Department Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Department base records. Columns Column Type Null Default Comment departmentid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_departmenttag&rev=1786130658  pears.DepartmentTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Allows non department candidate date questions to be departmentalised. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_deptmaintenance&rev=1786130658  pears.deptmaintenance Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records which staff members have manintenace rights in which department. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_diary&rev=1786130658  pears.diary Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Appointment diary records. Columns Column Type Null Default Comment diaryid char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_diaryextraday&rev=1786130658  pears.diaryextraday Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Global Temp Table used in rendering diary displays. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_diarytasklist&rev=1786130658  pears.DiaryTaskList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Task list tasks. Columns Column Type Null Default Comment DiaryTaskListID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_dictionary&rev=1786130658  pears.dictionary Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_division&rev=1786130658  pears.Division Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Divisions in the organisation. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_divisionaccess&rev=1786130658  pears.DivisionAccess Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Staff records to Divisions. Staff with no records have access to all Divisions. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_divisionsallowed&rev=1786130658  pears.DivisionsAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - contains the Divisions that the current user is entitled to access. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_dllrequired&rev=1786130658  pears.DLLRequired Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment DLLRequiredID char(20) NOT NULL DLLName text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_docpackfilelist&rev=1786130658  pears.DocPackFileList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description TempTable - used to assemble files to be inserted into a document pack. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_docpackperson&rev=1786130658  pears.DocPackPerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - used in asembling document packs. Linking a person to a pack. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_docpackvalidation&rev=1786130658  pears.DocPackValidation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in conjunction with DocumentPackAllowed(). Rows inserted by exe and checked by the (user defined function) which needs to clean up table as required. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentpack&rev=1786130658  pears.DocumentPack Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Master records for the defined Document Packs. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentpackdepartment&rev=1786130658  pears.DocumentPackDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Document Packs to Departments. Packs with no record are available for all Departments. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentpackreport&rev=1786130658  pears.DocumentPackReport Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment DocumentPackReportID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentpacktype&rev=1786130658  pears.DocumentPackType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lists types of Document available in a given pack by default. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentstamp&rev=1786130658  pears.DocumentStamp Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stamp Images that are available to be applied to documents when redacting. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documentstampdepartment&rev=1786130658  pears.DocumentStampDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Stamp Images to Departments. Images with no record are available for all Departments. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documenttag&rev=1786130658  pears.DocumentTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Questions (ie TagIDs) associated with a Document Type for Compliance Documents text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documenttype&rev=1786130658  pears.DocumentType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Classification of Documents (including definition of Compliance & Non-Compliance Documents). text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_documenttypedepartment&rev=1786130658  pears.DocumentTypeDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Document Types to Departments. Types with no record are available for all Departments. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_duplicatecheck&rev=1786130658  pears.DuplicateCheck Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment DuplicateCheckID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_duplicatecheckresult&rev=1786130658  pears.DuplicateCheckResult Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment DuplicateCheckResultID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ebpayband&rev=1786130658  pears.EBPayBand Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense Benefit payband Columns Column Type Null Default Comment EBPayBandID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ebtimesheet&rev=1786130658  pears.EBTimeSheet Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense Benefit timesheet Columns Column Type Null Default Comment EBTimeSheetID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ebtimesheetline&rev=1786130658  pears.EBTimeSheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense Benefit timesheet line Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailsignature&rev=1786130658  pears.EmailSignature Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Table holding definitions and rules for e-mail signatures. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailstaffnotification&rev=1786130658  pears.EmailStaffNotification Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Email addresses to be used where an individual is not suitable. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailstaffnotificationaddress&rev=1786130658  pears.EmailStaffNotificationAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used for more than a single instance of the above. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailtosend&rev=1786130658  pears.EmailToSend Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment EmailToSendID char(20) NOT NULL EmailType text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailtosendattachment&rev=1786130658  pears.EmailToSendAttachment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment EmailToSendAttachmentID bigint NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_emailtosendcontactevent&rev=1786130658  pears.EmailToSendContactEvent Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment EmailToSendContactEventID bigint text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_employment&rev=1786130658  pears.employment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between Person and Company defining employment. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_etip&rev=1786130658  pears.ETip Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Shift Import from Email Columns Column Type Null Default Comment EtipID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_etiplog&rev=1786130658  pears.ETipLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Shift Import from Email (log) Columns Column Type Null Default Comment LogID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_etipregex&rev=1786130658  pears.ETipRegEx Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Regular expressions for shift import Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitchoice&rev=1786130658  pears.ExpenseBenefitChoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lookup of choices for Expense Benefit Scheme Items Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitoptout&rev=1786130658  pears.ExpenseBenefitOptOut Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lookup of user defined reasons for Candidates opting out of Expenese Benefit - links to Pay_Employment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitplacementitem&rev=1786130658  pears.ExpenseBenefitPlacementItem Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense Benefit values for individual Placements Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitscheme&rev=1786130658  pears.ExpenseBenefitScheme Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header records for Expense Benefit Schemes Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitschemeitem&rev=1786130658  pears.ExpenseBenefitSchemeItem Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Detail records for Expense Benefit Schemes Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefitshiftitem&rev=1786130658  pears.ExpenseBenefitShiftItem Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Expense Benefit values for individual Shifts Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_expensebenefittype&rev=1786130658  pears.ExpenseBenefitType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Definitions of types of Expense Benefit available with behaviour settings text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_exportoptions&rev=1786130658  pears.ExportOptions Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores filesname and paths for payroll and invoice exports Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_externalcredential&rev=1786130658  pears.ExternalCredential Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ExternalCredentialID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_externalemployment&rev=1786130658  pears.externalemployment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Employment for temps when the company doesn't exist in IQX. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_extphone&rev=1786130658  pears.ExtPhone Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description non standard Columns Column Type Null Default Comment phoneid char(20) NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_favourites&rev=1786130658  pears.Favourites Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of favourite records - links to company - person…. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_fuzeerrors&rev=1786130658  pears.FuzeErrors Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment FuzeErrorsID bigint NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_fuzeusers&rev=1786130658  pears.FuzeUsers Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffID char(20) NOT NULL SubscriptionID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_globaldocument&rev=1786130658  pears.globaldocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of standard documents for IQXWeb - contracts - terms of engagement - etc. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_globaldocumentlink&rev=1786130658  pears.GlobalDocumentLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment GlobalDocumentLinkID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_holidaypayyear&rev=1786130658  pears.HolidayPayYear Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in Configuring the Holiday Pay System. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_htmlimage&rev=1786130658  pears.HTMLImage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to contactevent - 1 record per image. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_imagestamping&rev=1786130658  pears.ImageStamping Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ImageType char(4) NOT NULL TS for timesheet, may be extended later text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_interpersonlink&rev=1786130658  pears.InterPersonLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Defines links between people - used for NOK etc. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_invoicemanagementgroup&rev=1786130658  pears.InvoiceManagementGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Groups that control the processing of invoices. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_invoicevalidreportdata&rev=1786130658  pears.InvoiceValidReportData Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in validation of invoices. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacaccount&rev=1786130658  pears.IQacAccount Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of ledger against account names Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacaccountsettings&rev=1786130658  pears.IQacAccountSettings Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Configuration for an iQac account. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacallocation&rev=1786130658  pears.IQacAllocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Allocates payments against invoices in cash accounting. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqaccountry&rev=1786130658  pears.IQacCountry Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Countries used in sales ledger. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqaccurrency&rev=1786130658  pears.IQacCurrency Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Currencies used in sales ledger. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacdocument&rev=1786130658  pears.IQacDocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Invoices and other financial documents. Links to company/placement or timesheet (xref) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacdocumenttemplate&rev=1786130658  pears.IQacDocumentTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Templates for Financial Documents. By the default the system uses two templates with IDs 'SalesInvoice' and 'Receipt' and Class 'Invoice' and 'Payment' respectively. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacjournal&rev=1786130658  pears.IQacJournal Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Invoice journal lines - links to timesheetlines Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacledger&rev=1786130658  pears.IQacLedger Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Ledger type cash/sales Columns Column Type Null Default Comment LedgerID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacnominal&rev=1786130658  pears.IQacNominal Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Nominal Code definitions and behaviour settings Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacparams&rev=1786130658  pears.IQacParams Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Default invoice settings Columns Column Type Null Default Comment DBID char(2) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacpaymentmethod&rev=1786130658  pears.IQacPaymentMethod Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Cash, BACS etc Columns Column Type Null Default Comment PaymentMethodCode text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacshift&rev=1786130658  pears.IQAcShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment IQAcShiftID char(20) NOT NULL DocumentID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacvatrate&rev=1786130658  pears.IQacVATRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description VAT rates Columns Column Type Null Default Comment VATCode char(3) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqacyear&rev=1786130658  pears.IQacYear Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment YearID char(12) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqbackuplog&rev=1786130658  pears.iqbackuplog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Results of database event backups. Redundant if IQXHub Backup used. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxaccountsstatistics&rev=1786130658  pears.IQXAccountsStatistics Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Incomplete attempt at speeding up margin reporting. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxhubbackup&rev=1786130658  pears.IQXHubBackup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Results of IQXHub Backup events Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxhubmonitor&rev=1786130658  pears.IQXHubMonitor Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description details of hub activity version run time etc. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxjobrunnerlog&rev=1786130658  pears.IQXJobRunnerLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Log of sucessful and failed runs by the Scheduler Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxjobrunnerschedule&rev=1786130658  pears.IQXJobRunnerSchedule Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of individual Jobs and their scheduled run times within a Schedule Group text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxjobrunnerschedulegroup&rev=1786130658  pears.IQXJobRunnerScheduleGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header records for Schedule Groups including last polled time Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetaction&rev=1786130658  pears.IQXNetAction Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to determine IQXWeb actions (EG: web refrencing uses this table to know when to send out emails/faxs for timesheet approvals) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetauditlog&rev=1786130658  pears.IQXNetAuditLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Audit log for actions in IQXWeb Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetbehaviour&rev=1786130658  pears.IQXNetBehaviour Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores global configuration settings that control iqxWEB behaviour. An iqxWEB behaviour is a single configurable rule keyed by text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetbehaviouroverride&rev=1786130658  pears.IQXNetBehaviourOverride Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores per-division, per-user-class, or per-user overrides for “ text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetbulletin&rev=1786130658  pears.IQXNetBulletin Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Bulletin/announcement messages shown to candidates or clients in iqxWEB. Bulletins can be time-limited via an expiry date, targeted to candidates, clients, or both, and scoped to specific divisions via text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetbulletindivision&rev=1786130658  pears.IQXNetBulletinDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Junction table that restricts a bulletin to specific divisions. If no rows exist for a bulletin it is shown across all divisions. Multiple rows can be inserted to target several divisions simultaneously. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetcandidateshifts&rev=1786130658  pears.IQXNetCandidateShifts Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Populated by the “PopulateCandidateShifts” process — stores which text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetdbversion&rev=1786130658  pears.IQXNetDBVersion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Tracks the current schema version of the iqxWEB database. Used to determine whether a migration or setup procedure needs to run and to guard against applying the same update twice. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetemaildetails&rev=1786130658  pears.IQXNetEmailDetails Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description This is the Maintaince > IQXWeb Settings > Email Details information Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnethostaddress&rev=1786130658  pears.IQXNetHostAddress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores the registered network addresses for each iqxWEB service component. Each row maps a named service to its host address, allowing the system to resolve the correct endpoint for inter-service communication without hardcoding addresses. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetlanguage&rev=1786130658  pears.IQXNetLanguage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores the default terminology and label definitions used throughout iqxWEB. Each entry represents a single UI string identified by a structured key in the pattern text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetlanguageoverride&rev=1786130658  pears.IQXNetLanguageOverride Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Allows agencies to override the default terminology defined in “IQXNetLanguage text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetmessagecompanyrecipient&rev=1786130658  pears.IQXNetMessageCompanyRecipient Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contact who receives a particular type of message from IQXWeb text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetmessagerecipient&rev=1786130658  pears.IQXNetMessageRecipient Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Staff member who receives a particular type of message from IQXWeb - Payroll - Timesheet etc. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetnotificationcascade&rev=1786130658  pears.IQXNetNotificationCascade Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description If original staff member does not respond who should the message cascade to text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetpagetext&rev=1786130658  pears.IQXNetPageText Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to store the pagetext and their values Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetpasskeys&rev=1786130658  pears.IQXNetPasskeys Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores WebAuthn/FIDO2 passkey credentials registered by users for passwordless authentication. Each row represents a single authenticator device linked to a user. The text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetpasswordchangerequest&rev=1786130658  pears.IQXNetPasswordChangeRequest Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Tracks password reset requests initiated via the forgotten password flow. When a user requests a reset a token is generated, BASE64-encoded, stored here, and emailed to them. On redemption the token is matched against this table and text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetreport&rev=1786130658  pears.IQXNetReport Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to store each report and the permissions for each web report Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetright&rev=1786130658  pears.IQXNetRight Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains all the IQXWeb rights for all user classes Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetrightallowed&rev=1786130658  pears.IQXNetRightAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains the allowed rights for each user class Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetrightassigned&rev=1786130658  pears.IQXNetRightAssigned Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains the assigned rights for each user class Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetrightdefault&rev=1786130658  pears.IQXNetRightDefault Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains which rights the user class has assigned by default Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetsettings&rev=1786130658  pears.IQXNetSettings Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetswitch&rev=1786130658  pears.IQXNetSwitch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains a list of switches for IQXWeb as well as the values Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnettaggroup&rev=1786130658  pears.IQXNetTagGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Questionaire Groups for IQXWeb Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnettaggroupmember&rev=1786130658  pears.IQXNetTagGroupMember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description The Questions that go into the above groups Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetuser&rev=1786130658  pears.IQXNetUser Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains each IQXWeb user Columns Column Type Null Default Comment IQXNetUserID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetuserclass&rev=1786130658  pears.IQXNetUserClass Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains a list of the user classes for IQXWeb Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetuserlink&rev=1786130658  pears.IQXNetUserLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links the IQXNetUser table to the person/staff table Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetwebsettings&rev=1786130658  pears.IQXNetWebSettings Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores per-user web preferences and security settings. One row per user, created on first use. Controls whether MFA is active for the user, whether it must be re-challenged on token refresh, and whether to use Gravatar for their avatar. The text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetwizardstate&rev=1786130658  pears.IQXNetWizardState Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Tracks where a candidate is in the registration wizard so they can resume mid-flow (e.g. after email validation). A row is created when a candidate begins registration and deleted once registration completes ( text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxnetyoti&rev=1786130658  pears.IQXNetYoti Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment IQXNetYotiID char(20) NOT NULL URLRequestCode text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxssoaccount&rev=1786130658  pears.IQXSSOAccount Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SSOID char(100) NOT NULL Unique SSO identity identifier text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_iqxwebrequestlog&rev=1786130658  pears.IQXWebRequestLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment RequestTime timestamp NULL current timestamp text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ixsresult&rev=1786130658  pears.IXSResult Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used for temporarily storing Index Server search results. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ixssearchdefinition&rev=1786130658  pears.IXSSearchDefinition Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Definitions of the types of text searches available using Index Server. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ixsstatus&rev=1786130658  pears.IXSStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Status of current searches. Columns Column Type Null Default Comment IXSQueryID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_kmlbuffer&rev=1786130658  pears.KMLBuffer Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID char(20) NOT NULL WhenEntered timestamp text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_leaveclasses&rev=1786130658  pears.LeaveClasses Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains list of types of leave (eg paid holiday - maternity leave etc) recorded in WeEmployLeave table. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_localwebpage&rev=1786130658  pears.LocalWebPage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID char(20) NOT NULL PageText long varchar text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_localwebpagedivision&rev=1786130658  pears.LocalWebPageDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment id char(20) NOT NULL divisionid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mailerselection&rev=1786130658  pears.mailerselection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Mailchimp 'LISTS' Columns Column Type Null Default Comment MailerSelectionID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mailerselectionmember&rev=1786130658  pears.mailerselectionmember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Candidate/client contacts on mailchimp list. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mailmerge&rev=1786130658  pears.mailmerge Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Pointers to OLE documents in Blobstore (class M) which are individual users own Word mail merge templates. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mailserver&rev=1786130658  pears.MailServer Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Mail Server configuration Columns Column Type Null Default Comment MailServerID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterroster&rev=1786130658  pears.MasterRoster Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header records for each Master Roster Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrosterchangelog&rev=1786130658  pears.MasterRosterChangeLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of changes to a Master Roster. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrosterchangereason&rev=1786130658  pears.MasterRosterChangeReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Look-up of allowed change reasons for Master Rosters. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrosterfaillog&rev=1786130658  pears.MasterRosterFailLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records of failure to create or fill shifts from a Master Roster. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrosterpreferredperson&rev=1786130658  pears.MasterRosterPreferredPerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Preferred candidates (with rank) for each Master Roster. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrostershift&rev=1786130658  pears.MasterRosterShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Detail records for Master Rosters Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_masterrostershiftinstance&rev=1786130658  pears.MasterRosterShiftInstance Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Shifts instantiated by the Master Roster. The delete restrict foreign key blocks deletion of MasterRosterShifts once instantiated text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mimemessage&rev=1786130658  pears.MIMEMessage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in constructing MIME email message. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mrshiftid2s&rev=1786130658  pears.MRShiftID2s Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - Used by Master Roster Process Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_mrshiftids&rev=1786130658  pears.MRShiftIDs Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - Used by Master Roster Process Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_nominalsegment&rev=1786130658  pears.NominalSegment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Nominal Code segments used to build up the nominal code attached to placement income. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_nominalsegmentdivision&rev=1786130658  pears.NominalSegmentDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NominalSegmentID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationbatch&rev=1786130658  pears.NotificationBatch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID bigint NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationdeeplink&rev=1786130658  pears.NotificationDeepLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NotificationDeepLinkID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationdepartment&rev=1786130658  pears.NotificationDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NotificationDepartmentID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationdocuments&rev=1786130658  pears.NotificationDocuments Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NotificationDocumentsID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationrates&rev=1786130658  pears.NotificationRates Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID bigint NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationreports&rev=1786130658  pears.NotificationReports Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NotificationReportsID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_notificationtemplate&rev=1786130658  pears.NotificationTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description SMS/Email templates for shift notification etc Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_offlimits&rev=1786130658  pears.OffLimits Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Limits on approaching Companies or People during specfied period. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_oledocument&rev=1786130658  pears.oledocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Pointers to documents belonging to People & Companies. Stored in the Blobstore (Class O) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_origin&rev=1786130658  pears.Origin Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Sources of different object types - Candidate - Client - Vacancy Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_origindivision&rev=1786130658  pears.OriginDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Determines avalibility of origin types for different Divisions Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_outlookemail&rev=1786130658  pears.OutlookEmail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment OutlookEmailEmailID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_params&rev=1786130658  pears.params Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description System parameters. Only one record in table. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pay_employee&rev=1786130658  pears.Pay_Employee Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Data related to a persons employment by the agency. One to one relationship with Person. Only created when required. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pay_employment&rev=1786130658  pears.Pay_Employment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains records of periods of employment of temps by the Agency (operating the Pears system) itself. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_payrollcalendar&rev=1786130658  pears.PayrollCalendar Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PayrollCalendarID integer NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_payrollcalendarweek&rev=1786130658  pears.PayrollCalendarWeek Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PayrollCalendarWeekID integer NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_payrollcompany&rev=1786130658  pears.PayrollCompany Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Payroll Companies defined. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_payrolldocument&rev=1786130658  pears.PayrollDocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to payroll PDF documents in the blobstore (class P) Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_payrollyear&rev=1786130658  pears.PayrollYear Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of the start and number of weeks in each payroll year. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pdfextradocument&rev=1786130658  pears.PDFExtraDocument Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Additional Documents for scanned timesheets Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_peaksearchresult&rev=1786130658  pears.PeakSearchResult Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PeakSearchResultID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_person&rev=1786130658  pears.Person Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Main Person records (includes Comapny Contacts). Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personincompatibility&rev=1786130658  pears.PersonIncompatibility Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records incompatabilities between individual providors and recipients. Healthcare (esp Home Care) usage. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personinterest&rev=1786130658  pears.PersonInterest Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between Person and Staff Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personkeywords&rev=1786130658  pears.PersonKeyWords Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonID char(20) NOT NULL RefreshRequired text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personshiftpreference&rev=1786130658  pears.PersonShiftPreference Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonShiftPreferenceID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personstafflink&rev=1786130658  pears.PersonStaffLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonStaffLinkID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personstafflinktype&rev=1786130658  pears.PersonStaffLinkType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonStaffLinkTypeID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personstafflinktypedivision&rev=1786130658  pears.PersonStaffLinkTypeDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonStaffLinkTypeDivisionID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personstatusdivision&rev=1786130658  pears.PersonStatusDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PersonStatusDivisionID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personwillingness&rev=1786130658  pears.PersonWillingness Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Peak Integration - how willing is someone to work. Generated by 3rd party and sent to IQX text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_personwillingnesshistory&rev=1786130658  pears.PersonWillingnessHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Peak Integration - how willing is someone to work. Generated by 3rd party and sent to IQX text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_phone&rev=1786130658  pears.phone Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Telephone - fax - email etc Columns Column Type Null Default Comment phoneid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_phonetype&rev=1786130658  pears.phonetype Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Type & capability definitions for telephone - fax - email etc Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placement&rev=1786130658  pears.Placement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header record for placements. Columns Column Type Null Default Comment placementid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementanalysis&rev=1786130658  pears.PlacementAnalysis Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Analysis of placement by nominal code Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementattribution&rev=1786130658  pears.placementattribution Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment placementattributionid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementdayvariation&rev=1786130658  pears.PlacementDayVariation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For Contract work hour variations Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementelement&rev=1786130658  pears.PlacementElement Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Instances of Placement Element Types for individual placements. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementelementtype&rev=1786130658  pears.PlacementElementType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stages in the calculation of fees and other headings for optional data collected at placement time. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementextension&rev=1786130658  pears.PlacementExtension Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PlacementExtensionID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementextensionreason&rev=1786130658  pears.PlacementExtensionReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PlacementExtensionReasonID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementlink&rev=1786130658  pears.PlacementLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PlacementLinkID char(20) NOT NULL PlacementID1 text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementremuneration&rev=1786130658  pears.placementremuneration Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment placementremunerationid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementrole&rev=1786130658  pears.PlacementRole Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Capacities in which Staff records are related to a Placement Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_placementtransfer&rev=1786130658  pears.PlacementTransfer Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment PlacementID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_places&rev=1786130658  pears.places Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Place - region and country names. Used for address tidying. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_popupescalation&rev=1786130658  pears.PopupEscalation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Staff records so that pop-ups can be escalated if Staff members not available. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_postcodeareacountries&rev=1786130658  pears.PostcodeAreaCountries Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Outward part of postcode to a county and country/region fro reporting use text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_postcodelocation&rev=1786130658  pears.PostCodeLocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PostCodeLocationID bigint NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_progress&rev=1786130658  pears.progress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Progress state of candidates under consideration / placed / rejected in vacancies. Links candidates to vacancies. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_progresshistory&rev=1786130658  pears.ProgressHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description History of progress items with dates that the progres state changed. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_progressstatusdivision&rev=1786130658  pears.ProgressStatusDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ProgressStatusDivisionID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pshealthperson&rev=1786130658  pears.psHealthPerson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links to PSHealth (now Mobisio) worker records Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pshealthshift&rev=1786130658  pears.psHealthShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment psHealthShiftID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pshealthvacancy&rev=1786130658  pears.psHealthVacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link to psHealth Case records Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pushnotificationdevice&rev=1786130658  pears.PushNotificationDevice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Test table for push notification devices Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_pushnotificationtemplate&rev=1786130658  pears.PushNotificationTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PushNotificationTemplateID char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_recentobjects&rev=1786130658  pears.RecentObjects Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of user viewing of different database objects. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_referencemaster&rev=1786130658  pears.ReferenceMaster Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Template for online referencing. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_referencemasterquestion&rev=1786130658  pears.ReferenceMasterQuestion Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Which questions to include in the reference request Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_referencerequest&rev=1786130658  pears.ReferenceRequest Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Individual Reference Request records Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_rejectionreason&rev=1786130658  pears.rejectionreason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Optional rejection reasons offered when a candidate is rejected. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_remuneration&rev=1786130658  pears.remuneration Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description REDUNDANT Columns Column Type Null Default Comment name char(25) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_report&rev=1786130658  pears.report Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Report & job templates registered with the system. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_reportdepartment&rev=1786130658  pears.ReportDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ReportDepartmentid char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_reportdivision&rev=1786130658  pears.ReportDivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Reports to Divisions Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_reporttype&rev=1786130658  pears.ReportType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ReportTypeID char(50) NOT NULL Notes char(100) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_rstempjobratemaster&rev=1786130658  pears.RSTempJobRateMaster Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TempJobRateMasterID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_sageline50defaults&rev=1786130658  pears.SageLine50Defaults Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Defaults for exports to sage Line50 Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_salesbrand&rev=1786130658  pears.SalesBrand Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SalesBrandID char(20) NOT NULL DivisionID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_search&rev=1786130658  pears.search Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of Candidates registration for Temp or Perm work with departments. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_secondaryagencycandidatestatus&rev=1786130658  pears.SecondaryAgencyCandidateStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Another status which only applies to secondary agency candidates. Used with state change validation. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_securedocumentlink&rev=1786130658  pears.SecureDocumentLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SecureDocumentLinkID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_segmenttarget&rev=1786130658  pears.SegmentTarget Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For reporting on consultant performance using placement nominal code segments against the segment targets. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_selfbillinvoicesforpdf&rev=1786130658  pears.SelfBillInvoicesforPDF Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in Self Billing process Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_semaphore&rev=1786130658  pears.Semaphore Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to police a locked section of code by using the db transaction mechanism. E.g. to make sure only one user is batch creating timesheets at a time. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_sentcvs&rev=1786130658  pears.SentCVs Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records of which candidates CVs were attached to particular contact events. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_shifttemplategroup&rev=1786130658  pears.ShiftTemplateGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For grouping shift templates Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_smsincomingnumber&rev=1786130658  pears.SMSIncomingNumber Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SMSIncomingNumberID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_smsworksconfig&rev=1786130658  pears.SMSWorksConfig Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SMSWorksConfigID bigint NOT NULL autoincrement text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_socialcarecontacttypes&rev=1786130658  pears.socialcarecontacttypes Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Social care. What types the contacts are i.e doctor neighbour - relative etc. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staff&rev=1786130658  pears.staff Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User records. Columns Column Type Null Default Comment staffid char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffexttempdeskaccess&rev=1786130658  pears.StaffExtTempdeskAccess Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used to grant rights to specific tempdesks for users with restricted rights text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffhistory&rev=1786130658  pears.StaffHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffHistoryID char(20) NOT NULL PersonID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffnote&rev=1786130658  pears.StaffNote Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffNoteID char(20) NOT NULL DivisionID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffnoteread&rev=1786130658  pears.StaffNoteRead Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffNoteReadID char(20) NOT NULL StaffNoteID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffpassword&rev=1786130658  pears.staffpassword Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used for controlling Staff password re-use. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffsynety&rev=1786130658  pears.StaffSynety Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Integration with Synety phone system. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffteam&rev=1786130658  pears.StaffTeam Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffTeamID char(20) NOT NULL Description text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staffteammember&rev=1786130658  pears.StaffTeamMember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffTeamMemberID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_stagedpayments&rev=1786130658  pears.StagedPayments Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For dealing with staggered payments for perms. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_standardwpfields&rev=1786130658  pears.StandardWPFields Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment FieldName char(30) NOT NULL No spaces or punctuation text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staticdatalog&rev=1786130658  pears.StaticDataLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment WhenLogged timestamp NOT NULL current timestamp text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_staticdataversions&rev=1786130658  pears.StaticDataVersions Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID char(20) NOT NULL Version integer text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_status&rev=1786130658  pears.status Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Multi-purpose table holding Person, Vacancy and Progress states. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_statushistory&rev=1786130658  pears.StatusHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StatusHistoryID char(20) NOT NULL PersonID text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_statustag&rev=1786130658  pears.StatusTag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StatusTagID char(20) NOT NULL TagID char(3) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_storedquicklookup&rev=1786130658  pears.StoredQuickLookup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores saved searches so that they can be accessed quicker via UI. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_storedsearch&rev=1786130658  pears.storedsearch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stored search headers. Individual criteria that constitute the search are stored in Criteria - with the appropiate location. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_storedselection&rev=1786130658  pears.storedselection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stored selection headers. Individual records that constitute the selection are in StoredSelectionMember. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_storedselectionmember&rev=1786130658  pears.storedselectionmember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between Stored Selection and Person, Company, Vacancy, Placement records text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_storedselectionstaff&rev=1786130658  pears.storedselectionstaff Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment storedselectionid char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_studentvacation&rev=1786130658  pears.StudentVacation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains the start and end dates of standard student vacations. Used when matching candidates with vacation availability / unavailability. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_subsidytype&rev=1786130658  pears.SubsidyType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment SubsidyTypeID char(2) NOT NULL Description text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tag&rev=1786130658  pears.tag Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined field definitions (Questionnaires) Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tagchoice&rev=1786130658  pears.tagchoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Choices for picklist responses to User Defined fields Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tagcompliance&rev=1786130658  pears.TagCompliance Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used for tag with expiry dates - set sms/email messages Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tagpersonexpirystatus&rev=1786130658  pears.TagPersonExpiryStatus Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment taglocation char(3) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tagvalue&rev=1786130658  pears.tagvalue Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Values for user defined fields Columns Column Type Null Default Comment taglocation text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempaccordnirecharge&rev=1786130658  pears.TempAccordNIReCharge Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in Invoice (switch dependent) to groups accord requests per document text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempaccordnirechargeline&rev=1786130658  pears.TempAccordNIReChargeLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in Invoice (switch dependent) to groups accord requests per document text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempaidcompany&rev=1786130658  pears.tempaidcompany Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Next time sheet number for each TempAid payroll company. Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempcustomjobrate&rev=1786130658  pears.TempCustomJobRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in Estimating shifts revenue Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempdesk&rev=1786130658  pears.tempdesk Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Desk settings. Columns Column Type Null Default Comment tempdeskid char(20) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempdeskaccess&rev=1786130658  pears.TempdeskAccess Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment tempdeskid char(20) NOT NULL staffid text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempdeskagencypoolmember&rev=1786130658  pears.TempDeskAgencyPoolMember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Way of linking companies or secondary agency companies with desks. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempdeskallowed&rev=1786130658  pears.TempdeskAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TempdeskID char(20) NOT NULL Primary Key text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempholiday&rev=1786130658  pears.TempHoliday Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description A way of recording branch holidays - not used Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempholidayscheme&rev=1786130658  pears.TempHolidayScheme Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Records making up the TempHolidayPayScheme. Each entry represents a line in the display calculation. Used in conjunction with the dedicated function - TempHolidayCalc() text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempinbox&rev=1786130658  pears.TempInbox Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment messageID char(200) NULL FromName char(100) text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempjobrate&rev=1786130658  pears.TempJobRate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains the pay & charge rates for individual vacancies and placements. This is the source of the rates used when a timesheet is created. First any rates for the Placement itself are looked for. If not found then the Vacancy is checked. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempjobratemaster&rev=1786130658  pears.TempJobRateMaster Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Detail line records with rates for each band for Temp Rate Schemes. Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempjobtype&rev=1786130658  pears.TempJobType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header records for Temp Rate Schemes. Detail lines for each constituent band are in TempJobRateMaster. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_templategrouptemplate&rev=1786130658  pears.TemplateGroupTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in master roster and vacancy limits Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_templatestore&rev=1786130658  pears.templatestore Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Word document template details. Actual templates are in the BlobStore with Class 'T'. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_templatestoredivision&rev=1786130658  pears.templatestoredivision Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Allows template store to be limited by division Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_templatestorestaff&rev=1786130658  pears.templatestorestaff Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description This table stores favourite templates that appear at top of lists Columns text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempmatchcandidate&rev=1786130658  pears.TempMatchCandidate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in skill / availability matching Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempmatchplan&rev=1786130658  pears.TempMatchPlan Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in skill / availability matching Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempmatchplancandidate&rev=1786130658  pears.TempMatchPlanCandidate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in skill / availability matching Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempmatchshift&rev=1786130658  pears.TempMatchShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table used in skill / availability matching Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temppayband&rev=1786130658  pears.TempPayBand Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of the available pay bands. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temppoolmember&rev=1786130658  pears.TempPoolMember Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between candidates and TempDesks. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temppricelist&rev=1786130658  pears.TempPriceList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Headers for available Price Lists. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempprovtimesheet&rev=1786130658  pears.TempProvTimeSheet Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Headers for provisional timesheets. Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempprovtimesheethistory&rev=1786130658  pears.TempProvTimeSheetHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description History for provisional timesheets. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempprovtimesheetline&rev=1786130658  pears.TempProvTimeSheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Detail lines for Provisional timesheets. Columns Column Type Null text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempprovtimesheetshift&rev=1786130658  pears.TempProvTimeSheetShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Shift records to a Provisional Timesheet Columns Column Type text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempratemarginaudit&rev=1786130658  pears.TempRateMarginAudit Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TempRateMarginAuditID char(20) NOT NULL text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempratescript&rev=1786130658  pears.TempRateScript Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Contains the code of each Rate Script - used to process shifts into rates. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempscriptgenrates&rev=1786130658  pears.TempScriptGenRates Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used during the processing of Rates Columns Column Type Null Default text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempsecagencyvacratescheme&rev=1786130658  pears.TempSecAgencyVacRateScheme Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Seceondary Agency Rate Schemes to Vacancies. Columns Column text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshift&rev=1786130658  pears.TempShift Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Individual shift details - once booked / worked / billed / paid etc. Also availability. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftadd&rev=1786130658  pears.TempShiftAdd Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description When shifts are added they are temporary placed here and then when they are finished they are moved back. text/html 2026-08-07T19:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftcancelreason&rev=1786130658  pears.TempShiftCancelReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined shift cancellation reason with settings for action required. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftcancelreasondept&rev=1786130660  pears.TempShiftCancelReasonDept Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TempShiftCancelReasonDeptid char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftinvoice&rev=1786130660  pears.TempShiftInvoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TempShiftInvoiceID char(20) NOT NULL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftorderreason&rev=1786130660  pears.TempShiftOrderReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined reasons for why shift is requested. Columns Column Type text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftorderreasondepartment&rev=1786130660  pears.TempShiftOrderReasonDepartment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between Departments and Shift Order Reasons. Reasons with no record are availabe to all Departments. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftplan&rev=1786130660  pears.TempShiftPlan Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Shift requirements. Linked to TempShift when booked / worked / billed / paid etc. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftplanauthorise&rev=1786130660  pears.TempShiftPlanAuthorise Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of (customer) authorisation of individual TempShiftPlan records. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftprogress&rev=1786130660  pears.TempShiftProgress Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Progress of candidates put forward for TempShiftPlan. Columns Column Type text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftprogresshistory&rev=1786130660  pears.TempShiftProgressHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description History of Progress of candidates put forward for TempShiftPlan. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshifttemplate&rev=1786130660  pears.TempShiftTemplate Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Definitions of Shift Templates - allowing quick creation of shifts with all necessary timing - grade - skill etc information. Templates remain linked to the created shift. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshifttemplateallowed&rev=1786130660  pears.TempShiftTemplateAllowed Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Controls whether a particular Shift Template is allowed for an individual Vacancy. If no record for a given Vacancy all Shift Templates for the vacancy Department are allowed. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshifttype&rev=1786130660  pears.TempShiftType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of defined shift types. Used in descriptions and rate processing. Columns text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempshiftunavailablereason&rev=1786130660  pears.TempShiftUnavailableReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description User defined list of reasons why candidate is unavailable for a shift. Also link to resultant AWR implication. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tempsubsidy&rev=1786130660  pears.TempSubsidy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Details of subsidies (advances) paid to temps. Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temptimesheet&rev=1786130660  pears.TempTimeSheet Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Timesheet headers. Columns Column Type Null Default Comment TempTimeSheetID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temptimesheetcancellation&rev=1786130660  pears.TempTimeSheetCancellation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_temptimesheetline&rev=1786130660  pears.TempTimeSheetLine Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Time sheet detail lines. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_terminology&rev=1786130660  pears.terminology Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description non standard Columns Column Type Null Default Comment terminologyid char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_timesheetapprovallink&rev=1786130660  pears.TimesheetApprovalLink Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TimesheetApprovalLinkID char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_timesheetcancelreason&rev=1786130660  pears.TimesheetCancelReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lookup of user defined reasons why Timesheet cancelled Columns Column text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_timesheetsignature&rev=1786130660  pears.TimesheetSignature Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TimesheetSignatureID char(20) NOT NULL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_timesheetunlinkedimage&rev=1786130660  pears.TimesheetUnlinkedImage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TimesheetUnlinkedImageID char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tmp_blob_import&rev=1786130660  pears.tmp_blob_import Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment FileName char(100) NOT NULL BlobClass text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tmpnewemployment&rev=1786130660  pears.TmpNewEmployment Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment NewEmploymentid char(20) NOT NULL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_town&rev=1786130660  pears.Town Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description List of Towns used to speed address entry Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_trengo&rev=1786130660  pears.Trengo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TrengoID integer NOT NULL Description char(100) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_trengomessage&rev=1786130660  pears.TrengoMessage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TrengoMessageID char(20) NOT NULL Ticket text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_trengoparameters&rev=1786130660  pears.TrengoParameters Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TrengoID integer NOT NULL ParameterNo text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_trengosent&rev=1786130660  pears.TrengoSent Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment TrengoSentID char(20) NOT NULL TrengoID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_trengoticket&rev=1786130660  pears.TrengoTicket Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ID char(20) NOT NULL Primary Key * text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tsimage&rev=1786130660  pears.TSImage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in the processing of Timesheet Images Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tsinbox&rev=1786130660  pears.TSInbox Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used in the processing of Timesheet Images Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tsqueryhistory&rev=1786130660  pears.TSQueryHistory Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Record of changes to Timesheet Queries Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tsquerylog&rev=1786130660  pears.TSQueryLog Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Timesheet Queries - current state of each Query (log is an inaccurate description) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_tsqueryreasons&rev=1786130660  pears.TSQueryReasons Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lookup of Timesheet Query Reasons Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ttbroadbean&rev=1786130660  pears.TTBroadbean Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_ttbroadbeanboardstopostto&rev=1786130660  pears.TTBroadbeanBoardsToPostTo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_unsubscribetomarketing&rev=1786130660  pears.UnsubscribeToMarketing Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Emails to send to mailchimp to unsubscribe Columns Column Type Null text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_utrcheck&rev=1786130660  pears.UTRCheck Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment UTRcheckID char(20) NOT NULL UTR char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancy_team&rev=1786130660  pears.vacancy_team Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Allows additional Staff records to be linked to Vacancy records Columns Column text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancy&rev=1786130660  pears.vacancy Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Header record for Vacancies. Columns Column Type Null Default Comment vacancyid text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyclass&rev=1786130660  pears.vacancyclass Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Erroneous table name. Should be Source. Superceded by origin Columns Column text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancycopyshortlist&rev=1786130660  pears.VacancyCopyShortList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Used when copying Vacancy short lists Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancycopyshortlisttemp&rev=1786130660  pears.VacancyCopyShortListTemp Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment StaffID char(20) NOT NULL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyetip&rev=1786130660  pears.VacancyEtip Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link to ETip Vacancies / shifts Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancykeywords&rev=1786130660  pears.VacancyKeyWords Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment VacancyID char(20) NOT NULL RefreshRequired text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancylimit&rev=1786130660  pears.VacancyLimit Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Spending Limits for Vacancies Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyoverrideratescheme&rev=1786130660  pears.VacancyOverrideRateScheme Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyposition&rev=1786130660  pears.VacancyPosition Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Frequently used position names - job titles. Columns Column Type Null text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyrole&rev=1786130660  pears.VacancyRole Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Capacities in which Staff records are related to a Vacancy (eg HR Manager etc) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancyroleallocation&rev=1786130660  pears.VacancyRoleAllocation Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link table between VacancyRole - Vacancies and Staff Columns Column text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_vacancysearchtemp&rev=1786130660  pears.VacancySearchTemp Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment PK integer NOT NULL autoincrement text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_withholdreason&rev=1786130660  pears.WithHoldReason Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment ReasonID char(20) NOT NULL Description text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_withholds&rev=1786130660  pears.WithHolds Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Stores witholds. When a worker is blocked from a vacancy or a company Columns text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkassignedrole&rev=1786130660  pears.WPKAssignedRole Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Link between Staff and WPKRoles. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkchangetracker&rev=1786130660  pears.WPKChangeTracker Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Gives last ClickCount for each WPKChangeTrackerID - used for detecting need to refresh WPK elements. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkcustomgridcolumn&rev=1786130660  pears.WPKCustomGridColumn Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Custom Column Definitions Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkcustomgridcolumnnamedselection&rev=1786130660  pears.WPKCustomGridColumnNamedSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Custom Column Definitions Columns Column Type text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkcustomgridcolumnprivateselection&rev=1786130660  pears.WPKCustomGridColumnPrivateSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Custom Column Definitions Columns Column text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkform&rev=1786130660  pears.WPKForm Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Form definitions. Columns Column Type Null Default Comment WPKFormID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkglobalswitch&rev=1786130660  pears.WPKGlobalSwitch Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Switch definitions. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkglobalswitchaltgroup&rev=1786130660  pears.WPKGlobalSwitchAltGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment WPKGlobalSwitchAltGroupID char(20) text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkglobalswitchgroup&rev=1786130660  pears.WPKGlobalSwitchGroup Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Groups of Woodpecker Switches. Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkglobalswitchsetting&rev=1786130660  pears.WPKGlobalSwitchSetting Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Individual values set for Woodpecker Switches. Columns Column Type text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkimage&rev=1786130660  pears.WPKImage Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Images (eg icons) Used by Woodpecker Forms. Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpklayout&rev=1786130660  pears.WPKLayout Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Layout definitions. Columns Column Type Null Default Comment WPKLayoutID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpklayoutview&rev=1786130660  pears.WPKLayoutView Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Links Woodpecker Views to Layouts. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpklayoutviewstaff&rev=1786130660  pears.WPKLayoutViewStaff Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment WPKLayoutID char(20) NOT NULL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpklookuptype&rev=1786130660  pears.WPKLookupType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Lookups for WPK types eg ViewItemType etc Columns Column Type Null Default text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkmultiselection&rev=1786130660  pears.WPKMultiSelection Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Temp Table - used to list records selected on a Woodpecker grid. Columns text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkpicklist&rev=1786130660  pears.WPKPickList Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice. text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkpicklistchoice&rev=1786130660  pears.WPKPickListChoice Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Choices for WPKPickList when not defined in SQL. Columns Column Type text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkrole&rev=1786130660  pears.WPKRole Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker Role definitions. Columns Column Type Null Default Comment WPKRoleID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkview&rev=1786130660  pears.WPKView Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker View definitions. Columns Column Type Null Default Comment WPKViewID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkviewcanselect&rev=1786130660  pears.WPKViewCanSelect Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Columns Column Type Null Default Comment WPKFormID char(20) NOT NULL WPKLayoutID text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:pears_wpkviewitem&rev=1786130660  pears.WPKViewItem Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Woodpecker View Item definitions. Columns Column Type Null Default Comment text/html 2026-08-07T19:24:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:tables:start&rev=1786130664  Tables Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * A * B * C * D * E * F * G * H * I * K * L * M * N * O * P * R * S * T * U * V *