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.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.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.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.staffpassword - Used for controlling Staff password re-use.
- pears.StaffSynety - Integration with Synety phone system.
- pears.StagedPayments - For dealing with staggered payments for perms.
- pears.status - Multi-purpose table holding Person, Vacancy and Progress states.
- 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.StudentVacation - Contains the start and end dates of standard student vacations. Used when matching candidates with vacation availability / unavailability.
127.0.0.1