Tables: C [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: C ======
<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_cardreadercard|pears.CardReaderCard]] - Current state (in or out) for each swipe card or equivalent.
  * [[database:tables:pears_cardreaderimport|pears.CardReaderImport]] - Import table for Time & Attendance data (eg card swipes etc).
  * [[database:tables:pears_cardreaderlog|pears.CardReaderLog]] - History of card swipes / activity / adjustments. Used for reporting.
  * [[database:tables:pears_cardreaderoverridesettings|pears.CardReaderOverrideSettings]] - Company level override of Time & Attendance settings.
  * [[database:tables:pears_cardreadersettings|pears.CardReaderSettings]] - Configuration for each individual Time & Attendance site / system.
  * [[database:tables:pears_cardreadershift|pears.CardReaderShift]] - Shifts assembled from Time & Attendance data.
  * [[database:tables:pears_cascadedeliveryaddress|pears.CascadeDeliveryAddress]] - Seconday Agency delivery addresses and methods
  * [[database:tables:pears_cascadedshift|pears.CascadedShift]] - Details of when and to whom Shifts have been cascaded. Including errors.
  * [[database:tables:pears_cascadedvacancy|pears.CascadedVacancy]] - Details of when and to whom Vacancies have been cascaded.  Including errors.
  * [[database:tables:pears_cascaderule|pears.CascadeRule]] - Settings determining when Shifts and Vacancies are cascaded to Secondary Agencies.
  * [[database:tables:pears_chat|pears.Chat]] - List of internal iqx chat messages
  * [[database:tables:pears_chatinvite|pears.ChatInvite]] - Links to chatmessage
  * [[database:tables:pears_chatmessage|pears.ChatMessage]] - Links to staff
  * [[database:tables:pears_cis07template|pears.CIS07Template]] - Construction Industry Scheme Templates - post 2007 legislation change
  * [[database:tables:pears_ciscard|pears.CISCard]] - Construction Industry Scheme Contractor details
  * [[database:tables:pears_cistemplate|pears.CISTemplate]] - Pre 2007 legislation change - Construction Industry Scheme Templates  
  * [[database:tables:pears_collection|pears.Collection]] - Links individual objects within a Collection.
  * [[database:tables:pears_collectionchat|pears.CollectionChat]]
  * [[database:tables:pears_collectionchatread|pears.CollectionChatRead]]
  * [[database:tables:pears_collectiontype|pears.CollectionType]] - User defined list of Collection types.
  * [[database:tables:pears_collectionusers|pears.CollectionUsers]]
  * [[database:tables:pears_company|pears.Company]] - Base Company / Client Record
  * [[database:tables:pears_companyaccount|pears.CompanyAccount]] - Holds details of Client Account - only exists for companies with allocated account code.
  * [[database:tables:pears_companydeptdoctype|pears.CompanyDeptDocType]] - Used to set standard Document Types to attach when sending CVs.
  * [[database:tables:pears_companykeywords|pears.CompanyKeyWords]]
  * [[database:tables:pears_companysalesstatus|pears.CompanySalesStatus]] - Look-up of sales statuses for Company
  * [[database:tables:pears_companysds|pears.CompanySDS]]
  * [[database:tables:pears_companystatus|pears.CompanyStatus]] - Look-up of company statuses (both inbuilt and user defined)
  * [[database:tables:pears_compliancedocumenttype|pears.ComplianceDocumentType]]
  * [[database:tables:pears_compliancedomain|pears.ComplianceDomain]] - Compliance template for scoring a candidate
  * [[database:tables:pears_compliancedomaintag|pears.ComplianceDomainTag]] - Tags used in Compliance Domains
  * [[database:tables:pears_compliancelinkeddomain|pears.ComplianceLinkedDomain]] - Linkage between Domains so several can apply
  * [[database:tables:pears_compliancepersondomain|pears.CompliancePersonDomain]] - Linkage between Domains so several can apply
  * [[database:tables:pears_compliancepersonstatus|pears.CompliancePersonStatus]]
  * [[database:tables:pears_compliancereferencetype|pears.ComplianceReferenceType]]
  * [[database:tables:pears_complianceviewdata|pears.ComplianceViewData]] - Temp Table - Used to construct the Person compliance view.
  * [[database:tables:pears_complianceviewhtml|pears.ComplianceViewHTML]] - Temp Table - Used to construct the Person compliance HTML view.
  * [[database:tables:pears_composite|pears.Composite]] - List of Composite Payroll Companies.
  * [[database:tables:pears_compositetmp|pears.CompositeTmp]] - Temp Table - used by interface when working with Composite Payroll Companies.
  * [[database:tables:pears_configlog|pears.ConfigLog]] - Manually recorded changes to configuration.
  * [[database:tables:pears_consentpersonoption|pears.ConsentPersonOption]] - Consent (GDPR) settings per Person 
  * [[database:tables:pears_consentpersonoptionhistory|pears.ConsentPersonOptionHistory]] - History of changes to person consent (GDPR etc) settings 
  * [[database:tables:pears_consenttype|pears.ConsentType]] - Master records for different types of Consent (GDPR)
  * [[database:tables:pears_consenttypeoption|pears.ConsentTypeOption]] - Options for each Consent Type (GDPR)
  * [[database:tables:pears_contactclass|pears.contactclass]] - Types of Contact Event.
  * [[database:tables:pears_contactdepartment|pears.ContactDepartment]] - List of Departments offered for Client Contacts (NOT linked to IQX Department records)
  * [[database:tables:pears_contactevent|pears.contactevent]] - Details of Contacts with candidate & client contacts. Optional links to vacancies - progress etc etc.
  * [[database:tables:pears_contacteventemaillog|pears.ContactEventEmailLog]] - Records when contact events are sent
  * [[database:tables:pears_contacteventspeciality|pears.ContactEventSpeciality]] - List of Divisions (?)
  * [[database:tables:pears_contactoutcome|pears.contactoutcome]] - Possible Contact Event Outcomes and associated default call back days.
  * [[database:tables:pears_contclasspersondivfilter|pears.ContClassPersonDivFilter]] - Specifies which classes of contactevent should cause person.filteredlastcontactevent to be updated by division (?)
  * [[database:tables:pears_country|pears.Country]] - List of Countries used to speed address entry
  * [[database:tables:pears_county|pears.County]]
  * [[database:tables:pears_criterion|pears.criterion]] - Individual instances of search criteria that make up Candidate & Vacancy Requirements. Stored Searches etc.
  * [[database:tables:pears_criterionsqlfragment|pears.criterionSQLFragment]] - Stores sql of requirements so it can be used in jobs
  * [[database:tables:pears_customwpfields|pears.CustomWPFields]] - Contains definitions of additional merge fields for Word.
  * [[database:tables:pears_customwpfieldslink|pears.CustomWPFieldsLink]]
  * [[database:tables:pears_cvsendextradocument|pears.CVSendExtraDocument]] - For adding extra documents when sending cv's.