ETD Trade Import

ETD(Exchange Traded Derivative) Source System

ETD Source System imports ETD trades from bank side to Merit system. It is a separate system unlike Merit system it doesn’t have a web interface, instead it has a thick client (desktop application) which is used by the Utility team to handle the service running for ETD system.

How trades imported to Merit system?

Bank uploads trades files to SFTP. From SFTP using a batch script, the trade files will be copied to Merit folder in the ETD system’s server. The coping will be done daily once.

The ETD source system have individual services which imports the trade data for each region from the merit folder to ETD database.

Services running for ETD system listed below:

• ASIA – Process Asia trade data
• EUROPE – Process Europe trade data
• US – Process US trade data
• INVCALC – To calculate invoices

Each service pickup respective region’s trade files from the path ‘D:\Merit_ETD\DATA\<region>\‘ (production env.) based on the COB date it is running. If the file exists, the service put an entry in the MRT_HFCLAIMSNUDGE table in the ETD database based on each COB date.

Example:

As per the current system’s implementation, if any of these trade file is missing or not generated and shared by the Bank for a particular date, these services won’t put an entry in this table and won’t run for the next consecutive days, till the file receive. To avoid this scenario, client will provide a blank trade file even there is no trade data available for a particular date.

The processed trade data from each region in ETD system now need to import to the merit system. From Merit side we have 2 services to do the import.

• INVCALC – Process the invoices.
• CLNT1_2 – Import data from ETD system and generates daily and monthly reports.

The CLNT1_2 service will check whether the process is complete, and the entry is there in the MRT_HFCLAIMSNUDGE table. Otherwise the CLNT1_2 service will wait for invoices to be processed by the brokerage INVCALC before it generates the reports.

The generated reports will be sent to the client over mail using the SENDMAILS service from merit system.

Below are the various reports generated on the trades data from ETD source system:

Name of the Report	Generated File Name
Daily
Trades Reconciliation report Phase:1 Region: xx for COB Date yyyymmdd	TRDRECFILE_P1_regionyyyymmdd-.csv
Trades Reconciliation report Phase:2 Region: xx for COB Date yyyymmdd	TRDRECFILE_P2_regionyyyymmdd-.csv
Trades Reconciliation report Phase:3 Region: xx for COB Date yyyymmdd	TRDRECFILE_P3_Europeyyyymmdd-.csv
Released period Open Account Cash Balance Reconciliation Phase:1 Region: xx for COB Date yyyymmdd	ACCBALRECFILE_P1_regionyyyymmdd-.csv
Released period Open Account Cash Balance Reconciliation Phase:2 Region: xx for COB Date yyyymmdd	ACCBALRECFILE_P2_regionyyyymmdd-.csv
Released period Open Account Cash Balance Reconciliation Phase:3 Region: xx for COB Date yyyymmdd	ACCBALRECFILE_P3_regionyyyymmdd-.csv
Monthly
Accrued period account balance reconciliation Phase:1 Region: xx for COB Date yyyymmdd	ACCRPRDACCBALRECFILE_P1_regionyyyymmdd-.csv
Accrued period account balance reconciliation Phase:2 Region: xx for COB Date yyyymmdd	ACCRPRDACCBALRECFILE_P2_regionyyyymmdd-.csv
Accrued period account balance reconciliation Phase:3 Region: xx for COB Date yyyymmdd	ACCRPRDACCBALRECFILE_P3_regionyyyymmdd-.csv