Using the Orion integration - SPA


Integration summary

Our integration with Orion helps you keep client portfolios in sync with the rest of your business:

  • View Orion Accounts & Holding information from the Practifi Client record
  • Summarise account performance with an Orion Insight dashboard
  • Access more Household information and features from the Orion Links navigation bar

Orion Households are captured in Practifi as an Entity owned by the Client, and that Entity record contains one or more Orion Accounts or Assets. The information flows between systems as per the table below:




Client Entity

🠜 Real-time 🠞


Orion Asset

🠜 Real-time 


Orion Holding

🠜 Real-time 



A detailed list of field mappings appears at the end of this document


Using the integration

Viewing Orion Accounts in Practifi
  • Orion Assets are located in the Orion Assets tab on the Client record
  • Clicking on an Asset record will take you to the Asset page, where you can see all the Holdings within the account.
  • Click Dashboard in the left-hand navigation bar to be taken to the Orion Insights dashboard for the account.
Linking Orion Accounts to Practifi Clients 
  •  In the User menu, click Data Management.
  • Select Un-linked Orion Accounts from the left-hand navigation bar.
  • To link a single Account, click the pencil icon next to the name of the Account, locate the Client you wish to link it to, then click Save.
  • To link multiple accounts to a single Client, select all the Accounts you wish to link, then click Mass Update Selected Rows, locate the Client you wish to link it to, then click Apply.
  • If a record isn't appearing on this page that you expect to see there, make sure it matches the criteria:
    • Has an Orion External ID & Household ID
    • Does not have an Entity Type
    • Has an Orgn Type of Client
Updating synchronised records
  • Updates to the Client record in Practifi will automatically synchronise with Orion's Households, and vice-versa.
  • Updates to the Asset record cannot be performed in Practifi.
Accessing Client Insights and Orion links

Client analytics and links are located in the Orion Links & Insights tab on the Client record. Select an Orion Account from the drop-down menu at the top of the page; once selected, the Orion Links bar and Insight dashboard below will appear below.

  • To define what links are available in the Orion Links bar:
    • Click Edit on the links bar to expose the editing panel & buttons
    • Click Sync
    • Refresh your Browser
    • Click Edit on the links bar again
    • Drag the links you wish to see to the main bar, then click Save Globally
  • The Insight dashboard shown to the user is the default one defined in the Insight app in Orion and Orion Connect. If you're not sure how to define the default dashboard in Insight, contact Orion Support.
Accessing the Orion Connect Salesforce application

Practifi's Orion integration is powered by Orion Connect, Orion's integration package designed for Salesforce. We've surfaced many of its features inside Practifi, but if you ever want to access the application directly you can do so by clicking Orion Connect in your User menu:


Detailed Field Mapping

The Orion Financial Account and Asset information is mapped to a separate page within Practifi.  An example is below:


The detailed mapping of the Orion Financial Account data (Accounts and Holdings) to the page is as follows:



Practifi Section Field Label Orion Fields
Account Summary Closed Date OASP__OAS_Closed_Date__c
Account Summary Performance 3YR OASP__OAS_Performance_ThreeYear__c
Account Summary Performance MTD OASP__OAS_Performance_MTD__c
Account Summary Performance QTD OASP__OAS_Performance_QTD__c
Account Summary Performance YTD OASP__OAS_Performance_YTD__c
Account Summary Unrealized Gain Loss OASP__OAS_Unrealized_GL__c
Account Summary  Performance 1YR OASP__OAS_Performance_OneYear__c
Account Summary  Performance as of Date OASP__OAS_Performance_AsOfDate__c
Account Summary, Header Account Value OASP__OAS_Account_Value__c
Account Summary, Header Start Date OASP__OAS_Start_Date__c
Account Summary, Header Starting Value OASP__OAS_Starting_Value__c
Billing Bill Cycle Month OASP__Bill_Cycle_Month__c
Billing Bill Frequency OASP__Bill_Frequency__c
Billing Bill Start Date OASP__Bill_Start_Date__c
Billing Bill Style OASP__Bill_Style__c
Billing Bill Valuation Method OASP__Bill_Valuation_Method__c
Details Payout Schedule OASP__Payout_Schedule__c
Details  Fee Schedule OASP__Fee_Schedule__c
Details   Payment Method OASP__Pay_Method__c
Details, Header Custodian OASP__OAS_Custodian__r.Name
Details, Header Financial Account Name Name
Details, Header Account Type OASP__OAS_Account_Type__c
Registration Type name of Registrant OASP__OAS_Registration__r. OASP__OAS_Registration_Type__r.Name
Registration   Name: First Name, Last Name of Registrant OASP__OAS_Registration__r. OASP__OAS_First_Name__c, Last_Name__c
Registration, Header Registration ID OASP__OAS_Registration_ID__c
Trading Minimum Cash  OASP__OAS_Minimum_Cash_Balance__c
Trading Minimum Cash Type OASP__OAS_Minimum_Cash_Balance_Type__c
Trading Model OASP__OAS_Model_Name__c
Trading Replenish Minimum Cash OASP__OAS_Replenish_Minimum_Cash__c
Trading Trading Blocked OASP__OAS_Trading_Blocked__c
Trading Trading Instructions OASP__OAS_Trading_Instructions__c
Not Mapped   OASP__OAS_Active__c
Not Mapped   OASP__Bill_Include_In_Aggregate__c
Not Mapped   OASP__OAS_Business_Line__c
Not Mapped   OASP__OAS_Cash_Value__c
Not Mapped   OASP__Discretionary__c
Not Mapped   OASP__OAS_Outside_of_model__c
Not Mapped   OASP__OAS_Fund_Family__c
Not Mapped   OASP__OAS_Group_Number__c
Not Mapped   OASP__OAS_Historical_Account__c
Not Mapped   OASP__OAS_Household__c
Not Mapped   OASP__OAS_Individual_Household__c
Not Mapped   OASP__Investment_Discretion__c
Not Mapped   OASP__OAS_IsManaged__c
Not Mapped   OASP__Managed_Account_Value__c
Not Mapped   OASP__OAS_Management_Style__c
Not Mapped   OASP__OAS_Account_ID__c
Not Mapped   OASP__OAS_Orion_Deleted__c
Not Mapped   OASP__Orion_Id__c
Not Mapped   OASP__Orion_Rep_ID__c
Not Mapped   OASP__Other_Mgrs_SEC__c
Not Mapped   OASP__OAS_Outside_ID__c
Not Mapped   OASP__OAS_Plan__c
Not Mapped   OASP__Qualified__c
Not Mapped   OASP__OAS_Realized_GL_Previous_Year__c
Not Mapped   OASP__OAS_Realized_GL_YTD__c
Not Mapped   OASP__OAS_Shareclass__c
Not Mapped   OASP__OAS_Status__c
Not Mapped   OASP__OAS_Sub_Advisor__c
Not Mapped   OASP__Sync__c
Not Mapped   OASP__Voting_Authority__c
Not Mapped   OASP__Wrap_Managed__c



Practifi Section Practifi Field Label
Orion Fields
Holdings Account No. OASP__Account_Number__c
Holdings Class OASP__Asset_Category__c
Holdings Segment OASP__Asset_Class__c
Holdings Value OASP__Asset_Value__c
Holdings Unitized OASP__Price__c
Holdings As At OASP__Price_Date__c
Holdings Holding OASP__Product_Type__c
Holdings Holding Name
Holdings Holding Status OASP__Status__c
Holdings Product Code OASP__Ticker__c
Holdings Unitized OASP__Units__c
Not Mapped   OASP__Active__c
Not Mapped   OASP__Asset_Level_Strategy__c
Not Mapped   OASP__Bill_Partial_Exclusion__c
Not Mapped   OASP__Bill_Partial_Exclusion_End_Date__c
Not Mapped   OASP__Bill_Partial_Exclusion_Of__c
Not Mapped   OASP__Bill_Partial_Exclusion_Start_Date__c
Not Mapped   OASP__Bill_Partial_Exclusion_Type__c
Not Mapped   OASP__Custodial_Cash__c
Not Mapped   OASP__Exclude_From_Bill_Fees_And_Payouts__c
Not Mapped   OASP__Exclude_From_Rebalance__c
Not Mapped   OASP__Financial_Account__c
Not Mapped   OASP__Is_Managed__c
Not Mapped   OASP__Orion_Account_ID__c
Not Mapped   OASP__Orion_Asset_ID__c
Not Mapped   OASP__Orion_Id__c
Not Mapped   OASP__Pays_Bill_Fee__c
Not Mapped   OASP__Product_Name__c
Not Mapped   OASP__Product_Sub_Type__c
Not Mapped   OASP__Risk_Category__c
Not Mapped   OASP__Secondary_Account_Number__c
0 out of 0 found this helpful



Please sign in to leave a comment.