Tables: A
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.AccordEmployee - Links Person records to Accord employee records. Used to detect address changes that need to be passed to Accord.
- pears.AccordExpenseBenefitExport - Expense benefit timesheets for Accord.
- pears.AccordParams - Accord payroll settings. One row only.
- pears.ACCORDPAYROLLDEFINITION - Translation between IQX & Accord field names. Used for providing meaningful messages.
- pears.AdhocInvoiceTemplate - Save As Template button on AdHoc Invoice
- pears.AdhocInvoiceTemplateLine - Lines for AdHoc Invoice Templates
- pears.agencydetails - Branch details. A branch usually represents a physical location.
- pears.AuditItems - Controls which items are included in auditing.
- pears.AuditTrail - Contains audit records inserted by system and by audit triggers.
- pears.AutoMatchDivisionConfig - For use by Auto-matching procedures
- pears.AutoMatchGlobalConfig - For use by Auto-matching procedures
- pears.AutoMatchNewTempWeightingConfig - For use by Auto-matching procedures
- pears.AutoMatchNotificationQueue - For use by Auto-matching procedures
- pears.AutoMatchOldTempWeightingConfig - For use by Auto-matching procedures
- pears.AutoMatchPersonConfig - For use by Auto-matching procedures
- pears.AutoMatchPersonPreferredShiftType - Preferred shift template group
- pears.AutoMatchShiftQueue - For use by Auto-matching procedures
- pears.AvailabilityTemplate - User defined availability patterns.
- pears.AWRcompany - AWR settings for Company records. One-to-one relationship with Company table.
- pears.AWRJobMaster - Links Person records with Vacancies for AWR purposes.
- pears.AWRvacancy - AWR settings for Vacancy records. One-to-one relationship with Vacancy table. Overrides AWRCompany.
- pears.AWRWeekFind - Temporary table. Used during calculation of AWR qualifying periods.
- pears.AWRWeeklyDetail - Records indicate qualifying / pausing activity etc in given week for AWRJobMaster records.
- pears.AWRWeeklyQualified - REDUNDANT
127.0.0.1