F.19 Firm Data Transfer Datamaps
The following table lists the Firm Data Transfer (FDT) Datamaps and the order they must be run in.
Table F-19 FDT Datamaps
| Datamap Number | Datamap Name | Predecessors |
|---|---|---|
| 70010 | Scrty_TradeExecutionStageInsert | NA |
| 70020 | Scrty_OrderStageInsert | NA |
| 70030 | MktCntr_OrderStageInsert | NA |
| 70040 | OrderStage_DQupdate | NA |
| 70050 | TradeExecutionEventStage_DQupdate | NA |
| 70060 | OrderStage_FDTupdate | 70040 |
| 70070 | OrderStage_RmngQtupdate | 70040 70060 |
| 70080 | OrderSummary | 70040 70060 70070 |
| 70090 | OrderSummary_OpenOrdrInsrt | 70040 70060 70070 70080 |
| 70100 | OrderSummary_QtyUpdate | 70040 70060 70070 70080 70090 |
| 70110 | OrderStage_OpenOderUpd | 70040 70060 70070 70080 70090 70100 |
| 70120 | OrderSummary_Update | 70040 70060 70070 70080 70090 70100 70110 |
| 70130 | OrderStage_OrdrSeqUpd | 70040 70060 70070 70080 70090 70100 70110 70120 |
| 70140 | OrderEvent_OrderStage | 70040 70060 70070 70080 70090 70100 70110 70120 70130 |
| 70150 | Execution_NewEvents | 70010 70050 |
| 70160 | Execution_CancelAndReplace | 70010 70050 |
| 70170 | Execution_CancelEvents | 70010 70050 70150 70160 |
| 70180 | Execution_CorrectionEvents | 70010 70050 70150 70160 70170 |
| 70190 | Trade_NewEvents | 70010 70050 |
| 70200 | Trade_CancelAndReplace | 70010 70050 |
| 70210 | Trade_CorrectionEvents | 70010 70050 70190 70200 |
| 70220 | Trade_CancelEvents | 70010 70050 70190 70200 70210 |
| 70230 | Trade_DerivedTrade | 70010 70050 70190 70200 70210 70220 |
| 70240 | Trade_OrigSeqIDUpd | 70010 70050 70190 70200 70210 70220 70230 |
| 70250 | Trade_ParentSeqIDUpd | 70010 70050 70190 70200 70210 70220 70230 70240 |
| 70260 | Trade_RplcngSeqIDUpd | 70010 70050 70190 70200 70210 70220 70230 70240 70250 |
| 70270 | TradeExecutionEvent_Trade | 70010 70050 |
| 70280 | TradeExecutionEvent_Execution | 70010 70050 |
| 70290 | TradeExecutionEvent_CancelReplaceTrade | 70010 70050 |
| 70300 | TradeExecutionEvent_FirmRefTrade | 70010 70050 70270 70280 70290 |
| 70310 | TradeExecutionEvent_MktRefTrade | 70010 70050 70270 70280 70290 |
| 70320 | Trade_RefData | 70010 70050 70270 70280 70290 |
| 70330 | Execution_Update | 70010 70050 70150 70160 70170 70180 |
The following table provides a list of datamaps and description for each datamap. These datamaps are listed in order.
Note:
To execute the TRADE_EXECUTION_EVENT_STAGE datamap, the corresponding dat files must be modified at the following location:<FIC_HOME>/database/golden_data. The name must be changed from
TradeExecutionStage_yyyymmdd_DLY_01.dat to
TradeExecutionEventStage_yyyymmdd_DLY_01.dat.
Table F-20 FDT Datamap Description
| Datamap Number | Datamap Name | Description |
|---|---|---|
| 70010 | Scrty_TradeExecutionStageInsert | This datamap populates the SCRTY table using ingested trade records present at TRADE_EXECUTION_EVENT_STAGE for that scurity, if security is not present already in the SCRTY table |
| 70020 | Scrty_OrderStageInsert | Thisdatamap populates the SCRTY table using ingested order records present at ORDR_STAGE for that security, if the security is not present already in the SCRTY table. |
| 70030 | MktCntr_OrderStageInsert | This datamap populates the MARKET_CENTER table using ingested order records present at ORDR_STAGE for that market centre, if themarket centre is not present already in the MARKET_CENTER table. |
| 70040 | OrderStage_DQupdate | This datamap updates the ORDR_STAGE table to mark invalid records. |
| 70050 | TradeExecutionEventStage_DQupdate | This datamap updates the TRDE_EXECUTION_EVENT_STAGE table to mark invalid trade events. |
| 70060 | OrderStage_FDTupdate | This datamap calculates and update information for each order event indentifying corresponding trade and quote information. |
| 70070 | OrderStage_RmngQtupdate | This datamap calculates and updates remaining units for each order event. |
| 70080 | OrderSummary | This datamap aggregates order events properties to identify the property for order, and populates the ORDR table. |
| 70090 | OrderSummary_OpenOrdrInsrt | This datamap populates the ORDR table based on the records in the OPEN_ORDR_STAGE table if required. |
| 70100 | OrderSummary_QtyUpdate | The datamap calculates the various quantity units and updates the ORDR table using those values. |
| 70110 | OrderStage_OpenOderUpd | This datamap populates the ORDR_STAGE table with order events not provided by customer but evident from the information provided by customer. |
| 70120 | OrderSummary_Update | This datamap updates the ORDR table for various events and trades occurred for order. |
| 70130 | OrderStage_OrdrSeqUpd | This datamap updates the ORDR_STAGE table using the corresponding order_seq_id from the ORDR table |
| 70140 | OrderEvent_OrderStage | This datamap populates the ORDR_EVENT table with records processed and calculated at the ORDR_STAGE table. |
| 70150 | Execution_NewEvents | This datamap populates the EXECUTION table identifying NEW events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70160 | Execution_CancelAndReplace | This datamap populates the EXECUTION table identifying CANCEL AND REPLACE events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70170 | Execution_CancelEvents | This datamap updates the EXECUTION table identifying CANCEL events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70180 | Execution_CorrectionEvents | This datamap updates the EXECUTION table identifying CORRECTION events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70190 | Trade_NewEvents | This datamap populates the TRADE table identifying NEW events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70200 | Trade_CancelAndReplace | This datamap populates the TRADE table identifying CANCEL AND REPLACE events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70210 | Trade_CorrectionEvents | This datamap updates the TRADE table identifying CORRECTION events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70220 | Trade_CancelEvents | This datamap updates the TRADE table identifying CANCEL events in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70230 | Trade_DerivedTrade | This datamap populates TRADE tables identifying DERIVED TRADES in the TRADE_EXECUTION_EVENT_STAGE table. |
| 70240 | Trade_OrigSeqIDUpd | This datamap updates the original sequence identifier for non replaced trades. |
| 70250 | Trade_ParentSeqIDUpd | This datamap updates the parent sequence identifiers for the TRADE table. |
| 70260 | Trade_RplcngSeqIDUpd | This datamap updates the replacing sequence identifiers for the TRADE table. |
| 70270 | TradeExecutionEvent_Trade | This datamap populates the TRADE_EXECUTION_EVENT table with non order based trade records from the TRADE_EXECUTION_EVENT_STAGE. |
| 70280 | TradeExecutionEvent_Execution | This datamap populates the TRADE_EXECUTION_EVENT table with executed order records from the TRADE_EXECUTION_EVENT_STAGE table. |
| 70290 | TradeExecutionEvent_CancelReplaceTrade | This datamap populates the TRADE_EXECUTION_EVENT table with CANCEL
AND
REPLACE event executed order records from the TRADE_EXECUTION_EVENT_STAGE table. |
| 70300 | TradeExecutionEvent_FirmRefTrade | This datamap updates firm reference information in the TRADE_EXECUTION_EVENT table using the EXECUTION and TRADE tables. |
| 70310 | TradeExecutionEvent_MktRefTrade | This datamap updates market reference information in the TRADE_EXECUTION_EVENT table using the REPORTED SALE and TRADE tables. |
| 70320 | Trade_RefData | This datamap updates market and firm reference data in the TRADE table using the TRADE_EXECUTION_EVENT table. |
| 70330 | Execution_Update | This datamap updates the EXECUTION table in using various events which occur for the trade in the TRADE_EXECUTION_EVENT_STAGE table. |