System for the registration and evaluation of security businesses.

The main objective of this application is the creation of sales statistics as well as the calculation of brokerages and sales credits.

The integrated client information system enables extensive analysis, i.e. not only statistics which are relevant for the bank itself, but also sales statistics for clients, which can be combined with the first-named, if required.

In the scope of brokerage, the following features are representative:

• Comparison official brokerage versus agreed brokerage.
• Monthly calculation of the brokerage (ultimo evaluation)
• Sales development within a specified period of time.
• Allocation of the brokerage to be paid to the different departments of a bank.

Extract from the sales credit evaluation:

• Calculation of the sales credits, relating to single brokers, broker teams and different locations of a bank.
• Product-related statistics.
• Sales credit trend in comparison with an earlier period of time.

Client-related sales statistics can be combined with the above-mentioned data for further processing due to the application's variable design.

A precondition for the creation of these reports is the integrated master data administration (securities, employees, departments, clients, brokerage rates, etc) as well as the provision of all the relevant sales data. The latter is guaranteed by the daily data import from Blooberg, whereby a current currency update via interface to Reuters (DDE) is carried through .

The internal user administration enables a level-related access to the single modules and reports. Moreover, there are various reports for the control of the master data available.

The main purpose of this application is the daily registration of a bank's securitiy holdings.

An essential feature is the control of the observance of a predetermined limit, which restricts for each issuer individually the market value of his booked holdings.

Again, the required data is made available by Bloomberg and Reuters as well as by the integrated master data administration.

After the daily import of this data, automated reports show the values of those issuers, whose limits have been exceeded.

Due to the administration of this data, it is possible to create reports containing the holdings' history for a specific issuer at any time. Furthermore, these data can also be grouped by countries.

Detailed information in the reports, such as limit, use to capacity in per cent, hitherto duration of a possible limit exceeding, and the difference between holdings and limit always guarantee the control of the current status.

The main purpose of this system is the provision of the functionalities necessary for the administration of the security businesses.

Main components are the functions for the registration, the prolongation and the setting of value dates for the security businesses and the calculation of the incurring increases or decreases due to market-value fluctuations (spot rate / forward rate). The required data is partly provided by the tables maintained in the program Client Information & Brokerage System (CIS).

Master data, which relate exclusively to the security business, can be administered by the system administrator with the help of implemented functions in the module WPTG.

The reporting module enables the print of the data which is relevant for the business activities in the different departments.

The system is focused on budgeting, planning and execution of complex development projects and their supervision by the project manager and the controlling. On annual basis the board of management makes release decisions for the different types of expenditure in which the budget information has been splitted.

All schemes of development can be united into frame orders which can be analysed in multifarious ways. Different views can be mapped in frame orders by means of priorities, assignment to subjects, allocation of types and other attributes.

Each frame order can be run in two currencies. Basically all frame orders are also led in a so called system currency e. i. Euro. Currency fluctuations can be shown through the history of exchange rates and accordingly considered within the cost control.

The project management represents all important functions as they are already known by classical systems. Especially for enterprises processing a multitude of parallel projects the system is of interest. The handling of project-comprehensive dependencies, time reports recorded by internal and external employees, the assignment of costs and last not least elaborated internal service charges put in a good word for the system. All tasks of the classical project management are covered by the system as well as the daily routine of those departments carrying the responsibility for the production run.

Besides the described basic functionality, elaborated possibilities to represent complex structures of organisation exist. Both hierarchic structures and matrix organisations can be mapped. The ability to clientele processing and the connection to the module of SAP-accountancy are essential features of the system.

This system is being developed for a german bank. Several extension levels are being prepared.