Standard Reports

SalesConnect includes several standard reports, each of which is described in this section. See these topics for details:

The Big Ticket Report

The Big Ticket report lists trades, by territory (within a particular territory categoryClosedA territory category represents one set of distinct territories that you need to maintain at the same time. A single territory category may not reflect how your sales force is distributed, so you can define up to fifteen (15) different territory categories in SalesConnect; however, only one version in each territory category can be current at any given time. Categories can represent particular lines of business (such as wirehouses or banks) or product lines (such as mutual funds or annuities), or any other meaningful division for which you need to support distinct sets of territories. Categories include as many named territories as you need to identify sales responsibilities. Named territories are often geographical in nature, but can also include channel/subchannel definitions and firm associations. Applicability also affects office and rep/partnership/team territory assignments: if a territory category is applicable to a firm, then entities associated with that firm can be assigned to territories in that category; but if the category is not applicable to a firm, then associated entities are not assigned to a defined territory in it, but are instead flagged "Not Applicable" for the category.), that exceed a designated minimum trade amount. When operators request this report, they supply values for the following parameters:

  • Trade Class
  • Territory Category
  • Territories
  • No Sales
  • Pass Throughs
  • Funds
  • Minimum Amount
  • Operator
  • Time Period (Start Date, End Date).

The Client System Maintenance Failure Report

If you are a Universal Dealer Services client, the Client System Maintenance Failure report is generated each day for you by Universal Dealer Services and is then placed in the public reports folder UD Reports. Each such report lists UDS-initiated maintenance transactions that failed in your SalesConnect system.

You cannot request the Client System Maintenance Failure report; it is automatically generated each business day.

The Daily Fund Sale Report

The Daily Fund Sale report shows daily sales of each fund by territory (within a particular territory category) with month-to-date and year-to-date summaries. When operators request this report, they supply values for the following parameters:

  • Funds
  • Firm
  • Office
  • Rep
  • Operator
  • Report Date.

The Daily Fund Sales - Monthly Report

The Daily Fund Sales - Monthly report shows month-to-date and year-to-date sales of each fund by territory (within a particular territory category). When operators request this report, they supply values for the following parameters:

  • Funds
  • Firm
  • Office
  • Rep
  • Operator
  • Report Date.

The Daily Journal Report

The Daily Journal report shows daily, calendar year-to-date, and by month sales activity by territory (within a particular territory category), by fund and by firmClosedA broker/dealer firm (or broker dealer or broker-dealer) is a connection associated with intermediary business, typically a top-level organization in this hierarchy. Broker/dealer firms are also sometimes referred to as just "firms" or "brokers" or "dealers" or "financial institutions." Each broker/dealer firm may have one or more offices affiliated with it, and through these offices, reps may also be affiliated with it. A broker/dealer firm may have associated firm contacts, as well. Possibly the most critical information you can track for broker/dealer firms are aliases, also known as trading IDs. Aliases are the IDs that associate transactions with each broker/dealer firm. If you need to write queries or reports: The primary data for broker/dealer firms is stored in the Firm table. The Firm Alias table stores trading IDs associated with broker/dealer firms. for the report date. When operators request this report, they supply values for the following parameters:

  • Territory Category
  • Territories
  • Firm
  • Fund
  • Report Date.

The Daily Sale History Report

The Daily Sale History report provides a detailed report of sales by territory (within a particular territory category). When operators request this report, they supply values for the following parameters:

  • Operator
  • Territory Category
  • Territories
  • Start Date
  • End Date.

The Firm by Territory Report

The Firm by Territory report shows firm sales and redemptions by territory (within a particular territory category). When operators request this report, they supply values for the following parameters:

  • Operator
  • Firm
  • Fund
  • Territory Category
  • Territories
  • Start Date
  • End Date.

The Firm Summary Posting Report

The Firm Summary Posting report provides a summary of total sales and redemptions by firm. When operators request this report, they supply values for the following parameters:

  • Firm Name
  • Address
  • Asset
  • Redemption
  • Start Date
  • End Date.

The Firms not Supported by UDS Report

The Firms not Supported by UDS report is available only to Universal Dealer Services clients. It lists identifying information for firms in SalesConnect that are not maintained by Universal Dealer Services. When you request this report, you supply a value for the Operator parameter.

The First Time Ticket Droppers Report

The First Time Ticket Droppers report lists reps with first-time sales or redemptions within a particular dollar amount range, for particular funds during a specified time period. When operators request this report, they supply values for the following parameters:

  • Start Date
  • End Date
  • Territory Category
  • Territories
  • Fund
  • Transaction type
  • Minimum amount
  • Maximum amount.

The Fund Totals Report

The Fund Totals report shows sales and redemptions of each fund by territory (within a particular territory category) for a designated time period. When operators request this report, they supply values for the following parameters:

  • Operator
  • Territory Category
  • Territories
  • Fund
  • Pass Through
  • Start Date
  • End Date.

The Heavy Hitters Report

The Heavy Hitters report lists representatives, by territory (within a particular territory category), who have exceeded a designated sales amount for a fund for a specified time period. When operators request this report, they supply values for the following parameters:

  • Operator
  • Territory Category
  • Territories
  • Fund
  • Minimum Amount
  • Start Date
  • End Date.

The Office Summary Posting Report

The Office Summary Posting report lists sales and redemptions by office. When operators request this report, they supply values for the following parameters:

  • Office Name
  • Address
  • Asset
  • Redemption
  • Start Date
  • End Date.

The Offices Not Supported by UDS Report

The Offices not Supported by UDS report is available only to Universal Dealer Services clients. It lists identifying information for offices in SalesConnect that are not maintained by Universal Dealer Services. When you request this report, you supply a value for the Operator parameter.

The Partnership Percentage Change Report

The Partnership Percentage Change report is available only to Universal Dealer Services clients. It lists partnership percentage changes in the previous business day that occurred as a result of maintenance by Universal Dealer Services. If the maintenance that caused the percentage change involved adding a member to or deleting a member from the partnership, this is detailed in the report. When you request this report, you supply a value for the Operator parameter.

The Past Trades Detail Supersheet Report

The Past Trades Detail Supersheet report provides detailed information about listed trades. When operators request this report, they supply values for the following parameters:

  • Operator
  • Fund
  • Territory Category
  • Territories
  • Firm
  • Office
  • Rep
  • Transaction
  • Start Date
  • End Date.

The Production for All Firms Report

The Production for All Firms report shows monthly totals by firm for a designated year. When operators request this report, they supply values for the following parameters:

  • Year
  • Fund
  • Number of Firms
  • Transaction.

The Reps Not Supported by UDS Report

The Reps not Supported by UDS report is available only to Universal Dealer Services clients. It lists identifying information for reps in SalesConnect that are not maintained by Universal Dealer Services. When you request this report, you supply a value for the Operator parameter.

The Sales by Fund Report

The Sales by Fund report summarizes transactions by fund for a specific date range. When you request this report, you supply values for the following parameters:

  • Start Date
  • End Date
  • No Sales
  • Pass Through
  • Funds
  • Operator.

The Sales by Fund - Month Report

The Sales by Fund - Month report summarizes, for selected month and for quarters, transactions by fund for a specific month and year. When you request this report, you supply values for the following parameters:

  • No Sales
  • Pass Through
  • Funds
  • Operator
  • Year
  • Month.

The Sales by State Report

The Sales by State report shows monthly totals by state for a designated year. When you request this report, you supply values for the following parameters:

  • State
  • Year.

The Summary Sales by Territory Report

The Summary Sales by Territory report shows month, prior month, year, and prior year sales and redemptions by territory. When operators request this report, they supply values for the following parameters:

  • Category
  • Year
  • Month.

The Territory Change Report

The Territory Change report lists the offices and representatives in your SalesConnect system for which territories changed in the previous day because of an address change. When you request this report, you supply a value for the Operator parameter.