Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Expand
titleView Changelog

Date

Changes

December 2023January 2024

Created initial version.

Overview

The Product Manager displays the information about financial products in our Compensation and Compliance modules. It accepts product data feeds from each custodian that a client works with. The Product Manager merges product data and matches them based on the CUSIP, which is the unique ID for each product.

To access the Product Manager, click the ADMIN tab (1), then click on Product Manager (2).

There are three tabs in the Product Manager module:

  • Product Monitor

  • Setup

  • Merger Tool

Anchor
monitor
monitor
Product Monitor Tab

The Product Monitor tab shows financial products: equities, fixed income, mutual funds, annuities, options, etc., using Clearing Brokers, direct data sources, and third-party data sources for product attributes (such as leveraged and inverse products).

Product Monitor window:

  • Ticker Symbol/Fund Code (1) - Product number

  • Product Name (2)- Name of the Product

  • Product Type (3)- Type of the Product, set by Providers

  • Group Provider (4) - Firm providing multiple groups of products

  • Status Flags (5) - Indicator of current status

  • CUSIP (6) - Identification number

  • Fund Name (7) - Name of the Fund

  • Product Category (8) - Category name of the grouped products

  • Provider (9) - Firm providing products

  • Share Class (10) - Specified The type of security.

Image RemovedImage Added

Explanations of Used Terms

Ticker Symbol/Fund Code and CUSIP (1)

There are two industry numbering standards:

  • Ticker Symbols are typically only used for equities and options. Usually, it is they are between two and five characters long.

  • The second is CUSIP. A CUSIP number is a unique identification number assigned to stocks and registered bonds in the United States and Canada. It comprises nine characters and includes letters and numbers.

Product Name (2) and Fund Name (7)

Each product has a name. If it is a Mutual Fund, in addition, it has a Fund Name. For example, “American Funds”.

nProduct

Product Type (3) and Product Category (8)

Product Type and Product Category are ways of grouping products. The database can contain an unlimited number of different products from various distributors. Searching for them can be time-consuming. Therefore, the products are combined in into related groups by type.

Providers set the Product Type field, but sometimes different Providers providers use diverse names. In these cases, you can combine them into Product Categories. These fields are used in compliance and reporting work.

Provider (9) and Group Provider (4)

Providers are the firms that are the sponsors for packaged products such as Mutual Funds and Annuities. The provider for Equities, Fixed Income, and Options products will usually be the Clearing Broker.

Because the provider designation is very detailed on the data feeds we receive, it is It is common to have five or more different providers (manufacturers or sponsors) for the same overall holding company. It is usually because sponsor companies often have a For example, there are separate legal entity entities for NY business and Fixed Annuity vs. Variable Annuity business. To put these detailed providers back together, we have a provider group that will combine the eight different Nationwide providers into one Nationwide Provider Group. It is useful for queries and reporting. There are providers (manufacturers or sponsors) for any packaged products, Mutual Funds, Variable Annuities, etc., which are priced only once per day. To facilitate the search, we recommend to group the products of one provider together. Group Provider. For example, Allianz Life Insurance Company of New York, Allianz Life Insurance Company of North America/LI, and Allianz Life Insurance Company of NY-Fixed Business, can be the in the Provider Group provider group Allianz.

Status Flags (5)

Status flags are the ways of indicating characteristics of a particular product. You can create status flags as needed and immediately get the results. For reporting purposes, configure the options them with the Status Flags Filter. For example:

  • To open the filter, click the three dots (1) after the Status Flags field

  • To enable or disable the option, double-click on the row check Yes or No (2) forInverseand/orLeverage option(s), as applicable .Select IcIlude All or click Include All (3) to check both Yes options, or Deselect All (3) to uncheck all checkboxes.

  • Click OK (4).

  • Then, in Product Monitor window, click FILTER .

Image RemovedTi: The clients can create status flags on the fly and immediately get the results.
  • (5).

Image Added

Share Class (10)

A share class is a designation applied to a specified specific type of security, such as a mutual fundMutual Fund. Companies with more than one class of common stock usually identify a class with an alphabetic markers, such as "Class A" and "Class B" shares. They carry different rights and privilegesThe most common one is Class A. Mutual Funds also have share classes with various sales charges, expense ratios, and minimum initial investment requirements.

The share class Share Class dropdown is relevant for Mutual Funds only. It contains a list of letters. Mutual Funds, when they are sold, are given the share class, and it indicates how they impact commissions

  • There are share classes you only pay when you sell but don't pay when you buy. 

  • There are shared classes that charge you a flat rate per year. 

  • There are shared classes without charges, for example, for institutional

    The most common one is typically shared class A. When you buy or sell a Mutual Fund with shared class A, you pay a certain percentage at the time you buy it, but you pay nothing when you sell it.

    Tip

    Tip: The last letter in the Fund Name field is the Share Class.

    How to Edit a Product

    Rw ui steps macro
    Rw step

    To edit a Product Record or to see more Product Details, in the Product Monitor window:

    • Double-click selected record (1) or

    • Select a record (1) and click DETAIL (2).

    Image Added

    The system opens the Edit Product window.

    Image Removed

    The Edit Product window It contains the following fields (see descriptions above):

    • The same fields as in the Product Monitor window:

      • Product Name

      • Product Type

      • CUSIP

      • Symbol

      • Fund Name

      • Provider

      • Asset (Share) Class

    • Additional fields:

      • Description (1) - Detailed description of the product

      • Market (2) - A name of the stock market where the product is traded (rarely used)

      • Price (3) - Price of the product as of date

      • Price Date (4) - Date of the price

      • Factor (5) - The factor allows converting the price to match the quantity. Primarily, it has a value of 1.0, except for Bonds and Fixed Income.

    Edit Product window tabs

    • User Defined Fields - These fields are individual columns in the database (UD1, … -UD5), which are convenient for sorting, filtering, and selection.

    • Lookup Tables - Tables for those products whose price depends on the purchase volume based on breakpoints. Parameters: Name, Type, Description, Start Date, and End Date. Mainly used for Mutual Funds.

    • Status Flags - (See the description in Product Monitor window Tab section)

    • Attributes - A list of attributes useful for particular tasks.

    Notes: The attributes can not be sorted. To filter them, you must create a custom filter. See the How to Create Custom Filter section for the details.

    Rw step

    Fill out the fields and click SAVE when finished.

    How to add a New Product and Provider to the Product Manager

    Follow these steps to add a new Provider to the Product Manager dropdown menu.

    Rw ui steps macro
    Rw step

    To add a new product, in the Product Monitor window, click ADD PRODUCT.

    The system opens the Add Product window with empty fields.

    Info

    Info: Add Product windows contain the same fields as the Edit Product window.

    Rw step

    Enter a Product Name.

    Rw step

    Select the appropriate Product Type from the dropdown.

    Rw step

    Enter values in the CUSIP, Symbol, Fund Name and Description fields.

    Rw step

    On the Provider dropdown, select <Add New>.

    Rw step

    Enter the name of the new Product Provider that you need added to the relevant dropdown menu and click OK.

    Note: Fill out other fields if required.

    Rw step

    Click SAVE.

    The new Product Provider (WESTERN LIFE ASSURANCE CO. in the example) now appears on the Product Provider dropdown.

    How to Delete a Product

    To delete a product, select it in the Product Monitor window , and click DELETE.

    Note

    Warning: If the selected product is associated with other objects in the database, such as Items or Accounts, it must first be removed from Items and Accounts.

    Anchor
    custom-filter
    custom-filter

    How to Create a Custom Filter

    Rw ui steps macro
    Rw step

    In the Product Monitor window, click Column Selector on the right bottom corner.

    Rw step

    In the Column Selector window:

    • Open the Custom Filters (1) tab

    • Point anywhere in the grid area and right-click the Add Custom Condition (2) button.

    Rw step

    In the Custom Filter window’s Edit Conditions tab, specify condition parameters:

    • Filter (1)

    • Filter Name (2)

    • Filter Conditions (3) (Times Leveraged in the example)

    • Click CHECK EXPRESSION (4) to verify the condition

    • Click SAVE (5).

    Rw step

    In the Column Selector window, click SAVE.

    Setup Tab

    In the Setup widow window, Administrators can grant or revoke authority giving the to end user users to control over the dropdown values and the parameters that govern the behavior of the software.

    There are seven sub-tabs:

    • Product Type

    • Product Category

    • Product Status Flags

    • Product Attributes

    • Product Type Attributes

    • Product Provider

    • Provider Group

    All of them have standard actions:

    • ADD

    • CANCEL

    • SAVE

    • DELETE

    Product Type

    In this window, the system allows maintenance of Product Types. Initially, Product Types come from the data feeds and are pre-populated here. The Product Types can be added, edited, or deleted. Each customer Provider defines Product Types differently, and the list may contain similar names.

    • Code [optional] - A two or three-digit code that is linked with a Product Type

    • Adds to total assets -

      • For

      an Account and an Investor, Product Type can be added
      • Accounts and Investors - check this box, if you want to add Product Type to the total assets.

      • For specific products, e.g., Life Insurance, it must be left unchecked because it doesn't increase the value of total assets.

    Product Category

    In the Product Category tab, clients (and only clients) Providers define their product categories (usually 10-20), for example, Fixed Annuities, Bonds, and Mutual Funds. These are manageable groupings. These categories are not updated by data feeds.

    • Code [optional] - A code that is linked with a Product Category

    • Adds to total assets -

      • For

      an Account and an Investor, Product Category can be added
      • Accounts and Investors - check this box, if you want to add Product Category to the total assets.

      • For specific products, e.g., Life Insurance, it must be left unchecked because it doesn't increase the value of total assets.

    Image RemovedSetup-ProdCategory v2.pngImage Added

    How to Map a CUSIP or Symbol to a Product Category in Product Manager

    Rw ui steps macro
    Rw step

    In the Product Monitor tab, enter Provider’s CUSIP value (1) (2222221 in the example) and click FILTER (2).

    Rw step

    First Clearing feed has these classified as Mutual Fund Open (1). This CUSIP is unmapped to a jCore Product Category (2).

    To map it, double-click this item (3), and go to Setup > Product Type (4) tab.

    Rw step

    From the Product Type dropdown, select Mutual Fund Open (1) from the Product Category dropdown, select the appropriate value [Mutual Funds] (2), and click SAVE (3).

    Rw step

    Go back to Product Monitor (1) tab, and click FILTER (2) to refresh the data. The Product Category column now contains the value selected on Product Type tab (3).

    Product Status Flags

    Status flags are the ways of indicating characteristics of a particular product.

    Flag Value - Possible values: 1, 2, 4, 8, 16, 32, etc

    .

    How to add Product Status Flag values

    Rw ui steps macro
    Rw step

    In the Product Monitor tab, double-click on the required item.

    Rw step

    In the Edit Product window, select the Status Flags tab (1).

    To enable or disable the option, double-click on the row for Inverse and/or Leverage, (2) as applicable.

    Click SAVE (3).

    Product Attributes

    Create required attributes useful for particular tasks by creating a in new fields and name them correspondingly. Attributes are stored as key-value pairs. The number of attributes is not limited. They are available for all of your products.

    • Name - The name is the field name in the database. It is an internal variable (read-only) that we use to reference. For example, when creating SQL scripts

    • Display Name - The name of the attribute shown in the UI

    • Type - Date, text, integer, long integer, numeric, character, or logical (boolean)

    • Display Component - Allows you to define how the Product Attribute will be rendered display to users (text, integer, string, etc.)

    Product Type Attributes

    Create required attributes useful for particular tasks by creating a in new fields and name them correspondingly. Attributes are stored as key-value pairs. The number of attributes is not limited. They are available for all of your product types. Open the Product Types tab, select Product Type and enter the value for the created attribute.

    • Display Name - The name of the attribute shown in the UI

    • Type - Date, text, integer, long integer, numeric, character, or logical (boolean)

    • Display Component - Allows you to define how the Product Type Attribute will be rendered (text, integer, string, etc.)

    Product Provider

    Providers are the firms that are the sponsors for packaged products such as Mutual Funds and Annuities. Assign a Provider Group if a Product Provider is a part of the larger company together with others.

    Provider Group

    Many companies incorporate a separate company because some states, especially New York, have very strict regulatory rules. To get all of them together, assign them to a separate Provider Group. It is useful when user wants to see all these related providers togetherThe following window is intended for creating and deleting Provider Groups.

    Merger Tool Tab

    Sometimes, various data providers have entered different CUSIPs for the same product but with different CUSIPs, or one provider has entered a CUSIP, but others do not. The Merger Tool allows Administrators to merge duplicated products, accounts, and contacts together.

    Click SEARCH to get a list of all Product CUSIPs.

    To get a list of products with the right CUSIP, select the CUSIP from the left-side dropdown. The system displays a list of products with that CUSIP.

    Click DETAIL (1) (or double-click the product (2)) to open the Edit Product window.

    To merge two products:

    1. Select both products (1)

    2. Check which of them is considered as the base the box next to the one you want to keep (2).

    3. Click MERGE (3).

    Audience: System Administrators, Data Administrators, Compliance Tool Users.

    Info

    Functionality:The Product Manager works with the information about financial products

    .