Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

220 total results found

Automation & Workflows

HaloPSA Database Schema

28 tables, 5 key tables. Workflow headers/steps, automation rules, auto-assign, and escalation messages.

Releases & Change Management

HaloPSA Database Schema

13 tables, 2 key tables. Release records and change sequence management.

Security & Access Control

HaloPSA Database Schema

19 tables, no key tables. Access control, API tokens, permissions, and security configuration.

Custom Fields & Configuration

HaloPSA Database Schema

34 tables, 3 key tables. Field definitions (FIELDINFO, FIELD) and system control settings (CONTROL with 808 columns).

Attachments & Files

HaloPSA Database Schema

13 tables, 1 key table. File attachments, document storage, and file management.

Audit & Logging

HaloPSA Database Schema

19 tables, 1 key table. Audit trail, system logs, and change tracking.

Identity & NHD Platform

HaloPSA Database Schema

13 tables, no key tables. NHServer/NHD platform identity and tenant configuration.

Trees & Navigation

HaloPSA Database Schema

10 tables, no key tables. Tree structures, navigation hierarchies, and menu configuration.

Miscellaneous

HaloPSA Database Schema

48 tables, no key tables. System tables, configuration, and uncategorized entities.

Integrations (General) - Table Index

HaloPSA Database Schema Integrations (General)

All 29 tables in the Integrations (General) category. Table Type Columns Key ConnectedInstance BASE TABLE 7 ExternalLink BASE TABLE 28 IncomingWebhook BASE TABLE 17 IncomingWebhookAttempt BASE TABLE 6 IntegrationConfiguration BASE TABLE 23 ...

Vendor Integrations - Table Index

HaloPSA Database Schema Vendor Integrations

All 83 tables in the Vendor Integrations category. Table Type Columns Key AWSDetails BASE TABLE 29 AddigyDetails BASE TABLE 25 AdobeAcrobatDetails BASE TABLE 13 AdobeCommerceDetails BASE TABLE 10 AmazonSellerDetails BASE TABLE 11 ArmisDet...

Security & Access Control - Table Index

HaloPSA Database Schema Security & Access Control

All 19 tables in the Security & Access Control category. Table Type Columns Key ADFSIDS BASE TABLE 4 AccessControl BASE TABLE 11 AccessToken BASE TABLE 10 AuthGuid BASE TABLE 4 Certificate BASE TABLE 7 FederatedCredential BASE TABLE 7 ...

Identity & NHD Platform - Table Index

HaloPSA Database Schema Identity & NHD Platform

All 13 tables in the Identity & NHD Platform category. Table Type Columns Key NHD_IDENTITY_Application BASE TABLE 53 NHD_IDENTITY_Authorization BASE TABLE 9 NHD_IDENTITY_Scope BASE TABLE 7 NHD_IDENTITY_Token BASE TABLE 12 NHD_Identity_Applic...

Trees & Navigation - Table Index

HaloPSA Database Schema Trees & Navigation

All 10 tables in the Trees & Navigation category. Table Type Columns Key Bookmark BASE TABLE 4 MAPPING BASE TABLE 4 MappingContinuum BASE TABLE 5 Permalinks BASE TABLE 6 SPOTLIGHT BASE TABLE 3 TABNAME BASE TABLE 14 TREE BASE TABLE 22 ...

Miscellaneous - Table Index

HaloPSA Database Schema Miscellaneous

All 48 tables in the Miscellaneous category. Table Type Columns Key AIAssistantRequest BASE TABLE 11 AOV BASE TABLE 4 APIAPPLICATION BASE TABLE 3 APIToken BASE TABLE 4 AiSuggestion BASE TABLE 16 AiSuggestionFault BASE TABLE 9 CHECKIN B...

Attachments & Files - Key Tables

HaloPSA Database Schema Attachments & Files

Full column listings for the 1 key table in this category. ATTACHMENT (26 columns) # Column Type Length Nullable Default 1 ATid int NO 2 ATBlob varbinary -1 YES 3 ATFilename nvarchar 4000 YES 4 ATDateCreated datetime YES 5 ATNote nvarchar ...

Attachments & Files - Table Index

HaloPSA Database Schema Attachments & Files

All 13 tables in the Attachments & Files category. Table Type Columns Key ATTACHMENT BASE TABLE 26 KEY ATTACHMENTACTION BASE TABLE 8 Attachment_Metadata BASE TABLE 1 DocumentCreation BASE TABLE 6 FILES BASE TABLE 10 PdfTemplate BASE TABLE ...

Audit & Logging - Key Tables

HaloPSA Database Schema Audit & Logging

Full column listings for the 1 key table in this category. AUDIT (15 columns) # Column Type Length Nullable Default 1 AID int NO 2 AFaultid int NO 3 AUnum int NO 4 ADate datetime YES 5 AValue nvarchar 4000 YES 6 ATo nvarchar -1 YES ...