====== Tables: P ======
<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_params|pears.params]] - System parameters. Only one record in table.
  * [[database:tables:pears_pay_employee|pears.Pay_Employee]] - Data related to a persons employment by the agency. One to one relationship with Person. Only created when required.
  * [[database:tables:pears_pay_employment|pears.Pay_Employment]] - Contains records of periods of employment of temps by the Agency (operating the Pears system) itself.
  * [[database:tables:pears_payrollcalendar|pears.PayrollCalendar]]
  * [[database:tables:pears_payrollcalendarweek|pears.PayrollCalendarWeek]]
  * [[database:tables:pears_payrollcompany|pears.PayrollCompany]] - List of Payroll Companies defined.
  * [[database:tables:pears_payrolldocument|pears.PayrollDocument]] - Links to payroll PDF documents in the blobstore (class P)
  * [[database:tables:pears_payrollyear|pears.PayrollYear]] - Details of the start and number of weeks in each payroll year.
  * [[database:tables:pears_pdfextradocument|pears.PDFExtraDocument]] - Additional Documents for scanned timesheets
  * [[database:tables:pears_peaksearchresult|pears.PeakSearchResult]]
  * [[database:tables:pears_person|pears.Person]] - Main Person records (includes Comapny Contacts).
  * [[database:tables:pears_personincompatibility|pears.PersonIncompatibility]] - Records incompatabilities between individual providors and recipients. Healthcare (esp Home Care) usage.
  * [[database:tables:pears_personinterest|pears.PersonInterest]] - Link between Person and Staff
  * [[database:tables:pears_personkeywords|pears.PersonKeyWords]]
  * [[database:tables:pears_personshiftpreference|pears.PersonShiftPreference]]
  * [[database:tables:pears_personstafflink|pears.PersonStaffLink]]
  * [[database:tables:pears_personstafflinktype|pears.PersonStaffLinkType]]
  * [[database:tables:pears_personstafflinktypedivision|pears.PersonStaffLinkTypeDivision]]
  * [[database:tables:pears_personstatusdivision|pears.PersonStatusDivision]]
  * [[database:tables:pears_personwillingness|pears.PersonWillingness]] - Peak Integration - how willing is someone to work.  Generated by 3rd party and sent to IQX
  * [[database:tables:pears_personwillingnesshistory|pears.PersonWillingnessHistory]] - Peak Integration - how willing is someone to work.  Generated by 3rd party and sent to IQX
  * [[database:tables:pears_phone|pears.phone]] - Telephone - fax - email etc
  * [[database:tables:pears_phonetype|pears.phonetype]] - Type & capability definitions for telephone - fax - email etc
  * [[database:tables:pears_placement|pears.Placement]] - Header record for placements.
  * [[database:tables:pears_placementanalysis|pears.PlacementAnalysis]] - Analysis of placement by nominal code
  * [[database:tables:pears_placementattribution|pears.placementattribution]] - REDUNDANT
  * [[database:tables:pears_placementdayvariation|pears.PlacementDayVariation]] - For Contract work hour variations
  * [[database:tables:pears_placementelement|pears.PlacementElement]] - Instances of Placement Element Types for individual placements.
  * [[database:tables:pears_placementelementtype|pears.PlacementElementType]] - Stages in the calculation of fees and other headings for optional data collected at placement time.
  * [[database:tables:pears_placementextension|pears.PlacementExtension]]
  * [[database:tables:pears_placementextensionreason|pears.PlacementExtensionReason]]
  * [[database:tables:pears_placementlink|pears.PlacementLink]]
  * [[database:tables:pears_placementremuneration|pears.placementremuneration]] - REDUNDANT
  * [[database:tables:pears_placementrole|pears.PlacementRole]] - Capacities in which Staff records are related to a Placement
  * [[database:tables:pears_placementtransfer|pears.PlacementTransfer]] - REDUNDANT
  * [[database:tables:pears_places|pears.places]] - Place - region and country names.   Used for address tidying.
  * [[database:tables:pears_popupescalation|pears.PopupEscalation]] - Links Staff records so that pop-ups can be escalated if Staff members not available.
  * [[database:tables:pears_postcodeareacountries|pears.PostcodeAreaCountries]] - Links Outward part of postcode to a county and country/region fro reporting use
  * [[database:tables:pears_postcodelocation|pears.PostCodeLocation]]
  * [[database:tables:pears_progress|pears.progress]] - Progress state of candidates under consideration / placed / rejected in vacancies. Links candidates to vacancies.
  * [[database:tables:pears_progresshistory|pears.ProgressHistory]] - History of progress items with dates that the progres state changed.
  * [[database:tables:pears_progressstatusdivision|pears.ProgressStatusDivision]]
  * [[database:tables:pears_pshealthperson|pears.psHealthPerson]] - Links to PSHealth (now Mobisio) worker records
  * [[database:tables:pears_pshealthshift|pears.psHealthShift]] - REDUNDANT
  * [[database:tables:pears_pshealthvacancy|pears.psHealthVacancy]] - Link to psHealth Case records
  * [[database:tables:pears_pushnotificationdevice|pears.PushNotificationDevice]] - Test table for push notification devices
  * [[database:tables:pears_pushnotificationtemplate|pears.PushNotificationTemplate]]