Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Expand | ||||
---|---|---|---|---|
| ||||
|
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 | ||||
---|---|---|---|---|
|
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.
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.
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.
It is common to have five or more different providers (manufacturers or sponsors) for the same overall holding company. For example, there are separate legal entities for NY business and Fixed Annuity vs. Variable Annuity business. To put these detailed providers back together, we have a 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 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, check Yes or No (2) forInverseand/orLeverage option(s), as applicable 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 (5).
Tip: You can create status flags on the fly and immediately get the results.
Share Class (10)
A share class is a designation applied to a specific type of security, such as a Mutual Fund. Companies with more than one class of common stock usually identify a class with alphabetic markers, such as Class A
and Class B
shares. The 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. It contains a list of letters. Mutual Funds, when they are sold, are given the share class, and it indicates how they impact commissions.
Tip |
---|
Tip: The last letter in the Fund Name field is the Share Class. |
How to Edit a Product
Rw ui steps macro | ||
---|---|---|
To edit a Product Record or to see more Product Details, in the Product Monitor window:
The system opens the Edit Product window. The Edit Product window contains the following fields (see descriptions above):
Edit Product window tabs
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.
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 | |||||||||
---|---|---|---|---|---|---|---|---|---|
To add a new product, in the Product Monitor window, click ADD PRODUCT. The system opens the Add Product window with empty fields.
Enter a Product Name.
Select the appropriate Product Type from the dropdown.
Enter values in the CUSIP, Symbol, Fund Name and Description fields.
On the Provider dropdown, select <Add New>.
Enter the name of the new Product Provider and click OK. Note: Fill out other fields if required.
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, 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 | ||||
---|---|---|---|---|
|
How to Create a Custom Filter
Rw ui steps macro | ||||
---|---|---|---|---|
In the Product Monitor window, click Column Selector on the right bottom corner.
In the Column Selector window:
In the Custom Filter window’s Edit Conditions tab, specify condition parameters:
In the Column Selector window, click SAVE. |
Setup Tab
In the Setup window, Administrators can grant or revoke authority to end users to control 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 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 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, only 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 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.
How to Map a CUSIP or Symbol to a Product Category in Product Manager
Rw ui steps macro | ||||
---|---|---|---|---|
In the Product Monitor tab, enter Provider’s CUSIP value (1) (2222221 in the example) and click FILTER (2).
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.
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).
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 | ||
---|---|---|
In the Product Monitor tab, double-click on the required item.
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 in new fields and name them correspondingly. Attributes are stored as key-value pairs. The number of attributes is not limited.
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 (text, integer, string, etc.)
Product Type Attributes
Create required attributes useful for particular tasks in new fields and name them correspondingly. Attributes are stored as key value pairs. The number of attributes is not limited. 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
The 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. The Merger Tool allows 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:
Select both products (1)
Check which of them is considered for the future use (2).
Click MERGE (3).
Audience: System Administrators, Data Administrators, Compliance Tool Users.
Info |
---|
Functionality:The Product Manager works with the information about financial products |
.