Page Comparison

This release uses XSD Revision 244.

Enhancements

EagleML

Added Special Character Escaping in Traded and Settled Cash Interfaces

...

A new object was added to the EagleML library. The Fair Value Comparison type was created to allow extracts of this feed type. The XSD was edited to contain the object and the following outbound rules were created to support extracts:

• t_acct_fair_value_comparison.xml

• t_acct_fair_value_comparison_streaming.xml

This issue was tracked as Item #141890.

...

These new fields were added to the common entity model:

• COUNTRY_OF_TAX

• PRICE_METHOD

• USER_DATE4

• VAR_RATE_SOURCE

• COA_NAME

• PRICE_SOURCE

• REGULATORY_CATEGORY

• TAX_EXEMPT_FLAG

• DISTRIBUTION_METHOD

• PYDN_GL_ACCNT

• STAR_ACCT_FIELD_29

• TAX_WTHLD_ACCNT_METHOD

The fields were frequently extracted with custom select statements for the EMLBB process. The EntityProperties.model XSD file was edited to add the new elements. Additionally a new parameter was created to control this functionality from control messages. The IncludeExtendedDetails parameter will include the new elements if it is set to "ALL".

...

The following elements were added to the SMF model:

• SECURITYDBO.DERIVATIVES.OFFSET

• SECURITYDBO.DERIVATIVES.OPTIONDESCR

• SECURITYDBO.DERIVATIVES.PREMIUM_TYPE

• SECURITYDBO.EQUITY.DRD_FLAG

• SECURITYDBO.EQUITY.EQUITY_CHAR1

• SECURITYDBO.EQUITY.QDI_ELIGIBLE_FLAG

• SECURITYDBO.FIXED_INCOME.ACCRUAL_METHOD

• SECURITYDBO.FIXED_INCOME.DATED_DATE

• SECURITYDBO.FIXED_INCOME.FEDERAL_TAX_INDICATOR

• SECURITYDBO.FIXED_INCOME.INTEREST_METHOD_CODE

• SECURITYDBO.FIXED_INCOME.MINIMUM_PIECE

• SECURITYDBO.FIXED_INCOME.SINK_FUND

• SECURITYDBO.FIXED_INCOME.STATE_CODE

• SECURITYDBO.FIXED_INCOME.VAR_RATE_FREQ_CODE

• SECURITYDBO.FIXED_INCOME_DETAIL_EXT.MARKET_ISSUE

• SECURITYDBO.SECMASTER_DETAIL_EXT.MARKET_SECTOR_DESCRIPTION

• SECURITYDBO.SECURITY_MASTER.COUPON_FREQ_CODE

• SECURITYDBO.SECURITY_MASTER.DAY_CNT

• SECURITYDBO.SECURITY_MASTER.LIQUID_FLAG

• SECURITYDBO.SECURITY_MASTER.MAT_DATE

• SECURITYDBO.SECURITY_MASTER.OID_BOND

• SECURITYDBO.SECURITY_MASTER.POOL_NUMBER

• SECURITYDBO.SECURITY_MASTER.QUANTITY_TYPE

• SECURITYDBO.SECURITY_MASTER.SEC_144A_FLAG

• SECURITYDBO.SECURITY_MASTER.SECURITY_MINOR_TYPE

• SECURITYDBO.SECURITY_MASTER.DEFAULT_FLAG

• SECURITYDBO.SECURITY_MASTER_DETAIL.BUSINESSDAY

• SECURITYDBO.SECURITY_MASTER_DETAIL.COUNTRY_OF_RISK

• SECURITYDBO.SECURITY_MASTER_DETAIL.REGION

• SECURITYDBO.SECURITY_MASTER_DETAIL.RISK_CLASSIFICATION_TYPE

• SECURITYDBO.SWAPS.NOTIONAL_RESET_TYPE

• SECURITYDBO.SWAPS.PAY_RECEIVE_IND

The elements were added in the XSD to the SMF model. Additionally, the IncludeExtendedDetails parameter was added to allow control from a control message. To include all the elements this parameter's value should be set to "ALL".

...

Nine new elements were added to the Estar distribution log by using the distribution amount field. The elements were as follows:

• fixedAmount

• periodicIAmount

• periodicLTAmount

• periodicSPAmount

• periodicSTAmount

• periodicaAJIAmount

• periodicaAJLTAmount

• periodicaAJSPAmount

• periodicaAJSTAmount

The distribution log was added as part of the NAV Daily extract. The following rules received code changes:

• extract_nav_multi_details_tables.inc

• extract_nav_multi_details_fields.inc

• t_warehouse_nav_multi_streaming.inc

This issue was tracked as Item #147847.

...

The warehouse NAV Daily extract received additional fields. Two existing fields were edited. The extract_warehouse_nav_multi.xml rule was edited to add the following elements:

• PRIOR_SHARES_OUTSTANDING

• PRIOR_MILL_RATE

• PRIOR_MILL_RATE_DAILY_YIELD

These elements were edited:

• PRIOR_RAW_NAV

• PRIOR_NET_ASSETS_NAV

This issue was tracked as Item #148258.

...

This issue was tracked as Item #149397.

EJM

Added Ability to Process Dynamic Datamask

...

This issue was tracked as Item #143477.

Software Fixes

EagleML

Corrected Issue with Special Characters in XReference Resolution (Loads)

The xref resolution within GenericSMF and MulitLeg loading had issues when the xref identifiers contained special characters. The following rules were fixed in order to allow for handling of the special characters in the xref resolution:

• get_xrefs_list.inc

• ins_upd_smf_req.inc

• ins_upd_xrefs.inc

• get_smf_all_xrefs_list.xsl

This issue was tracked as Item #149043.

...

There were mismatches between the data loaded and extracted using the Reference Exchange Price interface. The t_issueprice_exchange.xml rules were changed to correct mismatches for the following nodes:

• priceExchangeCode

• priceFlag

• priceCurrency

• sourceSrcIntfcInst

This issue was tracked as Item #138543.

...

Two new fields, pointSize and lastTradeDate, were added to the generic and accounting SMF interfaces. The pointSize and lastTradeDate were added mapped in the following rules:

• smf_aliases.inc

• generic_smf_base_model.inc

• smf_egl_gen_interface_template.xsl

This issue was tracked as Item #148538.

...

Extracts could have less records than expected. This was caused by a size limit on the outgoing file. To resolve this issue, the following file in /eagle_ml-2-0_cm were updated:

• extract2t.inc

• extract_eofw.inc

This issue was tracked as Item #148845.

...

During the installation of EagleML packages through the auto installer stream, there were some streams which get overwritten when they should not. The following streams are meant to remain constant:

• app_id

• stream_status

• stream_parameters

• stream_category_1

• stream_category_2

• stream_category_3

To resolve this issue, changes were made to the auto installer that would maintain some streams and not allow them to be overridden.

...

This issue was tracked as Item #149087.

EJM

Fixed File Assignment for Load During Message Center Restarts

...

This issue was tracked as Item #148542.

I2I

Added new streaming XMLDBAPI Position Extract

...