Skip to main content

Recently Updated Pages

Tickets (Faults) - Table Index

HaloPSA Database Schema Tickets (Faults)

All 39 tables in the Tickets (Faults) category. Table Type Columns Key BudgetType BASE TAB...

Updated 7 months ago by Nate Smith

Clients & Sites - Table Index

HaloPSA Database Schema Clients & Sites

All 29 tables in the Clients & Sites category. Table Type Columns Key ADDRESSBOOK BASE TAB...

Updated 7 months ago by Nate Smith

Agents & Technicians - Table Index

HaloPSA Database Schema Agents & Technicians

All 44 tables in the Agents & Technicians category. Table Type Columns Key AgentCheckIn BA...

Updated 7 months ago by Nate Smith

Knowledge Base - Table Index

HaloPSA Database Schema Knowledge Base

All 25 tables in the Knowledge Base category. Table Type Columns Key FAQCLIENT BASE TABLE ...

Updated 7 months ago by Nate Smith

SLA & Service Level - Table Index

HaloPSA Database Schema SLA & Service Level

All 20 tables in the SLA & Service Level category. Table Type Columns Key Downtime BASE TA...

Updated 7 months ago by Nate Smith

SLA & Service Level - Key Tables

HaloPSA Database Schema SLA & Service Level

Full column listings for the 4 key tables in this category. HOLIDAYS (18 columns) # Column Typ...

Updated 7 months ago by Nate Smith

Releases & Change Management - Table Index

HaloPSA Database Schema Releases & Change Management

All 13 tables in the Releases & Change Management category. Table Type Columns Key CABHEAD...

Updated 7 months ago by Nate Smith

Releases & Change Management - Key Tables

HaloPSA Database Schema Releases & Change Management

Full column listings for the 2 key tables in this category. CHANGESEQ (40 columns) # Column Ty...

Updated 7 months ago by Nate Smith

Live Chat - Table Index

HaloPSA Database Schema Live Chat

All 17 tables in the Live Chat category. Table Type Columns Key CHATMESSAGE BASE TABLE 7 ...

Updated 7 months ago by Nate Smith

Live Chat - Key Tables

HaloPSA Database Schema Live Chat

Full column listings for the 2 key tables in this category. LIVECHATHEADER (34 columns) # Colu...

Updated 7 months ago by Nate Smith

Projects & Milestones - Table Index

HaloPSA Database Schema Projects & Milestones

All 8 tables in the Projects & Milestones category. Table Type Columns Key MileStone BASE ...

Updated 7 months ago by Nate Smith

Projects & Milestones - Key Tables

HaloPSA Database Schema Projects & Milestones

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

Updated 7 months ago by Nate Smith

Contracts & Recurring - Table Index

HaloPSA Database Schema Contracts & Recurring

All 16 tables in the Contracts & Recurring category. Table Type Columns Key CONTRACT BASE ...

Updated 7 months ago by Nate Smith

Contracts & Recurring - Key Tables

HaloPSA Database Schema Contracts & Recurring

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

Updated 7 months ago by Nate Smith

Software & Licences - Table Index

HaloPSA Database Schema Software & Licences

All 7 tables in the Software & Licences category. Table Type Columns Key AzureLicences BAS...

Updated 7 months ago by Nate Smith

Software & Licences - Key Tables

HaloPSA Database Schema Software & Licences

Full column listings for the 1 key table in this category. Licence (38 columns) # Column Type ...

Updated 7 months ago by Nate Smith

Audit & Logging - Table Index

HaloPSA Database Schema Audit & Logging

All 19 tables in the Audit & Logging category. Table Type Columns Key AUDIT BASE TABLE 15 ...

Updated 7 months ago by Nate Smith

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 Le...

Updated 7 months ago by Nate Smith

Attachments & Files - Table Index

HaloPSA Database Schema Attachments & Files

All 13 tables in the Attachments & Files category. Table Type Columns Key ATTACHMENT BASE ...

Updated 7 months ago by Nate Smith

Attachments & Files - Key Tables

HaloPSA Database Schema Attachments & Files

Full column listings for the 1 key table in this category. ATTACHMENT (26 columns) # Column Ty...

Updated 7 months ago by Nate Smith