Search Legislation

Commission Implementing Regulation (EU) No 1247/2012Show full title

Commission Implementing Regulation (EU) No 1247/2012 of 19 December 2012 laying down implementing technical standards with regard to the format and frequency of trade reports to trade repositories according to Regulation (EU) No 648/2012 of the European Parliament and of the Council on OTC derivatives, central counterparties and trade repositories (Text with EEA relevance)

 Help about what version

What Version

More Resources

 Help about UK-EU Regulation

Legislation originating from the EU

When the UK left the EU, legislation.gov.uk published EU legislation that had been published by the EU up to IP completion day (31 December 2020 11.00 p.m.). On legislation.gov.uk, these items of legislation are kept up-to-date with any amendments made by the UK since then.

Close

This item of legislation originated from the EU

Legislation.gov.uk publishes the UK version. EUR-Lex publishes the EU version. The EU Exit Web Archive holds a snapshot of EUR-Lex’s version from IP completion day (31 December 2020 11.00 p.m.).

Status:

This is the original version as it was originally adopted in the EU.
This legislation may since have been updated - see the latest available (revised) version

ANNEX

Table 1

Counterparty Data

FieldFormat
Parties to the contract
1Reporting timestampISO 8601 date format / UTC time format.
2Counterparty IDLegal Entity Identifier (LEI) (20 alphanumerical digits), interim entity identifier (20 alphanumerical digits), BIC (11 alphanumerical digits) or a client code (50 alphanumerical digits).
3ID of the other Counterparty

Legal Entity Identifier (LEI) (20 alphanumerical digits),

interim entity identifier (20 alphanumerical digits),

BIC (11 alphanumerical digits) or a

client code (50 alphanumerical digits).

4Name of the counterparty100 alphanumerical digits or blank in case of coverage by Legal Entity Identifier (LEI).
5Domicile of the counterparty500 alphanumerical digits or blank in case of coverage by Legal Entity Identifier (LEI).
6Corporate sector of the counterparty

Taxonomy:

A

=

Assurance undertaking authorised in accordance with Directive 2002/83/EC;

C

=

Credit institution authorised in accordance with Directive 2006/48/EC;

F

=

Investment firm in accordance with Directive 2004/39/EC;

I

=

Insurance undertaking authorised in accordance with Directive 73/239/EEC;

L

=

Alternative investment fund managed by AIFMs authorised or registered in accordance with Directive 2011/61/EU;

O

=

Institution for occupational retirement provision within the meaning of Article 6(a) of Directive 2003/41/EC;

R

=

Reinsurance undertaking authorised in accordance with Directive 2005/68/EC;

U

=

UCITS and its management company, authorised in accordance with Directive 2009/65/EC; or

blank in case of coverage by Legal Entity Identifier (LEI) or in case of non-financial counterparties.

7Financial or non-financial nature of the counterpartyF=Financial Counterparty, N=Non-Financial Counterparty.
8Broker ID

Legal Entity Identifier (LEI) (20 alphanumerical digits),

interim entity identifier (20 alphanumerical digits),

BIC (11 alphanumerical digits) or a client code (50 alphanumerical digits).

9Reporting entity ID

Legal Entity Identifier (LEI) (20 alphanumerical digits),

interim entity identifier (20 alphanumerical digits),

BIC (11 alphanumerical digits) or a

client code (50 alphanumerical digits).

10Clearing member ID

Legal Entity Identifier (LEI) (20 alphanumerical digits),

interim entity identifier (20 alphanumerical digits),

BIC (11 alphanumerical digits) or a

client code (50 alphanumerical digits).

11Beneficiary ID

Legal Entity Identifier (LEI) (20 alphanumerical digits),

interim entity identifier (20 alphanumerical digits),

BIC (11 alphanumerical digits) or a

client code (50 alphanumerical digits).

12Trading capacityP=Principal, A=Agent.
13Counterparty sideB=Buyer, S=Seller.
14Trade with non-EEA counterpartyY=Yes, N=No.
15Directly linked to commercial activity or treasury financingY=Yes, N=No.
16Clearing thresholdY=Above, N=Below.
17Mark to market value of contractUp to 20 numerical digits in the format xxxx,yyyyy.
18Currency of mark to market value of the contractISO 4217 Currency Code, 3 alphabetical digits.
19Valuation dateISO 8601 date format.
20Valuation timeUTC time format.
21Valuation typeM=mark to market / O=mark to model.
22CollateralisationU=uncollateralised, PC= partially collateralised, OC=one way collateralised or FC=fully collateralised.
23Collateral portfolioY=Yes, N=No.
24Collateral portfolio codeUp to 10 numerical digits.
25Value of the collateralSpecify the value the total amount of collateral posted; up to 20 numerical digits in the format xxxx,yyyyy.
26Currency of the collateral valueSpecify the currency of field 25; ISO 4217 Currency Code, 3 alphabetical digits.

Table 2

Common Data

FieldFormatApplicable types of derivative contract
Section 2a - Contract typeAll contracts
1Taxonomy used

Identify the taxonomy used:

U

=

Product Identifier [endorsed in Europe]

E

=

Interim taxonomy

2Product ID 1

For taxonomy = U:

Product Identifier (UPI), to be defined

For taxonomy = I:

ISIN or AII,

12 digits alphanumerical code

For taxonomy = E:

Derivative class:

CO

=

Commodity

CR

=

Credit

CU

=

Currency

EQ

=

Equity

IR

=

Interest Rate

OT

=

Other

3Product ID 2

For taxonomy = U

Blank

For taxonomy = I

CFI, 6 characters alphabetical code

For taxonomy = E:

Derivative type:

CD

=

Contracts for difference

FR

=

Forward rate agreements

FU

=

Futures

FW

=

Forwards

OP

=

Option

SW

=

Swap

OT

=

Other

4Underlying

ISIN (12 alphanumerical digits);

LEI (20 alphanumerical digits);

Interim entity identifier (20 alphanumerical digits);

UPI (to be defined);

B

=

Basket;

I

=

Index.

5Notional currency 1ISO 4217 Currency Code, 3 alphabetical digits.
6Notional currency 2ISO 4217 Currency Code, 3 alphabetical digits.
7Deliverable currencyISO 4217 Currency Code, 3 alphabetical digits.
Section 2b - Details on the transactionAll contracts
8Trade IDUp to 52 alphanumerical digits.
9Transaction reference numberAn alphanumeric field up to 40 characters
10Venue of execution

ISO 10383 Market Identifier Code (MIC), 4 digits alphabetical.

Where relevant, XOFF for listed derivatives that are traded off-exchange or XXXX for OTC derivatives.

11CompressionY = if the contract results from compression; N= if the contract does not result from compression.
12Price / rateUp to 20 numerical digits in the format xxxx,yyyyy.
13Price notationE.g. ISO 4217 Currency Code, 3 alphabetical digits, percentage.
14Notional amountUp to 20 numerical digits in the format xxxx,yyyyy.
15Price multiplierUp to 10 numerical digits.
16QuantityUp to 10 numerical digits.
17Up-front paymentUp to 10 numerical digits in the format xxxx,yyyyy for payments made by the reporting counterparty and in the format xxxx,yyyyy for payments received by the reporting counterparty.
18Delivery typeC=Cash, P=Physical, O=Optional for counterparty.
19Execution timestampISO 8601 date format / UTC time format.
20Effective dateISO 8601 date format.
21Maturity dateISO 8601 date format.
22Termination dateISO 8601 date format.
23Settlement dateISO 8601 date format.
24Master Agreement typeFree Text, field of up to 50 characters, identifying the name of the Master Agreement used, if any.
25Master Agreement versionYear, xxxx.
Section 2c - Risk mitigation / ReportingAll contracts
26Confirmation timestampISO 8601 date format, UTC time format.
27Confirmation meansY=Non-electronically confirmed, N=Non-confirmed, E=Electronically confirmed.
Section 2d - ClearingAll contracts
28Clearing obligationY=Yes, N=No.
29ClearedY=Yes, N=No.
30Clearing timestampISO 8601 date format / UTC time format.
31CCP IDLegal Entity Identifier (LEI) (20 alphanumerical digits) or, if not available, interim entity identifier (20 alphanumerical digits) or, if not available, BIC (11 alphanumerical digits).
32IntragroupY=Yes, N=No.
Section 2e - Interest RatesInterest rate derivatives
33Fixed rate of leg 1Numerical digits in the format xxxx,yyyyy.
34Fixed rate of leg 2Numerical digits in the format xxxx,yyyyy.
35Fixed rate day countActual/365, 30B/360 or Other.
36Fixed leg payment frequencyAn integer multiplier of a time period describing how often the counterparties exchange payments, e.g. 10D, 3M, 5Y.
37Floating rate payment frequencyAn integer multiplier of a time period describing how often the counterparties exchange payments, e.g. 10D, 3M, 5Y.
38Floating rate reset frequency
D

=

An integer multiplier of a time period describing how often the counterparties exchange payments, e.g. 10D, 3M, 5Y.

39Floating rate of leg 1The name of the floating rate index, e.g. 3M Euribor.
40Floating rate of leg 2The name of the floating rate index, e.g. 3M Euribor.
Section 2f – Foreign ExchangeCurrency derivatives
41Currency 2ISO 4217 Currency Code, 3 alphabetical digits.
42Exchange rate 1Up to 10 numerical digits in the format xxxx,yyyyy.
43Forward exchange rateUp to 10 numerical digits in the format xxxx,yyyyy.
44Exchange rate basisE.g. EUR/USD or USD/EUR.
Section 2g - CommoditiesIf a UPI is reported and contains all the information below, this is not required unless to be reported according to Regulation (EU) No 1227/2011.Commodity derivatives
General
45Commodity base
AG

=

Agricultural

EN

=

Energy

FR

=

Freights

ME

=

Metals

IN

=

Index

EV

=

Environmental

EX

=

Exotic

46Commodity details

Agricultural

GO

=

Grains oilseeds

DA

=

Dairy

LI

=

Livestock

FO

=

Forestry

SO

=

Softs

Energy

OI

=

Oil

NG

=

Natural gas

CO

=

Coal

EL

=

Electricity

IE

=

Inter-energy

Metals

PR

=

Precious

NP

=

Non-precious

Environmental

WE

=

Weather

EM

=

Emissions

Energy
47Delivery point or zoneEIC code, 16 character alphanumeric code.
48Interconnection PointFree text, field of up to 50 characters.
49Load type

Repeatable section of fields 50-54 to identify the product delivery profile which correspond to the delivery periods of a day;

BL

=

Base Load

PL

=

Peak Load

OP

=

Off-Peak

BH

=

Block Hours

OT

=

Other

50Delivery start date and timeISO 8601 date format / UTC time format.
51Delivery end date and timeISO 8601 date format / UTC time format.
52Contract capacityFree text, field of up to 50 characters.
53Quantity Unit10 numerical digits in the format xxxx,yyyyy.
54Price/time interval quantities10 numerical digits in the format xxxx,yyyyy.
Section 2h - OptionsContracts that contain an option
55Option typeP=Put, C=Call.
56Option style (exercise)A=American, B=Bermudan, E=European, S=Asian.
57Strike price (cap/floor rate)Up to 10 Numerical digits in the format xxxx,yyyyy.
Section 2i - Modifications to the contractAll contracts
58Action type
N

=

New

M

=

Modify

E

=

Error,

C

=

Cancel,

Z

=

Compression,

V

=

Valuation update,

O

=

Other.

59Details of action typeFree text, field of up to 50 characters.

Back to top

Options/Help

Print Options

Close

Legislation is available in different versions:

Latest Available (revised):The latest available updated version of the legislation incorporating changes made by subsequent legislation and applied by our editorial team. Changes we have not yet applied to the text, can be found in the ‘Changes to Legislation’ area.

Original (As adopted by EU): The original version of the legislation as it stood when it was first adopted in the EU. No changes have been applied to the text.

Close

Opening Options

Different options to open legislation in order to view more content on screen at once

Close

More Resources

Access essential accompanying documents and information for this legislation item from this tab. Dependent on the legislation item being viewed this may include:

  • the original print PDF of the as adopted version that was used for the EU Official Journal
  • lists of changes made by and/or affecting this legislation item
  • all formats of all associated documents
  • correction slips
  • links to related legislation and further information resources
Close

More Resources

Use this menu to access essential accompanying documents and information for this legislation item. Dependent on the legislation item being viewed this may include:

  • the original print PDF of the as adopted version that was used for the print copy
  • correction slips

Click 'View More' or select 'More Resources' tab for additional information including:

  • lists of changes made by and/or affecting this legislation item
  • confers power and blanket amendment details
  • all formats of all associated documents
  • links to related legislation and further information resources