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 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 Type (3) and Product Category (8)

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

Providers set the Product Types, but sometimes different Providers use diverse names, e.g., “money market“ versus “cash“ or “option“ versus “equity.“ In these cases, clients can combine them into Product Categories. It is a way of regrouping them into higher-level groupings. These types and categories of products are used in compliance and reporting work. For example, to create the alert for the products with prices less than $5, the products must be separated because this price can be appropriate for a mutual fund but not for equity.

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 common to have five or more different providers for the same overall holding company. It is usually because sponsor companies often have a separate legal entity 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. 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 in the Provider Group Allianz.

Status Flags (5)

Status flags are the ways of indicating characteristics of a particular product. For reporting purposes, configure the options with the Status Flags Filter. For example:

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

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

• Select IcIlude All or Deselect All

• Click OK.

• Then, in Product Monitor window, click FILTER.

Ti: The clients can create status flags on the fly and immediately get the results.

Share Class (10)

A share class is a designation applied to a specified 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 privileges. Mutual Funds also have share classes with various sales charges, expense ratios, and minimum initial investment requirements.

The 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.

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). The system opens the Edit Product window. The Edit Product window 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 on in the database UD1, … UD5, which are convenient for sorting, sophisticated 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 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 is required. 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, establishing a naming convention. Rw step Select the appropriate Product Type from the dropdown. Rw step Enter values in each of the CUSIP, Symbol, Fund Name and Description fields. Rw step On the Provider dropdown, select <Add New> option. Rw step Enter the name of the 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 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.

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 widows Administrator widow, Administrators can grant or revoke authority giving the end user 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 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 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) define their product categories (usually 10-20), for example, Fixed Annuities, Bonds, and Mutual Funds. These are manageable groupings. Categories 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 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

Rw step In the Product Monitor tab, enter Provider’s CUSIP value (1) 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 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 user you to define how the Product Attribute will be rendered (text, integer, string, etc.)

Product Type Attributes

Create required attributes useful for particular tasks by creating a 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 user 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 Mutual Funds and annuitiesAnnuities. Assign a Provider Group if a Product Provider is a part of the larger provider company together with other providersothers.

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 together.

Merger Tool Tab

Sometimes, various data providers have the same product but with different CUSIPs, or one provider has entered a CUSIP, but others do not. 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 required 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 (2).

3. Click MERGE (3).