Tables: S [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: S ======
<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_sageline50defaults|pears.SageLine50Defaults]] - Defaults for exports to sage Line50
  * [[database:tables:pears_salesbrand|pears.SalesBrand]]
  * [[database:tables:pears_search|pears.search]] - Details of Candidates registration for Temp or Perm work with departments.
  * [[database:tables:pears_secondaryagencycandidatestatus|pears.SecondaryAgencyCandidateStatus]] - Another status which only applies to secondary agency candidates.  Used with state change validation.
  * [[database:tables:pears_securedocumentlink|pears.SecureDocumentLink]]
  * [[database:tables:pears_segmenttarget|pears.SegmentTarget]] - For reporting on consultant performance using placement nominal code segments against the segment targets.
  * [[database:tables:pears_selfbillinvoicesforpdf|pears.SelfBillInvoicesforPDF]] - Temporary table used in Self Billing process
  * [[database:tables:pears_semaphore|pears.Semaphore]] - 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.
  * [[database:tables:pears_sentcvs|pears.SentCVs]] - Records of which candidates CVs were attached to particular contact events.
  * [[database:tables:pears_shifttemplategroup|pears.ShiftTemplateGroup]] - For grouping shift templates
  * [[database:tables:pears_smsincomingnumber|pears.SMSIncomingNumber]]
  * [[database:tables:pears_smsworksconfig|pears.SMSWorksConfig]]
  * [[database:tables:pears_socialcarecontacttypes|pears.socialcarecontacttypes]] - Social care.  What types the contacts are i.e doctor neighbour - relative etc.
  * [[database:tables:pears_staff|pears.staff]] - User records.
  * [[database:tables:pears_staffexttempdeskaccess|pears.StaffExtTempdeskAccess]] - Used to grant rights to specific tempdesks for users with restricted rights
  * [[database:tables:pears_staffhistory|pears.StaffHistory]]
  * [[database:tables:pears_staffnote|pears.StaffNote]]
  * [[database:tables:pears_staffnoteread|pears.StaffNoteRead]]
  * [[database:tables:pears_staffpassword|pears.staffpassword]] - Used for controlling Staff password re-use.
  * [[database:tables:pears_staffsynety|pears.StaffSynety]] - Integration with Synety phone system.
  * [[database:tables:pears_staffteam|pears.StaffTeam]]
  * [[database:tables:pears_staffteammember|pears.StaffTeamMember]]
  * [[database:tables:pears_stagedpayments|pears.StagedPayments]] - For dealing with staggered payments for perms.
  * [[database:tables:pears_standardwpfields|pears.StandardWPFields]]
  * [[database:tables:pears_staticdatalog|pears.StaticDataLog]]
  * [[database:tables:pears_staticdataversions|pears.StaticDataVersions]]
  * [[database:tables:pears_status|pears.status]] - Multi-purpose table holding Person, Vacancy and Progress states.
  * [[database:tables:pears_statushistory|pears.StatusHistory]]
  * [[database:tables:pears_statustag|pears.StatusTag]]
  * [[database:tables:pears_storedquicklookup|pears.StoredQuickLookup]] - Stores saved searches so that they can be accessed quicker via UI.
  * [[database:tables:pears_storedsearch|pears.storedsearch]] - Stored search headers. Individual criteria that constitute the search are stored in Criteria - with the appropiate location.
  * [[database:tables:pears_storedselection|pears.storedselection]] - Stored selection headers. Individual records that constitute the selection are in StoredSelectionMember.
  * [[database:tables:pears_storedselectionmember|pears.storedselectionmember]] - Link between Stored Selection and Person, Company, Vacancy, Placement records
  * [[database:tables:pears_storedselectionstaff|pears.storedselectionstaff]]
  * [[database:tables:pears_studentvacation|pears.StudentVacation]] - Contains the start and end dates of standard student vacations. Used when matching candidates with vacation availability / unavailability.
  * [[database:tables:pears_subsidytype|pears.SubsidyType]]