EagleML Release Notes - September 2021
- Olga Galis (Deactivated)
- Larry Ackerman
Enhancements
SDP-54093 Enhance the Zero Balance Filter Switch for the WRHSOPENLOTEXTRACT and WRHSPOSITIONEXTRACT to include additional pending activity related records for zero positions
A new value was created for the ZeroBalanceSwitch that further defines the behavior of the ZeroBalance filter for the Warehouse Position and Open Lots extracts. The filter is applied when the parameters IncludeZeroBalances and onlyHeld are set to N and the ZeroBalanceSwitch is set to the new value of PendingActivity. The parameters heldeffectivedate and heldPositionSources are often included during implementation as well to select the date and sources executed.
The PendingActivity value will return all positions with 0 quantity that remain with additional market value activity including pending settlements. The Where clause generated is:
AND (POSITION_DETAIL.SHARE_PAR_VALUE = 0 AND NOT (POSITION_DETAIL.MARKET_VALUE_INCOME_LOCAL = 0 AND POSITION_DETAIL.SETTLED_BASE_TOTAL_URGL = 0 AND POSITION_DETAIL.SETTLED_MARKET_VALUE = 0 AND POSITION_DETAIL.BOOK_VALUE_LOCAL = 0) OR POSITION_DETAIL.SHARE_PAR_VALUE != 0)
Sample values:
<taskParameter>
<name>IncludeZeroBalances</name>
<dataType>S</dataType>
<value>N</value>
</taskParameter>
<taskParameter>
<name>ZeroBalanceSwitch</name>
<dataType>S</dataType>
<value>PendingActivity</value>
</taskParameter>
<taskParameter>
<name>onlyHeld</name>
<dataType>S</dataType>
<value>N</value>
</taskParameter>
<taskParameter>
<name>heldPositionSources</name>
<dataType>S</dataType>
<value>STARDIRECT</value>
</taskParameter>
<taskParameter>
<name>heldeffectivedate</name>
<dataType>S</dataType>
<value>2021-06-17</value>
</taskParameter>
Files Changed:
eagle_ml-2-0_cm/extract_filter_zero_balance.inc
SDP-53977 Revised the calcMasterTransactionId and introduced new element calcGroupMasterTransactionId for the WRHSOPENLOTEXTRACT, WHRSTRADEEXTRACT and WRHSCLOSELOTEXTRACT
The calcMasterTransactionId for the WRHSCLOSELOTEXTRACT, WRHSOPENLOTEXTRACT and WRHSTRADEEXTRACT was reverted back to their original state prior to the August 2021 Release. The calcMasterTransactionId from August 2021 was moved to a new element named calcGroupMasterTransactionId that is available to present a Master Transaction Id across the WRHSCLOSELOTEXTRACT, WRHSOPENLOTEXTRACT and WRHSTRADEEXTRACT.
The logic is applied when the existing EnhanceCalcTransactionId parameter is used with a value of Y and the IncludeExtendedDetails has a value of Y or ALL.
<taskParameter>
<name>EnhanceCalcTransactionId</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
<taskParameter>
<name>IncludeExtendedDetails </name>
<dataType>S</dataType>
<value>ALL</value>
</taskParameter>
Files changed:
eagle_ml-2-0_cm/out/tagvalue/extract_warehouse_trade.inc
eagle_ml-2-0_cm/out/tagvalue/extract_warehouse_closelot.inc
eagle_ml-2-0_cm/out/tagvalue/extract_warehouse_openlot.inc
eagle_ml-2-0_cm/out/t_calc_link_identifiers_fields_streaming.inc
SDP-53912 The Warehouse Trade extract was enhanced with a switch to override the TRADE_DETAIL.CASH_TYPE for OPENFUTURES / CLOSEFUTURES
Introduced new RTR parameter, CashTypeSignageFlag, to evaluate based upon conditional logic to maintain the original value of DISB or RECPT.
<taskParameter>
<name>CashTypeSignageFlag</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
This parameter impacts the TRADE_DETAIL.CASH_TYPE field only and evaluates the Cash Type flipping the incorrect value for the technical short and technical long futures when there is a total gain or total loss to reflect the correct DISB / RECPT value that syncs up with the Settled Cash record.
It is activated when passed when the EnableSignageLogic is set to Y and the IncludeExtendedDetails is set to Y or ALL.
<taskParameter>
<name>EnableSignageLogic</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
<taskParameter>
<name>IncludeExtendedDetails </name>
<dataType>S</dataType>
<value>ALL</value>
</taskParameter>
File changed:
eagle_ml-2-0_cm/out/tagvalue/extract_wrhs_trade_signage_logic.inc
SDP-53755 The MasterTransactionId calculation was revised for the SETTLEDCAEXTRACT and TRADEDCAEXTRACT for Coupons and Reclaims
The MasterTransactionId calculation was revised for the SETTLEDCAEXTRACT and TRADEDCAEXTRACT for Coupons and Reclaims to sync up the id between the two extracts.
Files changed:
eagle_ml-2-0_cm/out/tagvalue/extract_acct_settled_cash_activity.inc
eagle_ml-2-0_cm/out/tagvalue/extract_acct_traded_cash_activity.inc
SDP-53658 The Signage logic was revised for the Warehouse trade extract for Group 01 - netAmountLocal / netAmountBase - TRS event type
The Signage logic was revised for Warehouse trade extract for Group 01 - netAmountLocal / netAmountBase - TRS event type. The revision syncs up the behavior to apply the same grouping logic to both the netAmountLocal and netAmountBase elements.
Signage is enabled when the parameter EnableSignageLogic is included.
<taskParameter>
<name>EnableSignageLogic</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
File changed:
eagle_ml-2-0_cm/out/tagvalue/extract_wrhs_trade_signage_logic.inc
SDP-53632 The WRHSTRADEEXTRACT was updated to Expand Signage Logic to support Settlement Amount - Additional Conditions
The Signage logic for the Settlement Amount element is enabled through an opt-in element. The SettlementSignageFlag is used along with the EnableSignageLogic set to Y. When the SettlementSignageFlag is set to Y, the signage logic is applied to the SETTLEMENT_AMOUNT field enabling the Warehouse Trade Extract to reflect the same values matching the Settled Cash Trade values.
Signage is enabled when the parameter EnableSignageLogic is included.
<taskParameter>
<name>EnableSignageLogic</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
<taskParameter>
<name>SettlementSignageFlag</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
An additional conditional was included for the Settlement Amount to support TRRESETCOST transactions.
Files changed:
eagle_ml-2-0_cm/out/tagvalue/extract_wrhs_trade_signage_logic.inc
SDP-53607 The Warehouse Trade Outbound interfaces was enhanced to support an additional field
The Warehouse Trade extract, WRHSTRADEEXTRACT, was updated to support an additional field which is supported in v17R2.30 forward:
TRADESDBO.TRADE_DETAIL.SETTLE_AMOUNT_BASE (tag 479)
Xpath:
EagleML/warehouseTransaction/warehouseTrade/settleAmountBase
File changed:
eagle_ml-2-0_cm/out/xml/t_warehouse_trade_streaming.inc
SDP-52875 The Security Resolution process was enhanced for all Warehouse Inbound Interfaces
The Security Resolution process for Warehouse objects used to resolve the Forward Security Leg incorrectly because the Currency was not included in the resolution process.
The ASSET_CURRENCY option was introduced to include the Currency in the Security Resolution process for Warehouse objects.
This option works the same way as the ASSET_CURRENCY option for the Reference objects.
If the assetResolutionOption is set to ASSET_CURRENCY and the localCurrency is part of the incoming message, then the Security Alias is resolved by the Security Xreference identifiers + the Local Currency.
Usage EagleML:
<warehouseTransaction>
<header>
<batchKey>5287501^20210701^EAGLE PACE^POSITION</batchKey>
<objectType>WarehousePosition</objectType>
</header>
<warehousePosition>
<assetResolutionOption>ASSET_CURRENCY</assetResolutionOption>
<localCurrency>USD</localCurrency>
</warehousePosition>
</warehouseTransaction>
Usage XMLDBAPI:
<EagleDBMLRequest>
<BATCH_KEY>5287501^20210701^EAGLE PACE^POSITION</BATCH_KEY>
<ASSET_RES_OPTION>ASSET_CURRENCY</ASSET_RES_OPTION>
<REQUEST>
<MSG_TYPE>MTADMIN</MSG_TYPE>
<SUB_MSG_TYPE>POS_EGL_GEN_INTERFACE</SUB_MSG_TYPE>
<INPUT_PAR>
<P n="in_local_currency">EUR</P>
</INPUT_PAR>
</REQUEST>
</EagleDBMLRequest>
Files changed:
eagle_default/in/xml/include/xml-dbdirect_sec_parse_xrefs.inc
eagle_default/in/xml/include/xml-dbdirect_sec_resolution.inc
eagle_default/in/xml/xml-warehouse_v2.xml
eagle_default/in/xml/xml-dbdirect_invar.xml
SDP-52116 The Warehouse Trades Security Resolution was improved by removing redundant code
The Warehouse Trade object had extra Security Resolution within the EagleML rules and the in_update_switch parameter was set based on the resolution result.
The TRADESDBO.EGL_GEN_TRADE.TRD_EGL_GEN_INTERFACE stored procedure already has the necessary logic to set the in_update_switch parameter correctly, and the redundant logic has been removed from the EagleML rules.
Files changed:
eagle_default/in/xml/include/xml-warehouse_common.inc
eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl
SDP-48322 The WRHSSPDDELTALOGEXTRACT was synchronized between MC and MC2
The WRHSSPDDELTALOGEXTRACT MC2 Extract was updated to support additional four security level fields from the CASHDBO.CASH_ACTIVITY to keep the extract in sync between MC0 and MC2:
x_id
x_id_type
in_sm_inactive_flag
long_short_ind
Files changed:
eagle_ml-2-0_cm/out/xml/t_warehouse_spd_delta_log_streaming.inc
eagle_ml-2-0_cm/out/xml/t_warehouse_spd_delta_log_streaming.xml
eagle_ml-2-0_cm/w_config.inc
SDP-54092 The Cloud Extract Workflow was updated
The Cloud Extract Workflow eagle_wrf_cloud_extract was enhanced to support the additional eds resources - pacecalendar and exchangeprice.
Files changed:
eagle_ml-2-0_workflows/eagle_wrf_cloud_extract.wrf
eis/ejmwfeagle_wrf_cloud_extract.ejmwf
SDP-54282 Security resolution for the EDS load genericsmf resource to Oracle database
The security resolution for the EDS genericsmf resource was implemented on load to the Oracle database. The default security resolution logic for the EDS genericsmf resource supports the “Find 1st Match” mode of security resolution and contains all additional settings and xreference identifiers specified.
The EDS genericsmf load resource is supported starting from the Eagle version v17R2.29, Oracle only.
Please use the eagle_ml-2-0_default_cm_exec_eds stream for every EDS load via the RTR below:
<EagleML xmlns:ns2="http://www.eagleinvsys.com/2011/EagleML-2-0 " xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ml="http://www.eagleinvsys.com/2011/wsdl/EagleML-2-0 "
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:RunTaskRequest"
eaglemlVersion="2.0" eaglemlType="RunTaskRequest">
<header>
<messageId>2R4PSASHHDABVI222</messageId>
<sentBy>http://www.eagleinvsys.com/eqlrest </sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_default_ruleservice </sendTo>
<replyTo>http://www.eagleinvsys.com/eqlrest </replyTo>
</header>
<taskIdentifier>
<correlationId>genericsmf2{GUID}</correlationId>
<businessTaskId>genericsmf_in</businessTaskId>
</taskIdentifier>
<taskTypeEnum>NEW</taskTypeEnum>
<taskParameters>
<taskParameter>
<name>ServiceName</name>
<dataType>S</dataType>
<value>EBS</value>
</taskParameter>
<taskParameter>
<name>ServiceMethodName</name>
<dataType>S</dataType>
<value>load</value>
</taskParameter>
<taskParameter>
<name>ResourceName</name>
<value>genericsmf</value>
</taskParameter>
<taskParameter>
<name>inFileName</name>
<value>data\msgcenter\cmw\in\data_file.xml</value>
</taskParameter>
</taskParameters>
</EagleML>
Files changed:
metadata/core/ontology/reference/genericsmf.json
metadata/core/ontology/reference/genericsmf-models.json
metadata/core/ontology/reference/genericsmf_in.json
metadata/core/ontology/templates/eagle_ref_genericsmf_insertupdate.txt
SDP-53817 The EDS GenericIssueAnalytic load resource
The load and extract are currently supported via the new EDS resource genericissuednalytic.
Two database providers are currently supported for load Oracle and Snowflake.
Please use the eagle_ml-2-0_default_cm_exec_eds stream for every EDS load via the RTR below:
<EagleML xmlns:ns2="http://www.eagleinvsys.com/2011/EagleML-2-0 " xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ml="http://www.eagleinvsys.com/2011/wsdl/EagleML-2-0 "
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:RunTaskRequest"
eaglemlVersion="2.0" eaglemlType="RunTaskRequest">
<header>
<messageId>2R4PSASHHDABVI222</messageId>
<sentBy>http://www.eagleinvsys.com/eqlrest </sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_default_ruleservice </sendTo>
<replyTo>http://www.eagleinvsys.com/eqlrest </replyTo>
</header>
<taskIdentifier>
<correlationId>GenericIssueAnalytic{GUID}</correlationId>
<businessTaskId>GenericIssueAnalyticLoad</businessTaskId>
</taskIdentifier>
<taskTypeEnum>NEW</taskTypeEnum>
<taskParameters>
<taskParameter>
<name>ServiceName</name>
<dataType>S</dataType>
<value>EBS</value>
</taskParameter>
<taskParameter>
<name>ServiceMethodName</name>
<dataType>S</dataType>
<value>load</value>
</taskParameter>
<taskParameter>
<name>ResourceName</name>
<value>genericissueanalytic</value>
</taskParameter>
<taskParameter>
<name>inFileName</name>
<value>data\msgcenter\cmw\in\data_file.xml</value>
</taskParameter>
</taskParameters>
</EagleML>
Files changed:
ontology/eagle-vocab-ref.json
ontology/eagle-vocab-ref-shared.json
ontology/Referencegenericissueanalytic.json
ontology/Referencegenericissueanalytic_in.json
ontology/Referencegenericissueanalytic-models.json
ontology/templateseagle_ref_genericissueanalytic_reinitbatch.oracle.txt
ontology/templateseagle_ref_genericissueanalytic_reinitbatch.showflake.txt
ontology/templates/db_oper/snowflakegenericissueanalytic.reinit_batch.sql
SDP-51367 The EDS genericissueanalytic load resource supports recently added fields to the SECURITYDBO.SECURITY_ANALYTICS_EXT table
Support of following fields was added to EDS Load and Extract interfaces for Reference GenericIssueAnalytic:
The Database field name ↔︎ The EagleML node name
SECURITY_ANALYTICS_EXT.BENCHMARK_SPREAD_BID <-> analyticExtModel/benchmarkSpreadBid
SECURITY_ANALYTICS_EXT.BENCHMARK_SPREAD_MID <-> analyticExtModel/benchmarkSpreadMid
SECURITY_ANALYTICS_EXT.BENCHMARK_SPREAD_ASK <-> analyticExtModel/benchmarkSpreadAsk
SECURITY_ANALYTICS_EXT BENCHMARK_ID <-> analyticExtModel/benchmarkId
SECURITY_ANALYTICS_EXT INDEX_SIDE <-> analyticExtModel/indexSide.
Files changed:
ontology/eagle-vocab-ref.json
ontology/eagle-vocab-ref-shared.json
ontology/Reference/genericissueanalytic-models.json
SDP-53087 The EDS codevalue load resource was enhanced for In-Market Oracle clients
The EDS Load codevalue resource was redesigned. Two database providers are currently supported for code value load - Oracle and Snowflake.
The load and extract of long descriptions for code values is now supported for up to 255 characters with multilingual options.
The languageId is set to 0 by default for English. To upload a long Code Value Description over 50 chars the new element codeValueLongDescription should be used.
Usage:
For multilingual Code Value Description less than 50 chars the codeValueDescription element should be used.
For multilingual Code Value Description over 50 chars the codeValueLongDescription element should be used.
In case of multilingual descriptions the languageId should be specified in the incoming data file and also set up in the database PACE_MASTERDBO.EGL _LANGUAGES before data load.
Files changed:
metadata/core/ontology/eagle-vocab-shared.json
metadata/core/ontology/reference/codevalue-models.json
metadata/core/ontology/reference/codevalue_in.json
metadata/core/ontology/reference/codevalue.json
metadata/core/ontology/template/eagle_ref_codevalue_insertupdate.txt
SDP-52759 The EDS codevalue extract was improved to support EGL_GENERIC_XLATION_ML table
The EDS codevalue extract was improved to support the EGL_GENERIC_XLATION_ML table for extracts in Oracle.
A new xml node codeValueLongDescription will be used for long code value description up to 255 characters. The EQL endpoint is supported for EDS REST API requests or ontology based extracts.
For example:
POST Request: https://o171-q001-ww01.eagleinvsys.com/eagle/v2/eql?
{
"ServiceName":"EBS",
"ServiceMethodName": "extract",
"ResourceName": "codevalue",
"codevalue": "SDP44550_ENEY_FR_3",
"disabledatasetcache": "Y",
"maxrows": "500",
"outputformat": "EagleML",
"SaveSQLQuery": "Y"
}
Files changed:
metadata/core/ontology/eagle-vocab-ref.json
metadata/core/ontology/reference/codevalue_in.json
metadata/core/ontology/reference/codevalue-models.json
SDP-51362 The additional Bloomberg fields are supported for load and extract via the EDS genericsmf resource
The EDS genericsmf resource has been improved to support the listed database fields for load and extract:
The Database field name ↔︎ The EagleML node name
SECURITYDBO.SECMASTER_DETAIL_EXT.BASEL_III <-> genericSMF/SMExtension/baselIII
SECURITYDBO.SECMASTER_DETAIL_EXT.CAP_CONTINGENT <-> genericSMF/SMExtension/capContingent
SECURITYDBO.SECMASTER_DETAIL_EXT.CAP_CONTINGENT_TYPE <-> genericSMF/SMExtension/capContingentType
SECURITYDBO.SECMASTER_DETAIL_EXT.CAP_CONT_TRIG_LEVEL <-> genericSMF/SMExtension/capContTrigLevel
SECURITYDBO.SECMASTER_DETAIL_EXT.CAP_CONT_PRICE_LEVEL <-> genericSMF/SMExtension/capContPriceLevel
SECURITYDBO.SECMASTER_DETAIL_EXT.CAP_CONT_FLOOR_LEVEL <-> genericSMF/SMExtension/capContFloorLevel
SECURITYDBO.FIXED_INCOME_DETAIL_EXT.FIX_FLOAT_CPN_FREQ <-> genericSMF/FixedIncomeModel/fixFloatCpnFreq
SECURITYDBO.FIXED_INCOME_DETAIL_EXT.FIX_FLOAT_DAY_CNT <-> genericSMF/FixedIncomeModel/fixFloatDayCnt
SECURITYDBO.SECMASTER_DETAIL_EXT.GUARANTOR_TYPE <-> genericSMF/SMExtension/guarantorType
SECURITYDBO.FIXED_INCOME_DETAIL_EXT.IS_COVERED <-> genericSMF/FixedIncomeModel/isCovered
SECURITYDBO.FIXED_INCOME_DETAIL_EXT.MTG_SECURED <-> genericSMF/FixedIncomeModel/mtgSecured
SECURITYDBO.SECMASTER_DETAIL_EXT.TIER1_CAPITAL <-> genericSMF/SMExtension/tier1Capital
SECURITYDBO.SECMASTER_DETAIL_EXT.TIER2_CAPITAL <-> genericSMF/SMExtension/tier2Capital
SECURITYDBO.SECMASTER_DETAIL_EXT.FUND_SHARE_CLASS <-> genericSMF/SMExtension/fundShareClass
SECURITYDBO.MBS_DETAIL_EXT.MTG_CPR_SPEED <-> genericSMF/MBSExtension/mtgCprSpeed
SECURITYDBO.MBS_DETAIL_EXT.MTG_PSA_SPEED <-> genericSMF/MBSExtension/mtgPsaSpeed
SECURITYDBO.MBS_DETAIL_EXT.MTG_WAL <-> genericSMF/MBSExtension/mtgWal
SECURITYDBO.MBS_DETAIL_EXT.MTG_PRINC_LOSSES <-> genericSMF/MBSExtension/mtgPrincLosses
Files changed:
metadata/core/ontology/eagle-vocab-issuer.json
metadata/core/ontology/eagle-vocab-ref-shared.json
metadata/core/ontology/eagle-vocab-shared.json
metadata/core/ontology/reference/genericsmf-models.json
metadata/core/ontology/reference/genericsmf.json
metadata/core/ontology/reference/genericsmf_in.json
metadata/core/ontology/definition/eagle-vocab-definition-issuer.json
metadata/core/ontology/definition/eagle-vocab-definition-ref-shared.json
metadata/core/ontology/definition/eagle-vocab-definition-shared.json
SDP-49086 New SECTOR and SECTOR_DETAIL fields are supported via the EDS genericsmf resource for load and extract
The genericsmf resource was enhanced to support additional database fields from the SECURITYDBO.SECTOR and SECURITYDBO.SECTOR_DETAIL tables for load and extract, including the corresponding fields in SECURITYDBO.SECTOR_HIST and SECURITYDBO.SECTOR_DETAIL_HIST tables:
The Database field name in SECTOR/SECTOR_HIST table ↔︎ The EagleML node name
SECURITYDBO.SECTOR.SECT_E_ASSET_CLASS <-> genericSMF/sectEAssetClass
SECURITYDBO.SECTOR.SECT_E_FLAG <-> genericSMF/sectEFlag
SECURITYDBO.SECTOR.SECT_E_IND_CLASS <-> genericSMF/sectEIndClass
SECURITYDBO.SECTOR.SECT_E_ISSUER_TYPE <-> genericSMF/sectEIssuerType
SECURITYDBO.SECTOR.SECT_E_LEVEL1_CODE <-> genericSMF/sectELevel1Code
SECURITYDBO.SECTOR.SECT_E_LEVEL2_CODE <-> genericSMF/sectELevel2Code
SECURITYDBO.SECTOR.SECT_E_LEVEL3_CODE <-> genericSMF/sectELevel3Code
SECURITYDBO.SECTOR.SECT_E_LEVEL4_CODE <-> genericSMF/sectELevel4Code
SECURITYDBO.SECTOR.SECT_E_LEVEL5_CODE <-> genericSMF/sectELevel5Code
SECURITYDBO.SECTOR.SECT_E_SUB_TYPE <-> genericSMF/sectESubType
SECURITYDBO.SECTOR.SECT_F_ASSET_CLASS <-> genericSMF/sectFAssetClass
SECURITYDBO.SECTOR.SECT_F_FLAG <-> genericSMF/sectFFlag
SECURITYDBO.SECTOR.SECT_F_IND_CLASS <-> genericSMF/sectFIndClass
SECURITYDBO.SECTOR.SECT_F_ISSUER_TYPE <-> genericSMF/sectFIssuerType
SECURITYDBO.SECTOR.SECT_F_LEVEL1_CODE <-> genericSMF/sectFLevel1Code
SECURITYDBO.SECTOR.SECT_F_LEVEL2_CODE <-> genericSMF/sectFLevel2Code
SECURITYDBO.SECTOR.SECT_F_LEVEL3_CODE <-> genericSMF/sectFLevel3Code
SECURITYDBO.SECTOR.SECT_F_LEVEL4_CODE <-> genericSMF/sectFLevel4Code
SECURITYDBO.SECTOR.SECT_F_LEVEL5_CODE <-> genericSMF/sectFLevel5Code
SECURITYDBO.SECTOR.SECT_F_SUB_TYPE <-> genericSMF/sectFSubType
SECURITYDBO.SECTOR.SECT_G_ASSET_CLASS <-> genericSMF/sectGAssetClass
SECURITYDBO.SECTOR.SECT_G_FLAG <-> genericSMF/sectGFlag
SECURITYDBO.SECTOR.SECT_G_IND_CLASS <-> genericSMF/sectGIndClass
SECURITYDBO.SECTOR.SECT_G_ISSUER_TYPE <-> genericSMF/sectGIssuerType
SECURITYDBO.SECTOR.SECT_G_LEVEL1_CODE <-> genericSMF/sectGLevel1Code
SECURITYDBO.SECTOR.SECT_G_LEVEL2_CODE <-> genericSMF/sectGLevel2Code
SECURITYDBO.SECTOR.SECT_G_LEVEL3_CODE <-> genericSMF/sectGLevel3Code
SECURITYDBO.SECTOR.SECT_G_LEVEL4_CODE <-> genericSMF/sectGLevel4Code
SECURITYDBO.SECTOR.SECT_G_LEVEL5_CODE <-> genericSMF/sectGLevel5Code
SECURITYDBO.SECTOR.SECT_G_SUB_TYPE <-> genericSMF/sectGSubType
SECURITYDBO.SECTOR.SECT_H_ASSET_CLASS <-> genericSMF/sectHAssetClass
SECURITYDBO.SECTOR.SECT_H_FLAG <-> genericSMF/sectHFlag
SECURITYDBO.SECTOR.SECT_H_IND_CLASS <-> genericSMF/sectHIndClass
SECURITYDBO.SECTOR.SECT_H_ISSUER_TYPE <-> genericSMF/sectHIssuerType
SECURITYDBO.SECTOR.SECT_H_LEVEL1_CODE <-> genericSMF/sectHLevel1Code
SECURITYDBO.SECTOR.SECT_H_LEVEL2_CODE <-> genericSMF/sectHLevel2Code
SECURITYDBO.SECTOR.SECT_H_LEVEL3_CODE <-> genericSMF/sectHLevel3Code
SECURITYDBO.SECTOR.SECT_H_LEVEL4_CODE <-> genericSMF/sectHLevel4Code
SECURITYDBO.SECTOR.SECT_H_LEVEL5_CODE <-> genericSMF/sectHLevel5Code
SECURITYDBO.SECTOR.SECT_H_SUB_TYPE <-> genericSMF/sectHSubType
SECURITYDBO.SECTOR.SECT_I_ASSET_CLASS <-> genericSMF/sectIAssetClass
SECURITYDBO.SECTOR.SECT_I_FLAG <-> genericSMF/sectIFlag
SECURITYDBO.SECTOR.SECT_I_IND_CLASS <-> genericSMF/sectIIndClass
SECURITYDBO.SECTOR.SECT_I_ISSUER_TYPE <-> genericSMF/sectIIssuerType
SECURITYDBO.SECTOR.SECT_I_LEVEL1_CODE <-> genericSMF/sectILevel1Code
SECURITYDBO.SECTOR.SECT_I_LEVEL2_CODE <-> genericSMF/sectILevel2Code
SECURITYDBO.SECTOR.SECT_I_LEVEL3_CODE <-> genericSMF/sectILevel3Code
SECURITYDBO.SECTOR.SECT_I_LEVEL4_CODE <-> genericSMF/sectILevel4Code
SECURITYDBO.SECTOR.SECT_I_LEVEL5_CODE <-> genericSMF/sectILevel5Code
SECURITYDBO.SECTOR.SECT_I_SUB_TYPE <-> genericSMF/sectISubType
SECURITYDBO.SECTOR.SECT_J_ASSET_CLASS <-> genericSMF/sectJAssetClass
SECURITYDBO.SECTOR.SECT_J_FLAG <-> genericSMF/sectJFlag
SECURITYDBO.SECTOR.SECT_J_IND_CLASS <-> genericSMF/sectJIndClass
SECURITYDBO.SECTOR.SECT_J_ISSUER_TYPE <-> genericSMF/sectJIssuerType
SECURITYDBO.SECTOR.SECT_J_LEVEL1_CODE <-> genericSMF/sectJLevel1Code
SECURITYDBO.SECTOR.SECT_J_LEVEL2_CODE <-> genericSMF/sectJLevel2Code
SECURITYDBO.SECTOR.SECT_J_LEVEL3_CODE <-> genericSMF/sectJLevel3Code
SECURITYDBO.SECTOR.SECT_J_LEVEL4_CODE <-> genericSMF/sectJLevel4Code
SECURITYDBO.SECTOR.SECT_J_LEVEL5_CODE <-> genericSMF/sectJLevel5Code
SECURITYDBO.SECTOR.SECT_J_SUB_TYPE <-> genericSMF/sectJSubType
SECURITYDBO.SECTOR.SECT_K_ASSET_CLASS <-> genericSMF/sectKAssetClass
SECURITYDBO.SECTOR.SECT_K_FLAG <-> genericSMF/sectKFlag
SECURITYDBO.SECTOR.SECT_K_IND_CLASS <-> genericSMF/sectKIndClass
SECURITYDBO.SECTOR.SECT_K_ISSUER_TYPE <-> genericSMF/sectKIssuerType
SECURITYDBO.SECTOR.SECT_K_LEVEL1_CODE <-> genericSMF/sectKLevel1Code
SECURITYDBO.SECTOR.SECT_K_LEVEL2_CODE <-> genericSMF/sectKLevel2Code
SECURITYDBO.SECTOR.SECT_K_LEVEL3_CODE <-> genericSMF/sectKLevel3Code
SECURITYDBO.SECTOR.SECT_K_LEVEL4_CODE <-> genericSMF/sectKLevel4Code
SECURITYDBO.SECTOR.SECT_K_LEVEL5_CODE <-> genericSMF/sectKLevel5Code
SECURITYDBO.SECTOR.SECT_K_SUB_TYPE <-> genericSMF/sectKSubType
SECURITYDBO.SECTOR.SECT_L_ASSET_CLASS <-> genericSMF/sectLAssetClass
SECURITYDBO.SECTOR.SECT_L_FLAG <-> genericSMF/sectLFlag
SECURITYDBO.SECTOR.SECT_L_IND_CLASS <-> genericSMF/sectLIndClass
SECURITYDBO.SECTOR.SECT_L_ISSUER_TYPE <-> genericSMF/sectLIssuerType
SECURITYDBO.SECTOR.SECT_L_LEVEL1_CODE <-> genericSMF/sectLLevel1Code
SECURITYDBO.SECTOR.SECT_L_LEVEL2_CODE <-> genericSMF/sectLLevel2Code
SECURITYDBO.SECTOR.SECT_L_LEVEL3_CODE <-> genericSMF/sectLLevel3Code
SECURITYDBO.SECTOR.SECT_L_LEVEL4_CODE <-> genericSMF/sectLLevel4Code
SECURITYDBO.SECTOR.SECT_L_LEVEL5_CODE <-> genericSMF/sectLLevel5Code
SECURITYDBO.SECTOR.SECT_L_SUB_TYPE <-> genericSMF/sectLSubType
SECURITYDBO.SECTOR.SECT_M_ASSET_CLASS <-> genericSMF/sectMAssetClass
SECURITYDBO.SECTOR.SECT_M_FLAG <-> genericSMF/sectMFlag
SECURITYDBO.SECTOR.SECT_M_IND_CLASS <-> genericSMF/sectMIndClass
SECURITYDBO.SECTOR.SECT_M_ISSUER_TYPE <-> genericSMF/sectMIssuerType
SECURITYDBO.SECTOR.SECT_M_LEVEL1_CODE <-> genericSMF/sectMLevel1Code
SECURITYDBO.SECTOR.SECT_M_LEVEL2_CODE <-> genericSMF/sectMLevel2Code
SECURITYDBO.SECTOR.SECT_M_LEVEL3_CODE <-> genericSMF/sectMLevel3Code
SECURITYDBO.SECTOR.SECT_M_LEVEL4_CODE <-> genericSMF/sectMLevel4Code
SECURITYDBO.SECTOR.SECT_M_LEVEL5_CODE <-> genericSMF/sectMLevel5Code
SECURITYDBO.SECTOR.SECT_M_SUB_TYPE <-> genericSMF/sectMSubType
SECURITYDBO.SECTOR.SECT_N_ASSET_CLASS <-> genericSMF/sectNAssetClass
SECURITYDBO.SECTOR.SECT_N_FLAG <-> genericSMF/sectNFlag
SECURITYDBO.SECTOR.SECT_N_IND_CLASS <-> genericSMF/sectNIndClass
SECURITYDBO.SECTOR.SECT_N_ISSUER_TYPE <-> genericSMF/sectNIssuerType
SECURITYDBO.SECTOR.SECT_N_LEVEL1_CODE <-> genericSMF/sectNLevel1Code
SECURITYDBO.SECTOR.SECT_N_LEVEL2_CODE <-> genericSMF/sectNLevel2Code
SECURITYDBO.SECTOR.SECT_N_LEVEL3_CODE <-> genericSMF/sectNLevel3Code
SECURITYDBO.SECTOR.SECT_N_LEVEL4_CODE <-> genericSMF/sectNLevel4Code
SECURITYDBO.SECTOR.SECT_N_LEVEL5_CODE <-> genericSMF/sectNLevel5Code
SECURITYDBO.SECTOR.SECT_N_SUB_TYPE <-> genericSMF/sectNSubType
SECURITYDBO.SECTOR.SECT_O_ASSET_CLASS <-> genericSMF/sectOAssetClass
SECURITYDBO.SECTOR.SECT_O_FLAG <-> genericSMF/sectOFlag
SECURITYDBO.SECTOR.SECT_O_IND_CLASS <-> genericSMF/sectOIndClass
SECURITYDBO.SECTOR.SECT_O_ISSUER_TYPE <-> genericSMF/sectOIssuerType
SECURITYDBO.SECTOR.SECT_O_LEVEL1_CODE <-> genericSMF/sectOLevel1Code
SECURITYDBO.SECTOR.SECT_O_LEVEL2_CODE <-> genericSMF/sectOLevel2Code
SECURITYDBO.SECTOR.SECT_O_LEVEL3_CODE <-> genericSMF/sectOLevel3Code
SECURITYDBO.SECTOR.SECT_O_LEVEL4_CODE <-> genericSMF/sectOLevel4Code
SECURITYDBO.SECTOR.SECT_O_LEVEL5_CODE <-> genericSMF/sectOLevel5Code
SECURITYDBO.SECTOR.SECT_O_SUB_TYPE <-> genericSMF/sectOSubType
SECURITYDBO.SECTOR.SECT_P_ASSET_CLASS <-> genericSMF/sectPAssetClass
SECURITYDBO.SECTOR.SECT_P_FLAG <-> genericSMF/sectPFlag
SECURITYDBO.SECTOR.SECT_P_IND_CLASS <-> genericSMF/sectPIndClass
SECURITYDBO.SECTOR.SECT_P_ISSUER_TYPE <-> genericSMF/sectPIssuerType
SECURITYDBO.SECTOR.SECT_P_LEVEL1_CODE <-> genericSMF/sectPLevel1Code
SECURITYDBO.SECTOR.SECT_P_LEVEL2_CODE <-> genericSMF/sectPLevel2Code
SECURITYDBO.SECTOR.SECT_P_LEVEL3_CODE <-> genericSMF/sectPLevel3Code
SECURITYDBO.SECTOR.SECT_P_LEVEL4_CODE <-> genericSMF/sectPLevel4Code
SECURITYDBO.SECTOR.SECT_P_LEVEL5_CODE <-> genericSMF/sectPLevel5Code
SECURITYDBO.SECTOR.SECT_P_SUB_TYPE <-> genericSMF/sectPSubType
SECURITYDBO.SECTOR.SECT_Q_ASSET_CLASS <-> genericSMF/sectQAssetClass
SECURITYDBO.SECTOR.SECT_Q_FLAG <-> genericSMF/sectQFlag
SECURITYDBO.SECTOR.SECT_Q_IND_CLASS <-> genericSMF/sectQIndClass
SECURITYDBO.SECTOR.SECT_Q_ISSUER_TYPE <-> genericSMF/sectQIssuerType
SECURITYDBO.SECTOR.SECT_Q_LEVEL1_CODE <-> genericSMF/sectQLevel1Code
SECURITYDBO.SECTOR.SECT_Q_LEVEL2_CODE <-> genericSMF/sectQLevel2Code
SECURITYDBO.SECTOR.SECT_Q_LEVEL3_CODE <-> genericSMF/sectQLevel3Code
SECURITYDBO.SECTOR.SECT_Q_LEVEL4_CODE <-> genericSMF/sectQLevel4Code
SECURITYDBO.SECTOR.SECT_Q_LEVEL5_CODE <-> genericSMF/sectQLevel5Code
SECURITYDBO.SECTOR.SECT_Q_SUB_TYPE <-> genericSMF/sectQSubType
SECURITYDBO.SECTOR.SECT_R_ASSET_CLASS <-> genericSMF/sectRAssetClass
SECURITYDBO.SECTOR.SECT_R_FLAG <-> genericSMF/sectRFlag
SECURITYDBO.SECTOR.SECT_R_IND_CLASS <-> genericSMF/sectRIndClass
SECURITYDBO.SECTOR.SECT_R_ISSUER_TYPE <-> genericSMF/sectRIssuerType
SECURITYDBO.SECTOR.SECT_R_LEVEL1_CODE <-> genericSMF/sectRLevel1Code
SECURITYDBO.SECTOR.SECT_R_LEVEL2_CODE <-> genericSMF/sectRLevel2Code
SECURITYDBO.SECTOR.SECT_R_LEVEL3_CODE <-> genericSMF/sectRLevel3Code
SECURITYDBO.SECTOR.SECT_R_LEVEL4_CODE <-> genericSMF/sectRLevel4Code
SECURITYDBO.SECTOR.SECT_R_LEVEL5_CODE <-> genericSMF/sectRLevel5Code
SECURITYDBO.SECTOR.SECT_R_SUB_TYPE <-> genericSMF/sectRSubType
SECURITYDBO.SECTOR.SECT_S_ASSET_CLASS <-> genericSMF/sectSAssetClass
SECURITYDBO.SECTOR.SECT_S_FLAG <-> genericSMF/sectSFlag
SECURITYDBO.SECTOR.SECT_S_IND_CLASS <-> genericSMF/sectSIndClass
SECURITYDBO.SECTOR.SECT_S_ISSUER_TYPE <-> genericSMF/sectSIssuerType
SECURITYDBO.SECTOR.SECT_S_LEVEL1_CODE <-> genericSMF/sectSLevel1Code
SECURITYDBO.SECTOR.SECT_S_LEVEL2_CODE <-> genericSMF/sectSLevel2Code
SECURITYDBO.SECTOR.SECT_S_LEVEL3_CODE <-> genericSMF/sectSLevel3Code
SECURITYDBO.SECTOR.SECT_S_LEVEL4_CODE <-> genericSMF/sectSLevel4Code
SECURITYDBO.SECTOR.SECT_S_LEVEL5_CODE <-> genericSMF/sectSLevel5Code
SECURITYDBO.SECTOR.SECT_S_SUB_TYPE <-> genericSMF/sectSSubType
The Database field name in SECTOR_DETAIL/SECTOR_DETAIL_HIST table ↔︎ The EagleML node name
SECURITYDBO.SECTOR_DETAIL.RUSSELL_GLOBAL <-> genericSMF/russellGlobal
SECURITYDBO.SECTOR_DETAIL.BARCLAYS_ISSUER_IND <-> genericSMF/barclaysIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.BLK_LIPPER <-> genericSMF/blackRockLipper
SECURITYDBO.SECTOR_DETAIL.BLK_INFRA_DEBT <-> genericSMF/blkInfrastructureDebt
SECURITYDBO.SECTOR_DETAIL.BLK_INFRA_DEBT_CLASS <-> genericSMF/blkInfrastructureDebtClass
SECURITYDBO.SECTOR_DETAIL.BOMBAY_STOCK_EXCHANGE <-> genericSMF/bombayStockExchange
SECURITYDBO.SECTOR_DETAIL.CHINA_SECURITIES_INDEX <-> genericSMF/chinaSecuritiesIndex
SECURITYDBO.SECTOR_DETAIL.CITI_GLOBAL <-> genericSMF/citiGlobal
SECURITYDBO.SECTOR_DETAIL.CITIGROUP <-> genericSMF/citigroup
SECURITYDBO.SECTOR_DETAIL.SIC_INDUSTRY <-> genericSMF/sicIndustry
SECURITYDBO.SECTOR_DETAIL.COLOMBIAN_STOCK_EXCHANGE <-> genericSMF/colombianStockExchange
SECURITYDBO.SECTOR_DETAIL.CSFB_ISSUER_IND <-> genericSMF/csfbIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.DEUTSCHE_BORSE <-> genericSMF/deutscheBorse
SECURITYDBO.SECTOR_DETAIL.DOW_JONES_ISSUER <-> genericSMF/dowJonesIssuer
SECURITYDBO.SECTOR_DETAIL.FITCH <-> genericSMF/fitch
SECURITYDBO.SECTOR_DETAIL.FTSE_ISSUER_IND <-> genericSMF/ftseIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.GOLDMAN <-> genericSMF/goldman
SECURITYDBO.SECTOR_DETAIL.GRETAI_SECURITIES <-> genericSMF/gretaiSecurities
SECURITYDBO.SECTOR_DETAIL.IBOXX <-> genericSMF/iBoxx
SECURITYDBO.SECTOR_DETAIL.JPM_ASIAN_CREDIT_INDEX <-> genericSMF/jpmAsianCreditIndex
SECURITYDBO.SECTOR_DETAIL.JPM_CEMBI_INDEX <-> genericSMF/jpmCembiIndex
SECURITYDBO.SECTOR_DETAIL.JPM_EMBI_INDEX <-> genericSMF/jpmEmbiIndex
SECURITYDBO.SECTOR_DETAIL.JPM_ISSUER_IND <-> genericSMF/jpmIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.LCD_LEVERAGED_LOAN_INDEX <-> genericSMF/lcdLeveragedLoanIndex
SECURITYDBO.SECTOR_DETAIL.MERRILL_LYNCH_CONVERT <-> genericSMF/merrillLynchConvertibles
SECURITYDBO.SECTOR_DETAIL.MERRILL_LYNCH_ISSUER <-> genericSMF/merrillLynchIssuer
SECURITYDBO.SECTOR_DETAIL.MOODY_ISSUER_IND <-> genericSMF/moodyIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.MOODY_CLO_DIVERSITY <-> genericSMF/moodyCloDiversity
SECURITYDBO.SECTOR_DETAIL.MSCI_HEDGE_ISSUER_IND <-> genericSMF/msciHedgeIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.MSCI_INDUSTRY <-> genericSMF/msciIndustry
SECURITYDBO.SECTOR_DETAIL.NOMURA_INDUSTRY <-> genericSMF/nomuraIndustry
SECURITYDBO.SECTOR_DETAIL.NOMURA_ISSUER_IND <-> genericSMF/nomuraIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.REUTERS_INDUSTRY <-> genericSMF/reutersIndustry
SECURITYDBO.SECTOR_DETAIL.SP_ISSUER_IND <-> genericSMF/spIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.SCOTIA_DEX_ISSUER_IND <-> genericSMF/scotiaDexssuerIndustry
SECURITYDBO.SECTOR_DETAIL.STANDARD_SIC_INDUSTRY <-> genericSMF/standardSicIndustry
SECURITYDBO.SECTOR_DETAIL.SIX_SWISS_EXCHANGE <-> genericSMF/sixSwissExchange
SECURITYDBO.SECTOR_DETAIL.TAIWAN_STOCK_EXCHANGE <-> genericSMF/taiwanStockExchange
SECURITYDBO.SECTOR_DETAIL.TOPIX <-> genericSMF/topix
SECURITYDBO.SECTOR_DETAIL.USB_ISSUER_IND <-> genericSMF/ubsIssuerIndustry
SECURITYDBO.SECTOR_DETAIL.WARSAW_STOCK_EXCHANGE <-> genericSMF/warsawStockExchange
SECURITYDBO.SECTOR_DETAIL.WIG <-> genericSMF/wig
SECURITYDBO.SECTOR_DETAIL.IBOXX_ALBI <-> genericSMF/iBoxxAlbi
SECURITYDBO.SECTOR_DETAIL.GLOBAL_PROPERTY_RESEARCH <-> genericSMF/globalPropertyResearch
SECURITYDBO.SECTOR_DETAIL.IBOXX_AUD_LARGE_CAP <-> genericSMF/iBoxxAudLargeCap
SECURITYDBO.SECTOR_DETAIL.LONDON_STOCK_EXCHANGE <-> genericSMF/londonStockExchange
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_MUNI_INDUSTRY <-> genericSMF/bloombergMuniIndustry
SECURITYDBO.SECTOR_DETAIL.IISL <-> genericSMF/iisl
SECURITYDBO.SECTOR_DETAIL.LOCAL_EXCHANGE <-> genericSMF/localExchange
SECURITYDBO.SECTOR_DETAIL.THAILAND_STOCK_EXCHANGE <-> genericSMF/thailandStockExchange
SECURITYDBO.SECTOR_DETAIL.MALAYSIA_STOCK_EXCHANGE <-> genericSMF/malaysiaStockExchange
SECURITYDBO.SECTOR_DETAIL.JAPAN_STOCK_EXCHANGE <-> genericSMF/japanStockExchange
SECURITYDBO.SECTOR_DETAIL.INDONESIA_STOCK_EXCHANGE <-> genericSMF/indonesiaStockExchange
SECURITYDBO.SECTOR_DETAIL.PHILIPPINES_STOCK_EXCH <-> genericSMF/philippinesStockExchange
SECURITYDBO.SECTOR_DETAIL.INDIA_STOCK_EXCHANGE <-> genericSMF/indiaStockExchange
SECURITYDBO.SECTOR_DETAIL.KOREA_STOCK_EXCHANGE <-> genericSMF/koreaStockExchange
SECURITYDBO.SECTOR_DETAIL.CSRC_CHINA <-> genericSMF/csrcChina
SECURITYDBO.SECTOR_DETAIL.SYWG_CHINA <-> genericSMF/sywgChina
SECURITYDBO.SECTOR_DETAIL.NAICS <-> genericSMF/naics
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_GOVERNMENT <-> genericSMF/bloombergGovernment
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_FIXED_INCOME <-> genericSMF/bloombergFixedIncome
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_EQUITY <-> genericSMF/bloombergEquity
SECURITYDBO.SECTOR_DETAIL.RUSSELL_GLOBAL_SRC <-> genericSMF/russellGlobalSource
SECURITYDBO.SECTOR_DETAIL.BARCLAYS_ISSUER_IND_SRC <-> genericSMF/barclaysIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.BLK_LIPPER_SRC <-> genericSMF/blackRockLipperSource
SECURITYDBO.SECTOR_DETAIL.BLK_INFRA_DEBT_SRC <-> genericSMF/blkInfraDebtSource
SECURITYDBO.SECTOR_DETAIL.BLK_INFRA_DEBT_CLASS_SRC <-> genericSMF/blkInfraDebtClassSource
SECURITYDBO.SECTOR_DETAIL.BOMBAY_STOCK_EXCHANGE_SRC <-> genericSMF/bombayStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.CHINA_SECURITIES_INDX_SRC <-> genericSMF/chinaSecuritiesIndexSource
SECURITYDBO.SECTOR_DETAIL.CITI_GLOBAL_SRC <-> genericSMF/citiGlobalSource
SECURITYDBO.SECTOR_DETAIL.CITIGROUP_SRC <-> genericSMF/citigroupSource
SECURITYDBO.SECTOR_DETAIL.SIC_INDUSTRY_SRC <-> genericSMF/sicIndustrySource
SECURITYDBO.SECTOR_DETAIL.COLOMBIAN_STOCK_EXC_SRC <-> genericSMF/colombianStockExcSource
SECURITYDBO.SECTOR_DETAIL.CSFB_ISSUER_IND_SRC <-> genericSMF/csfbIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.DEUTSCHE_BORSE_SRC <-> genericSMF/deutscheBorseSource
SECURITYDBO.SECTOR_DETAIL.DOW_JONES_ISSUER_SRC <-> genericSMF/dowJonesIssuerSource
SECURITYDBO.SECTOR_DETAIL.FITCH_SRC <-> genericSMF/fitchSource
SECURITYDBO.SECTOR_DETAIL.FTSE_ISSUER_IND_SRC <-> genericSMF/ftseIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.GOLDMAN_SRC <-> genericSMF/goldmanSource
SECURITYDBO.SECTOR_DETAIL.GRETAI_SECURITIES_SRC <-> genericSMF/gretaiSecuritiesSource
SECURITYDBO.SECTOR_DETAIL.IBOXX_SOURCE <-> genericSMF/iBoxxSource
SECURITYDBO.SECTOR_DETAIL.JPM_ASIAN_CREDIT_INDX_SRC <-> genericSMF/jpmAsianCreditIndexSource
SECURITYDBO.SECTOR_DETAIL.JPM_CEMBI_INDEX_SRC <-> genericSMF/jpmCembiIndexSource
SECURITYDBO.SECTOR_DETAIL.JPM_EMBI_INDEX_SRC <-> genericSMF/jpmEmbiIndexSource
SECURITYDBO.SECTOR_DETAIL.JPM_ISSUER_IND_SRC <-> genericSMF/jpmIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.LCD_LEV_LOAN_INDEX_SRC <-> genericSMF/ldcLevLoanIndexSource
SECURITYDBO.SECTOR_DETAIL.MERRILL_CONVERT_SRC <-> genericSMF/merrillConvertSource
SECURITYDBO.SECTOR_DETAIL.MERRILL_ISSUER_SRC <-> genericSMF/merrillIssuerSource
SECURITYDBO.SECTOR_DETAIL.MOODY_ISSUER_IND_SRC <-> genericSMF/moodyIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.MOODY_CLO_DIVERSITY_SRC <-> genericSMF/moodyCloDiversitySource
SECURITYDBO.SECTOR_DETAIL.MSCI_HEDGE_ISSUER_IND_SRC <-> genericSMF/msciHedgeIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.MSCI_INDUSTRY_SRC <-> genericSMF/msciIndustrySource
SECURITYDBO.SECTOR_DETAIL.NOMURA_INDUSTRY_SRC <-> genericSMF/nomuraIndustrySource
SECURITYDBO.SECTOR_DETAIL.NOMURA_ISSUER_IND_SRC <-> genericSMF/nomuraIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.REUTERS_INDUSTRY_SRC <-> genericSMF/reutersIndustrySource
SECURITYDBO.SECTOR_DETAIL.SP_ISSUER_IND_SRC <-> genericSMF/spIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.SCOTIA_DEX_ISSUER_IND_SRC <-> genericSMF/scotiaDexIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.STANDARD_SIC_INDUSTRY_SRC <-> genericSMF/standardSicIndustrySource
SECURITYDBO.SECTOR_DETAIL.SIX_SWISS_EXCHANGE_SRC <-> genericSMF/sixSwissExchangeSource
SECURITYDBO.SECTOR_DETAIL.TAIWAN_STOCK_EXCHANGE_SRC <-> genericSMF/taiwanStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.TOPIX_SRC <-> genericSMF/topixSource
SECURITYDBO.SECTOR_DETAIL.USB_ISSUER_IND_SRC <-> genericSMF/usbIssuerIndSource
SECURITYDBO.SECTOR_DETAIL.WARSAW_STOCK_EXCHANGE_SRC <-> genericSMF/warsawStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.WIG_SRC <-> genericSMF/wigSource
SECURITYDBO.SECTOR_DETAIL.IBOXX_ALBI_SRC <-> genericSMF/iBoxxAlbiSource
SECURITYDBO.SECTOR_DETAIL.GLOBAL_PROP_RESEARCH_SRC <-> genericSMF/globalPropResearchSource
SECURITYDBO.SECTOR_DETAIL.IBOXX_AUD_LARGE_CAP_SRC <-> genericSMF/iBoxxAudLargeCapSource
SECURITYDBO.SECTOR_DETAIL.LONDON_STOCK_EXCHANGE_SRC <-> genericSMF/londonStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_MUNI_IND_SRC <-> genericSMF/bloombergMuniIndSource
SECURITYDBO.SECTOR_DETAIL.IISL_SRC <-> genericSMF/iislSource
SECURITYDBO.SECTOR_DETAIL.LOCAL_EXCHANGE_SRC <-> genericSMF/localExchangeSource
SECURITYDBO.SECTOR_DETAIL.THAILAND_STOCK_EXCH_SRC <-> genericSMF/thailandStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.MALAYSIA_STOCK_EXCH_SRC <-> genericSMF/malaysiaStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.JAPAN_STOCK_EXCH_SRC <-> genericSMF/japanStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.INDONESIA_STOCK_EXCH_SRC <-> genericSMF/indonesiaStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.PHILIPPINES_STK_EXCH_SRC <-> genericSMF/philippinesStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.INDIA_STOCK_EXCHANGE_SRC <-> genericSMF/indiaStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.KOREA_STOCK_EXCHANGE_SRC <-> genericSMF/koreaStockExchangeSource
SECURITYDBO.SECTOR_DETAIL.CSRC_CHINA_SRC <-> genericSMF/chinaSecuritiesSource
SECURITYDBO.SECTOR_DETAIL.SYWG_CHINA_SRC <-> genericSMF/sywgChinaSource
SECURITYDBO.SECTOR_DETAIL.NAICS_SRC <-> genericSMF/northAmericanIndustrySource
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_GOVERNMENT_SRC <-> genericSMF/bloombergGovernmentSource
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_FI_SRC <-> genericSMF/bloombergFixedIncomeSource
SECURITYDBO.SECTOR_DETAIL.BLOOMBERG_EQUITY_SRC <-> genericSMF/bloombergEquitySource
Files changed:
metadata/core/ontology/eagle-vocab-issuer.json
metadata/core/ontology/eagle-vocab-ref-shared.json
metadata/core/ontology/eagle-vocab-shared.json
metadata/core/ontology/reference/genericsmf-models.json
metadata/core/ontology/reference/genericsmf.json
metadata/core/ontology/reference/genericsmf_in.json
metadata/core/ontology/definition/eagle-vocab-definition-issuer.json
metadata/core/ontology/definition/eagle-vocab-definition-ref-shared.json
metadata/core/ontology/definition/eagle-vocab-definition-shared.json
metadata/core/ontology/templates/eagle_ref_genericsmf_insertupdate.txt
SDP-48722 The EDS Load framework was enhanced to support data load in CSV format
The EDS Data load framework was improved to support the data load in CSV format.
The Ontology datasets are now supported in XML, JSON and CSV formats.
The initial tests for the warehouseposition in CSV format were validated.
Files changed:
src/eagleinvsys/ebs/ebs_t.py
src/eagleinvsys/mc2py/dsparser.py
src/eagleinvsys/mc2py/format_enums.py
src/eagleinvsys/mc2py/genetl.py
src/eagleinvsys/mc2py/string_utils.py
SDP-47712 The EDS Load framework was enhanced to support data load in JSON format
The EDS Data load framework was improved to support the data load in JSON format.
The Ontology datasets are now supported in XML and JSON formats.
The initial tests for the warehouseposition and the warehouseopenlot in JSON format were validated.
Files changed:
src/eagleinvsys/ebs/ebs_t.py
src/eagleinvsys/mc2py/dsjsonparser.py
src/eagleinvsys/mc2py/dsxmlparser.py
src/eagleinvsys/mc2py/isink.py
src/eagleinvsys/mc2py/json_enum.py
src/eagleinvsys/mc2py/jsondescriptor.py
src/eagleinvsys/mc2py/string_utils.py
Production Bugs
SDP-54094 The TSR for Synchronous Webservice Calls and JMS delivery method was corrected
The synchronous webservice requests for the streaming extracts did not return the extract result in the TSR.
The extract file was moved to the JMS stream before it was read and included into the TSR for the JMS delivery method. The issue was corrected. The extract is now part of the TSR in case of the Synchronous Webservice requests and JMS delivery method.
File changed:
eagle_ml-2-0_cm/reporter_dist.inc
SDP-53862 The element mapping was corrected for the MultilegSMF Inbound interface
Corrected the issue with the variationMarginFlag element having the same tagId as the derivCahr26 element which was resulting in the incorrect data mapping for the payLeg and the receiveLeg.
Files changed:
eagle_default/in/xml/includepay_leg_alliases.ince
eagle_default/in/xml/includereceive_leg_alliases.inc