Import Formats determine which fields (columns) are extracted from the source system and how the data is stored in the FDMEE staging table. Import Formats are created for a single accounting entity. However, if you are importing data from multiple accounting entities that have the same Chart of Accounts, you can define one Import Format using a representative accounting entity, and then use it for importing data for all accounting entities with the same Chart of Accounts.
You define import formats to map source segments or chartfields to target dimensions. You can create import formats to:
Define the import format mapping between the source system segments or chartfields and the dimensions (used in the metadata load and data load process).
Define the import format mapping between the EPM dimensions and the source system segments or chartfields (used in the write-back process).
Define and maintain import format mapping information for source adapter based integrations
Define and maintain import format mapping information between source and target EPM dimensions for data synchronization.
Note: | You do not need to define import mappings for use with human resources source systems. This is only applicable to the rebuilt Peoplesoft HCM integration. |
You work with import formats on the Import Format screen, which consists of three sections:
Import Format Summary—Displays common information relevant to the source and target applications.
Import Format Detail—Enables you to add and maintain import format information.
Import Format Mappings—Enables you to add and maintain import format mapping information.