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).
- pears.CardReaderLog - History of card swipes / activity / adjustments. Used for reporting.
- pears.CardReaderOverrideSettings - Company level override of Time & Attendance settings.
- pears.CardReaderSettings - Configuration for each individual Time & Attendance site / system.
- pears.CardReaderShift - Shifts assembled from Time & Attendance data.
- pears.CascadeDeliveryAddress - Seconday Agency delivery addresses and methods
- pears.CascadedShift - Details of when and to whom Shifts have been cascaded. Including errors.
- pears.CascadedVacancy - Details of when and to whom Vacancies have been cascaded. Including errors.
- pears.CascadeRule - Settings determining when Shifts and Vacancies are cascaded to Secondary Agencies.
- pears.Chat - List of internal iqx chat messages
- pears.ChatInvite - Links to chatmessage
- pears.ChatMessage - Links to staff
- pears.CIS07Template - Construction Industry Scheme Templates - post 2007 legislation change
- pears.CISCard - Construction Industry Scheme Contractor details
- pears.CISTemplate - Pre 2007 legislation change - Construction Industry Scheme Templates
- pears.Collection - Links individual objects within a Collection.
- pears.CollectionType - User defined list of Collection types.
- pears.Company - Base Company / Client Record
- pears.CompanyAccount - Holds details of Client Account - only exists for companies with allocated account code.
- pears.CompanyDeptDocType - Used to set standard Document Types to attach when sending CVs.
- pears.CompanySalesStatus - Look-up of sales statuses for Company
- pears.CompanyStatus - Look-up of company statuses (both inbuilt and user defined)
- pears.ComplianceDomain - Compliance template for scoring a candidate
- pears.ComplianceDomainTag - Tags used in Compliance Domains
- pears.ComplianceLinkedDomain - Linkage between Domains so several can apply
- pears.CompliancePersonDomain - Linkage between Domains so several can apply
- pears.ComplianceViewData - Temp Table - Used to construct the Person compliance view.
- pears.ComplianceViewHTML - Temp Table - Used to construct the Person compliance HTML view.
- pears.Composite - List of Composite Payroll Companies.
- pears.CompositeTmp - Temp Table - used by interface when working with Composite Payroll Companies.
- pears.ConfigLog - Manually recorded changes to configuration.
- pears.ConsentPersonOption - Consent (GDPR) settings per Person
- pears.ConsentPersonOptionHistory - History of changes to person consent (GDPR etc) settings
- pears.ConsentType - Master records for different types of Consent (GDPR)
- pears.ConsentTypeOption - Options for each Consent Type (GDPR)
- pears.contactclass - Types of Contact Event.
- pears.ContactDepartment - List of Departments offered for Client Contacts (NOT linked to IQX Department records)
- pears.contactevent - Details of Contacts with candidate & client contacts. Optional links to vacancies - progress etc etc.
- pears.ContactEventEmailLog - Records when contact events are sent
- pears.ContactEventSpeciality - List of Divisions (?)
- pears.contactoutcome - Possible Contact Event Outcomes and associated default call back days.
- pears.ContClassPersonDivFilter - Specifies which classes of contactevent should cause person.filteredlastcontactevent to be updated by division (?)
- pears.Country - List of Countries used to speed address entry
- pears.criterion - Individual instances of search criteria that make up Candidate & Vacancy Requirements. Stored Searches etc.
- pears.criterionSQLFragment - Stores sql of requirements so it can be used in jobs
- pears.CustomWPFields - Contains definitions of additional merge fields for Word.
- pears.CVSendExtraDocument - For adding extra documents when sending cv's.
127.0.0.1