Service Changes
Mifid II Related Changes
Base Object Changes
Order
public int? MifidClientId { get; set; }
public string MifidClientShortCode { get; set; }
public PartyRoleQualifier? MifidClientQualifier { get; set; }
public string MifidClientDescription { get; set; }
...
public int? MifidInvestmentDecisionMakerId { get; set; }
public string MifidInvestmentDecisionMakerShortCode { get; set; }
public PartyRoleQualifier? MifidInvestmentDecisionMakerQualifier { get; set; }
public string MifidInvestmentDecisionMakerDescription { get; set; }
...
Customer
public double? AverageTradeDirtyPrice string LegalEntityIdentifier { get; set; }
AllocationService
CreateAllocation
CreateAllocationRequest
public double? AverageTradeDirtyPrice //Legal Identity Identifier code (LEI)
User
public string SSN { get; set; }
CalculateOrderResponseCreateOrderInstructionRequest
public Kodi.Kodiak.Services.DataContracts.Bonds.BondCalculation TradePriceBondCalculation int? MifidExecutionDecisionMakerId { get; set; }
Customer
public string LegalEntityIdentifier MifidExecutionDecisionMakerShortCode { get; set; } //Legal Identity Identifier code (LEI)User
public string SSN PartyRoleQualifier? MifidExecutionDecisionMakerQualifier { get; set; }CreateOrderInstructionRequest
public int? MifidExecutionDecisionMakerId MifidInvestmentDecisionMakerId { get; set; }
public string MifidExecutionDecisionMakerShortCode MifidInvestmentDecisionMakerShortCode { get; set; }
public PartyRoleQualifier? MifidExecutionDecisionMakerQualifier MifidInvestmentDecisionMakerQualifier { get; set; }
CreateOrderRequest
public int? MifidInvestmentDecisionMakerId MifidClientId {get;set;}
public string MifidInvestmentDecisionMakerShortCode MifidClientShortCode { get; set; }
public PartyRoleQualifier? MifidInvestmentDecisionMakerQualifier MifidClientQualifier { get; set; }
CreateOrderRequest
public int? MifidClientId MifidExecutionDecisionMakerId { get; set; }
public string MifidClientShortCode MifidExecutionDecisionMakerShortCode { get; set; }
public PartyRoleQualifier? MifidClientQualifier MifidExecutionDecisionMakerQualifier { get; set; }
public int? MifidExecutionDecisionMakerId MifidInvestmentDecisionMakerId { get; set; }
public string MifidExecutionDecisionMakerShortCode MifidInvestmentDecisionMakerShortCode { get; set; }
public PartyRoleQualifier? MifidExecutionDecisionMakerQualifier MifidInvestmentDecisionMakerQualifier { get; set; }public int? MifidInvestmentDecisionMakerId
AverageTradeDirtyPrice Related Changes
Base Object: Allocation
public double? AverageTradeDirtyPrice { get; set; }
public string MifidInvestmentDecisionMakerShortCode
Service: OrderCalculationService
Operation: CalculateOrder
Input Parameter: CalculateOrderResponse
public Kodi.Kodiak.Services.DataContracts.Bonds.BondCalculation TradePriceBondCalculation { get; set; }
Service: AllocationService
Operation: CreateAllocation
Input Parameter: CreateAllocationRequest
public PartyRoleQualifierdouble? MifidInvestmentDecisionMakerQualifier AverageTradeDirtyPrice { get; set; }
Service: OffExchangeTradeService
Operation: CreateOffExchangeTrade
InputParameter: CreateOffExchangeTradeRequest.CreateOffExchangeOrderRequest
public double? AverageTradeDirtyPrice { get; set; }
Database Changes.
Sql Server
alter table USERS ADD SSN VARCHAR(50) NULL; alter table CUSTOMERS ADD LEI_CODE VARCHAR(20) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_ID INT NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_SHORT_CODE varchar(10) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_QUALIFIER int NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_ID INT NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_SHORT_CODE varchar(10) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_QUALIFIER int NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_ID INT NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_SHORT_CODE varchar(10) NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_QUALIFIER int NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_ID INT NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_SHORT_CODE varchar(10) NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_QUALIFIER int NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_ID INT NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_SHORT_CODE varchar(10) NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_QUALIFIER int NULL; ALTER TABLE INSTRUCTIONS WITH CHECK ADD CONSTRAINT [FK_INSTRUCT_MIFID_EXEC] FOREIGN KEY(MIFID_EXEC_DEC_ID) REFERENCES USERS (ID_USERS) GO ALTER TABLE INSTRUCTIONS WITH CHECK ADD CONSTRAINT [FK_INSTRUCT_MIFID_INVEST] FOREIGN KEY(MIFID_INVEST_DEC_ID) REFERENCES USERS (ID_USERS) GO ALTER TABLE ORDERS WITH CHECK ADD CONSTRAINT [FK_ORDERS_MIFID_CLIENT] FOREIGN KEY(MIFID_CLIENT_ID) REFERENCES CUSTOMERS (ID_CUSTOMERS) GO ALTER TABLE ORDERS WITH CHECK ADD CONSTRAINT [FK_ORDERS_MIFID_EXEC] FOREIGN KEY(MIFID_EXEC_DEC_ID) REFERENCES USERS (ID_USERS) GO ALTER TABLE ORDERS WITH CHECK ADD CONSTRAINT [FK_ORDERS_MIFID_INVEST] FOREIGN KEY(MIFID_INVEST_DEC_ID) REFERENCES USERS (ID_USERS) GO
ALTER TABLE ALLOCATIONS ADD AVERAGE_TRADE_DIRTY_PRICE FLOAT NULL;
ALTER TABLE TRADE_REPORTS ADD REFERENCE_ID VARCHAR(32) NULL; ALTER TABLE TRADE_REPORTS ADD CLIENT_REFERENCE VARCHAR(100) NULL; ALTER TABLE TRADE_REPORTS ADD EXECUTION_METHOD INT NULL; ALTER TABLE TRADE_REPORTS ADD CLEARING_ACCOUNT_TYPE INT NULL; ALTER TABLE TRADE_REPORTS ADD TRADE_PRICE_CONDITION INT NULL; ALTER TABLE TRADE_REPORTS ADD TRADE_CLEARING_INSTRUCTIONS INT NULL; ALTER TABLE TRADE_REPORTS ADD CONNECTION_ID VARCHAR(255) NULL; ALTER TABLE TRADE_REPORTS ADD STATUS VARCHAR(100) NULL;
Oracle
alter table USERS ADD SSN VARCHAR2(50) NULL; alter table CUSTOMERS ADD LEI_CODE VARCHAR2(20) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_ID NUMBER(10,0) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_SHORT_CODE varchar2(10) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_EXEC_DEC_QUALIFIER NUMBER(10,0) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_ID NUMBER(10,0) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_SHORT_CODE varchar2(10) NULL; ALTER TABLE INSTRUCTIONS ADD MIFID_INVEST_DEC_QUALIFIER NUMBER(10,0) NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_ID NUMBER(10,0) NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_SHORT_CODE varchar2(10) NULL; ALTER TABLE ORDERS ADD MIFID_CLIENT_QUALIFIER int NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_ID NUMBER(10,0) NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_SHORT_CODE varchar2(10) NULL; ALTER TABLE ORDERS ADD MIFID_EXEC_DEC_QUALIFIER int NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_ID NUMBER(10,0) NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_SHORT_CODE varchar2(10) NULL; ALTER TABLE ORDERS ADD MIFID_INVEST_DEC_QUALIFIER NUMBER(10,0) NULL; ALTER TABLE INSTRUCTIONS ADD CONSTRAINT FK_INSTRUCT_MIFID_EXEC FOREIGN KEY(MIFID_EXEC_DEC_ID) REFERENCES USERS (ID_USERS) / ALTER TABLE INSTRUCTIONS ADD CONSTRAINT FK_INSTRUCT_MIFID_INVEST FOREIGN KEY(MIFID_INVEST_DEC_ID) REFERENCES USERS (ID_USERS) / ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_MIFID_CLIENT FOREIGN KEY(MIFID_CLIENT_ID) REFERENCES CUSTOMERS (ID_CUSTOMERS) / ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_MIFID_EXEC FOREIGN KEY(MIFID_EXEC_DEC_ID) REFERENCES USERS (ID_USERS) / ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_MIFID_INVEST FOREIGN KEY(MIFID_INVEST_DEC_ID) REFERENCES USERS (ID_USERS) /
ALTER TABLE ALLOCATIONS ADD AVERAGE_TRADE_DIRTY_PRICE FLOAT NULL;
ALTER TABLE TRADE_REPORTS ADD REFERENCE_ID VARCHAR(32) NULL; ALTER TABLE TRADE_REPORTS ADD CLIENT_REFERENCE VARCHAR(100) NULL; ALTER TABLE TRADE_REPORTS ADD EXECUTION_METHOD INT NULL; ALTER TABLE TRADE_REPORTS ADD CLEARING_ACCOUNT_TYPE INT NULL; ALTER TABLE TRADE_REPORTS ADD TRADE_PRICE_CONDITION INT NULL; ALTER TABLE TRADE_REPORTS ADD TRADE_CLEARING_INSTRUCTIONS INT NULL; ALTER TABLE TRADE_REPORTS ADD CONNECTION_ID VARCHAR(255) NULL; ALTER TABLE TRADE_REPORTS ADD STATUS VARCHAR(100) NULL;