TRACE Foreign Sovereign Debt Report Card
The TRACE Detail Data Download is designed to accompany the TRACE Quality of Markets Summary Report Card as a tool to help a firm analyze and improve its compliance-related activities associated with reporting transactions via TRACE.
The following table describes the content and structure of the detail data download file:
| Field Name | Definition |
|---|---|
| Alert Type | This is an abbreviation for the exception category on the report card into which this transaction fell. Users can sort this file by the Alert Type to group transactions with certain characteristics together. A list of the alert codes, as well as their corresponding categories in the TRACE Quality of Markets Report Card, is included below. |
| Execution Date | This is the date the transaction was executed. |
| Execution Time | This is the time the transaction was executed. |
| Report Date | This is the date the transaction was reported to TRACE. |
| Report Time | This is the time the transaction was reported to TRACE. |
| Settlement Date | This is the date the transaction settled. |
| Reporting Executing Firm | This is the MPID of your firm, i.e., the executing party with reporting responsibility for this transaction. Note: if this trade report was submitted pursuant to a give-up agreement, the firm that reported the trade on your firm’s behalf will appear in the Reporting Party field. |
| Report Firm Cap | Indicates whether the firm executed the trade for its own account (P for Principal) or for a third party (A for Agent). |
| Report Clearing ID | This is the Clearing ID of the firm clearing the trade. This field is not required. |
| Contra Firm | This is the party on the other side of the trade. Contra parties that are non-FINRA members will be identified with the letter “C” (for customer). Contra parties that transaction with non-member affiliates are identified with the letter "A" (for affiliate). |
| ATS Execution MPID | This field allows Reporting firms to identify if a trade is an ATS execution (the trade was executed on an ATS’s platform) by entering the ATS’ MPID. An ATS may or may not be a party (RP or CP) in these transactions. CPID of (C or A) are not allowed on ATS Executions |
| Symbol | This is the TRACE symbol of the bond. |
| Issuer Name | The Name of the security’s issuer |
| CUSIP | This is the CUSIP of the bond. |
| ISIN | The International Securities Identification Number (ISIN) is a code that uniquely identifies a security globally for the purposes of facilitating clearing, reporting and settlement of trades. |
| FIGI | Financial Instrument Global Identifier™ (FIGI™) is an established global standard and an identification standard adopted by the American National Committee X9. The FIGI standard is issued and distributed by Bloomberg L.P. as a Registration Authority and Certified Provider under the auspice of OMG®. |
| Security Description | The security description |
| Buy/Sell | Indicates whether the firm bought (B) or sold (S) the security. |
| Entered Price | This is the price at which the firm reported the trade was executed. |
| Size | This is the dollar amount of the trade. |
| Reporting Party | This is the firm that submitted the trade report. If the trade was submitted on behalf of your firm pursuant to a give-up agreement, this will be the MPID of the firm that had the responsibility to report the trade on your firm’s behalf. |
| Submitting Firm | This is the entity that entered the trade. The trade may be entered by the responsible party, a Give-Up firm, a firm you have an agreement with, or a service bureau. This value will be different from Reporting Party when a Service Bureau submits the trade on the Reporting Party’s behalf. |
| Seller Commission | This is the dollar amount charged as commission on the sell side. This field is not required and will only be viewable if your firm is on the sell side of the transaction. |
| Buyer Commission | This is the dollar amount charged as commission on the buy side. This field is not required and will only be viewable if your firm is on the buy side of the transaction. |
| No Remuneration Indicator | This field is used to identify whenever a commission or markup/markdown is not assessed on the trade at the item of execution. Entry of “N” indicates the trade does not include remuneration of any kind. Blank value means the trade does include remuneration, for example commission or markup/markdown built into the price. |
| Modifier 3 | This field pertains to Extended Hours/Late Sale Conditions. Possible values are:
|
| Modifier 4 | This field is provided when the transaction is reported with a Weighted Average Price modifier (“W”). |
| Price Override | An O in this column indicates that the firm set the Override flag when reporting this transaction. |
| Special Price Indicator | A Y in this column indicates that the firm set the Special Price flag when reporting this transaction. |
| Special Price Memo | This field is a required memo field when Special Price flag = Y, and is used to describe the reason for the special price. |
| Source | This indicates the source of the TRACE submission. Values are:
|
| Status | This indicates the status of the transaction. Values are:
|
| As-Of | A Y in this column indicates that the trade was reported as an as-of report. |
| Reversal | A Y in this column indicates that the trade report was a reversal. |
| Locked-In Indicator | A Y in this column indicates that the trade is locked-in and satisfies both sides (Buy and Sell) of the trade reporting requirement. |
| TRACE Control ID | This is a unique ID for this transaction, provided by TRACE. |
| Control Date | This is the date the trade was reported. A trade is uniquely identified by Control ID + Control Date. In the case of a cancelation or correction, this is the date the cancelation or correction was reported, and prior trade control date will contain the date the trade being canceled or corrected was originally submitted. |
| Client Trade ID | This is an optional user-defined trade reference number which may be used by firms to perform trade management. |
| Prior Trade Control ID | This is the reference number of the prior trade. This will be populated on cancelations and corrections. |
| Prior Trade Control Date | This will be populated on cancelations and corrections and is the date the trade being canceled or corrected was originally submitted. A trade is uniquely identified by Control ID + Control Date. |
| Memo Text | This field may be used for internal purposes by the reporting firm. |
| Branch Seq Num | This is an in-house reference number assigned to the trade by the Reporting Party. |
| Trading Mkt Indicator | This indicates whether the data is for a Primary Market Trade (P1) or Secondary Market Trade (S1). |
| Match Identifier | This field is provided for detail records where Alert Type = ExTimeDiff. The Match Identifier and Match Date will be the same on the Report and Contra side trades that matched. |
| Match Date | This is the date that TRAQS matched the trades. This field is provided for detail records where Alert Type = ExTimeDiff. The Match Identifier and Match Date will be the same on the Report and Contra side trades that matched. |
| Reporting Party Type Code | A – Affiliates B – Depository Customer C – Customer D – Dealer N – Non-ATS Depository P - Platform Traded Funds S – ATS Depository T – Non-Depository ATS |
| Contra Party Type Code | A – Affiliates B – Depository Customer C – Customer D – Dealer N – Non-ATS Depository P - Platform Traded Funds S – ATS Depository T – Non-Depository ATS |
Note: for each trade included in the Execution Time Difference count on the report card, the firm will have two trade reports flagged as ExTimeDiff. A firm will be able to see its trade report and the trade report submitted by the contra that matched, so that the difference in execution times can be reviewed.
| Alert Code | Report Card Field | Description | ||
|---|---|---|---|---|
| LSDCust | Late Same Day – Customer | Late same day trade report with a customer as contra | ||
| AsOfCust | As-Of - Customer | Late As-of report with a customer as contra | ||
| LSDDealer | Late Same Day – Dealer | Late same day trade report with a dealer as contra | ||
| AsOfDealer | As-Of - Dealer | As-of report with a dealer as contra | ||
| LSDLockIn | Late Same Day – Locked-In | Late same day locked-in trade report | ||
| AsOfLockIn | As-Of – Locked-In | Late As-of locked-in trade report | ||
| LSDAffiliate | Late Same Day – Affiliate | Late same day trade report with a customer as affiliate | ||
| AsOfAffiliate | Late As-Of - Affiliate | Late As-of report with a customer as affiliate | ||
| NonMilitary | Non-military Execution Time | Potential occurrence of execution time not in military format; these are trades with an execution time between 01:00 and 06:00 | ||
| AsOfExTime | As-Of Execution Time | Execution date 1+ days earlier, execution time same as report time | ||
| CancelSD | Same Day Cancel | Cancelation on the day the trade was originally reported | ||
| CancelPD | Prior Day Cancel | Cancelation between 1 and 20 days after the trade was reported | ||
| Reversal | Reversal | Cancelation more than 20 days after the trade was reported | ||
| CorrectSD | Same Day Correction | Correction on the day the trade was reported | ||
| CorrectPD | Prior Day Correction | Correction one or more days after the trade was reported | ||
| Override | Price Override | Price override indicator provided on trade report | ||
| SpecialPrice | Special Price Indicator | Special Price Indicator provided on trade report | ||
| NoRemuneration | No Remuneration Indicator | No Remuneration Indicator provided on trade report | ||
| UnmatchR | Report Side Unmatched | Inter-Dealer trade report submitted by report firm for which no matching trade report was identified by TRACE | ||
| UnmatchC | Contra Side Unmatched | Inter-Dealer trade report submitted by another firm listing this firm as contra for which no matching trade report was identified by TRACE | ||
| ExTimeDiffEarlier | Execution Time Difference Earlier Report | Inter-Dealer trade report in which the report matched with a contra firm’s trade report but the execution time submitted by the report firm was more than 15 minutes before the execution time submitted by the contra firm. | ||
| ExTimeDiffLater | Execution Time Difference Later Report | Inter-Dealer trade report in which the report matched with a contra firm’s trade report but the execution time submitted by the report firm was more than 15 minutes after the execution time submitted by the contra firm. | ||
| IntraFirm | Intra Firm Trade Report | Inter-Dealer or Locked-in trade report in which the reporting and contra parties (as identified by their MPID) are related to the same broker-dealer (mapping to the same Firm CRD #) | ||
| ATSUnmatched | ATS Unmatched Trades | Inter-Dealer trade report in which the report matched with a contra firm’s trade report but the ATS MPID submitted by the report firm different than the ATS MPID of the contra firm’s report. Just like other unmatched analyses, we provide both the reporting and contra side trade for the transaction. | ||
| RPTG_PARTY_TYPE_CD | Reporting Party Type Code | A – Affiliates B – Depository Customer C – Customer D – Dealer N – Non-ATS Depository P - Platform Traded Funds S – ATS Depository T – Non-Depository ATS | ||
| CNTRA_PARTY_TYPE_CD | Contra Party Type Code | A – Affiliates B – Depository Customer C – Customer D – Dealer N – Non-ATS Depository P - Platform Traded Funds S – ATS Depository T – Non-Depository ATS | ||