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