These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Wealth Management Platform
- Data model and import order
The tables behind Wealth Management Platform
Wealth Management Platform ships with 16 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 16
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Client Instructions:
Instructions, Counterparties, record attachments. Each instruction belongs to an organization, names an eligible counterparty and an owning team member, and carries a version number.
Independent Review:
Review decisions record the decision, reason and reviewer against an instruction version.
Trading Orders:
Trading orders, Executions, trading accounts, Instruments. An order belongs to one custodian account and instrument; executions belong to one order.
Execution Evidence:
Execution evidence lines belong to an instruction and carry the provider event ID, quantity, price, fees and status.
Portfolio Reconciliation:
Position snapshots hold quantity, cost basis and mark price by account, instrument and date; portfolio snapshots hold the household snapshot with custodian reference and market value.
Operations Control:
Operation receipts record each guarded action on an instruction; exchange rates hold read-only effective rates.
Access:
Organizations, team members and Users scope each staff member to a firm.
Every table, by feature
- Client Instructions4
- Independent Review4
- Trading Orders4
- Execution Evidence3
- Portfolio Reconciliation4
- Operations Control5
- Shared and settings2
- Instructions
Client and operational instructions with lifecycle status
Linked to Organizations, Team members, Counterparties - Counterparties
Eligible external counterparties per organization
Linked to Organizations - Record attachments
Supporting files attached to instructions
Linked to Instructions, Team members - Organizations
Firms and client organizations served by the platform
- Review decisions
Independent review decisions on instruction revisions
Linked to Instructions, Team members - Instructions
Client and operational instructions with lifecycle status
Linked to Organizations, Team members, Counterparties - Team members
Internal staff with platform identity and role scope
Linked to Organizations, Users - Counterparties
Eligible external counterparties per organization
Linked to Organizations
- Trading orders
Advisor-reviewed trading orders
Linked to Trading accounts, Instruments - Executions
Provider executions against trading orders
Linked to Trading orders - Trading accounts
Custodian trading accounts
- Instruments
Tradable instruments with venue and asset class
- Execution evidence
Provider execution evidence lines attached to instructions
Linked to Instructions - Instructions
Client and operational instructions with lifecycle status
Linked to Organizations, Team members, Counterparties - Operation receipts
Idempotent operation receipts for guarded actions
Linked to Instructions
- Portfolio snapshots
Custodian portfolio reconciliation snapshots
Linked to Instructions, Organizations, Trading orders, Instruments - Position snapshots
As-of custodian position snapshots
Linked to Trading accounts, Instruments - Trading accounts
Custodian trading accounts
- Instruments
Tradable instruments with venue and asset class
- Operation receipts
Idempotent operation receipts for guarded actions
Linked to Instructions - Record attachments
Supporting files attached to instructions
Linked to Instructions, Team members - Organizations
Firms and client organizations served by the platform
- Team members
Internal staff with platform identity and role scope
Linked to Organizations, Users - Counterparties
Eligible external counterparties per organization
Linked to Organizations
Keys and references
Every instruction keeps a stable record number, every counterparty and organization a code, every account an account code and external account ID, and every instrument a symbol. Import executions by provider execution ID and evidence by provider event ID so repeats are recognized. Keep the custodian’s snapshot ID on each position. Amounts are recorded in US dollars as received.
The platform holds 16 tables and 22 relationships.
Migration order
- Load Organizations, Users and team members.
- Load Counterparties, Instruments and trading accounts.
- Load open Instructions with record numbers, owners and versions, then record attachments.
- Load open trading orders and their Executions.
- Load the latest position snapshots and the last approved portfolio snapshots.
- Reconcile open instructions, orders and household values with the source before submitting new work.
Set up Wealth Management Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.