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 LastDisclosureValue. 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 |
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 | X |
Data Requirements
IssuerId
needs 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
1010,Legal,101,AU039682961,3060215,Wesfarmers,Disclosure,6.2,2018-08-05
1019,Voting,100,AT292972016,6792031,Red Bull GmbH,Disclosure,4.08,2018-12-21
1020,Voting,100,AT292972016,6792031,Red Bull GmbH,Disclosure,4.08,2018-12-21
1816,Legal,100,US0378331005,1059122,Apple,Disclosure,5.59,2018-10-31
1270,Legal,100,CNE000000W05,1269110,China CSSC,Disclosure,6.01,2018-10-19
1270,NULL,14,CNE000000W05,1269110,China CSSC,Disclosure,6.01,2018-10-19
Updated 3 months ago