====== Tables: D ======
<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_dashboarddisplayedobject|pears.DashboardDisplayedObject]] - Objects which actually appear on individuals IQXWeb dashboard
  * [[database:tables:pears_dashboardobject|pears.DashboardObject]] - Objects which may appear on IQXWeb dashboard
  * [[database:tables:pears_databaseloginattempts|pears.DatabaseLoginAttempts]] - Details user login attempts
  * [[database:tables:pears_databaseupdatelog|pears.DatabaseUpdateLog]] - Log of when an automated database update has been run & by whom.
  * [[database:tables:pears_datamanagementlog|pears.DataManagementLog]] - GDPR - Records which records have been anonomised for GDPR - and what actions happened.  Data cannot be recovered from here.
  * [[database:tables:pears_dateformat|pears.DateFormat]]
  * [[database:tables:pears_daxtraparams|pears.DAXTRAParams]] - Used for Daxtra Document Imports. Populated from Daxtra Web Service.
  * [[database:tables:pears_debtortext|pears.DebtorText]] - Contains text of different stages of severity of Debt Chasing letters.
  * [[database:tables:pears_deletedcriterion|pears.DeletedCriterion]] - Record of deleted Criterion data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deleteddepartmenttag|pears.DeletedDepartmentTag]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deleteddocumenttag|pears.DeletedDocumentTag]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deletediqxnettaggroupmember|pears.DeletedIQXNetTagGroupMember]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deletedreferencemasterquestion|pears.DeletedReferenceMasterQuestion]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deletedtag|pears.DeletedTag]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deletedtagchoice|pears.DeletedTagChoice]]
  * [[database:tables:pears_deletedtagcompliance|pears.DeletedTagCompliance]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_deletedtagvalue|pears.DeletedTagValue]] - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
  * [[database:tables:pears_department|pears.Department]] - Department base records.
  * [[database:tables:pears_departmenttag|pears.DepartmentTag]] - Allows non department candidate date questions to be departmentalised.
  * [[database:tables:pears_deptmaintenance|pears.deptmaintenance]] - Records which staff members have manintenace rights in which department.
  * [[database:tables:pears_diary|pears.diary]] - Appointment diary records.
  * [[database:tables:pears_diaryextraday|pears.diaryextraday]] - Global Temp Table used in rendering diary displays.
  * [[database:tables:pears_diarytasklist|pears.DiaryTaskList]] - Task list tasks.
  * [[database:tables:pears_dictionary|pears.dictionary]] - Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists.
  * [[database:tables:pears_division|pears.Division]] - List of Divisions in the organisation.
  * [[database:tables:pears_divisionaccess|pears.DivisionAccess]] - Links Staff records to Divisions. Staff with no records have access to all Divisions.
  * [[database:tables:pears_divisionsallowed|pears.DivisionsAllowed]] - Temp Table - contains the Divisions that the current user is entitled to access.
  * [[database:tables:pears_dllrequired|pears.DLLRequired]]
  * [[database:tables:pears_docpackfilelist|pears.DocPackFileList]] - TempTable - used to assemble files to be inserted into a document pack.
  * [[database:tables:pears_docpackperson|pears.DocPackPerson]] - Temp Table - used in asembling document packs.  Linking a person to a pack.
  * [[database:tables:pears_docpackvalidation|pears.DocPackValidation]] - Used in conjunction with DocumentPackAllowed(). Rows inserted by exe and checked by the (user defined function) which needs to clean up table as required.
  * [[database:tables:pears_documentpack|pears.DocumentPack]] - Master records for the defined Document Packs.
  * [[database:tables:pears_documentpackdepartment|pears.DocumentPackDepartment]] - Links Document Packs to Departments. Packs with no record are available for all Departments.
  * [[database:tables:pears_documentpackreport|pears.DocumentPackReport]]
  * [[database:tables:pears_documentpacktype|pears.DocumentPackType]] - Lists types of Document available in a given pack by default.
  * [[database:tables:pears_documentstamp|pears.DocumentStamp]] - Stamp Images that are available to be applied to documents when redacting.
  * [[database:tables:pears_documentstampdepartment|pears.DocumentStampDepartment]] - Links Stamp Images to Departments. Images with no record are available for all Departments.
  * [[database:tables:pears_documenttag|pears.DocumentTag]] - Questions (ie TagIDs) associated with a Document Type for Compliance Documents
  * [[database:tables:pears_documenttype|pears.DocumentType]] - Classification of Documents (including definition of Compliance & Non-Compliance Documents).
  * [[database:tables:pears_documenttypedepartment|pears.DocumentTypeDepartment]] - Links Document Types to Departments. Types with no record are available for all Departments.
  * [[database:tables:pears_duplicatecheck|pears.DuplicateCheck]]
  * [[database:tables:pears_duplicatecheckresult|pears.DuplicateCheckResult]]