PMI Knowledge base

Back to Knowledge base
Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Filter by Custom Post Type
PMI Knowledge Base
Article contents
Print

Data elements required from S&C

Updated
ByAndreas Engkvist
Views701
Please Share Your Feedback
How Can We Improve This Article?

Why? The data set allows calculation of daily revenue forecast and optimal productivity as well as staffing level in PMI. 

What? The data set comprises of a daily snapshot of all sales and catering reservations recorded on the book for the next 365 days.

1
2
3
4
5
6
7
8
9
10
11
12
13
PMI data element (target)
Property ID
Property Name
Department ID
Department Name
EventType ID
EventType Name
MealPeriod ID
MealPeriod Name
Extract Date
Event Date
Covers
NetRevenue
Event Status
Description
ID of the property (hotel, restaurant)
Name of the property (hotel, restaurant)
ID of the department within the property
Name of the department within the property
ID of the event type
Name of the event type
ID of the meal period
Name of the meal period (e.g. Breakfast, Lunch, Dinner)
Date of the data extract
Event Date
Number of covers/guests
Revenue without VAT and other authority charge rates
Booking status of the reservation
Mandatory / Optional
Optional
Mandatory
Optional
Mandatory
Optional
Mandatory
Optional
Optional
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Comment
An event type can be any kind of catering activity; it can be as simple as a one-hour reception, or something more complex such as a three-day business meeting with meals, breaks, and specific meeting room, setup, and resource requirements. Other common examples are: dinner, meeting, coffee break, etc. These attributes are used to map associated revenue to correct departments and segments.

Please note: The table above shows the PMI data elements required. Equivalent data elements must be identified in source S&C application as part of the extract specification exercise.

The export should be scheduled daily as early as possible in the morning.

Please see the article Transfer methods for more details. 

Tags: