Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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.
- From the application-level menu, choose View > Site Map > Application Administration > Industries.
- The Industries view appears.
- In the Industries list, add a record and complete the necessary fields.
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
- From the application-level menu, choose View > Site Map > Application Administration > List of Values.
- 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.
- In the List of Values list, add a record and complete the necessary fields.
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.
- From the application-level menu, choose View > Site Map > Application Administration > List of Values.
- 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.
- 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.
- From the application-level menu, choose View > Site Map > Application Administration > List of Values.
- 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.
- In the List of Values list, add a record and complete the necessary fields.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel eFinance Guide Published: 20 October 2003 |