Tables: D

pears.DashboardDisplayedObject - Objects which actually appear on individuals IQXWeb dashboard

pears.DashboardObject - Objects which may appear on IQXWeb dashboard

pears.DatabaseLoginAttempts - Details user login attempts

pears.DatabaseUpdateLog - Log of when an automated database update has been run & by whom.

pears.DataManagementLog - GDPR - Records which records have been anonomised for GDPR - and what actions happened. Data cannot be recovered from here.

pears.DateFormat

pears.DAXTRAParams - Used for Daxtra Document Imports. Populated from Daxtra Web Service.

pears.DebtorText - Contains text of different stages of severity of Debt Chasing letters.

pears.DeletedCriterion - Record of deleted Criterion data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedDepartmentTag - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedDocumentTag - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedIQXNetTagGroupMember - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedReferenceMasterQuestion - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedTag - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedTagChoice

pears.DeletedTagCompliance - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.DeletedTagValue - Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

pears.Department - Department base records.

pears.DepartmentTag - Allows non department candidate date questions to be departmentalised.

pears.deptmaintenance - Records which staff members have manintenace rights in which department.

pears.diary - Appointment diary records.

pears.diaryextraday - Global Temp Table used in rendering diary displays.

pears.DiaryTaskList - Task list tasks.

pears.dictionary - Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists.

pears.Division - List of Divisions in the organisation.

pears.DivisionAccess - Links Staff records to Divisions. Staff with no records have access to all Divisions.

pears.DivisionsAllowed - Temp Table - contains the Divisions that the current user is entitled to access.

pears.DLLRequired

pears.DocPackFileList - TempTable - used to assemble files to be inserted into a document pack.

pears.DocPackPerson - Temp Table - used in asembling document packs. Linking a person to a pack.

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.

pears.DocumentPack - Master records for the defined Document Packs.

pears.DocumentPackDepartment - Links Document Packs to Departments. Packs with no record are available for all Departments.

pears.DocumentPackReport

pears.DocumentPackType - Lists types of Document available in a given pack by default.

pears.DocumentStamp - Stamp Images that are available to be applied to documents when redacting.

pears.DocumentStampDepartment - Links Stamp Images to Departments. Images with no record are available for all Departments.

pears.DocumentTag - Questions (ie TagIDs) associated with a Document Type for Compliance Documents

pears.DocumentType - Classification of Documents (including definition of Compliance & Non-Compliance Documents).

pears.DocumentTypeDepartment - Links Document Types to Departments. Types with no record are available for all Departments.

pears.DuplicateCheck

pears.DuplicateCheckResult