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.
Used for registration of tickets.
The file structure is the same for actual and on the book. The only difference is that the date is before today (actual) or from today onward (otb).
|Interface name incl. version||Comment|
|Citybreak_Hist_V101||Retrieving actual data|
|Citybreak_OTB_V100||Retrieving data on the book|
|#||PMI data element (target)||Description||Mandatory / Optional||Data transformation/load rules||Data element (source)||Comment|
|1||Date||Transaction/OTB date||M||Directly mapped from source file||ArrivalDate||In the format dd.MM.yyyy hh:mm:ss|
|2||Department||ID or name of the department||M||Not in source file|
|3||Account||ID or name of the account||M||Not in source file|
|4||Description||Account description||M||Directly mapped from source system||Name|
|5||Revenue||Revenue without authority charge rates||M||Directly mapped from source file||Revenue||Using Norwegian punctuation and including VAT|
|6||Covers||Number of covers||M||Directly mapped from source file||Guests||Imported as room nights|
Output examples for download:
- Flat file CSV File:Citybreak Otb V100.txt