Tables: I

pears.ImageStamping

pears.InterPersonLink - Defines links between people - used for NOK etc.

pears.InvoiceManagementGroup - Groups that control the processing of invoices.

pears.InvoiceValidReportData - Used in validation of invoices.

pears.IQacAccount - List of ledger against account names

pears.IQacAccountSettings - Configuration for an iQac account.

pears.IQacAllocation - Allocates payments against invoices in cash accounting.

pears.IQacCountry - Countries used in sales ledger.

pears.IQacCurrency - Currencies used in sales ledger.

pears.IQacDocument - Invoices and other financial documents. Links to company/placement or timesheet (xref)

pears.IQacDocumentTemplate - Templates for Financial Documents. By the default the system uses two templates with IDs 'SalesInvoice' and 'Receipt' and Class 'Invoice' and 'Payment' respectively.

pears.IQacJournal - Invoice journal lines - links to timesheetlines

pears.IQacLedger - Ledger type cash/sales

pears.IQacNominal - Nominal Code definitions and behaviour settings

pears.IQacParams - Default invoice settings

pears.IQacPaymentMethod - Cash, BACS etc

pears.IQAcShift

pears.IQacVATRate - VAT rates

pears.IQacYear - REDUNDANT

pears.iqbackuplog - Results of database event backups. Redundant if IQXHub Backup used.

pears.IQXAccountsStatistics - Incomplete attempt at speeding up margin reporting.

pears.IQXHubBackup - Results of IQXHub Backup events

pears.IQXHubMonitor - details of hub activity version run time etc.

pears.IQXJobRunnerLog - Log of sucessful and failed runs by the Scheduler

pears.IQXJobRunnerSchedule - Details of individual Jobs and their scheduled run times within a Schedule Group

pears.IQXJobRunnerScheduleGroup - Header records for Schedule Groups including last polled time

pears.IQXNetAction - Used to determine IQXWeb actions (EG: web refrencing uses this table to know when to send out emails/faxs for timesheet approvals)

pears.IQXNetAuditLog - Audit log for actions in IQXWeb

pears.IQXNetBehaviour - Stores global configuration settings that control iqxWEB behaviour. An iqxWEB behaviour is a single configurable rule keyed by “IQXNetBehaviourID” that governs a specific operation (for example: turning a feature on/off, setting thresholds or limits, or choosing string-based UI/flow options). Each rule has a strict type (“DataType”: Boolean/Number/String), a documented purpose (“Description”), and a default system value (“Value”) that can be selectively overridden at division, user-class, or individual-user level.

pears.IQXNetBehaviourOverride - Stores per-division, per-user-class, or per-user overrides for “IQXNetBehaviour” defaults. When the system resolves a behaviour value it checks this table first, falling back to the base “IQXNetBehaviour.Value” if no matching override is found. Any combination of “DivisionID”, “IQXNetUserClassID”, and “IQXNetUserID” can be supplied; omitting a field means the override applies more broadly.

pears.IQXNetBulletin - 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 “IQXNetBulletinDivision”. If no division rows exist for a bulletin it is shown to all divisions. Archived bulletins are hidden without being deleted.

pears.IQXNetBulletinDivision - 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.

pears.IQXNetCandidateShifts - Populated by the “PopulateCandidateShifts” process — stores which “TempShiftPlan” shifts are available and eligible for each candidate to book. Acts as a security gate: a candidate cannot book a shift unless a matching row exists in this table. The populate process applies filtering rules (availability, grade, requirements etc.) defined in “IQXNetBehaviour” before inserting rows.

pears.IQXNetDBVersion - 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.

pears.IQXNetEmailDetails - This is the Maintaince > IQXWeb Settings > Email Details information

pears.IQXNetHostAddress - 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.

pears.IQXNetLanguage - 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 “v2-{userclass}-{component}-{key}” (e.g. “v2-cand-registration-firstname”). These defaults can be selectively overridden per division or user class via “IQXNetLanguageOverride” without modifying the base record.

pears.IQXNetLanguageOverride - Allows agencies to override the default terminology defined in “IQXNetLanguage” on a per-division and/or per-user-class basis. When the system resolves a label it checks this table first, using the most specific match available, before falling back to the “IQXNetLanguage.DefaultValue”. Omitting “DivisionID” or “IQXNetUserClassID” makes the override apply more broadly.

pears.IQXNetMessageCompanyRecipient - Contact who receives a particular type of message from IQXWeb

pears.IQXNetMessageRecipient - Staff member who receives a particular type of message from IQXWeb - Payroll - Timesheet etc.

pears.IQXNetNotificationCascade - If original staff member does not respond who should the message cascade to

pears.IQXNetPageText - Used to store the pagetext and their values

pears.IQXNetPasskeys - Stores WebAuthn/FIDO2 passkey credentials registered by users for passwordless authentication. Each row represents a single authenticator device linked to a user. The “Counter” is incremented on every authentication assertion and checked server-side to prevent replay attacks. “BackedUp” indicates whether the credential is a synced/multi-device passkey (eligible for cloud backup) as opposed to a hardware-bound single-device key.

pears.IQXNetPasswordChangeRequest - 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 “Sent” is checked to confirm the email was dispatched before allowing the password change.

pears.IQXNetReport - Used to store each report and the permissions for each web report

pears.IQXNetRight - Contains all the IQXWeb rights for all user classes

pears.IQXNetRightAllowed - Contains the allowed rights for each user class

pears.IQXNetRightAssigned - Contains the assigned rights for each user class

pears.IQXNetRightDefault - Contains which rights the user class has assigned by default

pears.IQXNetSettings - Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures)

pears.IQXNetSwitch - Contains a list of switches for IQXWeb as well as the values

pears.IQXNetTagGroup - Questionaire Groups for IQXWeb

pears.IQXNetTagGroupMember - The Questions that go into the above groups

pears.IQXNetUser - Contains each IQXWeb user

pears.IQXNetUserClass - Contains a list of the user classes for IQXWeb

pears.IQXNetUserLink - Links the IQXNetUser table to the person/staff table

pears.IQXNetWebSettings - 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 “MFASecret” is a TOTP base32 seed set during MFA enrolment and must be kept confidential.

pears.IQXNetWizardState - 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 (“NetV2RegistrationComplete”). “WizardID” allows multiple distinct wizard variants (e.g. per division) to run independently; “DEFAULT” is used when no custom wizard is configured.

pears.IQXNetYoti

pears.IQXSSOAccount

pears.IQXWebRequestLog

pears.IXSResult - Used for temporarily storing Index Server search results.

pears.IXSSearchDefinition - Definitions of the types of text searches available using Index Server.

pears.IXSStatus - Status of current searches.