Tables: B
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.BankModulus - Contains list of valid sortcode ranges and which modulus check applies.
- pears.BankModulusValidSortcodes - List of sort codes to be excluded from modulus checking.
- pears.BatchTransfers - Records of transfer jobs etc. Maintained by the individual processes.
- 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.
- pears.BlobStoreDeleteQueue - External Blob files awaiting deletion
- pears.BoilerPlate - Contains standard text which can be dropped into various types of note field.
- pears.BoilerPlatedivision - Links BoilerPlate records with Divsions. Boiler Plates with no records are available to all.
- pears.BroadbeanCandidate - Broadbean Candidate
- pears.BroadbeanChannels - Broadbean Channels
- pears.BroadbeanHybridLocation - Broadbean Locations - Standard Broadbean List
- pears.BroadbeanIndustry - Broadbean industries- Standard Broadbean List
- pears.BroadbeanJobBoard - Old non-Hybrid tables. Contents not to be touched.
- pears.BroadbeanJobBoardAllocation - Links to staff records agains BB job board
- pears.BroadbeanLocation - Old non-Hybrid tables. Contents not to be touched.
- pears.BroadbeanRejectionReason - List of reasons candidates not imported from BB
- pears.BroadbeanUser - Broadbean user login details
- pears.BroadbeanVacancy - Links to vacancy - which vacancy posted to BB
127.0.0.1