PMS – Fidelio

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.
The file name pattern is: Res*f*c*t*

Interface name incl. versionComment
Fidelio_resfct_V001Retrieving OTB Revenue, rooms and guests
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesdata element (source)Comment
1DateOTB dateMDirectly mapped from source fileCHAR_RESERVATION_DATEIn the format dd.MM.yy
2DescriptionDescriptionMDirectly mapped from source systemMARKET_CODE
3RevenueRevenue without authority charge ratesMDirectly mapped from source fileTOTAL_DEFINITE_REVENUE
4Room nightsNumber of room nightsMDirectly mapped from source fileNO_DEFINITE_ROOMS
5Guest nightsNumber of room guestsMDirectly mapped from source fileNO_DEFINITE_GUEST

Output examples for download:

Was this article helpful?

Related Articles