This reference guide provides a comprehensive list of all available Guests data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Controls fields are available when building custom reports, what information each field represents, and how to select the right fields for your reporting needs. This resource helps you make informed decisions when configuring reports and ensures you're pulling the correct data.

Controls 

Column Name What It Means
ControlIDUnique identifier for the control/VC
OperatorID
Linked operator (if applicable)
GuestIDUnique customer identifier
FirstName
Guest's first name
Surname
Guest's last name
FullName
Complete name
Salutation
Title/greeting
BusinessName
Company/business name
PhoneNumber
Home/work phone
MobileNumber
Mobile/cell phone
FaxNumber
Fax number
Email
Email address
Address
Street address
SuburbCity/town
State
State/province    
Postcode
Postal/ZIP code
Country
Country name
ENewsletter
Opted in for newsletters?
GuestNotesPublic notes about guest
InternalNotes
Private staff notes
Source
How did they find you?