====== Tables: A ======
<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_accordemployee|pears.AccordEmployee]] - Links Person records to Accord employee records. Used to detect address changes that need to be passed to Accord.
  * [[database:tables:pears_accordexpensebenefitexport|pears.AccordExpenseBenefitExport]] - Expense benefit timesheets for Accord.
  * [[database:tables:pears_accordparams|pears.AccordParams]] - Accord payroll settings. One row only.
  * [[database:tables:pears_accordpayrolldefinition|pears.ACCORDPAYROLLDEFINITION]] - Translation between IQX & Accord field names. Used for providing meaningful messages.
  * [[database:tables:pears_accountoverrideinvoiceaddress|pears.AccountOverrideInvoiceAddress]]
  * [[database:tables:pears_adhocinvoicetemplate|pears.AdhocInvoiceTemplate]] - Save As Template button on AdHoc Invoice
  * [[database:tables:pears_adhocinvoicetemplateline|pears.AdhocInvoiceTemplateLine]] - Lines for AdHoc Invoice Templates
  * [[database:tables:pears_agencydetails|pears.agencydetails]] - Branch details. A branch usually represents a physical location.
  * [[database:tables:pears_alternativeinvoiceaddressemail|pears.AlternativeInvoiceAddressEmail]]
  * [[database:tables:pears_audititems|pears.AuditItems]] - Controls which items are included in auditing.
  * [[database:tables:pears_audittrail|pears.AuditTrail]] - Contains audit records inserted by system and by audit triggers.
  * [[database:tables:pears_automatchdivisionconfig|pears.AutoMatchDivisionConfig]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatchglobalconfig|pears.AutoMatchGlobalConfig]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatchnewtempweightingconfig|pears.AutoMatchNewTempWeightingConfig]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatchnotificationqueue|pears.AutoMatchNotificationQueue]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatcholdtempweightingconfig|pears.AutoMatchOldTempWeightingConfig]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatchpersonconfig|pears.AutoMatchPersonConfig]] - For use by Auto-matching procedures
  * [[database:tables:pears_automatchpersonpreferredshifttype|pears.AutoMatchPersonPreferredShiftType]] - Preferred shift template group
  * [[database:tables:pears_automatchshiftqueue|pears.AutoMatchShiftQueue]] - For use by Auto-matching procedures
  * [[database:tables:pears_availabilitytemplate|pears.AvailabilityTemplate]] - User defined availability patterns.
  * [[database:tables:pears_awrcompany|pears.AWRcompany]] - AWR settings for Company records. One-to-one relationship with Company table.
  * [[database:tables:pears_awrjobmaster|pears.AWRJobMaster]] - Links Person records with Vacancies for AWR purposes.
  * [[database:tables:pears_awrvacancy|pears.AWRvacancy]] - AWR settings for Vacancy records. One-to-one relationship with Vacancy table. Overrides AWRCompany.
  * [[database:tables:pears_awrweekfind|pears.AWRWeekFind]] - Temporary table. Used during calculation of AWR qualifying periods.
  * [[database:tables:pears_awrweeklydetail|pears.AWRWeeklyDetail]] - Records indicate qualifying / pausing activity etc in given week for AWRJobMaster records.
  * [[database:tables:pears_awrweeklyqualified|pears.AWRWeeklyQualified]] - REDUNDANT