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 | M | Directly mapped from source file | BUSINESS_DATE | In the format dd-MM-yy |
| 1 | Date (V002) | Transaction Date | M | Directly mapped from source file | CHAR_BUSINESS_DATE | In the format dd.MM.yy |
| 2 | Description | Description | M | Directly mapped from source system | MARKET_CODE | |
| 3 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | REVENUE | |
| 4 | Room nights | Number of room nights | M | Directly mapped from source file | NO_DEFINITE_ROOMS | |
| 5 | Guest nights | Number of room guests | M | 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 | M | Directly mapped from source file | RESERVATION_DATE | See interface descriptions for details of versions. |
| 2 | Description | Description | M | Market code: {Directly mapped from source file} | MARKET_CODE | |
| 3 | Revenue | Revenue without authority charge rates | M | Directly mapped from source file | TOTAL_REVENUE | See interface descriptions for details of versions. |
| 4 | Room nights | Number of room nights | M | Directly mapped from source file | NO_DEFINITE_ROOMS | |
| 5 | Guest nights | Number of room guests | M | 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 | M | Directly mapped from source file | CONSIDERED_DATE | In the format dd-MMM-yy |
| 2 | Description | Description | M | Hard coded in the interface | “Arrivals/Departures” | |
| 4 | Arrivals | Number of arrivals | M | Directly mapped from source file | ARRIVAL_ROOMS | |
| 5 | Departures | Number of departures | M | 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: