This reference guide provides a comprehensive list of all available Pax data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Pax 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.
Pax
| Column Name | What It Means |
| ControlID | The Visitor Centre managing this booking |
| OperatorID | The tour company or event provider |
| BookingID | The unique ID for the specific tour/event booking |
| ItineraryID | The overall trip/itinerary this passenger belongs to |
| PaxID | Unique identifier for this passenger record |
| FirstName | Passenger's first name or initial |
| Surname | Passenger's last name |
| FullName | Complete name (combines FirstName and Surname) |
| PassportNumber | Passenger's passport number (if collected) |
| Nationality | Country of citizenship |
| DateOfBirth | Passenger's birth date |
| TicketID | The physical or electronic ticket identifier |
| Status | Current state of the ticket: - Unused - Ticket issued but guest hasn't arrived yet - Accepted - Guest checked in and attended - Pass-out - Guest left the tour/venue temporarily - Pass-in - Guest returned to the tour/venue - Void - Ticket cancelled or invalidated |
| TicketType | Category of ticket purchased |
| AdmittedDate | Date and time the guest actually checked in/attended |
| AdmittedBy | Staff member who checked in the passenger |
| TicketActivityDate | When the ticket status last changed |
| TicketActivityAction | What action was taken with the ticket |
| TicketActivityBy | Who performed the last ticket action |