16Managing Holdings and Interests

About Managing Holdings and Interests

In Siebel Finance, there is a collection of screens and views that helps financial representatives track multidimensional information on client's investment interests, including:

  • Products, such as stocks, bonds, mutual funds, options, and investment trust units

  • Industries

  • Sectors

  • Analyst ratings

Use these procedures to perform the administrator tasks of modifying product information as well as adding industries, security product classes, security categories, security exchanges, and new securities.

End users use Siebel Finance to capture specific details about each investment, such as basic product information, issuer fundamentals, market data, literature, research, and news.

Securities information assists users in searching for a type of investment that would satisfy a customer’s specific requirements and providing details on specific investments. Institutional salespeople can search to determine the contacts and investors who have either expressed an interest in a specific security or are currently holding that security in their portfolios. Also, sales agents and financial representatives can generate a call list, which is a list of targeted contacts that is associated with one or more securities.

You can save time and reduce keystrokes by using a workflow to automate steps that are repeatedly performed by end users. For more information, see Siebel Business Process Framework: Workflow Guide.

Scenario for Promoting a Market Opportunity to Targeted List of Clients

This scenario features sample tasks performed by a financial institution’s applications administrator and an investment representative. Your company might follow different workflows according to its business requirements.

An administrator is requested to add a new municipal bond issue to Siebel Finance. The administrator checks if all the required information to define the security exists in the application, and creates list of values entries as necessary. Then, the administrator adds the municipal bond by entering product information, which includes such details as the product name, symbol, industry, region, and sector.

In the morning sales meeting, they discuss the new bond product. After covering the details of the new product on the morning call, the sales team cross references the new bond’s profile against the list of their clients’ interested in purchasing the new bond. The firm anticipates the current bond market rally to continue and the firm takes a substantial position in NYC municipals. The fixed income desk is requested to promote the product heavily for the week.

At the conclusion of the call, the bond desk creates a targeted, prioritized call list to promote the product. They search for investors and contacts who have expressed interest in bonds. Further, they target investors and individuals who are holding or have expressed interest in Munis. The financial instrument held has a B rating. The salesperson first targets investors and individuals interested in B rating or better, and also customers with accounts registered in NY or managing NY mutual funds. Munis represent the highest values to these customers.

Process of Administering Securities

This process represents a portion of the tasks carried out in the Scenario for Promoting a Market Opportunity to Targeted List of Clients. This process includes:

  1. Setting Up Securities Lists of Values

  2. Creating and Modifying Stock, Bond, and Mutual Fund Records

Typically, securities information is imported into Siebel Finance using Siebel Enterprise Integration Manager (EIM). Your organization can import the data displayed in the Securities views from one or more other systems (such as a trading system).

You can also manually add or edit records of securities using administrative functions described in this topic.

For more information about Siebel Enterprise Integration Manager, see Siebel Enterprise Integration Manager Administration Guide.

Setting Up Securities Lists of Values

Before entering new securities into Siebel Finance, make sure that all the fields used to define a security are populated with the appropriate terms and classifications used by their organization. The following securities fields must be set up with the appropriate values:

  • Industry

  • Product Line

  • Product Class

  • Category

  • Exchange

The task is part of Process of Administering Securities.

Defining Industry Values

When you enter a new security, the Industry field is used to indicate the industry or sector to which the security belongs. Populate the industry field with a list of values that are relevant to your organization. For example, if you are adding a new biotechnology stock as a security to Siebel Finance, you might want to add Biotechnology if the industry does not already exist. For details on how to modify the industry field values, see Adding Industries.

Note: The Industries table is used throughout Siebel Finance. Be sure to add industries that represent your companies and clients.

The task is part of Setting Up Securities Lists of Values.

Defining Product Lines

When you enter a new security, the Product Line field is used to indicate the asset class of the security. For example, if your company is an investment firm you might want to add equity, fixed income, derivatives, and mutual fund product lines, if they do not already exist.

Note: In Siebel Finance, the Product Line field and the Product Class field are used to indicate a security asset class in different modules of the application. The fields are used exclusively in different modules of the application. As a result, both fields must be populated with the same list of values to indicate the asset classes.

For more information about creating a product line, see Managing Products and Pricing

The task is part of Setting Up Securities Lists of Values.

Defining Product Classes

The Product Class field is used in addition to the Product Line field to indicate the asset classes of securities when they are added to Siebel Finance. Using Siebel Finance, you can add and modify the asset classes that appear in the Product Class field.

The task is part of Setting Up Securities Lists of Values.

To add a product class for a security

  1. Navigate to the Administration - Data screen, and then the List of Values view.

  2. Run a new query for Type = FINS_ASSET_CLASS.

    The current FINS_ASSET_CLASS records are returned with the existing list of values for the Product Class type.

  3. In the List of Values list, add a record, and complete the necessary fields as described in the following table.

    Field Description

    Active

    Check box to determine whether or not the value is displayed to the end user in the Product Class dialog box.

    Display Value

    Value as displayed in the Product Class drop-down list.

    Language-Independent Code

    Code used internally by the Siebel application.

    Language Name

    Language used for the list of values Display Value field.

    Order

    Numerical order in which a value is displayed within the Product Class drop-down list.

    Parent LIC

    Language-independent code of a parent list of values. It is used in hierarchical lists of values.

    Translate

    When checked, indicates that the list of values is part of a multilingual list of values (MLOV).

    Type

    The type of list of values. Select FINS_ASSET_CLASS.

Note: Deleting LOV table entries is not recommended; instead, use the Active check box to deactivate an LOV entry and thereby remove it from the Product Class drop-down list.

Adding Categories

When you enter a new security, the Category field is used to indicate another level of classification in addition to the Product Class field. For example, a security with a Product Class value of Stock might be further classified as a Category of Preferred Stock. A security with a Product Class value of Bond might have a Category of Mortgage or Corporate Bond. Using Siebel Finance, you can add the categories that appear in the Category field.

The task is part of Setting Up Securities Lists of Values.

To add a security category

  1. Navigate to the Administration - Data screen, and then the List of Values view.

  2. Run a new query for Type = FINS_INVST_CATEGORY.

    The current FINS_INVST_CATEGORY records are returned with the existing list of values for the Category type.

  3. In the List of Values list, add a record, and complete the necessary fields.

Adding Security Exchanges

In some instances, you must add new exchange information to Siebel Finance. The Exchange field is used to indicate the securities exchange systems. For example, a brokerage organization might populate the Exchange field with values, such as NASDAQ, FTSE, and Nikkei. Add all the exchanges that are relevant to your organization.

The task is part of Setting Up Securities Lists of Values.

To add a security exchange
  1. Navigate to the Administration - Data screen, and then the List of Values view.

  2. Run a new query for Type = SECURITY_EXCHANGE.

    The current SECURITY_EXCHANGE records are returned with the existing list of values for the Product Class type.

  3. In the List of Values list, add a record, and complete the necessary fields.

Creating and Modifying Stock, Bond, and Mutual Fund Records

Once the securities lists of values are populated correctly, you can then add and modify individual securities records. You can also associate a literature item with a security.

Typically, securities information is imported into Siebel Finance using Siebel Enterprise Integration Manager (EIM). An organization can import the data displayed in the Securities views from one or more other systems (such as a trading system). Administrators can also add or modify securities for their organizations in the All Securities view in the Finance Administration screen.

For more information about Siebel Enterprise Integration Manager, see Siebel Enterprise Integration Manager Administration Guide.

This task is part of Process of Administering Securities.

To add a new securities record

  1. Navigate to the Administration - Finance screen, and then the Securities view.

  2. In the Securities list, add a record, and complete the necessary fields.

Editing Mutual Fund Information

You can also edit mutual fund information as needed.

To edit mutual fund information

  1. Navigate to the Administration - Finance screen, and then the Mutual Funds view.

  2. In the Mutual Fund form, locate the appropriate fund.

  3. Click the Mutual Fund Holdings view tab.

  4. In the Fund Holdings list, do one of the following:

    • Add a record and complete the necessary fields for each security that makes up the mutual fund

    • Modify or delete existing securities

  5. From the Asset Allocation drop-down list, select Asset Allocation List.

  6. In the Asset Allocation list, do one of the following:

    • Add an asset class and associate the percentage of holdings in each mutual fund

    • Modify or delete existing asset classes

Note: The Asset Allocation Chart provides a graphical representation of the asset allocation for the mutual fund.

Associating Literature Documents with a Security

You can also associate a literature document with a security.

To associate a literature document with a security

  1. Navigate to the Administration - Finance screen, and then the Securities view.

  2. In the Securities list, select a security.

  3. Click the Literature view tab.

  4. In the Literature list, add a record, and complete the necessary fields.

Process of Tracking Clients’ Interests and Creating Interest-Based Call Lists

This process represents a portion of the tasks carried out in the Scenario for Promoting a Market Opportunity to Targeted List of Clients. This process includes:

  1. Entering Interests and Holdings Information

  2. Creating and Using Targeted Call Lists

From the Holdings and Interests views, end users can track a particular security. From the List Management Call List view, end users can review and manage their generated call lists.

Siebel Enterprise Integration Manager imports the market data displayed in the Securities views. An organization can import the data displayed in the Securities views from one or more other systems (such as a trading system). Also, those with the required administrative responsibilities, such as Siebel administrators, can manually add or edit records of securities using administrative functions described in Process of Administering Securities.

For more information about Siebel Enterprise Integration Manager, see Siebel Enterprise Integration Manager Administration Guide.

Entering Interests and Holdings Information

Tracking your clients’ interests and holdings is an important first step towards building targeted call lists.

This task is a step in Process of Tracking Clients’ Interests and Creating Interest-Based Call Lists.

To record an interest

  1. Navigate to the Contacts screen, then Contacts List view.

  2. Drill down on the contact for which you wish to add interests information.

  3. Click the Interests view tab.

  4. Create a new record and complete the necessary fields as described in the following table.

    Field Description

    Description

    Enter text to describe the contact’s interest, or the system will automatically enter a string containing a compiled list of the interest attributes.

    Ticker

    Select any of the securities previously entered into your Siebel application.

    Volume

    Trading volume of the security.

    Quantity

    Number of shares the contact is interested in transacting.

    Interest Type

    Registers if the interest is in selling or buying.

    Analyst

    A particular research analyst.

    Industry Group

    The high-level industry interest, for example Technology. Also known as a sector.

    Industry

    Specific industry interest, for example Software.

    Internal Rating

    The research rank of the product, for example Strong Buy.

Note: You can record a contact’s interests using either the Contacts or the Holdings and Interests screen.

Recording an Interest Based on a Holding

You can also record an interest based on a holding.

To record an interest based on a holding

  1. Navigate to the Holdings and Interests screen, then the Interests view.

  2. In the Interests list, create a new record and complete the necessary fields, some of which are described in Step 4 in the topic Entering Interests and Holdings Information.

  3. In the Interests form, check the Holding box to signify this is an interest based on a holding.

Note: You cannot perform a search on a holding unless the holding has been saved as an interest with the Holding box checked.

Entering Holdings Information

You can add individual holdings information for Investors from the Holdings and Interests Holdings view. In addition, use the Financial Accounts Investment Holdings view to add holdings to financial accounts.

Note: These holdings are not searched in the Holdings and Interests Search view. Only interests based on holdings are searched. See Recording an Interest Based on a Holding.

To add a holding record

  1. Navigate to the Holdings and Interests screen, then the Holdings view.

  2. In the Holdings list, add a new record and complete the fields.

  3. In the Holdings form, enter additional information about the holding.

Creating and Using Targeted Call Lists

Generate and execute call lists based upon your client’s interests and holdings-based interests through a:

  • Batch search to add multiple contacts

  • Single selection to add an individual client

Note: If your organization chooses to use the call list functionality, coordinate with your IT department to run a regular batch process to remove dated lists.

This task is a step in Process of Tracking Clients’ Interests and Creating Interest-Based Call Lists.

To search for contacts with particular interests

  1. Navigate to the Holdings and Interests, then the Search view.

  2. In the Criteria form, enter investment and classification criteria as described in the following table.

    Field Description

    Ticker(s)

    Select any of the securities previously entered into your Siebel application.

    Search for multiple tickers by listing them separated by a comma. For example: CSCO, SEBL, IBM.

    Search

    Select whether to search Interests only, Holdings only, or both Interests and Holdings.

    Interests only returns contacts with an active interest in the named security. If the Inactive checkbox is checked on the interest record, then it is ignored in the search.

    Holdings only returns contacts with an active holdings-based interest in the named security. For information on how these types of records are created, see Recording an Interest Based on a Holding.

    Holdings and Interests returns contacts with either an interest or holdings-based interest in the named security.

    Market Cap

    The market cap ranking of the issuing company, for example Small Cap.

    Product

    The security type in which the client is interested, for example Equities, Fixed Income, or Options.

  3. Click Add Above Criteria to add the criteria to the search.

    Note: If multiple criteria are entered within a single criteria search record, the search includes an AND clause such that all field values must be met to return a contact. For example, within a single search record you enter an interest in ticker IBM and interest type Buy, then only contacts who have both an interest in IBM with an interest type of Buy will be returned in the search results.
  4. Repeat Step 2 and Step 3 to add additional criteria, if needed.

    Note: The search aggregates multiple criteria search records into an OR clause, so if, for example, two criteria forms are added, one specifying an interest in ticker SEBL and another specifying an interest in ticker IBM, contacts with an interest in either or both tickers are returned.
  5. Click Go to execute the search.

    Contacts that meet the search criteria appear in the Contacts list.

  6. There are now three active buttons in the Contacts list, each providing a different way to proceed to an existing or new call list:

    • Add to Active Call List. Adds contacts to the user’s most recently created call list from the current date, while remaining on the Holdings and Interests Search view. If no call list exists for the current date, a new call list is created.

    • Create New Call List. Adds contacts to a new call list identified by the user’s ID and the current date and time, while remaining on the Holdings and Interests Search view.

    • Go to Call Lists. Navigates to the List Management Call List view where the user can see all of their own generated call lists.

Modifying the Contacts in a Targeted Call List

You can also modify the contacts in a targeted call list.

To modify the contacts in a targeted call list

  1. Navigate to the List Management screen, then the Call List view.

  2. Select a call list to modify.

  3. In the Call List list, review the contacts, modifying as described in the following table.

    To... Then...

    Remove a contact.

    Select it in the list and click Remove.

    Add a contact.

    Click Add and select a contact in the Pick Contact dialog box.

    Contacts added in this way will have no criteria associated with them.

Using a Targeted Call List

The following instructions describe how to use a targeted call list.

To use a targeted call list

  1. Navigate to the List Management screen, then the Call List view.

  2. Select a call list to use and work through the call list, marking the contacts according to the action performed:

    • Ignore

    • Called

    • Emailed

  3. Clarify the list of calls remaining by clicking Refresh List.

    If the Show drop-down list is set to Outstanding Items, an updated list containing only the contacts not yet marked as either Ignore, Called, or Emailed is displayed.

  4. To return to the full call list, click the drop-down list and select All List Members.

Configuring Call List Generation

The call list generation functionality, which included the three Call List Buttons on the Holdings and Interests Search view, are supported by user properties definitions for predesigned behavior. You might wish to modify these user properties to fit your own business processes.

The following options are all configured through the FINS Contact Interest Search Result business component. The following table lists the user properties.

User Property Value Comment

Reset Called Flag

Y

Called flag is reset to N when a duplicate contact is added to the call list.

N

Called flag is not updated when a duplicate contact is added to the call list.

Reset Emailed Flag

Y

Emailed flag is reset to N when a duplicate contact is added to the call list.

N

Emailed flag is not updated when a duplicate contact is added to the call list.

Reset Ignore Flag

Y

Ignore flag is reset to N when a duplicate contact is added to the call list.

N

Ignore flag is not updated when a duplicate contact is added to the call list.

Merge Criteria

Y

Criteria Matched field is merged when a duplicate contact is added to the call list.

N

Criteria Matched field is not updated when a duplicate contact is added to the call list.

Merge or Ignore Duplicate Contact

Merge

If a contact is already in the call list, other attributes of this contact record are merged.

Ignore

If a contact is already in the call list, no action is taken with this record.

Popup When Add Call List

Y

A dialog box pops up when the user adds contacts to an active call list.

N

No dialog box pops up when the user adds contacts to an active call list.

Popup When Create Call List

Y

A dialog box pops up when the user creates a new call list.

N

No dialog box pops up when the user creates a new call list.

Reflect Holding

Holding (default)

The value of this property shows as prefix text on the Criteria Matched field to indicate that the matched criteria is associated with a holding.

Reflect Holding and Interest

Holding/Interest (default)

The value of this property will show as prefix text on the Criteria Matched field to indicate that the matched criteria is associated with both holdings and interests.

Reflect Interest

Interest (default)

The value of this property shows as prefix text on the Criteria Matched field to indicate that the matched criteria is associated with an interest.