The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the adapter to get the desired data format and/or result in the PMI staging table where such have been applicable.

An example of the source file data, format and structure is also attached below the table. This table will be updated whenever the source file or the adapter in question are changed throughout the interface life-cycle.

Interface name incl. version Comment
Opera_restat_V001 The columns are tab delimited.
Opera_restat_V002 The columns are semicolon delimited. Works with Opera version 5.0.03.03e20.
Interface name incl. version Comment
Opera_resfct_V001 Works with Opera version 5.0.03.03e20.
Opera_resfct_V002 Same as V001 with the following exception: Semicolon delimited instead of tab delimited. Uses the field CHAR_RESERVATION_DATE instead of RESERVATION_DATE for date. Has date format dd.MM.yy instead of dd-MMM-yy. Uses ROOM_REVENUE instead of TOTAL_REVENUE for revenue.
Opera_resfct_V003 Same as V002 with the following exceptions: Adds Roomnights Tentative. BOOKING_STATUS “INQ” is rejected. Only BOOKING_STATUS “DEF and “ACT” are accepted for revenue, guest nights and room nights. For tentative room nights the BOOKING_STATUS “DEF” and “ACT” are rejected.
Opera_resfct_V004 Same as V002 with the following exceptions: TOTAL_DEFINITE_REVENUE instead of ROOM_REVENUE for revenue. NO_DEFINITE_GUEST instead of NO_OF_GUESTS for guest nights.
Opera_resfct_V005 Same as V004 with the following exception: Interprets the revenue according to the en-gb culture.
Interface name incl. version Comment
Opera_AD_V101 The columns are tab delimited. Uses date format dd-MMM-yy.
Opera_AD_V102 Not in use. Probably built for the so called “arrival and departure” report in Opera..
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date (V001) Transaction Date Mandatory Directly mapped from source file BUSINESS_DATE In the format dd-MM-yy
2 Date (V002) Transaction Date Mandatory Directly mapped from source file CHAR_BUSINESS_DATE In the format dd.MM.yy
3 Description Description Mandatory Directly mapped from source system MARKET_CODE
4 Revenue Revenue without authority charge rates Mandatory Directly mapped from source file REVENUE
5 Room nights Number of room nights Mandatory Directly mapped from source file NO_DEFINITE_ROOMS
Guest nights Number of room guests Directly mapped from source file IN_GUEST
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date Transaction Date Mandatory Directly mapped from source file RESERVATION_DATE See interface descriptions for details of versions.
2 Description Description Mandatory Market code: {Directly mapped from source file} MARKET_CODE
3 Revenue Revenue without authority charge rates Mandatory Directly mapped from source file TOTAL_REVENUE See interface descriptions for details of versions.
4 Room nights Number of room nights Mandatory Directly mapped from source file NO_DEFINITE_ROOMS
5 Guest nights Number of room guests Mandatory Directly mapped from source file NO_OF_GUESTS See interface descriptions for details of versions.
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date Transaction Date Mandatory Directly mapped from source file CONSIDERED_DATE In the format dd-MMM-yy
2 Description Description Mandatory Hard coded in the interface “Arrivals/Departures”
4 Arrivals Number of arrivals Mandatory Directly mapped from source file ARRIVAL_ROOMS
5 Departures Number of departures Mandatory Directly mapped from source file DEPARTURE_ROOMS

Output examples for download:

Flat file CSV for Opera_restat interface:

Flat file CSV for Opera_resfxt interface: