Understanding the Data Export Import Utility

PeopleSoft Financials delivers the Data Export Import Utility, which is a data-mapping utility that empowers you to map fields easily and to interface both incoming and outgoing data between source and target. The data set for the source and target can be in XML, flat file, fixed, or record formats. Examples of typical uses for this mapping utility are:

• Importing external data from third-party systems.

• Exporting data to third-party systems.

• Creating payment files by format.

• Creating statutory audit files.

You can map simple structures or modify complex mappings without having to alter the underlying PeopleCode, thus avoiding customizations. The Data Export Import Utility applies transformation rules to format the data with controls in order to meet third-party system requirements.