Setup flat-file ingestion stream(s)

To start, setup a FFIP stream for the 1-2 314(a) files clients will download from FinCen's portal every ~2 weeks.

If the client has both persons and businesses on their platform, they will need to setup both streams. If they just have one or the other, they will need one stream. Both streams are of type 'entity.'

To setup the persons stream, see screenshots below.

Outside of the screenshots showing the mapping of the file to the Unit21 values and hard-coded values, there is one transformation:

1. Unit21 entity id --> find and replace all from an empty space (' '); this is to get all empty space values out of the id column

In addition, you will notice the relationship that needs to be setup for the 314(a) alias information. The relationship can be setup on the 'Relationships' tab in 'Data Management' and should look like this:

To setup the business stream, see the screenshots below.

Outside of the screenshots showing the mapping of the file to the Unit21 values and hard-coded values, there is one transformation:

1. Unit21 entity id --> find and replace all from an empty space (' ') to nothing ("); this is get all empty space values out of the id column.

In addition, you will notice the relationship needs to be setup for the 314(a) DBA information. The relationship can be setup on the 'Relationships' tab in 'Data Management' and should look like this: