PMS – Skidata

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 interface in question are changed throughout the interface life-cycle.
The imported files are in XML format and follow the file name pattern: *PMITICKET*

Interface name incl. versionComment
Skidata_Pos_V001The file is in XML format
#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesData element (source)Comment
1DateTransaction dateMDateDay_Closure_UntilTransformed to date format yyyy-MM-dd
2DepartmentName of the departmentMDirectly mapped from source fileTicket_pool
3AccountID or name of the accountMDirectly mapped from source systemCategory_Name
4DescriptionDescriptionMDirectly mapped from source systemTicket_Designation
5RevenueRevenue without authority charge ratesMDirectly mapped from source fileTotal_Revenue
6CoversNumber of coversMDirectly mapped from source fileRevenue_Transactions

Download an example of the source file format: File:Skidata Pos

Was this article helpful?

Related Articles