Tables: P
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.params - System parameters. Only one record in table.
- pears.Pay_Employee - Data related to a persons employment by the agency. One to one relationship with Person. Only created when required.
- pears.Pay_Employment - Contains records of periods of employment of temps by the Agency (operating the Pears system) itself.
- pears.PayrollCompany - List of Payroll Companies defined.
- pears.PayrollDocument - Links to payroll PDF documents in the blobstore (class P)
- pears.PayrollYear - Details of the start and number of weeks in each payroll year.
- pears.PDFExtraDocument - Additional Documents for scanned timesheets
- pears.Person - Main Person records (includes Comapny Contacts).
- pears.PersonIncompatibility - Records incompatabilities between individual providors and recipients. Healthcare (esp Home Care) usage.
- pears.PersonInterest - Link between Person and Staff
- pears.PersonWillingness - Peak Integration - how willing is someone to work. Generated by 3rd party and sent to IQX
- pears.PersonWillingnessHistory - Peak Integration - how willing is someone to work. Generated by 3rd party and sent to IQX
- pears.phone - Telephone - fax - email etc
- pears.phonetype - Type & capability definitions for telephone - fax - email etc
- pears.Placement - Header record for placements.
- pears.PlacementAnalysis - Analysis of placement by nominal code
- pears.placementattribution - REDUNDANT
- pears.PlacementDayVariation - For Contract work hour variations
- pears.PlacementElement - Instances of Placement Element Types for individual placements.
- pears.PlacementElementType - Stages in the calculation of fees and other headings for optional data collected at placement time.
- pears.placementremuneration - REDUNDANT
- pears.PlacementRole - Capacities in which Staff records are related to a Placement
- pears.PlacementTransfer - REDUNDANT
- pears.places - Place - region and country names. Used for address tidying.
- pears.PopupEscalation - Links Staff records so that pop-ups can be escalated if Staff members not available.
- pears.PostcodeAreaCountries - Links Outward part of postcode to a county and country/region fro reporting use
- pears.progress - Progress state of candidates under consideration / placed / rejected in vacancies. Links candidates to vacancies.
- pears.ProgressHistory - History of progress items with dates that the progres state changed.
- pears.psHealthPerson - Links to PSHealth (now Mobisio) worker records
- pears.psHealthShift - REDUNDANT
- pears.psHealthVacancy - Link to psHealth Case records
- pears.PushNotificationDevice - Test table for push notification devices
127.0.0.1