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.

Image: File Integration Wizard process flow to generate flat files

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

File Integration Wizard process flow to generate flat files