Tables: I [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Tables: I ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

  * [[database:tables:pears_imagestamping|pears.ImageStamping]]
  * [[database:tables:pears_interpersonlink|pears.InterPersonLink]] - Defines links between people - used for NOK etc.
  * [[database:tables:pears_invoicemanagementgroup|pears.InvoiceManagementGroup]] - Groups that control the processing of invoices.
  * [[database:tables:pears_invoicevalidreportdata|pears.InvoiceValidReportData]] - Used in validation of invoices.
  * [[database:tables:pears_iqacaccount|pears.IQacAccount]] - List of ledger against account names
  * [[database:tables:pears_iqacaccountsettings|pears.IQacAccountSettings]] - Configuration for an iQac account.
  * [[database:tables:pears_iqacallocation|pears.IQacAllocation]] - Allocates payments against invoices in cash accounting.
  * [[database:tables:pears_iqaccountry|pears.IQacCountry]] - Countries used in sales ledger.
  * [[database:tables:pears_iqaccurrency|pears.IQacCurrency]] - Currencies used in sales ledger.
  * [[database:tables:pears_iqacdocument|pears.IQacDocument]] - Invoices and other financial documents. Links to company/placement or timesheet (xref)
  * [[database:tables:pears_iqacdocumenttemplate|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.
  * [[database:tables:pears_iqacjournal|pears.IQacJournal]] - Invoice journal lines - links to timesheetlines
  * [[database:tables:pears_iqacledger|pears.IQacLedger]] - Ledger type cash/sales
  * [[database:tables:pears_iqacnominal|pears.IQacNominal]] - Nominal Code definitions and behaviour settings
  * [[database:tables:pears_iqacparams|pears.IQacParams]] - Default invoice settings
  * [[database:tables:pears_iqacpaymentmethod|pears.IQacPaymentMethod]] - Cash, BACS etc
  * [[database:tables:pears_iqacshift|pears.IQAcShift]]
  * [[database:tables:pears_iqacvatrate|pears.IQacVATRate]] - VAT rates
  * [[database:tables:pears_iqacyear|pears.IQacYear]] - REDUNDANT
  * [[database:tables:pears_iqbackuplog|pears.iqbackuplog]] - Results of database event backups.  Redundant if IQXHub Backup used.
  * [[database:tables:pears_iqxaccountsstatistics|pears.IQXAccountsStatistics]] - Incomplete attempt at speeding up margin reporting.
  * [[database:tables:pears_iqxhubbackup|pears.IQXHubBackup]] - Results of IQXHub Backup events
  * [[database:tables:pears_iqxhubmonitor|pears.IQXHubMonitor]] - details of hub activity version run time etc.
  * [[database:tables:pears_iqxjobrunnerlog|pears.IQXJobRunnerLog]] - Log of sucessful and failed runs by the Scheduler
  * [[database:tables:pears_iqxjobrunnerschedule|pears.IQXJobRunnerSchedule]] - Details of individual Jobs and their scheduled run times within a Schedule Group
  * [[database:tables:pears_iqxjobrunnerschedulegroup|pears.IQXJobRunnerScheduleGroup]] - Header records for Schedule Groups including last polled time
  * [[database:tables:pears_iqxnetaction|pears.IQXNetAction]] - Used to determine IQXWeb actions (EG: web refrencing uses this table to know when to send out emails/faxs for timesheet approvals)
  * [[database:tables:pears_iqxnetauditlog|pears.IQXNetAuditLog]] - Audit log for actions in IQXWeb
  * [[database:tables:pears_iqxnetbehaviour|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.
  * [[database:tables:pears_iqxnetbehaviouroverride|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.
  * [[database:tables:pears_iqxnetbulletin|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.
  * [[database:tables:pears_iqxnetbulletindivision|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.
  * [[database:tables:pears_iqxnetcandidateshifts|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.
  * [[database:tables:pears_iqxnetdbversion|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.
  * [[database:tables:pears_iqxnetemaildetails|pears.IQXNetEmailDetails]] - This is the Maintaince > IQXWeb Settings > Email Details information
  * [[database:tables:pears_iqxnethostaddress|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.
  * [[database:tables:pears_iqxnetlanguage|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.
  * [[database:tables:pears_iqxnetlanguageoverride|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.
  * [[database:tables:pears_iqxnetmessagecompanyrecipient|pears.IQXNetMessageCompanyRecipient]] - Contact who receives a particular type of message from IQXWeb
  * [[database:tables:pears_iqxnetmessagerecipient|pears.IQXNetMessageRecipient]] - Staff member who receives a particular type of message from IQXWeb - Payroll - Timesheet etc.
  * [[database:tables:pears_iqxnetnotificationcascade|pears.IQXNetNotificationCascade]] - If original staff member does not respond who should the message cascade to
  * [[database:tables:pears_iqxnetpagetext|pears.IQXNetPageText]] - Used to store the pagetext and their values
  * [[database:tables:pears_iqxnetpasskeys|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.
  * [[database:tables:pears_iqxnetpasswordchangerequest|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.
  * [[database:tables:pears_iqxnetreport|pears.IQXNetReport]] - Used to store each report and the permissions for each web report
  * [[database:tables:pears_iqxnetright|pears.IQXNetRight]] - Contains all the IQXWeb rights for all user classes
  * [[database:tables:pears_iqxnetrightallowed|pears.IQXNetRightAllowed]] - Contains the allowed rights for each user class
  * [[database:tables:pears_iqxnetrightassigned|pears.IQXNetRightAssigned]] - Contains the assigned rights for each user class
  * [[database:tables:pears_iqxnetrightdefault|pears.IQXNetRightDefault]] - Contains which rights the user class has assigned by default
  * [[database:tables:pears_iqxnetsettings|pears.IQXNetSettings]] - Contains some IQXHub settings that are required for IQXWeb to function - It also contains IQXWeb settings (EG: NonAuth Procedures)
  * [[database:tables:pears_iqxnetswitch|pears.IQXNetSwitch]] - Contains a list of switches for IQXWeb as well as the values
  * [[database:tables:pears_iqxnettaggroup|pears.IQXNetTagGroup]] - Questionaire Groups for IQXWeb
  * [[database:tables:pears_iqxnettaggroupmember|pears.IQXNetTagGroupMember]] - The Questions that go into the above groups
  * [[database:tables:pears_iqxnetuser|pears.IQXNetUser]] - Contains each IQXWeb user
  * [[database:tables:pears_iqxnetuserclass|pears.IQXNetUserClass]] - Contains a list of the user classes for IQXWeb
  * [[database:tables:pears_iqxnetuserlink|pears.IQXNetUserLink]] - Links the IQXNetUser table to the person/staff table
  * [[database:tables:pears_iqxnetwebsettings|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.
  * [[database:tables:pears_iqxnetwizardstate|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.
  * [[database:tables:pears_iqxnetyoti|pears.IQXNetYoti]]
  * [[database:tables:pears_iqxssoaccount|pears.IQXSSOAccount]]
  * [[database:tables:pears_iqxwebrequestlog|pears.IQXWebRequestLog]]
  * [[database:tables:pears_ixsresult|pears.IXSResult]] - Used for temporarily storing Index Server search results.
  * [[database:tables:pears_ixssearchdefinition|pears.IXSSearchDefinition]] - Definitions of the types of text searches available using Index Server.
  * [[database:tables:pears_ixsstatus|pears.IXSStatus]] - Status of current searches.