Archer

Archer's Data Cloud hosted through Snowflake® provides direct integration with a data marketplace so asset management teams can query their Archer datasets alongside proprietary and third-party data. Managers can schedule queries to suit their needs and use available apps to quickly view data subsets and data visualizations. This approach helps asset managers directly query a database for the greatest amount of flexibility in the combination of what and how information can be obtained.

ACCOUNT PROFILE DATA All accounts’ profile data, including terminated accounts with termination date and termination value. Firm ID; Custodian Name; Custodian Account Number; Archer Account ID; Entity Name; Entity Long Name; Entity Status Description; Portfolio Model Name; Buy List Name; Account Objective Name; Investment Style Name; Portfolio Manager Name; Proxy Voting Description; Inception Date; Discretion; Sponsor Name; Sponsor Program Name; Salesperson Name; Client Type; Reconciled as of Date; Order Round Direction; Posting Method; Concentrated Portfolio; Cash % Min; Cash % Max; Equity % Min; Equity % Max; Fixed % Min; Fixed % Max; User Defined 1; User Defined 2; User Defined 4; User Defined 5; User Defined 6; Tax Status; State Code; ERISA Indicator; Birthday; Index 1; Index 1 Inception MTD Return; Index 2; Index 2 Inception MTD Return; FC Name; FC Code; Original Account Number; Value at Inception; Termination Date; FC ID; Value at Termination; First Name; Middle Name; Last Name; Address; Address Line1; Address Line2; Address Line3; Address Line4; City; State; Mail Code; Entity Sub Type; Marketing Group; Customer Type; Run Date ACTIVE ACCOUNTS’ AUM AND FLOWS Currently active accounts with latest or PME AUM and flows through MTD or as of PME. Firm ID; Archer Account ID; Begin Date; End Date; Beginning Market Value; New Client Flow; Existing Client Flow; Ending Market Value; Terminated Account Cash Flow; Run Date BILLING PROFILE Billing detail by account including breakpoints and calculation settings.

Annual rate; Billing Method; Billing On; Billing Profile ID; Billing Type; Days in Year; Debit Account; Entity ID; Firm ID; Frequency Per Year; Household Incl Flag; Level Description; Market Value Basis; Market Value Source; Maximum Market Value; Minimum Market Value; Payment Type; Period Calculation Method; Run Date; Start Month CLIENT CONTACTS Client contacts associated with Archer accounts; may be used for reporting and invoices. Firm ID; Archer Account ID; Contact Name; Company Name; Address Type; Address Line1; Address Line2; Address Line3; Address Line4; City; State; Mai Code; Country; Primary Address Flag; Email; Home Phone; Cell Phone; Business Phone; Run Date FINANCIAL CONSULTANT Lists financial consultant information stored in Archer. Firm ID; Sponsor ID; Sponsor Name; FC ID; FC Code; First Name; Last Name; FC Name; FC Addr1; FC Addr2; FC Addr3; FC Assistant Email; FC Assistant Name; FC Assistant phone; FC Branch; FC City; FC Email; FC Fax; FC Phone; FC Region; FC State; FC Zip; Run Date PAPERWORK Archer’s workflow documentation by account.

Firm ID; Archer Account ID; Received Date; Close Date; Last Update Time; Paperwork Type; Paperwork Status; Kind; Transaction Amount; Filename; Notes; Run Date RESTRICTIONS Listing of restrictions assigned at the account level; includes a current violation indicator. Excludes restrictions that are automatically assigned based in Account Group membership.