Development Guides

Data Mapping – Financial Planning

https://oas.force.com/BrinkerSupport/s/article/Orion-Mapping-to-Orion-Planning

The below mapping information provides the data sync from Orion Connect to Orion Planning.

  • When reviewing these fields, always reference this table to ensure you are looking in the right place (Orion or Orion Planning) to make an adjustment.
  • Refer to the notes at the bottom of the document. Not all fields are updated after every login (Single Sign-on). 
  Orion FieldDirectionOrion Planning Field
1 Primary Contact  
 aHousehold level Email>>User Email
 bEdit Household>General>>Principle
 cFirst Name>>First Name
 dLast Name>>Last Name
 eDOB>>Year of Birth
2 Partner  
 aEdit Household>Household Members>Husband or Wife must be selected>>Partner
 bFirst Name>>First Name
 cLast Name>>Last Name
 dDOB>>Year of Birth
3 Child  
 aEdit Household>Household Members>Son or Daughter must be selected>>Child
 bFirst Name>>First Name
 cDOB>>Year of Birth
4 N/A</>Tax Filing: Individual or Married Filing Jointly if Household has a Spouse
5 State>>Filing State
6 Account  
 aAccount Type>>Account Type
 bName (Registration Level)>>Account Owner
 cRegistration Name>>Account Description
 dCustodian>>Financial Institution 
 eCurrent Value>>Current Market Value
 fAsset Class>>Asset Allocation
 gN/A</>Hypothetical Return (Calculated in Advizr)
7 Real Estate  
 aAccount Type>>Name
 bN/A</>Usage (Default to Personal)
 cName (Registration Level)>>Owner
 dCurrent Value>>Market Value
8 Business Asset  
 aAccount Type>>Name
 bName (Registration Level)>>Owner
 cCurrent Value>>Value
10 N/A</>A trust is created if an Orion account is owned by a trust, and a trust does not already exist in Advizr.

Note: Fields 1-3.c are updated at every login (SSO) from Orion to Orion Planning. Tax information is NOT updated after the first login from Orion to Orion Planning. Fields 6.c, 6.e, 7.d, and 8.c are updated at every login if the Sync Account Value is turned on for each respective Asset. Fields 6.f and 6.g are only updated at every login if Sync Asset Allocation is turned on for each respective Asset. 

*** Direction:  The symbol “>>” means data flows from Orion to Orion Planning, and “</>” means there is no connection, and in some instance a default input is entered in Orion Planning.