Using the Orion Integration

Follow

Overview

Our Orion integration allows advisors to keep client portfolios in sync between Practifi and Orion. This article outlines the integration, how to use the integration and the data field mapping of the integration.

Please note: This functionality will not be available in your organization if the integration has not been enabled.

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 need to be linked to a Household in Practifi with Orion Accounts and Assets mapped across to Practifi Assets and Holdings, respectively.  

The Orion integration has been designed to have Households in Orion transferred and available in Practifi, subject to some Household activity rules, but are not immediately created as a Practifi Client. Instead, they can be searched in Practifi and promoted to Prospect or Client and they are created as simply Entities in the Practifi system. Clients in Practifi can be created in Orion as a Household manually, initiated from within Practifi, but are not automatically created in Orion. 

Once an Orion Household and a Practifi Client have been linked, any updates to information on either side will flow between systems as per the table below. 

Practifi

Sync

Orion

Client Account

🠜 Real-time 🠞

Household

Person Account

🠜 Real-time 🠞

Household Member

Asset Liability

🠜 Real-time 

Account

Holding

🠜 Real-time 

Asset

 

It is important to note that a user must have both a Practifi license and an Orion license attached to their user profile to use the Orion integration successfully. The user will also need to have authorized the OrionConnect App. Failure to have either of these will cause errors within your organization's sync and can lead to information changes made in Practifi being overwritten during the sync. If a ‘Default User’ is set up in the Orion app, then this user can be used to sync updates from Practifi to Orion and not all the users need an Orion license in the CRM.


Using the Integration

Viewing Orion Account Assets and Holding in Practifi 

To view the Orion Account Assets and Holdings, select the Financials button in the Client record's side panel. 

mceclip0.png


Clicking on an Asset record will take you to the Asset page, where you can see all the Holdings within the account.

List of Assets and Liabilities of the Client.

mceclip2.png

Details of a particular Asset.

mceclip3.png

 
List of Holdings under an Asset.

mceclip4.png


Details of a particular Holding.

mceclip5.png

Creating and Linking Orion Accounts to Practifi Clients

mceclip6.png


Alternatively, you can use a custom page prepared by Orion to list Practifi Clients who have not yet been linked to a corresponding Orion Household using a search tool. The link will be supplied by your Practifi Customer Support team on setting up your system.

This produces a list of Practifi Clients who, as yet, do not have a link to an Orion Household.

mceclip7.png

If a record isn't appearing on this page that you expect to see there, make sure it matches the criteria:

  1. Orion ID is empty.
  2. Has Entity Record Type as Household Client.

Clicking on the Create/Link in Orion link will open a panel by which Orion Households can be located.

mceclip0.png


Here, no match was found for "Daniel Smith" under Keyword Search.  

mceclip2.png

But changing the Keyword Search term and clicking outside the field produces a list of potential Smith Households.

mceclip10.png

 Selecting one of the existing Orion Households gives the options to

  • Compare fields between the Practifi and Orion records, to confirm the match
  • Link the Practifi Client and Orion Household

mceclip11.png

mceclip12.pngIf Link has been selected, confirmation messages will appear

mceclip14.png

mceclip15.png

On refresh of the Client record, the Orion Id will display as a link in the Orion Status field.

 

mceclip3.png

Updating Synchronized Records

  • Updates to the Client record in Practifi will automatically synchronize into Orion's Households, and vice-versa.
  • Updates to the Asset and Holding records made in Practifi will not be synched back to Orion (not supported).

Accessing Client's Orion link and Orion Insights

You can access Orion Links and Orion Insights under the Financial navigation section on the Client page.

mceclip4.png
mceclip5.png

Please note: To see all four Orion Insight charts, the user needs a widescreen or can zoom out on a small screen, otherwise only two charts will display.

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 under the App Launcher. If it does not appear in your frequently used list, use the App Launcher search to search for Orion Connect.

mceclip0.png

Field Mapping

Below are the field mappings for the integration between Orion and Practifi. These field mappings are separated into tables by Orion object and their corresponding Practifi object. Any field that is not listed within these tables is not mapped and should be set to the <<NOT SYNCED FROM ORION>> value in the sync mapping settings. 

Orion Household to Practifi Entity

Practifi Object: Account

Record Type: Household Client

Orion Field Practifi Field Orion API Return Mapping
Active Active (OASP__OAS_Active__c) portfolio.IsActive
BillingCity Billing City (BillingCity) portfolio.city
BillingPostalCode Billing Zip/Postal Code (BillingPostalCode) portfolio.zip
BillingState Billing State/Province (BillingState) portfolio.state
BillingStreet Billing Street (BillingStreet)

portfolio.address1

Name Entity Name (Name)
[may be Account Name (Name)]

portfolio.name

Performance 1 YR Performance Last 12 Months (practifi__Performance_Last_12_Months__c)

 

Performance 2 YR Performance Last 36 Months (practifi__Performance_Last_36_Months__c)

 

Performance MTD  Performance MTD (practifi__Performance_MTD__c)

 

Performance QTD Performance QTD (practifi__Performance_QTD__c)

 

Performance YTD Performance YTD (practifi__Performance_YTD__c)

 

 

Orion Household Member to Practifi Individual 

Practifi Object: Account

Record Type: Individual Member 

Orion Field Practifi Field
Birthdate Birthdate (PersonBirthDate)
Email Email (practifi__Email__c)
Fax

Entity Fax (Fax)

[may be Account Fax]

FirstName First Name (FirstName)
HomePhone Home Phone (PersonHomePhone)
Household Orion_Id Parent Entity (Orion Id) (Parent.OASP__Orion_Id__c)
LastName Last Name (LastName)
MailingCity Mailing City (PersonMailingCity)
MailingPostalCode Mailing Zip/Postal Code (PersonMailingPostalCode)
MailingState Mailing State/Province (PersonMailingState)
MailingStreet Mailing Street (PersonMailingStreet)
MobilePhone Mobile (PersonMobilePhone)
Orion_Deleted Orion_Deleted (OASP__Orion_Deleted__c)
Orion_Id Orion Id (OASP__Orion_Id__c)
Title Title (PersonTitle)

 

Orion Account to Practifi Asset/Liability 

Practifi Object: Asset/Liability 

Record Type: Asset 

Orion Field Practifi Field Notes
Account Type Registration Type (practifi__Registration_Type__C)  
Closed_Date Closed Date (practifi__Date_Closed__c)  
Household.Orion_Id Client (Orion Id) (practifi__Client__r.OASP__Orion_Id__c)  
IsManaged Under Advice (practifi__Under_Advice__c)  
Name Account Number (practifi__Account_Number__c)  
Orion_Id External Id (practifi__External_Id__c)  
Starting_Value Initial Value (practifi_Inital_Value__c)  
Custodian Custodian (Custodian__c) [lookup:OAS_Custodian__c] This field requires additional assistance for mapping to be successful. Please contact Practifi for additional assistance if you are looking to map this field.
Bill Valuation Method AUM Valuation Method (practifi__AUM_Valuation_Method__c)  
Bill Frequency Billing Frequency (practifi__Billing_Frequence__c)  
Bill Start Date Billing Start Date (practifi__Billing_Start_Date__c)  
Fee Schedule Fee Schedule Description (practifi__Fee_Schedule_Description__c)  
Bill Included in Aggregate Bill Included in Aggregate (Billl_Include_In_Aggregate__c) [checkbox] This field requires additional assistance for mapping to be successful. Please contact Practifi for additional assistance if you are looking to map this field.
Performance 1 YR Performance Last 12 Months (practifi__Performance_Last_12_Months__c)  
Performance 3 YR Performance Last 36 Months (practifi__Performance_Last_36_Months__c)  
Performance MTD Performance MTD (practifi__Performance_MTD__c)  
Performance QTD Performance QTD (Performance_QTD__c)  
Performance YTD Performance YTD (Performance_YTD__c)  
Realized G/L YTD Realized Gain YTD (practifi_Realized_Gain_YTD__c)  
Realized G/L Previous Year Realized Gaint Last Year (practifi__Realized_Gain_Last_Year__c)  
Unrealized Gain/Loss Unrealized Gain (pracitifi__Unrealized_Gain__c)  

 

Orion Asset to Practifi Holding

Practifi Object: Holding 

Orion Field Practifi Field
Account.Orion_Id Asset/Liability (External_Id) (practifi__Asset_Liability__r.practifi__External_Id__c)
Asset Name Holding Name (Name)
Asset Value  Balance (practifi__Balance__c)
Orion_Id External Id (practifi__External_Id__c)
Price Price (practifi__Price__c)
Price Date As At (practifi__As_At__c)
Product Sub Type Segment Name (practifi__Segment_Name__c)
Product Type Class Name (practifi__Class_Name__c)
Ticker Product Code (practifi__Product_Code__c)
Units Units (practifi__Units__c)

 

Orion Receivables to Practifi Installments

Practifi Object: Installments (practifi__Installment__c)

Orion Field Practifi Field
Receivables ID External Id (practifi__External_Id__c)
Adjustments Adjustments (practifi__Adjustements__c)
As Of Date Date (practifi__Date__c)
Financial Account Asset (practifi__Asset__r.practifi__External_Id__c)
Initial Amount Initial Amount (practifi__Initial_Amount__c)
Total Amount Final Amount (practifi__Final_Amount__c)

 

Enhanced Data Model

With our Albariño release, we have added fields to maximize the power of the Orion integration. The new fields appear in the Basics section on Assets and Services; however, for Clients we’ve placed them in the Financials section of the record page to avoid cluttering the Basics section there. These fields are visible in the Specifics tab in that section. Fields are conditionally displayed, so records that don’t have data to present won’t have these fields visible on their record pages.

Implementation Details

The following Lightning pages have been modified to add these fields as part of this enhancement:

  • Asset/Liability Record Page
  • Client Record Page

If your firm has customized the above pages, an administrator will need to either copy the changes into your customized version or switch to the Practifi version and redo the changes. 

Please note the following about the tables below: Field names in italics are editable fields; all other fields are read-only.

Asset/Liability

Name

Field Type

Help text

Custodian Name

Text (255)

 

AUM Valuation Method

Picklist (Period End Value, Avg Daily Balance)

How is the AUM value of this asset factored into its fee calculations?

Billing Frequency

Picklist (Monthly, Quarterly, Semi-Annually, Annually)

 

Billing Start Date

Date

 

Fee Schedule Description

Text (255)

How are the fees for this asset calculated?

Exclude from Billing

Checkbox

If checked, then the asset is not factored into billing calculations for this client.

Performance Last 12 Months

Percent (7,2)

Time-weighted return, or compound rate of growth, for the asset in the twelve calendar months that precede the current one.

Performance Last 36 Months

Percent (7,2)

Time-weighted return, or compound rate of growth, for the asset in the thirty-six calendar months that precede the current one.

Performance MTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for the asset so far this month.

Performance QTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for the asset so far this quarter.

Performance YTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for the asset so far this year.

Realized Gain YTD

Currency (12,2)

Profit from selling shares so far this year.

Realized Gain Last Year

Currency (12,2)

Profit from selling shares in the previous calendar year.

Unrealized Gain

Currency (12,2)

Gains or losses not yet traded in for cash.

 

Entity

Name

Field Type

Help text

Performance Last 12 Months

Percent (7,2)

Time-weighted return, or compound rate of growth, for this client’s assets in the twelve calendar months that precede the current one.

Performance Last 36 Months

Percent (7,2)

Time-weighted return, or compound rate of growth, for this client’s assets in the thirty-six calendar months that precede the current one.

Performance MTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for this client’s assets so far this month.

Performance QTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for this client’s assets so far this quarter.

Performance YTD

Percent (7,2)

Time-weighted return, or compound rate of growth, for this client’s assets so far this year.

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.