HaloITSM SQL Schema Glossary

Disclaimer: This glossary is AI-generated from exported Halo schema metadata and is not official Halo documentation. Table meanings, field descriptions, joins, and categories may be incomplete or incorrect. Always validate against your own HaloITSM or HaloPSA environment before using this information in production reports, automations, billing, or configuration decisions.
TableCommon use
FAULTSTickets, incidents, service requests, changes, and logged records.
ACTIONSTicket notes, updates, actions, time entries, and history records.
USERSEnd users, requesters, and customer contacts.
UNAMEAgents, technicians, and internal Halo users.
REQUESTTYPETicket type and request type configuration.
STDREQUESTService catalogue items and standard request definitions.
FIELDINFO / FIELDField and custom field metadata used in forms and reports.
CONTROL / CONTROL2 / CONTROL3Global configuration and administration-related settings.
CategoryTableColumnSQL data typeMeaningDescriptionRelated / Join
Loading glossary...