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.
|
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 |
With offices as underscore e.g. _MEAG MUC/_MEAG HK/_VU/_MEAG NY |
100 |
Yes |
|
Counterparty Code |
A- Invoice Group |
Referred with underscore and all in capital letters: e.g. ERGO_SU MROM +_(office) (same as for counterparty name) |
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 |
1.1.3. Assignment of Product groups
|
Product ext ref |
Asset Manager |
Exclusions |
Column / Logic |
Link to Product group |
|
H-SCD Security ID |
All |
Nicht relevant
|
U- InstrumentGroup_L- Currency Group |
Combine U- Instrument Type Group with L- Currency Group |
| SCD Columns | Description | FinSoft internal mapping | Data type | Mandatory | Sample data |
| Fee Date (x) | Date which defines the fee period | Rebate date | Date, dd.mm.yyyy | Yes | 31.03.2026 |
| N/A | Create a unique reference for the entry by combining Fee Date_Portfolio_Product | Transaction external reference | String 50 characters, case sensitive | Yes | 31012026_PK7500D00_XS1076018305 |
| SCD Security ID (H) | Refers to which Assets/projects etc are being invoiced | Product external reference | String 50 characters, case sensitive | No | XS123456789 |
| Depot (G) | Refers to the account/portfolio etc were assets are located | Portfolio External reference | String 50 characters, case sensitive | Yes | SX7108984664 |
| N/A | Here the fixed value SCD should be used. | Portfolio source system | String, 255 characters, case sensitive | Yes | SCD |
| N/A | Refers to the sub service under which the data is invoiced | Sub Service code | String, 50 characters | Yes | AdmFee, TravelCost, PerfFee etc |
|
(P) Dirty Value QC |
The Amount which is the basis of the fee calculation- here : AUA | AUM (Fee Base Amount) | Real, 14,4 | No | 1.765,00 |
|
(Q) Dirty Value PC |
The Amount which is the basis of the fee calculation - here: AUA |
AUA (Fee Base Amount) | Real, 14,4 | No | 1.500,00 |
|
(K) Currency |
The currency of the fee base amount (see above) | Fee Base Amount CCY | ISO Currency code | No | EUR |
|
Period From |
Default to first day of the month from column X |
Statement start date |
Date ddd.mm.yyyy |
Yes | 01.01.2026 |
|
(X) Fee date |
The end date of the period for which the fees are invoiced. (example 31.03.2026) . This will appear on the invoice ! | Statement end date |
Date dd.mm.yyyy |
Yes | 31.03.2026 |
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 |