Tables: M [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Tables: M ======
<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_mailerselection|pears.mailerselection]] - Mailchimp 'LISTS'
  * [[database:tables:pears_mailerselectionmember|pears.mailerselectionmember]] - Candidate/client contacts on mailchimp list.
  * [[database:tables:pears_mailmerge|pears.mailmerge]] - Pointers to OLE documents in Blobstore (class M) which are individual users own Word mail merge templates.
  * [[database:tables:pears_mailserver|pears.MailServer]] - Mail Server configuration
  * [[database:tables:pears_masterroster|pears.MasterRoster]] - Header records for each Master Roster
  * [[database:tables:pears_masterrosterchangelog|pears.MasterRosterChangeLog]] - Record of changes to a Master Roster.
  * [[database:tables:pears_masterrosterchangereason|pears.MasterRosterChangeReason]] - Look-up of allowed change reasons for Master Rosters.
  * [[database:tables:pears_masterrosterfaillog|pears.MasterRosterFailLog]] - Records of failure to create or fill shifts from a Master Roster.
  * [[database:tables:pears_masterrosterpreferredperson|pears.MasterRosterPreferredPerson]] - Preferred candidates (with rank) for each Master Roster.
  * [[database:tables:pears_masterrostershift|pears.MasterRosterShift]] - Detail records for Master Rosters
  * [[database:tables:pears_masterrostershiftinstance|pears.MasterRosterShiftInstance]] - Shifts instantiated by the Master Roster. The delete restrict foreign key blocks deletion of MasterRosterShifts once instantiated
  * [[database:tables:pears_mimemessage|pears.MIMEMessage]] - Used in constructing MIME email message.
  * [[database:tables:pears_mrshiftid2s|pears.MRShiftID2s]] - Temp Table - Used by Master Roster Process
  * [[database:tables:pears_mrshiftids|pears.MRShiftIDs]] - Temp Table - Used by Master Roster Process