Siebel eFinance Guide > Securities > Administrator Procedures >

Adding Securities Lists of Values

Typically, securities information is imported into Siebel eFinance using 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).

Those with the required administrative responsibilities, such as Siebel administrators, manually add or edit records of securities using administrative functions described in this section.

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

Before entering new securities into Siebel eFinance, administrators should 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 need to be set up by the administrator with the appropriate values:

When an administrator enters a new security, the Industry field is used to indicate the industry or sector to which the security belongs. The industry field should be populated with a list of values that are relevant to the administrator's organization. For example, an administrator adding a new biotechnology stock as a security to Siebel eFinance may need to add Biotechnology if the industry does not already exist. Using Siebel eFinance, administrators can add the industries that appear in the Industry field.

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

To add an industry

  1. From the application-level menu, choose View > Site Map > Application Administration > Industries.
  2. The Industries view appears.
  3. In the Industries list, add a record and complete the necessary fields.
    Field
    Description
    Language Code
    Primary language of the classification used
    SIC Code
    Standard Industry Classification code as defined by the US Department of Commerce
    Type
    The classification used to describe the industry

Product Line

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

NOTE:  In Siebel eFinance, 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 should be populated with the same list of values to indicate the asset classes.

Using Siebel eFinance, administrators can add the product lines used in the Product Line field. For more information about creating a product line, see Products and Pricing.

Product Class

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 eFinance. Using Siebel eFinance, administrators can add the asset classes that appear in the Product Class field.

To add a product class for a security

  1. From the application-level menu, choose View > Site Map > Application Administration > List of Values.
  2. Run a new query in which 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.

    Some fields are 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:  You cannot delete LOV table entries; use the Active check box to deactivate an LOV entry and thereby remove it from the Relationship drop-down list.

Category

When an administrator enters 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 may be further classified as a Category of Preferred Stock. A security with a Product Class value of Bond may have a Category of Mortgage or Corporate Bond. Using Siebel eFinance, administrators can add the categories that appear in the Category field.

To add a security category

  1. From the application-level menu, choose View > Site Map > Application Administration > List of Values.
  2. Run a new query in which Type = FINS_INVST_CATEGORY.

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

Exchange

In some instances, new exchange information may need to be added to Siebel eFinance. The Exchange field is used to indicate the securities exchange systems. For example, a brokerage organization may populate the Exchange field with values, such as NASDAQ, FTSE, and Nikkei. Companies should add all the exchanges that are relevant to their organization.

To add a security exchange

  1. From the application-level menu, choose View > Site Map > Application Administration > List of Values.
  2. Run a new query in which 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.

 Siebel eFinance Guide 
 Published: 20 October 2003