SCD feed for IC_AA (Fee model commission calculation)

The file has the agreed naming convention, the file is formatted in csv. 

FSC picks the file up from the defined storage place. After some pre-processing (see separate use case) the data is imported.

Any error are visible in the session monitor.

The computation is kicked off after successful import 

Multiple copies of the file need to be taken to:

- produce portfolio-counterparty links

- Counterparty creation and maintenance

- Product creation and maintenance

- Product group creation and maintenance

- Clean vs dirty value asset valuation 

Note : The import is done monthly. Quarterly and monthly agreements which are calculated based on 'last day of period'  can be handled in FSC directly 

Calculations based on for example:

• average of 2 or 3 month end positions 
• leveraged by number of day in quarter  

will not be automatic. Please contact FinSoft for these agreements as these need to be sourced via the standard template with pre-calculated values and the values from the SCD file excluded to avoid double invoicing 

Both columns for clean value PC (column P) and dirty value PC (column Q) show values in EUR. If in the future, there are values from other currencies delivered, the file needs to be enhanced with a logic to identify the match between value and currency for all cases, Please note that the user will not be able to detect if there is a USD valuation in the file. 

File needs to be copied, so that both clean and dirty value (held in columns P and Q) can be imported. So each product will have a value for clean and for dirty value. 

To differentiate the valuation between them, the product external ref (G-Depot) will be extended with _CV for clean value. For Dirty value the product external reference remains unchanged.  Each of the products is then aligned with the relative columns containing the valuation.

The currency of the values in columns P and Q is hardcoded to EUR.  If any other currency will be delivered in the future in these columns, the import process will need to be reviewed.

Upon import of the file, (new) products will be created in FSC. Due to the two different valuations mentioned in the previous rule, each product needs to exist twice: Once with clean valuation and once with dirty valuation.

To differentiate between the products, the dirty valuation is linked to the initial Product external reference (H-SCD Security ID)  and the clean valuation will be linked to the Product external reference_CV (H-SCD Security ID).

Example.

The product external reference (H-SCD Security ID). in the file is LU0123456789.

The import creates two products

1) LU0123456789

2) LU0123456789_CV

The product name is taken as it is for both products from the file, The short name for clean value will show the product external reference_CV

For these products, different valuations will then be imported

1) LU0123456789 - Asset value (Nr of shares) taken from  column Q - Dirty value PC

2) LU0123456789_CV - Asset value (Nr of shares) taken from column P -Clean value PC

Another import process is the creation and maintenance of product groups. With the initial import, all products (no differentiation by instrument type or group) are added to the newly created product groups depending on their valuation  (clean vs dirty value). 

The two product group will be: 

All_SCD_IC_Products_CV (containing the products with initial product external reference (SCD Security ID) 

All_SCD_IC_Products_DV (containing the products with initial product external reference (SCD Security ID) 

The link start date for products will be set to 01/01/2026.

Ongoing maintenance of links:

Any new product(s) found in the file, are added to the product group(s) with the start date of 01/01/2026.

If a product is no longer delivered in the file, the link remains open nevertheless. 

If, for any reason, the link needs to be ended, the user need to manually set an end date to the link.

Counterparties are also created and maintained upon import. Same for links from portfolios to counterparties. These will start at 01/01/2026. For ongoing maintenance, any new portfolios will be added with same start end. If a portfolio is no longer part of the file, the link remains open. The termination of link(s) needs to be initiated by the user. 

File naming convention should be LiquidAssets_IC_YYYYMMDD where the date should be when the extract is taken or uploaded.

The process in FSC is to multiply a number of shares ( Columns Q and P) with a NAV price to valuate the assets. 

In this specific case, we take the number in columns Q and P and assume a NAV price of 1.