This form explains the table reservation data we need in PMI for its daily cover forecasting algorithms. Its purpose is to help experts find the precise data points (fields) to extract from a table reservation system. Preferably, the daily extraction should utilize an API, although flat file transfer is also supported.
| # | PMI data element (target) | Description | Mandatory / Optional | Comment |
|---|---|---|---|---|
| 1 | Property ID | ID of the property (hotel, restaurant) | Mandatory | |
| 2 | Property Name | Name of the property (hotel, restaurant) | Mandatory | |
| 3 | Department ID | ID of the department within the property | Mandatory | |
| 4 | Department Name | Name of the department within the property | Mandatory | |
| 5 | MealPeriod ID | ID of the meal period | Optional | |
| 6 | MealPeriod Name | Name of the meal period (e.g. Breakfast, Lunch, Dinner) | Optional | |
| 7 | Extract Date | Date of the data extract | Mandatory | |
| 8 | Arrival Date | Arrival Date | Mandatory | |
| 9 | Covers | Number of covers/guests | Mandatory | |
| 10 | NetRevenue | Revenue without VAT and other authority charge rates | Mandatory |