Avaloq 2.6

Front 1

How many languages does Avaloq support?

Back 1

5

Front 2

What is a collection

Back 2

Definition: A Collection is a set of objects, , hich are either selected through a query or directly specified by the user. , he object Collection in Avaloq allows saving the results of a user-defined selection of objects, , rouped and sorted (possible on

Front 3

Can collections contain different types of objects?

Back 3

No

Front 4

How can a collection be created (GUI)?

Back 4

Lookup -> search for relative objects -> select the objects in question -> either right click, Collection, save as static or button 'sava as dynamic collecion' bottom left.

Front 5

What are the two different types of Collections?

Back 5

static and dynamic

Front 6

In the business model, what can assets be linked to?

Back 6

Positions and Macc

Front 7

How can a new client with a current account be entered in the system?

Back 7

Open a new BP, open a new Container, open a new Macc or use the Privat Client mask, where the three objects are opened in the background.

Front 8

Where can Background processes be stopped (GUI)?

Back 8

Central Services

Front 9

How can a date be entered dynamically?

Back 9

% infront of the expression

Front 10

Can orderbooks be protected?

Back 10

yes

Front 11

Where can current orders be seen (GUI)?

Back 11

Orderbook

Front 12

What two different types of order views are ther?

Back 12

stuctured and unstructured

Front 13

Where can you find reports?

Back 13

Reporst are everywhere (Orderbook, Lookup, Portfolio)

Front 14

Was ist ein Adapter?

Back 14

Eine Schnittstelle mit der Avaloq mit Umsystemen verbunden werden kann.

Front 15

Welche Arten von Adaptern / Schnittstellen gib es?

Back 15

Standard-, zertifizierte und Projektschnittstelle

Front 16

Erkläre den Unterschied zwischen einer Standard und einer zertifizierten Schnittstelle

Back 16

Bei der Standartschnittstelle trägt Avaloq sorge um di Kompatibilität zwischen Releases. Bei zertifizierten Schnittstellen liegt die Verantwortung beim Dritthersteller.

Front 17

Nenne mind. 3 Objekte in Avaloq

Back 17

Business Partner, Containter, Position, Asset, Money Account, Adress

Front 18

Wie löse ich in Avaloq eine Aktion aus?

Back 18

Bei Objekten über einen static Workflow. Bei Transaktionen über einen transactional Workflow.

Front 19

Was bedeutet SESI, MEMI und MESI

Back 19

SESI: Single Entity Single Instanz, EMI: Multi Entity Multi Instanzen, ESI: Multi Entity Single Instanz

Front 20

Wie sieht das Object Modell aus

Back 20

BP - (ADDR) - CONT - POS - ASSET

Front 21

Was sind die Konzepte um Objekte

Back 21

Relastions, Additions, Classes, Keys, Names, Security, Remarks

Front 22

Welche Arten von Aufträgen (Orders) gibt es

Back 22

Static Data Orders: Generiert oder manipuliert ein Objekt, ransaction: Generiert Bookings welche auf Positionen gespeichert werden

Front 23

Was ist eine Context Action

Back 23

Context Action ist das Menu für ein Objekt (Rechter Maus-Click im GUI)

Front 24

Was ist ein Event in Avaloq

Back 24

Das Resultat aus einer Transaktion (Ereignis, Botschaft, Nachricht, Message)

Front 25

Welche Typen von Orderbooks gibt es

Back 25

Unstructured Orderbook (flat), tructured Orderbook (hierarchical)

Front 26

Welche Arten von Collections kennst du

Back 26

Static Collection (von Hand definiert und gepflegt), ynamic Collection (Selektion anhand von Merkmalen)

Front 27

Gründe für Collections

Back 27

Vereinfachung von Selektionen, rweiterung der Lookup Funktionalität, enutzung in Task-Applikation, nterstützung PM Funktionalität

Front 28

Was ist eine Business Unit (BU)

Back 28

Eine BU ist eine eigenständige Geschäftseinheit welche Bankdienstleistungen unter eigenem Namen an Kunden anbietet. Wird oft auch Mandant genannt.

Front 29

Wie ist das Konzept der "Chinese Wall"

Back 29

Die Instanz ist unterteilt in einen öffentlichen Bereich mit einer BU und private Bereiche mit mehreren BUs.

Front 30

Was ist ein Money Account

Back 30

Der Money Account ist ein Konto und eine spezielle Form einer Position. Ein MACC hat einen Namen und einen Key

Front 31

Was sind die Eigenschaften von Keys

Back 31

Suchbegriff in der Lookup Applikation, ind nicht historisiert, erden eingegeben oder vom System gebildet, önnen Regelbasiert sein, erden parametrisiert mit Sourcen (1 Source pro Key), önnen als Pflichtfeld definiert werden

Front 32

Was sind die Eigenschaften von Additions

Back 32

Additions sind optionale Felder, aben einen definierten Datentyp, erden nicht historisiert, aben keine Lookup-Möglichkeit, önnen über Avaloq Scripts gelesen werden (Reports, Order Validations), önnen vordefinierte Werte aus Codetabellen haben, erden param

Front 33

Was sind die Eigenschaften von Klassen

Back 33

Beinhalten ein definiertes Set an Klassen (Codetabellen), önnen historisert werden, önnen automatisch gebildet werden (Derived Classes), erden im Lookup verwendet, önnen als Pflichtfelder definiert werden, erden im OMD-Sheet (API) oder mit TOAD parametris

Front 34

Was sind die Eigenschaften von Names

Back 34

5 Sprachen (E,G, I, F, S), bject-Namen können in unterschiedlichen Sprachen abgelegt werden, Names sind historisiert

Front 35

Was sind die Eigenschaften von Remarks

Back 35

Nur zu Informationszwecken, einhalten free text Format, önnen mit einem Valid-To Datum versehen werden, aben keine Lookup Möglichkeit, önnen gelöscht werden, erden nicht historisiert, ind lesbar via Avaloq Scripts (Reports), erden mit Sources parametrisie

Front 36

Was sind die Eigenschaften von Relationsships

Back 36

Verbinden zwei Objekte, ient zur Navigation zwischen Objekten mit Beziehungen, erden mittels Subtyp und Priorität beschrieben, rägt Informationen auf der Beziehung, ind definiert als unterschiedliche Typen (Verantwortung, Teilen, Beziehung), erden nicht h

Front 37

Welche Sicherheitsbereiche gibt es

Back 37

Object Security: Wer darf auf welche Objekte zugreifen, orkflow Security: Wer kann welche Workflow Steps ausführen, unctional Security: Wer darf was machen (z.B. User Administration)

Front 38

Welche Regel-Typen gibt es

Back 38

System Rules: Bestandteil vom Avaloq-System, ank Rules: Selbstdefinierte Regeln (Anforderung der Bank)

Front 39

Was sind die Eigenschaften von Post-it

Back 39

Post-it stehen auf den Orders, trukturierte oder free Texte, aben Typen und Subtypen

Front 40

Was ist immer in einem Workflow vorhanden

Back 40

Start-Status Open, inal-Status Done oder Discarded

Front 41

Welche Task-Typen gibt es

Back 41

Orderbook, Reports, Programs, Messages, Sources, Others

Front 42

Wie werden Tasks gestartet

Back 42

Mittels Run (sofort, synchron) und Submit (Background-Prozess, asynchron)

Front 43

Woraus besteht ein Task

Back 43

Task Definition, Task Template und Task Layout

Front 44

Was sind Komponenten zu den Orders

Back 44

Order Validation, Post-it, Order Linking, Order Auditing, Order Keys und Order Additions

Front 45

How do you find a list of all the script types?

Back 45

Tasks> Reports > Search for 'script' > Report: Avoaloq Script Type: .Default

Front 46

Name three areas where Avaloq Scripts are used?

Back 46

Order Validation, Report Writer, AMI, Matching Conditions Rule Loader, Contex Actions

Front 47

Is Avaloq Script a programming language?

Back 47

No, it's always used in the contex of the system and never as a stand along language

Front 48

Name the three data layers in Avaloq.

Back 48

Order memory (mem), rder Persistance (doc), ernal Layer (Object)

Front 49

What on which layer are orders and objects found?

Back 49

Order memory (static data orders, transaction orders) - lost if computer is off, rder Persistance (saved orders), ernel Layer (objects)

Front 50

What are the data dictionary prefix for the three data layers and datamarts in avaloq?

Back 50

Order Memory - mem_doc, rder Persistance - doc, ernel Layer - obj, atamart - dtm

Front 51

What is the purpose of the Data Dictionary (DDIC)

Back 51

It serves as a reference to the structure of the data objects

Front 52

How can you bring up the mask with the data dictionary template?

Back 52

Tasks> Reports > Search for 'dict' or 'ddic'

Front 53

What source and table are error messages defined in?

Back 53

Source: CODE_UI_ERR.SENT, able: CODE_UI_ERR

Front 54

What are the two different way to raise an error?

Back 54

session.raise_ui_err(), ession.raise_fa_err()

Front 55

Via what package are classes, additions, order additions and keys accessed_

Back 55

extn

Front 56

Name three useful scripting packages

Back 56

util, format, tab, err

Front 57

Would you use 'session' or 'lookup' to find out what the language with id 2 is on the table code_lang. Also which function would it be?

Back 57

lookup.fld(...)

Front 58

What is the difference between system validation and order validation. Who defines each one?

Back 58

System validation - necessary for avaloq to function - defined by avaloq, rder Validation - user defines as desired.

Front 59

What triggers an order validation

Back 59

A workflow action

Front 60

To what business types are order validations applicable.

Back 60

All of them

Front 61

Situation: You have a start and end state. You perform a workflow action and there are order validations. , uestions: a) If the validation generates an, what state will you end in right after the error? b) If the validation genreates a warning, what state

Back 61

a) state, ) if the user clicks cancel then you will go back to the starting state if the user clicks ok, you will go the end state.

Front 62

What tables are used to parametrize order validations?, hallenge: What do you have to chagen on each table?

Back 62

CODE_UI_ERR, ODE_OVERRIDE, UT_TEXT

Front 63

What sources are used to parametrize order validations, hallenge: What do you have to change in each source?

Back 63

CODE_ORDER_TYPE, FC_STATUS, FC_ACTION

Front 64

Welches sind die 4 wichtigsten Typen von Rules?

Back 64

Cost Rules, Context Action Rules, Default Field Value Rule, Default Account Rule

Front 65

Wie werden Rules gruppiert?

Back 65

a) In Rule Sets. Eine Rule im Set triggert und liefert ein Resultat., ) In Sequenzen (Gruppen von Rule Sets). Jedes Rule Set liefert ein Resultat.

Front 66

Wie sind die Matching Kriterien und Value Constraints einer Rule verknüpft?

Back 66

AND (IF)

Front 67

Welche Rule triggert, falls bei mehreren die Bedingungen erfüllt sind?

Back 67

Diejenige mit der höchsten Priorität.

Front 68

Nenne ein Beispiel für ein Kriterium auf einer Klasse.

Back 68

bp_branch:zh (wobei zh die intl_id ist).

Front 69

Nenne ein Beispiel für ein Kriterium auf einem Key.

Back 69

country_iso:CH (wobei CH die intl_id ist).

Front 70

Was ist zu beachten, wenn ein Kriterium in Avalog Script definiert wird?

Back 70

Die Expression steht in [] und das Resultat des Ausdruckes ist true oder false.

Front 71

Was gibt es für Rule Typen und was bedeuten sie?

Back 71

expr: Das Resultat der Rule ist die Auswertung eines Ausdruckes (z.B. die konkrete Fax Nummer eines BP)., onst: Das Resultat ist eine Konstante (z.B. 6 Franken).

Front 72

Welche Rule sollte man nie vergessen?

Back 72

Die Catch All Rule.

Front 73

Wie lädt man eine Rule manuell?

Back 73

a) xxx_RULE_LD Tabelle befüllen., ) Rule Loader Task ausführen (es gibt einen Task pro Rule Loader Tabelle).

Front 74

Wie lädt man eine Rule über ENV?

Back 74

a) OMD Sheet befüllen., ) Mittels Makro den Code generieren., ) Code z.B. per SQL*Plus auf die DB laden.

Front 75

Wieviele Rule Sets können maximal gleichzeitig aktiv sein?

Back 75

1

Front 76

Was sind die 3 Typen von Resultaten einer Cost Rule Engine und was bedeuten sie?

Back 76

a) COST: Sofort belastete Kosten (z.B. Courtage)., ) FEES: Periodisch belastete Kosten (z.B. Kreditkarten Gebühr)., ) DEFERRED COST: Transaktionsbasierte Kosten, welche über eine Periode kummuliert belastet werden (z.B. Portospesen, die monatlich abgezoge

Front 77

Wie werden Rules parametriert?

Back 77

OMD, auch TOAD möglich.

Front 78

Welches Rule Set ist geladen, wenn beim Laden ein Syntax Fehler auftritt?

Back 78

Das bisher geladene. Wenn eine Rule eines Rule Set einen Fehler enthält, so wird das gesamte Rule Set verworfen und der Zustand vor dem Ladeversuch bleibt bestehen.

Front 79

Does Avaloq cover all major banking functionalities?

Back 79

Yes, it does.

Front 80

Do Avaloq interfaces provide the connection to data suppliers and stock markets?

Back 80

Yes, they do.

Front 81

What is the Avaloq Community?

Back 81

The Avaloq Community consists of Avaloq customers, partners and employees.

Front 82

What are Wildcards?

Back 82

Wildcards stand for characters when performing searches: "?", "%" or "*" for any number of characters and "_" for one character.

Front 83

What are Lookups?

Back 83

Lookups are search windows or code table windows.

Front 84

A banking client must have…

Back 84

… at least a Container to have a business relationship with the bank.

Front 85

How is usually the currency of a Money Account defined?

Back 85

On the Model Bank the currency is defined by the Contract of the Money Account.

Front 86

There is no difference between CHF and N.CHF! True or false?

Back 86

False. N.CHF is an Asset, CHF is a Currency.

Front 87

The system stops me if I forget to enter information that is needed! True or false?

Back 87

True.

Front 88

Orders are sent to the employee's inbox! True or false?

Back 88

False.

Front 89

All changes to static data can be traced! True or false?

Back 89

True. (Exception: Remarks)

Front 90

Can you combine search criteria about a Business Partner, e.g. name and domicile, in the Lookup application?

Back 90

Yes.

Front 91

Can you combine search criteria of a Business Partner and of a Container in the same search field?

Back 91

Yes.

Front 92

In a few terms, how do you create a Static Collection?

Back 92

Lookup Application à Search and select à Right mouse click (Collection>Save As Static) à Verify Direct.

Front 93

How many documents with the ID 1079 can you find in the Avaloq Community?

Back 93

This varies with every release update. Ask your teacher! (Lookup in the Community with Docu ID)

Front 94

Which version of Microsoft Windows is recommended to be used with ClassicClients for the current Avaloq release?

Back 94

This may vary with every release update. Look it up in Technical Requirements, Docu ID 1079.

Front 95

May a customer program/design an adapter?

Back 95

Certainly!

Front 96

Can client relationships be managed in Avaloq?

Back 96

Yes, using the CRM Desk as the central tool to manage client relationships.

Front 97

Where is the work of the front, middle and back office in Avaloq?

Back 97

One workflow may contain different statuses, e.g. to be reviewed by middle office, at back office for execution, etc. The workflow status may represent one role, one person or one office in a bank. All transactions/orders in such a status represent the wo

Front 98

Is it possible to parameterise (or set parameters for) the Navigation?

Back 98

Yes, with context actions.

Front 99

Is it possible to parameterise (or set parameters for) the End user view of menus?

Back 99

Yes, with end-user security rights.

Front 100

Is it possible to parameterise (or set parameters for) triggering processes per right mouse click?

Back 100

Yes, with context actions.

Front 101

Is it possible to parameterise a new field to save information about my customers, e.g. the colour of their socks?

Back 101

Yes.

Front 102

Is it possible to update a classification that was delivered by Avaloq?

Back 102

Yes.

Front 103

What cannot be parameterised?

Back 103

System checks (e.g. the field quantity must not be empty for a Stock Exchange transaction), new database tables, i.e. new table definitions, the beginning and the end of workflow processes and new object types.

Front 104

What does MEMI stand for?

Back 104

Multiple Entity Multiple Instances (Model LGT)

Front 105

Name the main objects used in the Avaloq Data Model.

Back 105

Business Partners, Addresses, Containers, Positions, Assets, Money Accounts.

Front 106

Which main objects typically are linked with each other?

Back 106

BPs and Containers, BPs and Addresses, Assets and Money Accounts with Positions

Front 107

What are additions, Classifications and Keys used for?

Back 107

Additions: Provide data fields not available in the standard entry forms, eys: Keys are unique symbolic references to objects (for the internal and external world).

Front 108

Name the concepts around orders supported by Avaloq!

Back 108

Status, Actions and Rules define a workflow. Apart from status Open, Discard and Done, everything in a workflow can be freely parameterised.

Front 109

What makes an Avaloq workflow?

Back 109

Booking Engine, Balance Engine

Front 110

Which Avaloq Engines are relevant in the context of Events?

Back 110

What is an Orderbook (Description & Business Purpose)?

Front 111

How can you adapt a standard Orderbook to only see all orders inserted by yourself for Stock Exchange Orders and subscribe to it?

Back 111

Avaloq>Tasks>Orderbook>Common, hoose 'DFLT' in the Layout field, nter 'stex' in the Meta_Type field, valoq>Tasks>Orderbook>Stock Exchange, nter '%me' in the field Inserted by

Front 112

What is a program?

Back 112

A program is a task with the purpose to insert, modify or delete data on the Avaloq database.

Front 113

What is a Collection and what types do exist in Avaloq?

Back 113

A Collection is a set of objects, which are either selected through a query (Dynamic Collection) or directly specified by the user (Static Collection). The object Collection allows saving the results of a user-defined selection of objects, grouped and sor

Front 114

An Orderbook is a consolidated view on Orders of a certain type (e.g. stock exchange orders) and it must meet defined criteria. Users maintain Orderbooks for every subject of interest in order to organize and simplify their daily work.

Back 114

Is there a connection between the functioning of the system and Central Services?

Front 115

Can Central Services be customised?

Back 115

- Central Services is an application, it opens in a separate window and will remain open unless you close the application explicitly or shut down Avaloq.

Front 116

What are tasks?

Back 116

They offer customisation features (queries, task templates, etc.)

Front 117

What are Jobs?

Back 117

A task is a procedure processed by Avaloq (such as reports, order book queries, programs …), - Synchronous tasks are stated via "Run" or "Show"., - Status "enabled": Does not mean it will be executed immediately, but as soon as a task dispatcher is free a

Front 118

What are background processes used for?

Back 118

- When executing a task via the "submit" or "print" commands asynchronously, By process queues, By technical processes offered within the Avaloq system, such as:, - End of Day processing, - File dispatching, - Job scheduling, - Application monitoring, -

Front 119

What is the difference between killing and stopping a BGP?

Back 119

- To stop (terminate) a BGP means, that you send a message to the process and ask it to be so friendly and stop processing as soon as the current work is finalized. In case the process is cooperative, it will do so., To kill a BGP means to take his life

Front 120

What are Process Queues (PRCQ)?

Back 120

A PRCQ processes entries in the list "Process Queue Entries". A BGP (BGP_PRCQ) regularly executes the PRCQs. The PRCQ executes an Avaloq script procedure which is in most cases implemented by Avaloq. Each PRCQ is responsible for specific work., PRCQ itse

Front 121

What are important PRCQ Groups, respectively PRCQ processors?

Back 121

- Low Priority:, processed by BGP: PRCQ_1 (ID: 905)): 20 PRCQs, High Priority:, processed by BGP: PRCQ_2 (ID: 906)): 14 PRCQs, STEX (parallel processing):, processed by BGP: PRCQ_3 (ID: 907)): 6 PRCQs, Bulk orders and Security events:, processed by BGP

Front 122

What differentiates the PRCQs processed by one BPG?

Back 122

- Priority (1 = highest / 9 = lowest), Timeslot (period of time when the corresponding PRCQ entries are processed before the linked BGP switches to the next PRCQ)., The keep period: How long work requests are being retained., The user: Each PRCQ is ass

Front 123

Currently, there are four (4) different entry points for parameterisation. Which ones are those?

Back 123

OMDs, APIs, TOAD, Sources

Front 124

List some disadvantages of direct table parameterisation through TOAD!

Back 124

- Requires technical know how and detailed knowledge of table architecture., The parameterisation specialist needs to know the table architecture of Avaloq., Consistency is not guaranteed. E.g. a source may affect 10 tables or more., There is no contro

Front 125

In which sequence of priorities appears the translation on an item? Consider not only the OUT_TEXT columns but also other table columns that you have been introduced to.

Back 125

- text in column TEXT, TEXT_GE, TEXT_FR, … (respective session language), text defined in TEXT_XX (default language), text in column NAME

Front 126

List an example where direct database parameterisation via TOAD is still done.

Back 126

Translations for specific parts

Front 127

Which columns are mandatory in a code table?

Back 127

ID, USER_ID, INTL_ID, NAME, ACTIV

Front 128

What is the purpose of ADT?

Back 128

ADT is the external parameterisation repository of Avaloq. It also serves as backup of the parameterisation of the Avaloq Instance.

Front 129

Is the parameterisation specialist writing PL/SQL code into the OMD sheet OMD_BP_CLASSIF.xls or simply meta data?

Back 129

Meta data. The PL/SQL code is generated by the macros from Modules.xls (delivered by Avaloq).

Front 130

Do rules affect the system behaviour?

Back 130

Yes

Front 131

To which source type do Object keys belong to?

Back 131

Source Type "Key Definition".

Front 132

To which source type do Additions belong to?

Back 132

Source Types "Code Table Data" and "Code Table Definition"

Front 133

To which source type do Data Dictionaries belong to?

Back 133

Source Type "DDIC"

Front 134

What is the risk in overwriting an Avaloq source?

Back 134

The source may get overwritten by Avaloq with the next release.

Front 135

What is the difference between the source status Corrupt and Error?

Back 135

A source's state is Corrupt when it compiles without an error in Avaloq but Oracle returns an error. A source's state is Error when the Avaloq compiler returns an error.

Front 136

How many Sources does a code table typically have?

Back 136

- Table Definition, Table Data

Front 137

Does a bank use only one Avaloq instance?

Back 137

No, clients have always a source versioning system (ENV).

Front 138

Does one source belong to several components?

Back 138

No, a source belongs to one component only.

Front 139

Is a source directly related to a change?

Back 139

No, a source version always belongs to a change.

Front 140

What do we need to do before closing a change?

Back 140

We need to write the documentation.

Front 141

Which are the views tin ENV hat show us the changes?

Back 141

We may see them in the Change View, in the Expression View, in the Orderbook…

Front 142

Can we modify an opened change? If yes, who can modify it?

Back 142

All the granted users may modify the sources in a change.

Front 143

Must a source be downloaded before compiling it?

Back 143

No, we can compile it directly (remotely) on a DB.

Front 144

Can I create new sources only?

Back 144

No, we can create new versions (and modify) or close sources.

Front 145

What "search" option do we have via ENV/ADT that we do not have via the Avaloq client?

Back 145

Via the Avaloq Client we cannot look for information in sources without specifying more information.

Front 146

Can we use ENV expressions to look for a source?

Back 146

Yes, we can. This is for example what we do in the Expression View.

Front 147

Give an example of a supplementary source type in ENV!

Back 147

Business Type Config (BTC)

Front 148

What is the difference between an API and an "insert into" statement?

Back 148

APIs take care of triggers and are re-runnable.

Front 149

How can we use a script to parameterise an instance?

Back 149

For example, by running it via an SQL client.

Front 150

BTC

Back 150

Business Type Config

Front 151

Is it enough to have saved a BTC source in ENV in order to parameterise an Avaloq instance?

Back 151

No, we still have to compile that source on the selected Avaloq instance.

Front 152

How can we track the modifications of a source?

Back 152

By comparing two versions for example.

Front 153

Which is the view that is based on the hierarchical structure between components, changes and sources?

Back 153

That view is called the Expression View.

Front 154

Clients have no possibility to reopen a change that has been closed? True or false?

Back 154

True

Front 155

May the same person close and audit a change? True or false?

Back 155

It depends on the rights that that person was assigned.

Front 156

Must the client use the (release-) boxes defined by Avaloq? True or false?

Back 156

The boxes are a set of possibilities; Avaloq can implement more for the client.

Front 157

ENV does not allow a customer to upgrade between two releases? True or false?

Back 157

False: ENV allows it and makes it easier.

Front 158

Does the Model Bank facilitate the first Avaloq implementation for a Bank? True or false?

Back 158

Yes, it does.

Front 159

What are the files that a bank receives for a release upgrade?

Back 159

So called "flat files".

Front 160

How are projects organized in teams, roles and responsibilities?

Back 160

The project organisation shows how a project is organized and who is responsible for what. The project plan may show the responsibilities on a task level.

Front 161

What is an initial project?

Back 161

An initial project is a project during which a bank (or banking-related enterprise) which does not yet use the Avaloq Banking System replaces its current system or parts thereof with the Avaloq Banking System.

Front 162

What happens during an evaluation phase?

Back 162

During the evaluation phase, the Avaloq Banking System is chosen as implementation package. During this phase functionality gaps may be identified.

Front 163

How are releases and service packs delivered to the customer?

Back 163

Releases are delivered via DVD, service packs are available for download in the Avaloq Community.

Front 164

What are the differences regarding the role of a parameterisation responsible in an initial project vs. upgrade projects?

Back 164

Initial project: work together with bank's key users and business analysts to specify the requirements., elease upgrade project: understand the delta between old and new release, understand the running Avaloq instance and identify means and ways to migrat

Front 165

What are the deliverables of a parameteriser in an initial project?

Back 165

- Source code according to specification, Technical specification, Input for test manager, use feedback of test manager to fix bugs etc., Input for communication with Avaloq

Front 166

Where do you find the Avaloq Community?

Back 166

www.avaloq.com à community

Front 167

Where do you find the Avaloq glossary?

Back 167

www.avaloq.com à community à glossary

Front 168

What is the Avaloq glossary for?

Back 168

The glossary forms and maintains the correct wording in Avaloq and what these terms are used for.

Front 169

How do you find out which is the most recent Document (last modified) in the Community?

Back 169

Use search and the date range to show the most recent documents

Front 170

Where do you find the Avaloq Documentation Tool?

Back 170

On the Avaloq webpage www.avaloq.com à community

Front 171

What is the Avaloq Documentation Tool for?

Back 171

Instead of a printed documentation, you have an up to date online resource about documentations of different sections, in different languages and for different versions of Avaloq.

Front 172

Which kind of issues can be entered into the Issue Tool?

Back 172

- Questions, Bugs, Development Internal Bugs, Change requests, Functional requests, GAPs (GAP, GAPi, Pre-GAP, GAPA), Internal requirements, Model Bank

Front 173

How can search criteria be saved for the next time?

Back 173

Using the action "save new query"

Front 174

How is the sort sequence determined by the system?

Back 174

It is determined alphanumerically (ASCII-table)

Front 175

The first frame has an identifier like 04.01. The second one has an identifier like 04.03. Why is the second one not defined like 04.02?

Back 175

It offers the possibility to insert a new frame without having to update the others.

Front 176

Whenever you define a label for a frame of a key what is the expression to use in the column Key in the table OUT_TEXT? What is added right after the expression?

Back 176

The expression ins OBJ_KEY.HIRA.[frame identifier]

Front 177

What different key types exist?

Back 177

Simple keys, calculated keys, referenced keys, rule based keys.

Front 178

For each key source compiled into the system a separate frame will be created automatically. Is that comment true or false? Justify your answer.

Back 178

No. The system creates only a separate frame if the parameterisation specialist uses a unique frame identifier.

Front 179

Are Additions crucial for most of the rule engines in Avaloq?

Back 179

No. In most of the rule engines are additions not directly parameterisable (extra column).

Front 180

Can additions be historised?

Back 180

No, they cannot.

Front 181

What do you have to parameterise additionally directly in the table of the database when creating initially an addition?

Back 181

You define a frame label with an entry in the table OUT_TEXT.

Front 182

Is it possible to set an addition mandatory?

Back 182

No, therefore you use the concept of order validation.

Front 183

Imagine you work in a project where a bank initially migrates to Avaloq. At what stage of the project would you model the classifications?

Back 183

Classifications are defined in an earlier stage of a migration project. It is absolutely crucial that classifications are well defined at implementation time. Once the system is live and running the effort to change existing classifications is much higher

Front 184

On which parameterisation concept are the derived classification based on?

Back 184

They are based on the rule loader concept.

Front 185

How many script types are available about Report Writer?

Back 185

- Start the Task Application, Go to the tab Reports, Enter ID 926, Select 'Avaloq Script Type: Default', Do a lookup on the script type field, Count the Report Writer specific Script Types, Answer is 6, Report Writer Consolidator, -File Layout, -Pri

Front 186

List at least three usage areas of Avaloq Script!

Back 186

- Report Writer, Order Validation, Avaloq Message Interface, Rule Loader, CTX Actions

Front 187

What happens to data in the order memory layer when the session is closed?

Back 187

This data is lost. No storage of data in memory layer is done.

Front 188

On which layer does Avaloq store an order permanently?

Back 188

Order Persistence layer.

Front 189

The data dictionary of which layer is displayed if you execute a CTX action on an object?

Back 189

Usually the data dictionary at the kernel layer (obj_xyz) is displayed. However, if you have an open order on the same object, the data dictionary at its memory layer will be displayed (mem_doc_xyz).

Front 190

What is the difference between the statements session.raise_ui_err(...) and session.raise_fa_error(...)?

Back 190

The first is displaying an information window with a message you specify in the parameter of the call. The second statement is a fatal error and stops the execution with a fatal error message and a log entry.

Front 191

Which is the resulting data type of the data access expressions doc.ref_curry.name? (root 'doc' is of business object type mem_doc_bp)

Back 191

text

Front 192

Which is the resulting data type of the data access expressions doc.ref_curry.domi_country.name? (root 'doc' is of business object type mem_doc_bp)

Back 192

text

Front 193

What triggers an order validation?

Back 193

A workflow action

Front 194

What is the difference between an order validation and a system check?

Back 194

Avaloq performs - by default - only validations that are necessary for the system to operate correctly (e.g. an order will execute properly). Order Validation allows a bank to implement its own checks. Order Validations are not mandatory. The system can o

Front 195

What is a view?

Back 195

A view is similar to a 'stored query' over one or more tables, but it never contains data.

Front 196

What is the Naming Convention for Rule Loader Tables?

Back 196

All Rule Loader Tables have the pattern 'RULE_LD' included in their name. Rule loader views are always based on Rule Loader Tables and have the pattern 'RULE_LD_V'.

Front 197

What are the possible values for the field RULE_KIND?

Back 197

const or expr

Front 198

How do priorities work?

Back 198

The system checks the rule with the highest priority first, e.g. 9999, until one rule matches.

Front 199

What is a catch all rule?

Back 199

It is the rule (usually with the lowest priority 0001 and usually with no matching criteria) that always matches. It normally is used to set a standard or default value.

Front 200

When do you need sequences?

Back 200

Sequence numbers allow you to apply more than one rule out of a rule set for the same input (one result for every sequence).

Front 201

Are there different tasks for loading rules?

Back 201

There is a different task for every Rule Loader Table.

Front 202

What happens if an error occurs while loading?

Back 202

There will be an error message on the screen or an entry in the error log table. No rules of the set are loaded, the rules within Avaloq remain unchanged.

Front 203

Using a rule loading template in the Tasks Application, what do you enter in the parameter field Rule Set?

Back 203

You must enter the same value as you find in the table in the column RULE_SET. The field is case sensitive!

Front 204

Are Priorities (of Business specifications) necessary?

Back 204

Business specifications are not complete if priorities can be deduced.

Front 205

Where can you find information about the default account rule loading?

Back 205

In the Docu ID 1093.

Front 206

Should you enter rules in a Rule Table?

Back 206

No! Only enter rules in Rule Loader Tables, not Rule Tables! Rule Tables are maintained by the system.

Front 207

Distinguish between Cost/Fees in Avaloq: virt-x trading fees?

Back 207

Cost

Front 208

Distinguish between Cost/Fees in Avaloq: Custody Fees?

Back 208

Fees

Front 209

Distinguish between Cost/Fees in Avaloq: payment expenses?

Back 209

Fees

Front 210

Explain the listed special Cost Rule Loader column: FACTOR!

Back 210

Cost tariff to be multiplied with the cost base quantity.

Front 211

Explain the listed special Cost Rule Loader column: OFFSET!

Back 211

The offset stands for the fixed cost. Fixed costs are charges that a client has to pay independent of the transaction base quantity.

Front 212

Explain the listed special Cost Rule Loader column: COST_CHRG_TYPE!

Back 212

This attribute allows defining, whether costs calculated by a rule shall be debited to the client, to the bank or if the cost calculation is for information purposes only.

Front 213

Do business processes and Avaloq workflows have the same quantity of steps?

Back 213

Not necessarily - There could be either equal, less or more workflows than business process steps.

Front 214

Which are basic components to parameterise workflows in Avaloq?

Back 214

Workflow Status, Workflow Actions, Workflow Rules and Workflow Commands

Front 215

Which tables are required for parameterisation workflows?

Back 215

WFC_STATUS, WFC_ACTION, WFC_RULE_LD and WFC_RULE

Front 216

For which object workflows can no workflow rules be implemented?

Back 216

Country and Collateral

Front 217

How are Context Actions parameterised?

Back 217

By direct insertion into database tables CTX_ACTION, WFC_ACTION, OUT_TEXT and CTX_ACTION_RULE_LD. If Avaloq Scripts are used, the corresponding sources need to be built.

Front 218

What are orderbooks good for?

Back 218

For organising the work, have a work or role specific To Do list, control activities an so on.

Front 219

How are orderbooks customised?

Back 219

In the applications Tasks on tab Orderbook show a list of all available orderbooks. By setting limiting parameters and filters, and saving them, the new definition can be subscribed.

Front 220

What is the sequence of execution for validations and commands?

Back 220

System Validation, Order Validation and Workflow Commands.

Front 221

What restrictions can be used for single constraints within an Order Validation?

Back 221

A single constraint can be restricted to be only executed for specified Workflow Actions.

Front 222

Which additional concepts support workflows?

Back 222

Context Actions, Orderbooks and Order Validations.

Front 223

How much Order Validation is meaningful?

Back 223

The quantity of Order Validation depends on the bank's needs. Be aware, too much Order Validation will slow down the system and reduces its usability.

Front 224

Which account type in a bank has the highest potential for fraud?

Back 224

To most famous account for fraud is the Account No 888888 from Neck Leeson. This was an in-house nostro and Nick Leeson managed somehow that is was no on the focus of internal controls. Consequently the losses booked on this account were not found until t

Front 225

Do I have to balance ledger container with manual balancing rules?

Back 225

No. Balancing rules of ledger container can be automatically inserted by a task (ID 612).

Front 226

Should interim accounts always balance out to 0?

Back 226

No. There are two types of interim accounts: A ledger container used for the balance side and a ledger container used for the profit and loss side. Interim Accounts for P&L do not balance to 0 (in most cases).

Front 227

What is the content of legal requirements for book keeping?

Back 227

Typically the structure of the balance, i.e. the detailed balance accounts of the profit and loss and of the off balance sheet items are defined. Additionally, rules for mapping of positions to the balance accounts and how these have to be valuated are sp

Front 228

Can the given general access rights be extended by inheritance of 'higher' general access rights?

Back 228

No

Front 229

Which context action on which object will show the users who have a specific access code?

Back 229

'Show member' on the access code (you can use this context action for instance when you navigate the users and find the access codes under the headline 'Specific Access Rights'.

Front 230

Which context actions will disable the user from using the system in the future and which of these will delete all access codes?

Back 230

Lock, Disable and Close. Close will delete the access codes.

Front 231

What reflects a 'role' typically?

Back 231

Typically, the technical 'role' reflects a task or a role in a bank, to which a person is normally assigned to. The role grants access to all kinds of activities that this assigned person gas to perform his daily work.

Front 232

Are the keys (access codes) encrypted?

Back 232

No. Access codes used as keys or as locks are not encrypted. There is no need to encrypt access codes in Avaloq.

Front 233

How do you exclude a user from an access right? How can you define that a group of users, except for one specific user, has certain access rights?

Back 233

This is not possible. With the concept of keys and locks you can only apply access rights but not deny them.

Front 234

Which of the following subjects can be protected individually? Object: Business Partner, Meta Type: Business Partner, Workflow action in Meta Type: Business Partner?

Back 234

All of these can be protected by access codes. Interdependencies have to be taken into account individually. For instance, it makes no sense to give access to the Meta Type BP, but not to any business partner or to none of the workflow actions. In other c

Front 235

What is the meaning of the access method 'ignore' and 'automatic insert'?

Back 235

These access methods are only available for the subject 'Overrides'. They control the right to override an error message. The difference is that the 'ignore' prevents the logging of the override whereas the 'automatic insert' is logged.

Front 236

Is it possible to parameterise Avaloq to use biometrical authentications?

Back 236

No. Avaloq itself provides no authentication method at all. As a standard the Oracle Authentication (UserID and password) is used. to implement biometrical authentication, it is possible to connect other authentication systems to Avaloq.

Front 237

Does Avaloq provide session context security?

Back 237

No. Session context security is only available with external systems for user authentication.

Front 238

What are the necessary elements for creating an Avaloq Report?

Back 238

Task, Flat Datamart, Report / Hierarchical Datamart, Layout Definition

Front 239

What applications are supported by Report Writer?

Back 239

Portfolio, Lookup, Orderbook, CRM-Desk, Central Services.

Front 240

What are tasks needed for in Report writer?

Back 240

Tasks are pieces of PL/SQL which provide data for a flat datamart

Front 241

How do you create flat datamarts?

Back 241

Flat datamarts are provided and maintained by Avaloq only. You cannot create them by yourself.

Front 242

What source types are tasks and flat datamarts created with?

Back 242

Task: source type "task" (TASK DEF),, lat Datamart: source type "DDIC"

Front 243

What is a hierarchical datamart?

Back 243

A hierarchical datamart is a kind of a view on the data provided by a flat datamart and enhanced with filters, aggregations and groupings, additional information etc…

Front 244

What source type is a report datamart created with?

Back 244

Report Datamart (REP DTM)

Front 245

Why should a hierarchical datamart definition and corresponding layout definition be stored in different sources?

Back 245

One report datamart may be used as a data source for different layout types (e.g. screen and print).

Front 246

May a report generator be used to create file reports?

Back 246

No. A report generator only supports screen layout.

Front 247

May generated screen reports be used in other applications than Avaloq?

Back 247

No. Screen reports are reports which are interpreted and shown by the Avaloq GUI-engine.

Front 248

What kinds of file types are supported by file reports?

Back 248

Plain text, HTML, XML. The provided Excel format is not native Excel but a plain CSV-file which can be read by Excel.

Front 249

What source type is a print report created with?

Back 249

Print reports (REP PRINT).

Front 250

What is Avaloq forms?

Back 250

Avaloq forms in an Avaloq script application which allows you to parameterise the order entry form shown on the user interface.

Front 251

What is the forms controller?

Back 251

The forms controller transforms the visible values from the form elements into the corresponding internal values of the order table and vice versa. The form controller also handles events such as form events coming from the presentation layer or order eve

Front 252

Is it possible to execute code through the event handler?

Back 252

Yes. As soon as the event is triggered any code defined in doc level- or form level-definition will be executed.

Front 253

What is the task of the layout manager?

Back 253

The layout manager is a software component that resides in the user interface and has the ability to layout elements during runtime according to the form layout.

Front 254

In Forms: What is defined in the group definition?

Back 254

In the group definition the group itself and the fields belonging to the group are defined.

Front 255

Is it possible to define value restrictions on a field?

Back 255

Yes. It is possible to restrict the values available for selection using the parameter 'context' followed by a condition in SQL notation.

Front 256

Name some field types supported in Avaloq Forms

Back 256

Text, Number, Obj, Date, Code, Text Area, etc…. see (Avaloq Forms Parameterisation (ID: 1648) section 4).

Front 257

What is EXTN++?

Back 257

EXTN++ is a feature of Avaloq Script applications which allows you to generate (nearly freely definable) list- or record-like data structures.

Front 258

What happens on binding the Avaloq Type in EXTN++?

Back 258

On binding the Avaloq Type, Avaloq creates the storage strategy, data dictionaries and transaction handling.

Front 259

EXTN++: What's the name of the generated data dictionary?

Back 259

MEM_DOC_EXTN_custr_ident, e.g. MEM_DOC_EXTN_MDB_FAVORITS

Front 260

Describe in your own words how an outgoing message is built, e.g. what triggers a message, which sources and database tables are involved etc.

Back 260

A message starting Point is an order. The message is triggered either in a settlement plan or in a workflow action. As a first step, the internal message is built by Message Builder based on the corresponding Outgoing Message Definition and stored on tabl

Front 261

List three usage areas of the business bus

Back 261

Incoming BB messages: Create or modify objects, utgoing BB messages: Export, acknowledge or request

Front 262

List three data providers for the Avaloq Market data interface!

Back 262

GAIN, Telekurs, Reuters

Front 263

Is Avaloq also a trading system?

Back 263

No, it is not.

Front 264

Does Avaloq store documents?

Back 264

Avaloq knows documents but if you want to store your documents you need an optical archive.

Front 265

When or where can Context Actions be used?

Back 265

Wherever there is an icon on the Avaloq GUI.

Front 266

How can you enter the last value date of a month in a date field?

Back 266

Type "u" into the date field. (Ultimo)

Front 267

Which two classes are mandatory when opening a 'Client' Business Partner on the Avaloq Model Bank?

Back 267

Customer type: Customer (01) and Branch office: e.g. Zurich (01).

Front 268

Can a Business Partner have two containers?

Back 268

Yes.

Front 269

In Cashier Operations, I can do a deposit with the workflow action "Withdrawal"! True or false?

Back 269

False.

Front 270

The Stock Exchange workflow process is a complex one! True or false?

Back 270

True.

Front 271

What does a workflow in Avaloq symbolize in a bank?

Back 271

It is the representation of business processes.

Front 272

Orderbooks may be individualized! True or false?

Back 272

True.

Front 273

When choosing the tab Orderbook, nothing appears! True or false?

Back 273

True (if you have not used it before).

Front 274

Is it possible to individualise the Navigator?

Back 274

No.

Front 275

Is it possible to call other reports (than the ones in the tabs) starting from the CRM Desk application?

Back 275

Yes, it is.

Front 276

Where in Avaloq are reports used?

Back 276

The Task application allows subscribing to Report templates or Orderbook templates, which will then be available in the respective tabs under queries. Reports are everywhere in Avaloq, e.g. in the applications and tabs (Lookup, CRM Desk, Portfolio, Naviga

Front 277

Is it possible to use LDAP (authentication)?

Back 277

Yes (confer (cf.) Docu ID 112, 1075).

Front 278

Is the use of interfaces and adapters for third-party systems optional?

Back 278

Yes, it is optional.

Front 279

What are the differences between standard, certified and project adapters?

Back 279

You will find the answers in Technical Requirements, Docu ID 1079, chapter 3., Standard A: by Avaloq, ertified A: by certified Partner, roject A: by customer or third-party system provider)

Front 280

How are business processes modelled and controlled in Avaloq?

Back 280

With workflows: the bank defines the workflow processes in Avaloq.

Front 281

Is it possible to parameterise (or set parameters for) Shortcuts?

Back 281

Yes, in the application 'Settings'.

Front 282

Is it possible to parameterise (or set parameters for) the View of customer data?

Back 282

Yes, with reports.

Front 283

Is it possible to parameterise (or set parameters for) Applications?

Back 283

Only the desks.

Front 284

Is it possible to parameterise (or set parameters for) the Business Partner entry mask?

Back 284

Yes.

Front 285

Is it possible to parameterise a new classification for specific evaluation in reports, e.g. evaluation of all German clients that pay taxes in Switzerland?

Back 285

Yes.

Front 286

Is it possible to parameterise a new sub-window?

Back 286

Yes, with Structured Extensions and Forms.

Front 287

What does MESI stand for?

Back 287

Multiple Entity Single Instance (Model LLB)

Front 288

What is the difference between MESI and SESI?

Back 288

Multiple Entity Single Instance: Several business units us a single database instance to store theirs data.Multiple Entity Multiple Instances: Several business units use several database instances to store their data.

Front 289

What is a Relationship?

Back 289

A relationship links two objects with each other. There are mandatory and optional relationships.

Front 290

Name the concepts around objects supported by Avaloq!

Back 290

Additions, Classifications and Classes, Keys, Names, Relationships, Security, Remarks

Front 291

What kind of orders do you know?

Back 291

Static data Orders & Transactions

Front 292

What is a workflow? Give Examples!

Back 292

An Event is the result of a transaction order (e.g. STEX) and consists of at least two Event Packets. An Event Packet symbolises different bookings on a Position.

Front 293

What is an Event in Avaloq? Please describe!

Back 293

Only one event status can be defined for each workflow status.

Front 294

How many events statuses can be defined for each workflow status?

Back 294

Which are the three elements of the Task Engine?

Front 295

What is a report?

Back 295

From a user's point of view, a Report is the visualisation of data created by various Avaloq applications. A report task takes this data and organizes it according to a certain layout, which was previously selected by the user., rom a technical point of v

Front 296

What is the difference between Orderbooks, Reports and Programs? Where can they be found in the Avaloq System?

Back 296

Whereas Orderbook tasks are only used to display data and Report tasks are mainly used to produce client output or user output, program tasks have the purpose to insert, modify or delete data on the Avaloq database. They are all tabs in the Tasks Applicat

Front 297

Can you define examples of Collections used in a bank?

Back 297

Clients of a relationship manager, banks, institutional clients, German clients, employees.

Front 298

Task Definition (capsules Procedures à Access to DB), Task Template, [Task Layout (à Legacy)]

Back 298

What is Central Services?

Front 299

What is a Session?

Back 299

Therefore, special technical access rights are required for all of its components., Each user logged into the Avaloq DB (level oracle) is assigned a session with a unique identifier. A S. is a "technical connection" to Oracle., - S. are on the Oracle DB

Front 300

What is the difference between stopping and killing a task?

Back 300

No answer given here. (Stop stops the BGP after all entries are terminated or timeslot has ended. Kill stops the BGP immediately and kills the corresponding session.)

Front 301

What are background processes?

Back 301

A BGP is an autonomous process that runs in the background without requiring user interaction. It is a secondary process running concurrently behind the active process appearing on the screen., GPs are defined (parameterised) with the following major attr

Front 302

What is the difference between BGPs BPG_ORA and BGP_OS?

Back 302

- BPG_ORA are implemented in PL/SQL and use the oracle package DBMS_Job. These BGP use the oracle job mechanism to perform their duties in the background., BGP_OS are UNIX shell scripts and executed directly in UNIX in an oracle session (via OCI or JDBC)

Front 303

Can Background Processes (BGPs) be cloned?

Back 303

Yes. The parameterisation in the source of the BGP defines how many instances on one BGP exist.

Front 304

How many PRCQ do exist?

Back 304

Approximately 60 PRCQ are available.

Front 305

What are PRCQs used for?

Back 305

- Execute time consuming calculations or data manipulations ("Bulk Order Generation"), Tasks not needed to be executed immediately in the workflow ("Generate Settlement Orders"), Tasks that need to be done regularly ("Standing Orders Generation").

Front 306

Is it possible to apply multiple BGPs to one PRCQ?

Back 306

Yes, but the recommendation of Avaloq is to apply only one BGP to a PRCQ, i.e. to implement a one to many relation between BGP and PRCQ.

Front 307

What is the main difference between the four entry points for parameterisation?

Back 307

Only TOAD is used to directly parameterise the database.

Front 308

How does Avaloq provide easy access to all table data to the parameterisation specialist?

Back 308

DDIC

Front 309

What is the purpose of the column KEY in OUT_TEXT?

Back 309

Provides a link between translated items and translation

Front 310

Is the filter for table values in TOAD case sensitive?

Back 310

Yes!

Front 311

Do workflow rules get parameterised via TOAD or OMD sheets?

Back 311

Both

Front 312

Why do OMD sheets use APIs?

Back 312

An API contains packages which transfer the OMD meta data into the respective tables. It is advisable to use Avaloq's APIs for two reasons:, The Avaloq API checks the meta data for consistency., The deployment of these APIs is independent of the knowled

Front 313

Are rules parameterised through sources?

Back 313

No, they are parameterised via OMD sheets or directly via TOAD (although this option should not be exercised).

Front 314

Which rule is needed in every Rule Set?

Back 314

The Catch All Rule.

Front 315

To which source type do Order Keys belong to?

Back 315

Source Types "Code Table Data" and "Code Table Definition"

Front 316

To which source type do BGPs belong to?

Back 316

Source Type "Background Process"

Front 317

To which source type does Navigator belong to?

Back 317

Source Type "Application"

Front 318

For what reason can not every source type be overridden?

Back 318

Because its compiler may not support an Override.

Front 319

How can you find out whether or not you are allowed to make changes to a code table? If you are allowed, where are changes permitted?

Back 319

Look up the public and private ID range in the Table Definition of that Code Table.

Front 320

Which is the Database that a Front Office Employee sees?

Back 320

The Avaloq Instance

Front 321

Does the Avaloq Client allow us to look at the information in ENV?

Back 321

No, the Avaloq Client connects itself to an Avaloq instance.

Front 322

Are components organisational aggregations of sources or logical relations between sources dependencies?

Back 322

Components are like folders, they are organisational aggregation of sources.

Front 323

Is a source directly related to a component?

Back 323

A source version belongs to a change that belongs to a component.

Front 324

How many users may work on the same change?

Back 324

There are four granted users permitted at one time.

Front 325

Can we modify a closed change?

Back 325

No. We need to open a new change to modify the sources (to create new source versions).

Front 326

Where do we indicate the database when we want to perform a remote compile?

Back 326

When we create a change we indicate the database via the field "Compilation DB".

Front 327

Can I open a source without opening a change?

Back 327

We cannot create a new source without creating a new change. (But as well it's possible to view a source without opening a change!)

Front 328

Can we look for information in a source code?

Back 328

Yes, we can. We do it via Gsearch.

Front 329

When we look for information in a source, do we have to compile that source before hand (on an Avaloq instance)? True or false?

Back 329

False - The source is stored in the ENV database.

Front 330

Where do we have more source types, in ENV or in an Avaloq instance?

Back 330

In ENV we have more source types.

Front 331

For what purpose might the source type Business Type Config be used for?

Back 331

It allows us to save and use PL/SQL code.

Front 332

Can we parameterise an instance by saving an Excel File?

Back 332

No, we should say that we can use Excel Files to produce the code that is going to parameterise an Avaloq instance.

Front 333

What are the sources in ENV where we can have PL/SQL code?

Back 333

Business Type Config (BTC)

Front 334

What do we call "unstructured sources"?

Back 334

BTC sources: They may have all kinds of very different parameterisations; this is why we call them "unstructured".

Front 335

How many versions may a source have?

Back 335

As many as we want.

Front 336

Could we have a new version of a BIN source?

Back 336

Yes, we can.

Front 337

Is the workflow from a change predefined by Avaloq?

Back 337

No, Avaloq only proposes "best practices".

Front 338

A change can only be closed when the docu has been audited? True or false?

Back 338

It depends on the workflow that the bank decided to implement.

Front 339

Avaloq releases and simple client changes have nothing in common. True or false?

Back 339

False: Releases are a set of changes.

Front 340

Might a service pack contain more changes than a release? True or false?

Back 340

False: a service pack is of minor importance than a release.

Front 341

Is the Model Bank also delivered in ENV? True or false?

Back 341

Yes, it is.

Front 342

Does the usage of ENV facilitate the private parameterisation of the Avaloq Banking System?

Back 342

Yes it does. It proposes, for example, a source versioning system.

Front 343

Which parties are involved in an Avaloq project?

Back 343

The following parties are involved: Bank, Avaloq and Implementation Partners.

Front 344

Which phases a project usually goes through and what deliverables are expected at the end of each phase?

Back 344

- Project initiation: Project Setup (Organisation, Project Plan etc.), Analysis & Design: Requirements specification, technical specification, Implementation & parameterisation: Source, finalised technical specification, Testing: Running System, Trans

Front 345

What difference between a product customer and an evolution customer?

Back 345

In contrast to the evolution customer, a product customer can go live with Avaloq based on the delivered CD and possible available Service Packs without requiring further functionality (gaps) to be developed.

Front 346

How often and when does Avaloq rollout a new release of the Avaloq Banking System?

Back 346

A new release of the Avaloq Banking System is rolled out to all customers every spring.

Front 347

What are the stages of release upgrade projects?

Back 347

Upgrade initialisation, installation clean-up, parameterisation adaptations, testing, cutover, post-cutover.

Front 348

What are the responsibilities of a parameteriser?

Back 348

- Parameterising the Avaloq Banking System., Discussing parameterisation issues with the bank's key business users and business analyst., Analysing functionality deltas within upgrade projects and defining migration scenarios to bridge them.

Front 349

What are the deliverables of a parameteriser in a release upgrade project?

Back 349

- Upgrade specification, Source code according to specification, Detailed technical specification, Input for test manager, use feedback of test manager to fix bugs etc., Input for communicating with Avaloq

Front 350

What is the Avaloq community?

Back 350

A 24/7 information portal and knowledge resource for the Avaloq professional

Front 351

What do you need to be able to use the Avaloq glossary?

Back 351

Have a valid username and login to the Avaloq community

Front 352

How do you find out how many documents are currently published in the Documentation Tool?

Back 352

Use search and submit without entering search criteria

Front 353

How do you find out which is the newest Avaloq release covered within a document in the Community?

Back 353

Use search and open the drop down field called "Release"

Front 354

What do you need to have to be able to use the Avaloq Documentation Tool?

Back 354

Username and password

Front 355

Where can issues related to Avaloq releases / functionality from clients projects be entered?

Back 355

Avaloq Issue Tool on Avaloq community website.

Front 356

Which kind of issues is relevant in which project phase?

Back 356

- Evaluation: GAP, Initial Project and Upgrade Project: all other types of issues

Front 357

Which issues can be entered by the parameteriser into the Issue Tool?

Back 357

Bugs and Questions

Front 358

You have a frame identifier like 01.00. Does the 01 in the frame identifier represent the type of object the source is assigned to?

Back 358

No, it represents just a naming convention but it helps to find the labels of frames in the table OUT_TEXT.

Front 359

Why is it for a frame identifier not recommended to use the INTL_ID instead of the ID as a reference for an object -type?

Back 359

The maximum length of the form order is limited to up to ten characters. If you used the INTL-ID instead of the ID for an object type then you may exceed the number of ten characters.

Front 360

Are the keys historised?

Back 360

No, they are not.

Front 361

Do you have to check the public ID range when parameterising keys?

Back 361

No, I do not have to because the compiler assigns the ID in the public ID range.

Front 362

What would be possibly necessary to parameterise additionally when you create a new key?

Back 362

If not yet implemented it could be necessary to define a frame label in the table OUT_TEXT.

Front 363

What sources are needed when parameterising client predefined values?

Back 363

Client specific predefined values require editing more than one source (CODE_CONST_TYPE, CODE_CONST_.[Name of the addition], [the Addition on an object or on an order]).

Front 364

What different data types can be used for additions?

Back 364

Text, date, boolean, [name of a code table], obj_[name of the object type], number, code_const.

Front 365

Where do you find the information for the ID range that you can use as a client?

Back 365

All the sources required to establish an addition are related to code tables. Therefore you look at the source of type 'code table definition'.

Front 366

Why are classifications more relevant for the system behaviour than additions?

Back 366

Because almost all rule tables (engines) contain a column to reference classes directly.

Front 367

You get the public ID range out of the source CODE_OBJ_CLASSIF of type 'Code Table Definition'. Is that true?

Back 367

No. There is no source on the Avaloq database. So the only way to get the public ID ranges is to look at the documentation 'ID Ranges' (1152).

Front 368

How is the API called that is actually entering the classification data?

Back 368

It is called 'obj_classif_ld'.

Front 369

What is one of the differences between Avaloq Script and PL/SQL?

Back 369

- PL/SQL accesses data through SQL queries in contrast to A(valoq) Script. A. Script does not offer direct SQL access., A. Script accesses data through the business objects e.g. Business Partner data, Asset data, etc.) that are exposed by the A. Banking

Front 370

List possible objects stored in the kernel layer?

Back 370

Business Partner, Container, Country, Address, etc.

Front 371

Does a static data order generate events for a booking engine?

Back 371

No, a static data order generates or modifies objects. Events are generated by a transactional order.

Front 372

List all types of data dictionaries! (See Docu ID 1670, 5.6)

Back 372

- Memory DDIC, Table DDIC, Datamarts, Pillar DDIC

Front 373

Each data dictionary consists of three parts. Which are they?

Back 373

- Fields, Methods, Constructors

Front 374

Write the message which is displayed by session.raise_ui_err(3, 'Academy')!

Back 374

Has to be in upper case letters: Academy" à Message #3 is "Has to be in upper case letters:

Front 375

Which is the resulting data type of the data access expressions doc.ref_curry_id? (root 'doc' is of business object type mem_doc_bp)

Back 375

number

Front 376

What is the difference between doc.ref_curry_id, doc.ref_curry.id and doc.ref_curry? (root 'doc' is of business object type mem_doc_bp)

Back 376

The first ID is retrieved directly out of the uppermost level of the DDIC. The second is retrieved out of the business object residing persistently in the database. The third expression is syntactically wrong, because the result is a link to a obj_curry b

Front 377

Can you change data in the kernel layer by using order validation?

Back 377

The definition of order validation is to check the validity of an order and to inform the user of a constraint which is violated. However, since Avaloq Script is used in an order validation source, you could - but you should never change data!, he use of

Front 378

Which are the parts of an order validation structure?

Back 378

- Header, Constraint, Check, Footer

Front 379

Mention five business areas where you can use rules?

Back 379

Check in the Docu ID 1055, chapter 5.

Front 380

What information can you read from the view DOC_FLD_RULE_ENTRY_V?

Back 380

Show the order fields, which can be filled in by default rules.

Front 381

Where can Avaloq Script be used in a Rule Loader Table?

Back 381

Avaloq Script can be used in the Matching Criteria fields, the COND field and the RESULT field.

Front 382

How are the matching criteria fields of rule loader tables linked to each other?

Back 382

With and; i.e. if 'matching criterion' and if 'matching criterion' and if ... then ... .

Front 383

Why set priorities?

Back 383

Priorities determine which rule is checked first and which ones will follow next.

Front 384

How do sequences work?

Back 384

The system checks the rules in the lowest sequence first, e.g. 1, then checks the rules of the next sequence, etc.

Front 385

What happens if two rules with the same priority are matching?

Back 385

The outcome is unpredictable. Avoid this situation by always setting clear priorities.

Front 386

What are Rule Sets? What are theirs characteristics?

Back 386

A rule set is a group of rules that belong together. A rule set must model the whole business situation in that context. Only one rule set of a kind can be active.

Front 387

Describe the process of implementing rules in Avaloq!

Back 387

Business specifications are defined. Rules are deigned and entered in the correspondent Rule Loader Table. The rules are loaded with the task that is specific to this Rule Loader Table. If there are no errors, the rules are entered in the Rule Table by th

Front 388

How many rule sets can be loaded simultaneously?

Back 388

In the Avaloq GUI only one set can be loaded at a time.

Front 389

Performance (of Business specifications)?

Back 389

It may be important to think about performance, i.e. the case that occurs the most should have the highest priority.

Front 390

How do you delete rules?

Back 390

- not recommended: delete the rows in the table, recommended: create a new set without these rules, recommended: load an empty Rule set

Front 391

Translate the following rule into the rule loader table: If Mr Willis places a Stock Exchange order, the field Medium should be set to fax.

Back 391

Mr Willis:BP, bp_symbol=MRWIL, Stock Exchange: intl_id_stex, Medium: field intl_id=medium, values: fax user_id=1, intl_id=fax, etc.

Front 392

Distinguish between Cost/Fees in Avaloq: Stock Exchange brokerage?

Back 392

Cost

Front 393

Distinguish between Cost/Fees in Avaloq: Swiss Stamp Tax?

Back 393

Cost

Front 394

Distinguish between Cost/Fees in Avaloq: Credit Card fees?

Back 394

Fees

Front 395

Distinguish between Cost/Fees in Avaloq: Account keeping charges?

Back 395

Fees

Front 396

Explain the listed special Cost Rule Loader column: MINIM_MAXIM!

Back 396

Defines the minimum/maximum value of cost. (Added to the Offset!)

Front 397

Explain the listed special Cost Rule Loader column: GRADUATED!

Back 397

Defines if different rules with the same book kind and matching criteria are aggregated or not.

Front 398

Explain the listed special Cost Rule Loader column: QTY_TYPE!

Back 398

The QTY_TYPE field is taken out of CODE_COST_QTY_TYPE. It defines for example, a tariff is calculated on number of shares or on the gross price.

Front 399

In which case is the modelling of business processes driven by the Avaloq workflows?

Back 399

When a process is very system specific, it usually is workflow driven.

Front 400

Which fixed Workflow Statuses exist? And which need to be used in all workflows?

Back 400

- 0 Start, 65 Rejected, 80 Ready for print, 90 Done, 91 Discarded, 92 Storno, mandatory are: 0, 90 and 91

Front 401

How is the translation for workflow components done?

Back 401

Translations will be done in table OUT_TEXT.

Front 402

What can be executed with context actions?

Back 402

Workflow Actions, Avaloq Script Packages, Reports and Tasks

Front 403

Are context Actions covered by the access rights concept of Avaloq?

Back 403

Yes

Front 404

What makes more sense?: To have general or specialised orderbooks?

Back 404

The right mix of general and specialised orderbooks makes the difference. Depending on the usage, both make sense.

Front 405

What triggers an Order Validation?

Back 405

Order Validations are triggered by workflow execution.

Front 406

Who builds the constraints used within an Order Validation?

Back 406

Constraints are built by parameterising persons on specification done by the bank / client.

Front 407

What are the main components of workflows?

Back 407

Workflow -Status, -Actions, -Commands and -Rules.

Front 408

Do I have only one Orderbook per Workflow?

Back 408

One Orderbook is the absolute minimum. Depending on the workflow, it makes sense to have an Orderbook per status or for a group of statuses.

Front 409

What is an engine and which engines exist in Avaloq?

Back 409

The combination of expert knowledge and a knowledge interpreter is called an engine. There are engines for instance for bookings, for balancing, for costs and fees., n difference to procedural programming languages, where code is defined statement by stat

Front 410

What are ledger containers?

Back 410

Ledger Containers are interim accounts used to ease the balancing. They are necessary as one Avaloq booking principle is 'Never book on balance accounts'. Thus, even money transactions cannot be booked directly on balance accounts, but rather on ledger co

Front 411

What is the difference between a money account, a ledger container and an interim account?

Back 411

A ledger container is an interim account. The interim account is a construct implemented for balancing purposes only. Consequently, they should not be misused, for instance to hide losses.

Front 412

What are the common groups of balance accounts?

Back 412

The Balance, the Profit and Loss (P&L) and the off balance sheet items.

Front 413

What are the central booking principles in Avaloq?

Back 413

- Debit = Credit: The total of the quantities of all event packets (bookings) of every asset involved in one event (transaction) must be balanced. The Book Engine performs this check automatically and generates different bookings if necessary., Net Posit

Front 414

Which technical access right is necessary to be able to see security related information?

Back 414

#See Security Information

Front 415

Which users are shown by the context action 'show members' used on an access code?

Back 415

Only the direct assigned are shown with 'show members', i.e. those where the access code is directly set. Users who have inherited the access or who have the general access rights 'any' will not be shown.

Front 416

Is there a context action that you have to use to update changes in a profile via inheritance?

Back 416

No. The inherited changes will be updated automatically.

Front 417

Are you able to see that there are objects where you have not sufficient access rights to see them?

Back 417

No. your universe is what you are allowed to see. The system acts as if those objects you are not allowed to see would not exist. Only example is when you are allowed to see the properties of an object (e.g. the properties of a container) and one of the p

Front 418

What is the difference between locks and keys?

Back 418

There is none, locks and keys are both access codes. The usage is different. A key is an access code applied to a user and a lock is an access code applied to a subject (i.e. something that has to be protected).

Front 419

How do you give partial access to a subject e.g. provide access to a business partner, but not to the relations of this business partner?

Back 419

This is not possible. Access is all or nothing per subject.

Front 420

Which subjects are impacted from the General Access Right: 'Workflow Action'?

Back 420

Via this General Access Right the access method of the Meta type, the workflow action and the context action are impacted.

Front 421

What is the difference between Authentication and Authorisation?

Back 421

Authentication is the process to ensure, that the anonymous person connecting to the system (may be via the internet) claiming to be a certain user with certain access rights is really the user. Authentication uses means like passwords, smart cars, keys o

Front 422

Why is it better to enable external authentication systems, instead of implementing a standard password control in Avaloq?

Back 422

Without standard password control in Avaloq, Avaloq can be connected with the existing authentication methods in the bank and reduce the amount of authentications. For instance, to implement a single-sign-on mechanism with only one authentication in the b

Front 423

What is the Report Writer designed for?

Back 423

Data out of Avaloq are selected, processed and enriched with information in order to fulfil users' needs for analyses and interpretations of this data.

Front 424

What is the basic language for Report Writer?

Back 424

Avaloq Script with Report Writer specific extensions.

Front 425

How do you set up a new report?

Back 425

- Select the task to be used to provide the flat datamart, Select a layout type, Write the hierarchical datamart definition or use an existing one, Write the layout definition based on the hierarchical datamart, Compile, check results and debug

Front 426

What is a flat datamart?

Back 426

A flat datamart is the temporary view on the data provided by the referenced task. Which data can be accessed is defined by the flat datamart definition.

Front 427

How can you find out which flat datamart and task match?

Back 427

Each task, which supports a certain flat datamart, can be seen in DDIC: Tasks are referenced by flat datamarts.

Front 428

Is it possible to support a flat datamart with more than one task?

Back 428

Yes, it is. (But not at the same time! Several tasks may be used to fill one DTM, but at parameterisation time, one of the possible tasks has to be selected for a specific report.)

Front 429

How many flat datamarts can be accessed by a report datamart?

Back 429

One. A report datamart is connected to exactly one flat datamart but may on the other hand be enhanced by referring to other DDICs in the report definition (e.g. obj_bp, obj_asset, …).

Front 430

What types of layout definitions are supported by Avaloq?

Back 430

Screen, File, Print, Script, Table

Front 431

What is a report generator?

Back 431

An application provided by Avaloq which creates hierarchical datamart definitions and screen layout definitions based on interactive input by the user. Theses sources may be used as a template for further refinery.

Front 432

What source type is a screen report created with?

Back 432

Screen Report (REP SCREEN)

Front 433

What source type is a file report created with?

Back 433

File report (REP FILE)

Front 434

May generated files be used in other applications than Avaloq?

Back 434

Yes. A report's developer may design any kind of file (if he knows how to do so…). One of the most common usages of file reports is generating XML-files which are further processed in other systems.

Front 435

What kind of format do generated print report outputs have?

Back 435

Print reports generate PostScript files which van be directly interpreted by any PostScript printer.

Front 436

What do the fields on the forms interface represent?

Back 436

The fields represent the values of a certain business object, which are held in a table on the Avaloq server.

Front 437

Can a form be bound to more than one business type?

Back 437

No. A form in bound to exactly one business type.

Front 438

What does 'doc' stand for?

Back 438

The data source 'doc' stands for an order of the bound business type (e.g. Mem_doc_bp).

Front 439

What is the keyword syntax used for a new source?

Back 439

[Form 1.0]

Front 440

What is the taborder?

Back 440

Taborder is the part of a source, where the order in which the cursor moves from one field to another is defined.

Front 441

In Forms: What happens to the string defined in 'naming'?

Back 441

After compilation of a source this string is shown in the Objects or Transactions menu.

Front 442

In Forrms: What is the minimum / maximum size of a column?

Back 442

1 - 4 (Supposed: Maximum may be higher?)

Front 443

Which is the source type of the data structure of EXTN++?

Back 443

'Type Definition'

Front 444

How are the Avaloq types coupled to an object type in EXTN++?

Back 444

The Avaloq Types have to be coupled to an object type via an addition.

Front 445

List the different source types used for configuring the Message Interface

Back 445

NETW, NETW STRUCT, MESS STRUCT, IN / OUT, Script packages

Front 446

Describe how an incoming message is processed.

Back 446

An external network puts a message using EMI. The message is stored into the table MSG_EXTL_IN. The appropriate Message Parser analyses the message and breaks it down into elements. In this form, the Message is stored into table MSG. The appropriate Messa

Front 447

The Business Bus is based on AMI: true or false?

Back 447

True. The AMI XML format is the technological basis forIncoming BB messages: Create or modify objects, utgoing BB messages: Export, acknowledge or request

Front 448

What kind of data is delivered via Telekurs or Reuters respectively?

Back 448

Asset Data

Front 449

What are the possible states for a task, in the order of processing?

Back 449

enabled, (holding), started, processed / killed / not processed

Front 450

What is the background process called that starts an enabled task?

Back 450

Task Dispatcher

Front 451

When does a task get the state ‘not processed’?

Back 451

A task goes from state ‘started’ too ‘not processed’ when the automatic system action failed.

Front 452

What are the possible states for a job, in the order of processing?

Back 452

scheduled, (holding), waiting, started, executed / failed

Front 453

What is the background process called that starts a scheduled job?

Back 453

Job Processor

Front 454

Which kernel module forms the core of the Central Services application?

Back 454

The report writer

Front 455

What is the main difference between a Process Queue and Job Processing?

Back 455

Batch Jobs are scheduled to run at a specific time, or when other jobs have ended. The Process Queue is executed continually, throughout the day and night

Front 456

What background process is provided for the execution of Process Queues?

Back 456

PRCQ Processor

Front 457

What is the unit of work called, which is processed by a Process Queue?

Back 457

Process Queue Entity, which is made up of Workflow Actions

Front 458

Can the background processes be disabled over night while the EOD (TEV) is running?

Back 458

No, the BGPs must be running while the EOD Jobs are processed

Front 459

How would you disable someone’s access to the avaloq client, with immediate effect?

Back 459

Lock or disable the user on the ‘User’ object, and then kill his session in the Central Services.