====== Tables: B ======
<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_bankmodulus|pears.BankModulus]] - Contains list of valid sortcode ranges and which modulus check applies.
  * [[database:tables:pears_bankmodulusvalidsortcodes|pears.BankModulusValidSortcodes]] - List of sort codes to be excluded from modulus checking.
  * [[database:tables:pears_banknamesortcode|pears.BanknameSortcode]]
  * [[database:tables:pears_batchtransfers|pears.BatchTransfers]] - Records of transfer jobs etc. Maintained by the individual processes.
  * [[database:tables:pears_blobstore|pears.blobstore]] - OLE objects and other blob data eg pictures. If external Blob Store is in use the records are links to the relevant files.
  * [[database:tables:pears_blobstoredeletequeue|pears.BlobStoreDeleteQueue]] - External Blob files awaiting deletion
  * [[database:tables:pears_boilerplate|pears.BoilerPlate]] - Contains standard text which can be dropped into various types of note field.
  * [[database:tables:pears_boilerplatedivision|pears.BoilerPlatedivision]] - Links BoilerPlate records with Divsions. Boiler Plates with no records are available to all.
  * [[database:tables:pears_borough|pears.Borough]]
  * [[database:tables:pears_broadbeancandidate|pears.BroadbeanCandidate]] - Broadbean Candidate
  * [[database:tables:pears_broadbeanchannels|pears.BroadbeanChannels]] - Broadbean Channels
  * [[database:tables:pears_broadbeanhybridlocation|pears.BroadbeanHybridLocation]] - Broadbean Locations - Standard Broadbean List 
  * [[database:tables:pears_broadbeanindustry|pears.BroadbeanIndustry]] - Broadbean industries- Standard Broadbean List 
  * [[database:tables:pears_broadbeanjobboard|pears.BroadbeanJobBoard]] - Old non-Hybrid tables. Contents not to be touched.
  * [[database:tables:pears_broadbeanjobboardallocation|pears.BroadbeanJobBoardAllocation]] - Links to staff records agains BB job board
  * [[database:tables:pears_broadbeanlocation|pears.BroadbeanLocation]] - Old non-Hybrid tables. Contents not to be touched. 
  * [[database:tables:pears_broadbeanrejectionreason|pears.BroadbeanRejectionReason]] - List of reasons candidates not imported from BB
  * [[database:tables:pears_broadbeanuser|pears.BroadbeanUser]] - Broadbean user login details
  * [[database:tables:pears_broadbeanvacancy|pears.BroadbeanVacancy]] - Links to vacancy - which vacancy posted to BB