Application Development
Cyber Security
Featured
Management Consultancy
TW
Author
Tyler Weltz
Read time
4 minute read
Published
19 Mar 2026
Topics
AI and Data Science
Executive summary
Trading file reporting to custodians — done right, done once.
Within the Investment Management industry, reporting of trading activities is critical. Trading files need to be sent out to custodians to ensure they are aware of any transactions that occurred for settlement purposes. With this hedge fund, they were going to be trading a wide array of asset types and needed three separate reports set up.
OmniVista Solutions worked with the report recipients to gather business requirements covering format and field expectations. We created a mapping document, identified missing data within the trading system, and then utilised the export functionality within Charles River to create the reports. A hybrid team of consultants, report recipient personnel, and hedge fund personnel completed implementation and testing.
Architecture
One unified view. Three asset-type reports. Zero duplicated logic.
The typical Charles River export process uses Definition tables to build SQL statements. Rather than embedding conditional field logic in each Definition table separately, OmniVista built a single SQL view to consolidate all required data — then accessed that view from each Definition table for display. This kept all conditional logic in one maintainable place.
Export pipeline — end to end
Why a unified view?
→
All conditional field logic lives in one place — not duplicated across three separate Definition tables.
→
Definition tables retain their built-in Charles River export features while referencing the view for display columns.
→
If a column displays inaccurate information, users simply update the view — no changes needed across multiple tables.
→
Asset-type routing is handled cleanly — each report only shows trades relevant to its designated asset class.
The process
From requirements to custodian-ready exports
OmniVista assembled a hybrid team — consultants, report recipient full-time personnel, and the hedge fund’s own team — to work through each phase from requirements gathering through to live testing.
Phase 01 — Requirements
Business requirements & field mapping
OmniVista worked directly with report recipients to capture business requirements — covering expected format, required fields, and optional fields. A mapping document was created to lay out which data points would populate each field in the export.
Phase 02 — Gap analysis
Identifying missing data in the trading system
Working with the hedge fund’s full-time personnel, OmniVista identified data points that appeared to be missing within the Charles River trading system — ensuring all required fields could be sourced before building began.
Phase 03 — Build
Unified view and definition table construction
A single SQL view was built to consolidate all required data across asset types. Three Definition tables were then configured to access this view — each filtering to the appropriate asset class for its custodian export.
Phase 04 — Testing
Hybrid team implementation and sign-off
A hybrid team of OmniVista consultants, report recipient personnel, and hedge fund staff completed implementation and testing — validating that trades appeared on the correct report based on asset type before go-live.
The three reports
Each report tailored to its asset class and custodian
Each report runs once daily, pulling from the unified view and filtering trades by asset type — ensuring every custodian receives only the transactions relevant to their settlement scope.
Benefits
Three functioning reports. One easy-to-maintain architecture.
The result was three functioning reports that would be easily maintainable going forward. If any column displayed inaccurate information, users simply access the view and make the required change — no touching multiple Definition tables.
Custodian settlement confidence
All three custodians receive accurate, asset-type-specific trading files daily — ensuring settlement processes run without manual intervention or data errors.
Single point of maintenance
All conditional logic lives in the unified view — changes to field logic only need to be made once, reducing the risk of inconsistency across reports.
Built-in Charles River export features retained
By keeping Definition tables and accessing them via the view, OmniVista preserved the full built-in export functionality of the Charles River platform.
Scalable for future asset types
The view-based architecture makes it straightforward to add new asset types or reports in the future — simply extend the view and create a new Definition table.
One view. Three reports. Zero manual intervention.
OmniVista · Application development · Management consultancy
Building trade reporting infrastructure in Charles River or another OMS?
OmniVista provides expert implementation and support for investment management platforms globally.
