Understanding File Integration Framework

The File Integration Framework is a guided process that assists users in creating Flat files such as Benefits AD&D, PNA Direct deposit etc. It is a setup driven configurable framework to generate flat files. Users do not have to customize the SQR to generate the files.

Using this, users can:

  • Set row level security to the data in the flat file configuration components.

  • Define constants and system variables that can be used in the flat file output.

  • Configure the output file type.

  • Order and format the output columns.

  • Preview and generate the file.

This diagram illustrates the File Integration Wizard process flow to generate flat files.

File Integration Wizard process flow to generate flat files