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 |
|---|---|
| Protel_Hstat_Actual_V100 | File pattern hstat* This interface is like the OTB interface with the exception that this imports the historical date where the OTB imports the future date. |
| Protel_Reshist_MarketCode_V001 | Imports from an XML file with file name pattern: ResHist*.xml Similar to Protel_Resforc_MarketCode except that it looks for the Day elements within the ResHistory element. |
| Protel_Reshist_MarketCode_V002 | Imports from an XML file with file name pattern: ResHist*.xml Does the same as V001 except that it handles a wrongly formatted XML |
| Protel_Reshist_RateCode_V001 | Similar to Reshist_MarketCode_V001 with the exception that instead of using the attribute from Market element it uses the attributes from RateCode and in the description it uses “Rate Code” instead of “Market Code”. |
| Protel_Reshist_RateCode_V002 | Similar to Reshist_RateCode_V001 except that it first does a preprocessing on the wrongly formatted XML file. |
| Protel_RevHistory_V001 | |
| Protel_Rev_V101 |
| Interface name incl. version | Comment |
|---|---|
| Protel_Hstat_Otb_V100 | File pattern hstat* |
| Protel_Resforc_V100 | Imports from an XML file. This interface is currently not used. |
| Protel_Resforc_MarketCode_V001 | Imports from an XML file with file name pattern: ResForc*.xml |
| Protel_Resforc_RateCode_V001 | Imports from an XML file with file name pattern: ResForc*.xml Same as Protel_Resforc_MarketCode_V001 with the exception that instead of using the attribute from Market element it uses the attributes from RateCode and in the description it uses “Rate Code” instead of “Market Code”. |
| Columns | Name |
|---|---|
| 1 | Not used |
| 2 | Date |
| 3 | Availableroom |
| 4 | Not used |
| 5 | Roomnights |
| 6-11 | Not used |
| 12 | Guestnights |
| 13-15 | Not used |
| 16 | Roomrevenue |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date/OTB Date | Mandatory | Directly mapped from source file | Date | In the format dd.MM.yyyy |
| 2 | Description | Description | Optional | Directly mapped from source system | Not used | |
| 3 | Revenue | Revenue without authority charge rates | Mandatory | Directly mapped from source file | Roomrevenue | |
| 4 | Room nights | Number of room nights | Mandatory | Directly mapped from source file | Roomnights | |
| 5 | Guest nights | Number of room guests | Mandatory | Directly mapped from source file | Guestnights |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date/OTB Date | Mandatory | Directly mapped from source file | Date attribute from Day element | |
| 2 | Description | Description | Optional | Directly mapped from source system | Not used | |
| 3 | Revenue | Revenue without authority charge rates | Mandatory | Directly mapped from source file | RRev attribute from Day element | |
| 4 | Room nights | Number of room nights | Mandatory | Directly mapped from source file | Rn attribute from Day element | |
| 5 | Guest nights | Number of room guests | Mandatory | Directly mapped from source file | Ad attribute from Day element | Adults only |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data transformation/load rules | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction Date/OTB Date | Mandatory | Directly mapped from source file | Date attribute from Day element | |
| 2 | Description | Description | Optional | Directly mapped from source system | Market code: {Code attribute} | Where the code attribute comes from the Market element within the Day element. |
| 3 | Revenue | Revenue without authority charge rates | Mandatory | Directly mapped from source file | RRev attribute from Market element within Day element | |
| 4 | Room nights | Number of room nights | Mandatory | Directly mapped from source file | Rn attribute from Market element within Day element | |
| 5 | Guest nights | Number of room guests | Mandatory | Directly mapped from source file | Ad+Ch attribute from Market element within Day element | Adults + Children |