SCD feed for IC_AA
Purpose / Description
SCD as a data source does already provide data for group clients in fee model commission calculation. For IC and AA, there will be a dedicated monthly feed
The SCD file will be copied multiple times to feed in relevant data such as:
- Products
- Assigning products to product pools
- Counterparties ( = Asset Owners)
- Portfolios
- Value of assets held for clean and dirty value
The below mapping allows to identify which data from the file is taken to derive the above information.
Use Case
| As a system I want to import holdings from the SCD monthly feed. Based on these holdings the system needs to calculate fees. | |
| Primary Actor(s) | FSC |
| Stakeholders and Interest | Invoice reviewer, Invoice manager |
| Trigger | Import of the file with dedicated naming convention |
| Pre-condition(s) |
The file has the agreed naming convention, the file is formatted in csv. |
| Post-condition(s) | The file is processed by FSC and results are visible in the session monitor |
| Main success scenario |
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 |
| Extensions |
See separate use case for cloning file to produce portfolio-counterparty links Counterparty creation Product creation Clean vs dirty value asset valuation |
| Exception scenarios |
The import is done monthly. Quarterly and monthly agreements which are calculated based on 'last day of period' will be automatic. Calculations based on for example:
will not be automatic. Please contact FinSoft for these agreements as these need to be sourced via the standard template with pre-calculated values.
|
| Special requirements | |
| Open questions |
Mockup
Functional Requirements
| Business rules and functional requirements |
| The portfolio source system will be mapped to SCD |
| File needs to be copied so that both clean and dirty value (held in different columns - location tbc) can be imported. To differentiate between them product external ref (G-Depot) will be extended with _CV for clean value and _DC for dirty value both are aligned with the relative columns containing the valuation |
|
Upon import of the file, product groups will be created. Upon creation, all products ( no differentiation by instrument type or group) are added to the newly created product groups depending on their currency and per valuation (clean vs dirty value). The product groups are created based on the following pattern: All_SCD_Products_<CV or DV>_<Currency>
Examples: All_SCD_Products_CV_EUR All_SCD_Products_DV_EUR All_SCD_Products_CV_USD All_SCD_Products_DV_USD
The link start date for products will be set to 01/01/2026. Ongoing maintenance of links: Any new products found in the file are added to the product group with the start date of 01/01/2026. If a product is no longer delivered in the file, the link remains open. If, for any reason the link needs to be ended, the user need to manually set an end date to the link. |
|
Counterparties are created upon import. |
Field level specification
|
FSC Usage |
SCD column |
Rules |
Size |
Mandatory |
|
Entity |
Take from file name |
Default to AMG |
3 |
No |
|
ISIN |
SCD_CV/SCD_DV |
|
50 |
No |
|
Portfolio external ref |
G - Depot |
|
50 |
Yes |
|
Portfolio code |
G - Depot |
|
50 |
Yes |
|
Portfolio name |
G - Depot |
|
255 |
Yes |
|
Product name |
J- Security Name |
|
100 |
Yes |
|
Product short name |
H- SCD Security ID |
|
50 |
Yes |
|
Product external ref |
H- SCD Security ID |
|
50 |
Yes |
|
Product currency |
K- Currency |
Confirm if always linked to clean vs dirty value |
3 |
Yes |
|
Counterparty name |
A- Invoice Group |
|
100 |
Yes |
|
Counterparty Code |
A- Invoice Group |
|
50 |
Yes |
|
Counterparty external reference |
A- Invoice Group |
|
50 |
Yes |
|
Shares ( = AUM) Dirty Value/ Clean Value |
P- Clean Value EUR Adjusted Q- Dirty Value EUR |
|
No limit |
Yes |
|
Date |
Cut off date from File name |
Applies also for Link start date for new - Counterparty portfolio links - Product product group links - Portfolios - Products |
N/A |
Yes |
|
Product group creation |
H- Security ID
|
|
255 |
Yes |
|
K - Currency |
|
|||
|
Office/ Asset Manager allocation |
B-Asset Manager |
Is needed to invoice only portfolios linked to specific offices |
N/A |
Yes |
Link product(s) to product group
|
Product ext ref |
Asset Manager |
Exclusions |
Column / Logic |
Link to Product group |
|
H-SCD Security ID |
All |
Nicht relevant
|
Combine H- Security ID with CV/DV and K-Currency |
Link to start on 01/01/2026 |
Link portfolio(s) to counterparty
Data validation failure response
| Problem | Visibility | Behaviour | Data dependencies | Additional information |
| Mandatory fields missing | Alert in session monitor | Line is not imported | ||
| Fields relate to data not existing (e.g. counter party, subservice etc) | Alert in session monitor | Line is not imported | Set up of sub service and counterparty in FSC prior import | |
| Wrong naming convention | Alert in session monitor | File is not imported | ||
| Negative AUM or AUA values | None | Lines are imported. | If these are not netted off the user can cap the invoice amount at Zero via constraints functionality | |
| File with same name is imported twice | None | Existing lines are overwritten if new data is different from old data. New lines will be added | Matching is done on product/portfolio/subservice and transaction external reference is identical |