Skip to main content

Recently Updated Pages

Support Tickets

DTC's Client Public Resources DTC Client Portal

The Service Tickets section is where you submit IT support requests and track their progress. Whe...

Updated 5 months ago by Nate Smith

Approvals

DTC's Client Public Resources DTC Client Portal

The Approvals page is your central hub for everything that needs your review or response. This in...

Updated 5 months ago by Nate Smith

ZeroTier End User Guide

ZeroTier

ZeroTier is used for secure network access to connect devices anywhere in the world as if they we...

Updated 5 months ago by Mike Schepers

Custom Fields & Configuration - Key Tables

HaloPSA Database Schema Custom Fields & Configuration

Full column listings for the 3 key tables in this category. CONTROL (808 columns) # Column Typ...

Updated 5 months ago by Nate Smith

Ticket Configuration - Key Tables

HaloPSA Database Schema Ticket Configuration

Full column listings for the 7 key tables in this category. CATEGORYDETAIL (14 columns) # Colu...

Updated 5 months ago by Nate Smith

Clients & Sites - Key Tables

HaloPSA Database Schema Clients & Sites

Full column listings for the 5 key tables in this category. AREA (332 columns) # Column Type L...

Updated 5 months ago by Nate Smith

Invoicing & Billing - Table Index

HaloPSA Database Schema Invoicing & Billing

All 40 tables in the Invoicing & Billing category. Table Type Columns Key ACCOUNTSINTERFAC...

Updated 5 months ago by Nate Smith

Invoicing & Billing - Key Tables

HaloPSA Database Schema Invoicing & Billing

Full column listings for the 5 key tables in this category. CHARGERATE (27 columns) # Column T...

Updated 5 months ago by Nate Smith

Tickets (Faults) - Key Tables

HaloPSA Database Schema Tickets (Faults)

Full column listings for the 13 key tables in this category. FAULTAPPROVAL (30 columns) # Colu...

Updated 5 months ago by Nate Smith

Actions (Ticket Notes) - Table Index

HaloPSA Database Schema Actions (Ticket Notes)

All 7 tables in the Actions (Ticket Notes) category. Table Type Columns Key ACT BASE TABLE...

Updated 5 months ago by Nate Smith

Actions (Ticket Notes) - Key Tables

HaloPSA Database Schema Actions (Ticket Notes)

Full column listings for the 3 key tables in this category. ACTARC (68 columns) # Column Type ...

Updated 5 months ago by Nate Smith

Agents & Technicians - Key Tables

HaloPSA Database Schema Agents & Technicians

Full column listings for the 4 key tables in this category. SECTIONDETAIL (50 columns) # Colum...

Updated 5 months ago by Nate Smith

Reports & Analytics - Table Index

HaloPSA Database Schema Reports & Analytics

All 63 tables in the Reports & Analytics category. Table Type Columns Key ANALYZERFILTER B...

Updated 5 months ago by Nate Smith

Reports & Analytics - Key Tables

HaloPSA Database Schema Reports & Analytics

Full column listings for the 2 key tables in this category. ANALYZERPROFILE (99 columns) # Col...

Updated 5 months ago by Nate Smith

Email & Communication - Table Index

HaloPSA Database Schema Email & Communication

All 50 tables in the Email & Communication category. Table Type Columns Key BulkEmail BASE...

Updated 5 months ago by Nate Smith

Email & Communication - Key Tables

HaloPSA Database Schema Email & Communication

Full column listings for the 3 key tables in this category. EMAILRULE (61 columns) # Column Ty...

Updated 5 months ago by Nate Smith

Assets & Configuration Items - Table Index

HaloPSA Database Schema Assets & Configuration Items

All 27 tables in the Assets & Configuration Items category. Table Type Columns Key ASSETFI...

Updated 5 months ago by Nate Smith

Assets & Configuration Items - Key Tables

HaloPSA Database Schema Assets & Configuration Items

Full column listings for the 4 key tables in this category. CONN (25 columns) # Column Type Le...

Updated 5 months ago by Nate Smith

Automation & Workflows - Table Index

HaloPSA Database Schema Automation & Workflows

All 28 tables in the Automation & Workflows category. Table Type Columns Key APPROVALPROCE...

Updated 5 months ago by Nate Smith

Automation & Workflows - Key Tables

HaloPSA Database Schema Automation & Workflows

Full column listings for the 5 key tables in this category. AUTOASSIGN (52 columns) # Column T...

Updated 5 months ago by Nate Smith