Tables: S

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

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