Managing Aliases

Aliases for firms, officesClosedAn office is a connection in the intermediary business hierarchy, an organization subordinate to a broker/dealer firm. Offices are also sometimes referred to as "branches'; institutional firms have branches in SalesConnect. An office is affiliated with a single broker/dealer firm, and may have one or more reps directly affiliated with it. An office may have associated office contacts, as well. Possibly the most critical information you can track for offices are aliases, also known as trading IDs. Aliases are the IDs that associate transactions with each office. If you need to write queries or reports: The primary data for offices is stored in the Office table. Information about office trading IDs is stored in the Office Alias table., repsClosedA rep is perhaps the most important contact connection in the intermediary business hierarchy. Each rep is an individual who sells funds and is affiliated with an office (and through the office, with a broker/dealer firm). Reps may also be referred to as "financial advisors." Possibly the most critical information you can track for reps are aliases, also known as trading IDs. Aliases are the IDs that associate transactions and assets with each rep. If you need to write queries or reports: The primary data for reps is stored in the Contact and Rep Profile tables. The Rep Alias table stores trading IDs associated with reps., and partnershipsClosedA partnership is a contact connection in the intermediary business hierarchy, though it is really a name for a group of reps working together to sell one or more products. A partnership, sometimes called a rep partnership, is treated as a special type of rep: this means that most of the tools for working with reps may be used to work with partnerships as well. Most views of transactions associated with an individual rep generally don't include transactions or parts of transactions that the rep may have cleared as part of a partnership. Instead, these kinds of trades are listed only for the rep partnership. Each member's portion of rep partnership sales data is always based on the percentages currently assigned to each member; no long-term historical information about percentages is maintained. SalesConnect does not store any calculated trade or asset values based on rep partnerships. If you need to write queries or reports: The primary data for partnerships is stored in the Contact, Rep Partnership, and Rep Profile tables. The Rep Alias table stores trading IDs associated with partnerships as well as reps. link trades and assets to these connectionsClosedConnections are entities; they're the different types of companies and individuals you may need to track. SalesConnect is set up to display information about the types of connections you care about, based on the roles to which you are assigned.. Since firms, offices, reps, and partnerships may have one or many aliases, SalesConnect links aliases back to specific organizations, people and groups. When you add intermediary connections, you can add aliases at the same time. See Adding Connections for details. Or you can use the Aliases tab of connection detail pages to review and maintain aliases; you may be able to hover over links on those tabs to display related information and then click them for more details. Tthe AliasClosedAn alias is a trading ID for a intermediary connection (broker/dealer firm, office and/or rep or rep partnership). An office alias must be associated with a single, specific firm-level trading ID. A rep alias must be associated with a single, specific firm trading ID and a single, specific office trading ID. Each tracked trade is linked to a single specific set of aliases; most trades will be associated with a firm, office and rep alias, but some may be associated only with a firm and/or office alias, if the trades were not resolved to the rep level. If you need to write queries or reports: The primary data for aliases is stored in the Firm Alias, Office Alias, and Rep Alias tables. History tabs on those pages show alias maintenance: new aliases added, existing aliases changed, alias reassignments, and alias deletions.

An Aliases field is included on the Information tab of connection detail pages; you can select the number in that field to see a popup listing the associated aliases. Select the number again to close the popup.

You may be able to: