HaloPSA Database Schema
SQL Server database schema reference for HaloPSA. 853 tables, 17,624 columns across 31 functional categories. Generated from INFORMATION_SCHEMA via DTC Dash.
Schema Overview
Generated from HaloPSA's SQL Server INFORMATION_SCHEMA.COLUMNS via the DTC Dash Report API. Sourc...
Tickets (Faults)
39 tables, 13 key tables. Core ticket/fault tables including FAULTS (757 cols), FAULTARC, FAULTAP...
Ticket Configuration
46 tables, 7 key tables. Request types, statuses, outcomes, categories, workflows, and standard r...
Actions (Ticket Notes)
7 tables, 3 key tables. Ticket actions, notes, replies, and action types.
Clients & Sites
29 tables, 5 key tables. Client records (AREA), sites, service sites, organisations, and companies.
Users & Contacts
26 tables, 1 key table. End user records (USERS), portal access, user preferences, and roles.
Agents & Technicians
44 tables, 4 key tables. Agent records (UNAME), sections/teams, templates, and agent configuration.
Invoicing & Billing
40 tables, 5 key tables. Invoice headers and details, payments, charge rates, and tax configuration.
Contracts & Recurring
16 tables, 3 key tables. Contract headers, details, and recurring billing configuration.
Supplier Orders & Purchasing
16 tables, 4 key tables. Supplier order headers/details and purchase order management.
Assets & Configuration Items
27 tables, 4 key tables. Device/asset records, device changes, connections, and configuration items.
Software & Licences
7 tables, 1 key table. Software licence tracking and management.
SLA & Service Level
20 tables, 4 key tables. SLA headers, work days, holidays, and service status configuration.
Time Tracking & Scheduling
20 tables, 3 key tables. Timesheets, appointments, and schedule management.
Projects & Milestones
8 tables, 3 key tables. Project notes, tasks, and milestone tracking.
Knowledge Base
25 tables, 1 key table. Knowledge base entries (KBENTRY with 318 columns) and related entities.
Reports & Analytics
63 tables, 2 key tables. Analyzer profiles, widgets, dashboards, and reporting configuration.
Email & Communication
50 tables, 3 key tables. Mailboxes, email rules, email storage, and communication configuration.
Quotes & Opportunities
11 tables, 2 key tables. Quotation headers, details, and opportunity management.
Items & Products
33 tables, 2 key tables. Item catalog, stock management, and product configuration.
Live Chat
17 tables, 2 key tables. Live chat headers, messages, and chat configuration.
Integrations (General)
29 tables, no key tables. General integration framework tables for third-party system connections.
Vendor Integrations
83 tables, no key tables. Vendor-specific integration tables for RMM, security, accounting, and m...
Automation & Workflows
28 tables, 5 key tables. Workflow headers/steps, automation rules, auto-assign, and escalation me...
Releases & Change Management
13 tables, 2 key tables. Release records and change sequence management.
Security & Access Control
19 tables, no key tables. Access control, API tokens, permissions, and security configuration.
Custom Fields & Configuration
34 tables, 3 key tables. Field definitions (FIELDINFO, FIELD) and system control settings (CONTRO...
Attachments & Files
13 tables, 1 key table. File attachments, document storage, and file management.
Audit & Logging
19 tables, 1 key table. Audit trail, system logs, and change tracking.
Identity & NHD Platform
13 tables, no key tables. NHServer/NHD platform identity and tenant configuration.
Trees & Navigation
10 tables, no key tables. Tree structures, navigation hierarchies, and menu configuration.
Miscellaneous
48 tables, no key tables. System tables, configuration, and uncategorized entities.