Release Notes: Data Services

See All Release Notes

Share:

May 2022

Last Recon Date - Exclusion of Advisor Maintained Assets

With the implementation of the last recon date functionality in Portfolio Audit we’ve been looking for situations that could misrepresent the cleanliness of a portfolio’s reconciliation when looking at one of the higher portfolio levels such as Household, Registration, or account. There are use cases where an account houses one or more Advisor Maintained assets alongside traditionally downloading and reconciled assets. 

 

With this update we will exclude the Advisor Maintained assets from the reconciliation check and therefore those assets will no longer generate the reconciliation warnings in Portfolio Audit.

How to get there: Portfolio Audit

April 2022

PNC Bank And Sunguard Data Feeds Now Support Principal and Income

The PNC Bank and Sunguard data feeds now have the option to break out the principal and income cash balances. This is done by allocating the income cash balance to a new cash asset in the account. You can have this enabled by submitting a request to sme-datarecon@orion.com 

How to get there: Orion Connect > Portfolio Audit > Accounts > Assets
AIP Transaction and AIP Asset update - Undo Functionality

Alternative Investment Platform (AIP)  users that utilize the AIP Transaction and the AIP Asset custom imports will now have the ability to undo both import types. Undoing a previously applied import will remove the data created by that import from the system.

How to get there: Orion Connect > Custom Imports > Import History > AIP Transaction or AIP Asset import that has been imported > View Import Data > Actions menu: Undo Import

March 2022

Alternative Data Audits

To better help advisors stay on top of their alternative data we’ve introduced an AIP Audits section. The AIP Audits section will provide five alternative data specific data queries to help bring greater visibility to specific data maintenance opportunities. The audits are:

AIP Product Summary: Summary by product of number of assets, asset description, and value for each product in AIP. Default parameter will be set to 1 which will only include assets with value. Use parameter 0 to include all assets.

 

AIP Product Overview: Gives a summary of total value, positions and commitment by alternative product.

 

AIP YTD Asset Review: Will return year to date performance returns across all AIP assets.

 

To better help advisors stay on top of their alternative data we’ve introduced an AIP Audits section. The AIP Audits section will provide five alternative data specific data queries to help bring greater visibility to specific data maintenance opportunities. The audits are:

AIP Performance by Manager: This audit will return various performance metrics including inception, period, month to date, quarter to date, year to date, 1 year, 3 year, 5 year, 10 year for IRR and TWR returns. The default parameter when first run will include all Fund Manager IDs with a short run-for period to ensure the results return quickly.

 

AIP Asset Consistency: This audit evaluates alternative products that have received a transaction event or a valuation on some but not all assets that belong to said product. An example of what would return in this audit would be Product ABC had a quarterly valuation added to 12 of 15 assets. The 3 assets that do not have a valuation record input for that same data as the other 12 would be returned. This audit will help look for gaps in data that potentially has been missed or is still waiting to be added.

Other Audits: This will link you to the Query application page and load your favorites for situations where you might have additional custom queries related to alternative data or anything else you might want to research.

How to get there: Orion Connect > Account Composer > Alternatives: AIP Audits
AIP Pending Statuses

For transaction and valuations records we’ve added functionality to allow for records to be added with a status of pending. In the system a pending status allows the records to be viewed and interacted without the attributes of the record such as units to impact the asset value or performance. To maintain the statuses of the transaction and valuation records in mass we’ve added right click functionality that allows users to select multiple records in a pending status and update them to complete at once. Once the status is set to ‘complete’ the records will impact asset value, performance, and be used in other areas of the platform like reports.

 

The ability to create a record with a pending status has also been added in the AIP transaction and valuation imports.

How to get there: Orion Connect > Account Composer > Alternatives: Transactions & Valuations

February 2022

Last Reconciled Date

We are releasing notifications in Portfolio Audit to allow visibility as to whether an account is in balance.   Two fields have been added to the account grid to show the most recent position file received for an account, and a flag to indicate whether all assets in the account are in balance with those most recent positions received.  In addition, indicators next to the tree icons in the Portfolio tree will present warning notifications for any accounts that are not in balance (yellow triangle), or for any accounts where the balance has not been verified as of the most recent business date (uncolored triangle).  Those flags carry up to the registration, portfolio group, and household level to notify if any accounts within that group carry a warning message.  

How to get there: Orion Connect > Portfolio Audit > Household> Registration> Account

January 2022

Product Name Override

Advisor level roles will now be able to customize the names of their products. The ability to change product names will be tied to a privilege that can be enabled in the Manage Users application. The privilege can be found by editing a role and navigating to Privileges > Actions > Products > Local Product Name Override where it can be enabled.

When a product name override is added at the local product level it will show up throughout the Orion platform wherever ‘product name’ is shown. Orion endpoints that return ‘product name’ will also return the override name, so if your firm leverages Orion APIs or have Integrations that use our API endpoints, the ‘product name’ field will also show the overridden product name in those situations.

At the global product level, the original product name will remain and show when loading a global product grid or viewing that information elsewhere. In the Product & Prices application, we’ve added the column “Orion Product Name” that can be added to your views so you can see any differences in product names in the grid. As best practice when communicating product information to Orion’s service teams, please use product ID or ticker, since product name can now differ in your database between the global and local tables.

How to get there: Orion Connect > Products and Prices > Edit Product

December 2021

ByAllAccounts Position-Only Data Feed

We are now able to support two data feeds for ByAllAccounts. The new feed will support accounts that you just need a balance for. This feed will bring in account holdings and insert a balance adjustment transaction to bring the Orion balance inline with the balance ByAll has captured. This offering allows you to bring in heldaway accounts at a lower cost but still allows  you to include the balance information in reports and financial planning.

How to get there: Reach out to sme-datarecon@orion.com for assistance in setting up this data feed.

November 2021

Transaction Add Custom Import Advisor Notes

The Advisor Notes field has been added to the Transaction Add custom import to allow the Advisor Notes to be populated when creating new transactions. 

How to get there: Orion Connect > Custom Imports > Transaction Add

October 2021

Pending Client Information Dashboard

To further help maintain demographic and account information changes that are sent from your custodial data providers we’ve made updates to the Pending Client Information section of the New Account Center. To start we’ve added the following columns to better help filter and maintain the clients information you’re reviewing. The new columns that can be added to the grid are: Account Number, Household Name, Registration Name, Representative Name, Rep Code, Custodian, and Fund Family.

The grid will also now display Household Name, Registration Type, and Rep Code as field types that can be reviewed and approved or denied.

How to get there: Orion Connect > New Account Center > Tools: Pending Client Information
Product Local Update Custom Import

We’ve taken the Product Main import from our legacy import suite and brought it into the new custom imports engine and experience. With the conversion of the import we included the following new fields: Annual Income Rate, ADV Asset Category, Is ADV Reportable, Is 13F Reportable, Has Fees, Federally Taxable, State Taxable, and Is Disabled. 

 

Users will still have access to the legacy Product Main import. The privilege to access the new Product Local import will be disabled by default and will need to be enabled to gain access.

 

Privilege: Manage Users > Roles > Right Click: Edit Role > Privileges: Actions > Custom Imports: Product – Local Settings

Training: Knowledge Article: How-To and Troubleshooting: Product Local Update

How to get there: Orion Connect > Custom Imports > Import Templates

September 2021

Additional Download Defaults

We have added four Download Defaults that can be set so that all accounts created through a download source automatically are set to the default chosen. The new download defaults are: Business Line, AUA Reportable, Wrap Managed, Wrap Sponsored

How to get there: These settings are only available internally. If you’d like to have any of the new or existing defaults enabled on a source for your database please contact the Recon Service team.
Newly Available Data Feeds

In Q3 the Interface Product Team completed the building and quality assurance checks on 10 new data feeds now available for full daily reconciliation.

  • Accutech Cheetah
  • Bremer Bank
  • PennMutual
  • Park National Bank – FiTek
  • Pacific Premier – Pensco Trust
  • Eaglebrook
  • BOK Financial
  • NixonPeabody
  • Huntington National Bank
  • Goldman Sachs
How to get there: If you’d like to request a new feed be established for any of the above interfaces please reach out to the Recon Service team or your firm's account advocate.

August 2021

Data Processing Speed and Quality Enhancements

We’ve optimized our transactional file processing to apply custodial transaction data significantly faster and with greater accuracy. These changes will positively impact all custodial transaction files loaded through the Orion Confirmation system.

 

Additionally we’ve refactored our sleeve data processing logic to also allow for significant improvements in processing times as well as much better data and reconciliation quality and accuracy.

FolioFN Custodial Cost Basis

We’ve introduced processing logic to allow us to load in custodial cost basis data for the FolioFN data format. We receive Position and Transactional data from FolioFN already sleeved and the Cost Basis data at a portfolio level.

With this new logic every sleeve’s assets will have the appropriate lot prorated and applied at the proportional percentage.

How to get there: Orion Connect > Tax Center

June 2021

AIP Enhancements: Custom Imports

AIP custom imports are now accessible in the Custom Imports app, which will allow users to edit data, add or remove rows within one screen.

How to get there: Orion Connect > Account Composer > Alternatives
AIP Enhancements: “As Of Date” Column

A column was added for an “as of date” value so the asset grid can show both the current value and the value as of a specific date. We have also updated the total cost basis so that it will return based on the date selected.

How to get there: Orion Connect > Account Composer > Alternatives
AIP Enhancements: Alternative Ledger Workflow

A simplified workflow for alternative ledger activity has been created, meaning users can stay within one field to update ledger information. Functionality to copy historical activity from another asset is also accessible within the alternative ledger activity.

How to get there: Orion Connect > Account Composer > Alternatives
SEI Trust Fee Detail

This enhancement allows for reporting of individual components of the trading expense transaction. The data points that are now broken out are: Activity Fee, Brokerage, Charge Applied To Min, Commission, Holding Fee, Income Fee, Issue Fee, Minimum Fee, Miscellaneous Fee 1, Miscellaneous Fee 2, Miscellaneous Expense, Operator Fee, Postage And Insurance, Principal Fee, Purchased Interest, Report Fee, SEC Fee, Special Holding Fee, and Special Issue Fee. 

Schwab VA Core

Partnering with Schwab and the enhancements they have made to their variable annuity data feed, we have enhanced our data feed to include holdings, transaction, price, security, and name files. 

Apex Clearing Cost Basis

We have partnered with Apex Clearing to add both realized and unrealized cost basis to the integration. This data can be used to enhance the trading experience or be included in reports.

May 2021

Pershing Transaction Expense Updates

The trading expense transactions have been updated to include the amounts Pershing list under the Misc Fee and Other Fee data points. This ensures the trading expense transaction includes all fees associated with the purchase or sale of a security.

Pershing Fee Detail

This breaks out the individual components of the trading expense transaction to make each component available to be queried. The data points that are broken out are: Interest, Commission, Tax, Transaction Fee, Misc Fee, Other Fee, TEFRA Withholding, Pershing Charge, Brokerage Charge, Sales Credit, Settlement Fee, Service Charge, Mark Up/Down.

2445-OAS-09/23/2020