| 2465 | AuctionNotice | |
| 2468 | AuctionNoticeBX | |
| 2466 | AuctionNoticeRC | |
| 2467 | AuctionNoticeSN | |
| 2485 | AuctionPrint | |
| 2488 | AuctionPrintBX | |
| 2486 | AuctionPrintRC | |
| 2487 | AuctionPrintSN | |
| 2464 | AuctionState | |
| 5130 | AutoHedgeControlGateway | SpdrAutoHedgeControl contains autohedge / risk group control details. Can be uploaded from SRSE, created from ExecutionEngines, or created by SR tools. |
| 5290 | AutoHedgeSymbol | AutoHedgeSymbol records are published by autohedge servers and contain all valid hedge target symbols. Execution engines reject auto-hedge requests for hedgeSecKeys that are not in this set. |
| 2498 | AutoResponderBX | |
| 2496 | AutoResponderRC | |
| 2497 | AutoResponderSN | |
| 2495 | AutoResponderVegaDir | |
| 5140 | ExternAggGroupGateway | This table allows clients to enter start-of-day positions, and quantity bot/sld today for each market. AggGroup is a code issued by SpiderRock to indentify the aggregation group that the reported positions and trades belong to. This will usually be your SpiderRock assigned ClientFirm code unless your firm has more than one aggregation unit. Note that start-of-day positions can be truncated if the truncation will not affect order marking. Contact SpiderRock support for details if this is what you intend. |
| 2270 | ExternAggGroupReport | |
| 5145 | FutAwayTktGateway | FutAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. |
| 5150 | FutOrderGateway | Records inserted, updated, or replaced into the FutureOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 5155 | MLegOrderGateway | Records inserted, updated, or replaced into the MLegOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 2480 | NoticeCancel | |
| 2475 | NoticeExecReport | |
| 2470 | NoticeResponse | |
| 5160 | OptAwayTktGateway | OptAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. |
| 5165 | OptOrderGateway | Records inserted, updated, or replaced into the OptionOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 5180 | ParentOrderGateway | Records inserted, updated, or replaced into the ParentOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 5185 | ParentOrderGatewayExt | Records inserted, updated, or replaced into the ParentOrderGatewayExt table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 2503 | ResponderMarkupBX | |
| 2501 | ResponderMarkupRC | |
| 2502 | ResponderMarkupSN | |
| 2500 | ResponderMarkupVegaDir | |
| 4655 | RiskGroupCounter | |
| 5190 | SecDefRequestGateway | |
| 3985 | SRAccntCancel | Records inserted into this table will result in the cancellation of all active/cancelable orders for the indicated SpiderRock trading accnt. |
| 3695 | SRAllocationNotice | |
| 3700 | SRAllocationNoticeStatus | |
| 5295 | SRAutoHedgeControl | SpdrAutoHedgeControl contains autohedge / risk group control details. Can be uploaded from SRSE, created from ExecutionEngines, or created by SR tools. |
| 5300 | SRAutoHedgeState | SpdrAutoHedgeState records are published by autohedge servers and describe the current state of an autohedge controller that is managing RiskGroup autohedge orders. |
| 3705 | SRAvailExecAllocation | |
| 1450 | SRAwayExecution | SpdrAwayExecution records are published by ToolServers, SRSE, and FIX drop recv gateways. They are consumed by AwayExecutionMarkupServer which, in turn, publishes corresponding SpdrParentExecution records, including M1 and M10 updates. |
| 3990 | SRBrokerCancel | Records inserted into this table causes the corresponding parent broker to cancel the current underlying parent order if active and cancellable. |
| 3920 | SRClientFirmRiskMgmt | SpdrClientFirmRiskMgmt records are created/published by SpiderRock Execution Engines and show exchange level risk management child order rejects. |
| 1460 | SRDropExecution | |
| 1465 | SRDropExecutionAck | |
| 1470 | SRExchRiskDrop | |
| 3925 | SRExchRiskMgmt | SpdrExchRiskMgmt records are created/published by SpiderRock Execution Engines and show exchange level risk management child order rejects. |
| 3835 | SRExchRiskReset | SpdrExchRiskMgmt records are created/published by SpiderRock Execution Engines and show exchange level risk management child order rejects. |
| 3710 | SRExecutionAllocation | |
| 3715 | SRExecutionAllocationStatus | |
| 4000 | SRFixParentCancel | Records inserted into this table causes the corresponding parent order to be cancelled if it is active and cancellable. |
| 4005 | SRFixParentExecution | |
| 4010 | SRFixParentReject | Record indicates that either a SpdrParentOrder (Add or Replace) or FixParentCancel request failed |
| 4025 | SRMLegBrkrEvent | SpdrMLegBrkrEvent records are published when a new or clx/replace parent order arrives causes a broker to beging working and again when a parent order terminates and the underlying broker stops working. The initial version contains state and market data from just after the initial risk check and first attempt at generating child orders. |
| 4030 | SRMLegBrkrState | SpdrMLegBrkrState records are published by execution engines and describe the current state of a broker that is managing a SpiderRock parent order. These records include a description of the active child orders managed by the broker. Records are updated whenever a child order changes and also at other times but are not completely live and may not always reflect current market data or limit levels for working orders. |
| 3720 | SROmniOrder | |
| 3725 | SRParentAllocation | |
| 3730 | SRParentAllocationStatus | |
| 4060 | SRParentBrkrDetail | SpdrParentBrkrDetail records are created/published by SpiderRock Execution Engines. Each record describes the current active detail of a single parent broker. |
| 4065 | SRParentBrkrEvent | SpdrParentBrkrEvent records are published when a new or cxl/replace parent order arrives causes a broker to begin working and again when a parent order terminates and the underlying broker stops working. The initial version contains state and market data from just after the initial risk check and first attempt at generating child orders. |
| 4070 | SRParentBrkrState | SpdrParentBrkrState records are created/published by SpiderRock Execution Engines. Each record describes the current state of one (or more) parent orders. If a parent order is canceled/replaced then entire chain is represented by a single broker state record. |
| 4075 | SRParentBrokerSummary | SpdrParentBrokerSummary records are created at the end of a trading period and contain a summary of trading activity for the period; Summary of Stk/Fut/Opt/MLeg Brkr State records. |
| 4080 | SRParentCancel | Records inserted into this table causes the corresponding parent order to be cancelled if it is active and cancellable. |
| 4085 | SRParentExecution | SpdrParentExecution records are published every time a parent order execution is received. They also update as additional post execution mark information is available at F+1m and F+10m. |
| 4090 | SRParentLimit | SpdrParentLimit records are supplied by clients (via SRSE) for use with parent orders having orderLimitType=Aux. This table can be updated either before or after a parent order begins working and will influence the limit(s) used when working child orders. Updates to this table do not constitute cancel/replace operations for the parent order. |
| 4095 | SRParentOrder | SpdrParentOrder records are visible in SRSE immediately after receipt. Parent orders received via FIX, SRSE or SpiderRock GUI tools, or 3rd party vendor systems are all visible in this table. |
| 4100 | SRParentReport | SpdrParentReport records contain the current state of a parent order and update as/when the order state changes. |
| 4195 | SRParentReviewRequest | SpdrParentReviewRequest records created when a parent order is submitted with StageType=StageReview. These records indicate that an external review of the parent order has been requested. |
| 4200 | SRParentReviewResponse | SpdrParentReviewResponse records are created when a parent order review request is completed |
| 4105 | SRReleaseWaitTrigger | SpdrReleaseWaitTrigger records are used to trigger the release of parent orders submitted with startType=WaitTrigger. Note that all parent orders in a risk group will be triggered together. |
| 2325 | SRRiskExecution | SpdrRiskExecution records are published every time a SpdrParentExecution record is published |
| 1467 | SRRiskGroupCancel | Records inserted into this table causes the corresponding parent broker to cancel the current underlying parent order if active and cancellable. |
| 4570 | SRRiskGroupControl | |
| 4110 | SRRouteCancel | Records inserted into this table will result in the cancellation of all active/cancelable orders for the indicated SpiderRock routing code |
| 4115 | SRSecKeyCancel | Records inserted into this table causes the corresponding parent broker to cancel the current underlying parent order if active and cancellable. |
| 4120 | SRSetActiveSize | SpdrSetActiveSize records control the active working size for parent orders that are locked (have active size controls). These records can be modified by ClientRiskTrader and ClientStageTrader user types. |
| 5355 | SRStrategyOrderLeggerX | |
| 5365 | SRStrategyReportLegX | |
| 5360 | SRStrategyReportLeggerX | |
| 5375 | SRStrategyStateLegX | |
| 5370 | SRStrategyStateLeggerX | |
| 4135 | SRStripeTrigger | SpdrStripeTrigger records are used to allocate sweep risk and trigger cross stripe release of parent orders submitted with startType=WaitTrigger. These records are published by a SR Strategy Server if/when a SpdrReleaseWaitTrigger message is received. |
| 2330 | SRSweepDetail | SpdrSweepDetail records are published by execution engines when sweep trigger groups are processed |
| 2335 | SRSweepExchDetail | SpdrSweepExchDetail records are published by execution engines when sweep trigger groups are processed |
| 4140 | SRUserCancel | Records inserted into this table cancels all parent orders associated with userName/clientFirm |
| 5220 | StkAwayTktGateway | StkAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. |
| 5225 | StkOrderGateway | Records inserted, updated, or replaced into the StockOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. |
| 3480 | ToolCompositeExecution | |
| 1915 | UserAuctionFilter | |