====== Tables: E ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * [[database:tables:pears_ebpayband|pears.EBPayBand]] - Expense Benefit payband * [[database:tables:pears_ebtimesheet|pears.EBTimeSheet]] - Expense Benefit timesheet * [[database:tables:pears_ebtimesheetline|pears.EBTimeSheetLine]] - Expense Benefit timesheet line * [[database:tables:pears_emailsignature|pears.EmailSignature]] - Table holding definitions and rules for e-mail signatures. * [[database:tables:pears_emailstaffnotification|pears.EmailStaffNotification]] - Email addresses to be used where an individual is not suitable. * [[database:tables:pears_emailstaffnotificationaddress|pears.EmailStaffNotificationAddress]] - Used for more than a single instance of the above. * [[database:tables:pears_emailtosend|pears.EmailToSend]] * [[database:tables:pears_emailtosendattachment|pears.EmailToSendAttachment]] * [[database:tables:pears_emailtosendcontactevent|pears.EmailToSendContactEvent]] * [[database:tables:pears_employment|pears.employment]] - Link between Person and Company defining employment. * [[database:tables:pears_etip|pears.ETip]] - Shift Import from Email * [[database:tables:pears_etiplog|pears.ETipLog]] - Shift Import from Email (log) * [[database:tables:pears_etipregex|pears.ETipRegEx]] - Regular expressions for shift import * [[database:tables:pears_expensebenefitchoice|pears.ExpenseBenefitChoice]] - Lookup of choices for Expense Benefit Scheme Items * [[database:tables:pears_expensebenefitoptout|pears.ExpenseBenefitOptOut]] - Lookup of user defined reasons for Candidates opting out of Expenese Benefit - links to Pay_Employment * [[database:tables:pears_expensebenefitplacementitem|pears.ExpenseBenefitPlacementItem]] - Expense Benefit values for individual Placements * [[database:tables:pears_expensebenefitscheme|pears.ExpenseBenefitScheme]] - Header records for Expense Benefit Schemes * [[database:tables:pears_expensebenefitschemeitem|pears.ExpenseBenefitSchemeItem]] - Detail records for Expense Benefit Schemes * [[database:tables:pears_expensebenefitshiftitem|pears.ExpenseBenefitShiftItem]] - Expense Benefit values for individual Shifts * [[database:tables:pears_expensebenefittype|pears.ExpenseBenefitType]] - Definitions of types of Expense Benefit available with behaviour settings * [[database:tables:pears_exportoptions|pears.ExportOptions]] - Stores filesname and paths for payroll and invoice exports * [[database:tables:pears_externalcredential|pears.ExternalCredential]] * [[database:tables:pears_externalemployment|pears.externalemployment]] - Employment for temps when the company doesn't exist in IQX. * [[database:tables:pears_extphone|pears.ExtPhone]] - non standard