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 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 interface in question are changed throughout the interface life-cycle. The two adapters that are now used are utilizing XML data retrieved from a web service. The web service creates a separate file for each restaurant based on the tag.
| Interface name incl. version | Description |
|---|---|
| 2Book_Otb_V001 | Deprecated, use one of the other interfaces instead |
| 2Book_OtbTentative_V001 | Registers the number of guests as room nights tentative |
| 2Book_OtbCovers | Registers the number of guests as covers/units. |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | OTB date | Mandatory | Direct mapping from source file | Date | |
| 2 | Department | ID or name of the department | Mandatory | Direct mapping from source file | Area | |
| 3 | Account | ID or name of the account | Optional | Not in source file | ||
| 4 | Description | Account description | Mandatory | Direct mapping from source file | Type | |
| 5 | Revenue | Revenue without authority charge rates | Mandatory | Direct mapping from source file | Amount | |
| 6 | Covers | Number of covers | Mandatory | Direct mapping from source file | NrOfGuests | See the interfaces for specific handling of this value |