CME STP Trade Capture to Database
- 1 Database Schema
- 2 STP-to-Database mapping
- 2.1 Table: CMESTPReports
- 2.2 Table: Sent_Messages_CMESTP
- 2.3 Table: CMESTP_Sides
- 2.4 Table: CMESTP_SideParties
- 2.5 Table: CMESTP_SideSubParties
- 2.6 Table: CMESTP_SideTrdRegIDs
- 2.7 Table: CMESTP_SideRegTimestamps
- 2.8 Table: CMESTP_PositionAmountData
- 2.9 Table: CMESTP_Legs
- 2.10 Table: CMESTP_LegsUndlyInstrument
- 2.11 Table: CMESTP_ReportingPty
- 2.12 Table: CMESTP_InstrumentAlternativeIDs
- 2.13 Table: CMESTP_InstrumentEvents
- 2.14 Table: CMESTP_UnderlyingInstrument
Database Schema
STP-to-Database mapping
Table: CMESTPReports
Usage: Table holds summary of reported trades.
Fields | ||||
Name | Tag | Req’d | Description | |
FIXML Element | FIX Tag | |||
TradeReportID
| RptID | 571 | Y | Key field. Unique identifier for the Trade Capture Report. |
SecondaryTradeID | TrdID2 | 1040 | N | Key field. Provides secondary trade ID. Unlike TradeID, this is unique across all trade dates and all clearing firms. |
ExecId | ExecID | 17 | Y | Exchanged assigned Execution ID (Trade Identifier). Unique ID for each side of each leg and will now have a length of a maximum 26 characters long. Note: ExecID will no longer match for the buyer and seller. |
LastPx | LastPx | 31 | Y | Overall Trade Price per contract for regular cleared trades. |
LastQty | LastQty | 32 | Y | Total Quantity based on user permissible allocation quantity. |
TransactTime
| TxnTm | 60 | Y | Date and Time when the trade was executed. |
TradeDate | TrdDt | 75 | Y | Trade date |
PriceType
| PxTyp | 423 | N | Settlement Price indicator for TAS, EFM and EFP's priced off settlement. Valid values:
|
MultiLegReportingType
| MLEGRptTyp | 442 | Y | Indicates if a trade is being reported as a single-leg outright, the leg of a spread, or a multi-leg trade report. Valid values:
|
TradeReportTransType
| TransTyp | 487 | Y | Type of Execution being reported. Valid values:
|
TradeRequestID
| ReqID | 568 | Y | Original RequestID from the Trade Capture Report Request |
ClearingBusinessDate
| BizDt | 715 | Y | The Clearing Business Date referred to by this report. |
LastUpdateTime | LastUpdateTm | 779 | N | Last update time of the trade.
|
QtyType
| QtyTyp | 854 | Y | Type of quantity specified in a quantity field. Valid values:
|
TrdMatchID
| TrdMtchID | 880 | N | Trade Match ID is assigned by the matching engine or clearing system and used to correlate a cleared trade with a match event. Should be common for all trade sides included in a match event. For CME ClearPort, this represents the deal number and always links strategies. For CME Globex and Floor, this links calendar spreads only. Will not be present for IRS/FRA trades. |
TradeID
| TrdID | 1003 | Y | Represents the CME Front End Clearing (FEC) Firm Trade ID. TradeID does not match across buy/sell side. |
SecurityID
| ID | 48 | Y | CME Group clearing product code, e.g. CL (2 Characters) |
SecurityIDSrc | Src | 22 | Y | Identifies the source of the Security ID. If it is not specified, the default of Clearing is used. Valid value: ‘H’ (Clearing House/ Organization) |
Symbol | Sym | 55 | Y | Symbol for a CME Contract, e.g. CLX05. Note that Symbol now matches the value used by clearing firms in the FEC system, and may differ somewhat from the representation used in the legacy CTAPI system. |
SecurityDesc
| Desc | 107 | N | Long description/name for a product. |
SecurityType
| SecTyp | 167 | Y | Indicates type of security. Valid values: |
MaturityMonthYear
| MMY | 200 | Y | Month and Year of the maturity (used for standardized futures and options). Format:
|
StrikePrice
| Strk | 202 | C | Strike Price for an Option. |
SecurityExchange
| Exch | 207 | Y | The exchange where the security is listed. Valid values: ‘CBT’, ‘CCE’, ‘CEE’, ‘CEU’, ‘CMD’, ‘CME’, 'COMEX' , 'DME', ‘NYMEX’ |
CFICode
| CFI | 461 | Y | Indicates the type of security - Classification of Financial Instruments (CFI code) Valid values: security type values as defined by ISO 10962 standard |
SecuritySubType
| SubTyp | 762 | Y | For spreads, indicates the strategy type. For CDS, indicates if the product is a Single Name or Index. Options: BX = Box BO = Butterfly XT = Xmas Tree CC = Conditional Curve CO = Condor DB = Double HO = Horizontal HS = Horizontal Straddle IC = Iron Condor 12 = Ratio 1x2 13 = Ratio 1x3 23 = Ratio 2x3 RR = Risk Reversal SS = Straddle Strip ST = Straddle SG = Strangle SR = Strip VT = Vertical JR = Jelly Roll GT = Guts GN = Generic
Futures: SP = Calendar Spread FX = FX Calendar Spread RT = Reduced Tick Calendar Spread EQ = Equity Calendar Spread BF = Butterfly CF = Condor FS = Strip IS = Intercommodity Spread PK = Pack MP = Month Pack PB = Pack Butterfly DF = Double Butterfly PS = Pack Spread C1 = Crack 1:1 FB = Bundle BS = Bundle Spread IV = Implied Treasury Intercommodity Spread EC = TAS Calendar Spread SI = Commodities Intercommodity Spread MS = BMD Futures Strip |
UnitofMeasure
| UOM | 996 | Y | Physical unit of measure for Derivative products. NOTE: Additional values may be used by mutual agreement of the counterparties.
|
TradeReportType | RptTyp | 856 | N | Indicates the purpose of the trade within the workflow and determines the action of the receiver of the trade Valid value: ‘101’ (Notification) |
AvgPx | AvgPx | 6 | N | Calculated average price of all fills on this order. Will be populated for Average Price System (APS) transactions only. |
SecondaryExecID | ExecID2 | 527 | N | Execution ID as assigned by originating platform, e.g. the ClearPort execution ID |
TradeType | TrdTyp | 828 | N | CME Trade Type & Trade Transfer Flag. Valid values:
|
TradeSubType | TrdSubTyp | 829 | N | Represents the CME Trade Type Subset, TAS Flag & the APS Offset and Onset Flag. Valid values:
|
TradeReportingStatus | TrdRptStat | 939 | N | Indicates the status of the trade in clearing. Valid values: ‘0’ (Accepted) |
VenueType | ||||