The FAQ addresses the fact that It is possible for a DSB FDL File (eg: totv-v2 ToTV-SC-20201108.records) to include more than one record for a particular ISIN.

This is a rare occurrence, but may happen when ESMA/the FCA publish data on FIRDS/FITRS after a set cut-off time and so the DSB may still be having unprocessed data for an ISIN, from the previous day, when a new data is received. This will result in multiple records for the same ISIN being recorded and so it is important for the user community to understand how these records should be handled.

Under these circumstances, the DSB recommends that the user should access the ToTV record with the latest LastModifiedDate, as that would have a complete dataset for that ISIN on that day.

An example of this can be seen in totv-v2 ToTV-SC-20201108.records file, where there is a duplicate entry for ISIN: EZQX7JBRY370:

{“ToTV-record”:{“version”:”2″,”Header”:{“ISIN”:”EZQX7JBRY370“,”LastCompletedProcessingDate”:”2020-11-08″,”LastModifiedDate”:”2020-11-07“},”DSB-ISIN”:{“TemplateVersion”:1,”Header”:{“AssetClass”:”Credit”,”InstrumentType”:”Swap”,”UseCase”:”Corporate”,”Level”:”InstRefDataReporting”},”ISIN”:{“ISIN”:”EZQX7JBRY370″,”Status”:”New”,”StatusReason”:””,”LastUpdateDateTime”:”2020-03-18T13:06:11″},”Derived”:{“FullName”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”ClassificationType”:”SCUCCA”,”CommodityDerivativeIndicator”:”FALSE”,”IssuerorOperatoroftheTradingVenueIdentifier”:”NA”,”ShortName”:”NA/CDS Corp SN Sr USD 20240320″,”UnderlyingAssetType”:”Single Name”,”ReturnorPayoutTrigger”:”Credit Default”,”UnderlyingIssuerType”:”Corporate”},”Attributes”:{“NotionalCurrency”:”USD”,”ExpiryDate”:”2024-03-20″,”Underlying”:{“InstrumentISIN”:”XS1806368897″},”DebtSeniority”:”SNDB”,”DeliveryType”:”OPTL”,”PriceMultiplier”:1}},”EU”:{“Derived”:{“ToTV”:false,”uToTV”:true,”uToTV-EffectiveDate”:”2007-11-01″},”RefDataRecords”:{“MTF”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20″,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”CXRT”,”FrstTradDt”:”2020-11-06T00:00:00Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-07″},”RlvntTradgVn”:”CXRT”}}}]}},”UK”:{“Derived”:{“ToTV”:false,”uToTV”:true,”uToTV-EffectiveDate”:”2016-12-01″},”RefDataRecords”:{“MTF”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20Z”,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”CXRT”,”FrstTradDt”:”2020-11-06T00:00:00Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-06Z”},”NvrPblshd”:false,”RlvntTradgVn”:”CXRT”}}}]}}}}

{“ToTV-record”:{“version”:”2″,”Header”:{“ISIN”:”EZQX7JBRY370“,”LastCompletedProcessingDate”:”2020-11-08″,”LastModifiedDate”:”2020-11-08“},”DSB-ISIN”:{“TemplateVersion”:1,”Header”:{“AssetClass”:”Credit”,”InstrumentType”:”Swap”,”UseCase”:”Corporate”,”Level”:”InstRefDataReporting”},”ISIN”:{“ISIN”:”EZQX7JBRY370″,”Status”:”New”,”StatusReason”:””,”LastUpdateDateTime”:”2020-03-18T13:06:11″},”Derived”:{“FullName”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”ClassificationType”:”SCUCCA”,”CommodityDerivativeIndicator”:”FALSE”,”IssuerorOperatoroftheTradingVenueIdentifier”:”NA”,”ShortName”:”NA/CDS Corp SN Sr USD 20240320″,”UnderlyingAssetType”:”Single Name”,”ReturnorPayoutTrigger”:”Credit Default”,”UnderlyingIssuerType”:”Corporate”},”Attributes”:{“NotionalCurrency”:”USD”,”ExpiryDate”:”2024-03-20″,”Underlying”:{“InstrumentISIN”:”XS1806368897″},”DebtSeniority”:”SNDB”,”DeliveryType”:”OPTL”,”PriceMultiplier”:1}},”EU”:{“Derived”:{“ToTV”:false,”uToTV”:true,”uToTV-EffectiveDate”:”2007-11-01″},”RefDataRecords”:{“MTF”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20″,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”CXRT”,”FrstTradDt”:”2020-11-06T00:00:00Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-07″},”RlvntTradgVn”:”CXRT”}}}],”SI”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20″,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”DBES”,”FrstTradDt”:”2020-11-06T04:11:35Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-08″},”RlvntTradgVn”:”CXRT”}}}]}},”UK”:{“Derived”:{“ToTV”:false,”uToTV”:true,”uToTV-EffectiveDate”:”2016-12-01″},”RefDataRecords”:{“MTF”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20Z”,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”CXRT”,”FrstTradDt”:”2020-11-06T00:00:00Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-06Z”},”NvrPblshd”:false,”RlvntTradgVn”:”CXRT”}}}],”SI”:[{“NewRcrd”:{“DerivInstrmAttrbts”:{“UndrlygInstrm”:{“Sngl”:{“ISIN”:”XS1806368897″}},”PricMltplr”:1,”XpryDt”:”2024-03-20Z”,”DlvryTp”:”OPTL”},”Issr”:”549300X2X6FG1ZZO4603″,”FinInstrmGnlAttrbts”:{“ShrtNm”:”NA/CDS Corp SN Sr USD 20240320″,”FullNm”:”Credit Swap Corporate Single Name XS1806368897 USD 20240320″,”Id”:”EZQX7JBRY370″,”NtnlCcy”:”USD”,”CmmdtyDerivInd”:false,”ClssfctnTp”:”SCUCCA”},”TradgVnRltdAttrbts”:{“IssrReq”:false,”TermntnDt”:”2024-03-20T23:59:59Z”,”Id”:”DBES”,”FrstTradDt”:”2020-11-06T04:11:35Z”},”TechAttrbts”:{“RlvntCmptntAuthrty”:”GB”,”PblctnPrd”:{“FrDt”:”2020-11-08Z”},”NvrPblshd”:false,”RlvntTradgVn”:”CXRT”}}}]}}}}

The record with LastModifiedDate of 2020-11-08 in the example is the latest dataset for ISIN: EZQX7JBRY370 on 2020-11-08.

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SIGN UP NOW

I would like to subscribe to: