AVQ SWISSC
Question from AVQ Academy Part 2 - Englisch und Deutsch gemischt
Question from AVQ Academy Part 2 - Englisch und Deutsch gemischt
Kartei Details
| Karten | 300 |
|---|---|
| Sprache | Deutsch |
| Kategorie | Informatik |
| Stufe | Andere |
| Erstellt / Aktualisiert | 11.03.2015 / 09.06.2017 |
| Weblink |
https://card2brain.ch/box/avq_swissc
|
| Einbinden |
<iframe src="https://card2brain.ch/box/avq_swissc/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
|
What different data types can be used for additions?
Text, date, boolean, [name of a code table], obj_[name of the object type], number, code_const.
Where do you find the information for the ID range that you can use as a client?
All the sources required to establish an addition are related to code tables. Therefore you look at the source of type 'code table definition'.
Why are classifications more relevant for the system behaviour than additions?
Because almost all rule tables (engines) contain a column to reference classes directly.
You get the public ID range out of the source CODE_OBJ_CLASSIF of type 'Code Table Definition'. Is that true?
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).
How is the API called that is actually entering the classification data?
It is called 'obj_classif_ld'.
What is one of the differences between Avaloq Script and PL/SQL?
– 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
List possible objects stored in the kernel layer?
Business Partner, Container, Country, Address, etc.
Does a static data order generate events for a booking engine?
No, a static data order generates or modifies objects. Events are generated by a transactional order.
List all types of data dictionaries! (See Docu ID 1670, 5.6)
– Memory DDIC, Table DDIC, Datamarts, Pillar DDIC
Each data dictionary consists of three parts. Which are they?
– Fields, Methods, Constructors
Write the message which is displayed by session.raise_ui_err(3, 'Academy')!
Has to be in upper case letters: Academy à Message #3 is "Has to be in upper case letters:"
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)
number
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)
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
Can you change data in the kernel layer by using order validation?
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
Which are the parts of an order validation structure?
– Header, Constraint, Check, Footer
Mention five business areas where you can use rules?
Check in the Docu ID 1055, chapter 5.
What information can you read from the view DOC_FLD_RULE_ENTRY_V?
Show the order fields, which can be filled in by default rules.
Avaloq Script can be used in the Matching Criteria fields, the COND field and the RESULT field.
How are the matching criteria fields of rule loader tables linked to each other?
With and; i.e. if 'matching criterion' and if 'matching criterion' and if ... then ... .
Priorities determine which rule is checked first and which ones will follow next.
The system checks the rules in the lowest sequence first, e.g. 1, then checks the rules of the next sequence, etc.
What happens if two rules with the same priority are matching?
The outcome is unpredictable. Avoid this situation by always setting clear priorities.
What are Rule Sets? What are theirs characteristics?
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.
Describe the process of implementing rules in Avaloq!
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
How many rule sets can be loaded simultaneously?
In the Avaloq GUI only one set can be loaded at a time.
Performance (of Business specifications)?
It may be important to think about performance, i.e. the case that occurs the most should have the highest priority.
How do you delete rules?
– not recommended: delete the rows in the table, recommended: create a new set without these rules, recommended: load an empty Rule set
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.
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.
Distinguish between Cost/Fees in Avaloq: Stock Exchange brokerage?
Cost
Distinguish between Cost/Fees in Avaloq: Swiss Stamp Tax?
Cost
Distinguish between Cost/Fees in Avaloq: Credit Card fees?
Fees
Distinguish between Cost/Fees in Avaloq: Account keeping charges?
Fees
Explain the listed special Cost Rule Loader column: MINIM_MAXIM!
Defines the minimum/maximum value of cost. (Added to the Offset!)
Explain the listed special Cost Rule Loader column: GRADUATED!
Defines if different rules with the same book kind and matching criteria are aggregated or not.
Explain the listed special Cost Rule Loader column: QTY_TYPE!
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.
In which case is the modelling of business processes driven by the Avaloq workflows?
When a process is very system specific, it usually is workflow driven.
Which fixed Workflow Statuses exist? And which need to be used in all workflows?
– 0 Start, 65 Rejected, 80 Ready for print, 90 Done, 91 Discarded, 92 Storno, mandatory are: 0, 90 and 91
How is the translation for workflow components done?
Translations will be done in table OUT_TEXT.
Workflow Actions, Avaloq Script Packages, Reports and Tasks
Are context Actions covered by the access rights concept of Avaloq?
Yes
