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.

PMI data element (target) Comment
Micros_revenue_V001 File name pattern: *.csv. Space delimited.
Micros_revenue_V002 File name pattern: *.csv. Comma delimited.
Micros_revenue_V003 Not currently used
Micros_revenue_V004 File name pattern: 20*.txt. Semicolon delimited. UTF-8 Encoding.
Micros_revenue_V005 File name pattern: Micro*.txt
Micros_revenue_V006 File name pattern: {chain custom}*.csv
Micros_Covers_V100 File name pattern: micros_covers_MIDd{3}_HID001_DIDd{3}.txt
# Name V001 Name V002 Name V003 Name V004 Name V004 Name V006 Name Covers V100
1 Not used Not used Date Date Date Property ServicePeriod
2 Date Date Department Hour Account Department FoodCover
3 Account Not used Account Department Department Date Not used
4 Not used Not used Description Account Revenue Account
5 Description Not used Revenue Description Description Meal period
6 Department Description Revenue Not used Covers
7 Not used Department Covers Revenue
8-13 Not used Not used
14 Revenue Not used
15 Revenue
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date Transaction Date Mandatory Direct mapping from source file Date
2 Description Description Mandatory Direct mapping from source file Description All versions except V004/V006
3 Description Description Mandatory {Description} – Hours: {Hour} Description and Hour V004 only
4 Description Description Mandatory Meal period : {Meal period} Description V006 only
5 Department Department Mandatory Directly mapped from source file Department
6 Account Account Mandatory Directly mapped from source file Account
7 Revenue Revenue without authority charge rates Mandatory Directly mapped from source file Revenue
8 Covers/Units Covers/Units Mandatory Directly mapped from source file Covers V004/V006 only
# PMI data element (target) Description Mandatory / Optional Data transformation/load rules Data element (source) Comment
1 Date Transaction Date Mandatory The previous day’s date In short date format
2 Description Description Mandatory Food Cover – Service Period {ServicePeriod} ServicePeriod
3 Department Department Mandatory Taken from the file name Last 2 digits from the 3 after DID
4 Account Account Mandatory Hard coded to 0
5 Covers/Units Covers/Units Mandatory Directly mapped from source file FoodCover

Output examples for download:

Flat file in CSV format for Micros_revenue interface:

Flat file in CSV format for Micros_Covers interface: