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 has 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.
| Interface name incl. version | Comment |
|---|---|
| RTP_POS_V001 | Retrieving actual data |
| RTP_POS_HIDMAP_V001 | Using Hierarchy mapping for Grand America – Sun Valley; see mapping details below |
| Column | Name |
|---|---|
| 1 | Date |
| 2 | Not used |
| 3 | Segment2 |
| 4 | Segment3 |
| 5 | Not used |
| 6 | Department |
| 7 | Description |
| 8 | Revenue |
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Date | Transaction date | M | Date | ||
| 2 | Department | ID or name of the department | O | Department | ||
| 3 | Account | ID or name of the account | M | Segment2 | ||
| 4 | Description | Account description | O | Description | ||
| 5 | Revenue | Revenue without authority charge rates | M | Revenue |
Download an example of the source file format: File:CJx.txt {| class=”wikitable”|+ style=”text-align:left;” |- Interface mapping|- style=”vertical-align:top;” ! Segment2 !! Segment3 !! -|Hierarchy ID|-|1||2100||277||}
Download an example of source file format: File:CJx.txt