Imported Disclosures
Workflow for declaring imported disclosures
When implementing our product SD, please check if you have made a disclosure in one of the countries that require the last disclosed value or last filing submission date. Please read more about it here. Furthermore, you can find a sample file here. Unlike the the other import files, these should be sent to [email protected] as we upload directly into the databases.
| Column Name | Description | Data type | Required |
|---|---|---|---|
| RuleID | ID of the rule for which this disclosure was made | String(255) | X |
| AggregationName | The aggregation structure where the rule triggered on | String(255) | X |
| PortfolioOrEntityID | ID of portfolio/entity where the rule triggered | String(255) | X |
| ISIN | ISIN of the instrument which triggered the rule | String(255) | X |
| IssuerId | ID of the issuer | String(255) | X |
| IssuerName | Name of the issuer | String(255) | X |
| ResultType | Type of result. The input should be “Disclosure” for all line items. | String(255) | X |
| Value | Ownership Percentage At Filing: Inputting 6.25 here is equivalent to 6.25% | Decimal(28,8) | X |
| Date | Date of disclosure. This must reference the actual trade date when the disclosure value was calculated. Choosing a weekend is not valid | Date(YYYY-MM-DD) | X |
| FiledDate | Date of filing. This must be the date this disclosure was filed to the regulator NOT the position date | Date(YYYY-MM-DD) |
Data Requirements
IssuerIdneeds to be needs to be consistent throughout time so that the system can link the imported disclosure to another disclosure in the future.
Example File
RuleID,AggregationName,PortfolioOrEntityID,ISIN,IssuerId,IssuerName,ResultType,Value,Date,FiledDate
1010,Legal,101,AU039682961,3060215,Wesfarmers,Disclosure,6.2,2018-08-05,2018-08-06
1019,Voting,100,AT292972016,6792031,Red Bull GmbH,Disclosure,4.08,2018-12-21,2018-12-22
1020,Voting,100,AT292972016,6792031,Red Bull GmbH,Disclosure,4.08,2018-12-21,2018-12-22
1816,Legal,100,US0378331005,1059122,Apple,Disclosure,5.59,2018-10-31,2018-12-31
1270,Legal,100,CNE000000W05,1269110,China CSSC,Disclosure,6.01,2018-10-19,2018-10-20
1270,NULL,14,CNE000000W05,1269110,China CSSC,Disclosure,6.01,2018-10-19,2018-10-20Updated 14 days ago