Process Workflow
Process Workflow
Process Workflow
User Guide
No part of this document may be reproduced or transmitted in any form or by any means,
Electronic or mechanical, for any purpose, without the express written permission of TEMENOS Holdings NV.
Table of Contents
Overview .................................................................................................................................................. 3
Setup ....................................................................................................................................................... 4
[Link].................................................................................................................................. 4
LOCKING ............................................................................................................................................. 5
COMPANY ........................................................................................................................................... 6
[Link] ................................................................................................................................ 7
Archiving ........................................................................................................................................... 7
[Link] ...................................................................................................................................... 10
[Link] ............................................................................................................................ 10
[Link] .............................................................................................................................. 11
[Link].................................................................................................................................... 15
[Link] ............................................................................................................................ 16
[Link] .................................................................................................................................... 17
[Link] ..................................................................................................................................... 19
ENQ [Link] .......................................................................................................................... 19
[Link]................................................................................................................................... 21
[Link] ............................................................................................................. 22
Enquiries ................................................................................................................................................ 24
Deal/Transaction processing ................................................................................................................. 27
[Link] ............................................................................................................................ 27
MAPPING .......................................................................................................................................... 28
@ID Mapping ..................................................................................................................................... 33
Automatic generation of records using OFS ...................................................................................... 34
The Process Workflow Setup: ........................................................................................................ 34
Auto Screen Presentation .............................................................................................................. 44
Auto process creation..................................................................................................................... 48
Data Mapping ..................................................................................................................................... 51
Local reference mapping ........................................................................................................ 57
Mathematical operators .......................................................................................................... 59
Application Program Interface ............................................................................................................... 61
Routines ............................................................................................................................................. 61
Literals................................................................................................................................................ 63
Reports .................................................................................................................................................. 64
Duration Analytics .............................................................................................................................. 64
Overview
T24 Process Workflow is aimed at grouping various businesses and banking procedures into a logical
process of activities. This grouping enables allocation of work to different users, ensuring vital tasks
are not left out causing a breakdown or delay in the process chain.
Individual activities are defined at micro level defining rules, statuses and user groups, which can all
be reused. These activities are then set out in a pre-defined sequence allowing a customized business
processed to be followed.
This module does not carry any business functionality but can be used to define and tune the flow of
business supported by other T24 modules.
Setup
[Link]
[Link].
An [Link] record must be set up for the [Link] and [Link] tables,
with an ID format of the following:
For [Link] table – ‘PW’YYJJJnnnnn. Where YY = Year, JJJ = Julian date and nnnnn =
sequence number.
For [Link], the set-up is the same but for the prefix of ‘PA’. – ‘PA’YYJJJnnnnn.
Once the [Link] record has been committed and authorised a LOCKING record will be
created for [Link] and [Link] containing the start Id’s for each file.
If these records are not set up correctly, when launching a new [Link] record in T24 Browser,
a blank screen will be displayed.
To correct this, reset the LOCKING records by correcting and recommitting the [Link]
record for PW. The Cache file for Browser, [Link], will also need to be cleared of all
records pertaining to [Link].
LOCKING
LOCKING.
COMPANY
COMPANY.
The [Link] table (only) must be entered into the [Link] field on the COMPANY
record to enable automatic creation of ID’s.
[Link]
Archiving
With the ever increasing transactions records in [Link] and [Link] the
configuration of [Link] can utilised for archiving these records and moving them to
History.
[Link] record.
The archiving process can either be done online using the [Link] record
BNK/[Link] or during the Close of Business using the BATCH process record
BNK/[Link].
Example
The current System Date is 30th Nov 2000.
As shown above the field [Link] in [Link] is defined as today’s system date.
The field [Link] in the [Link] record is set at 30th Nov 2000.
A shown below on running the [Link] record BNK/[Link], the [Link] and
its related [Link] records are moved to history since they have reached the specified
[Link].
[Link]
[Link].
Status codes are defined separately and attached to [Link] records. They are needed to
define the default status or starting status of an activity ([Link] on the [Link]
record) e.g. PENDING, and are also used to set the [Link], in conjunction with a
[Link], on the [Link] record when the conditions of the rule has been met.
[Link]
[Link].
This table is used to group Users or Account Officers together and is attached to either the
[Link] or [Link] record. A User/Account Officer is then automatically allocated to
an Activity, spreading the workload systematically between all users/ Account Officers within the
[Link] group.
This helps Users/Account Officers in identifying their daily work by using an Enquiry to drill down and
launch their specific tasks.
[Link]
[Link] is the table used to define conditions/transition rules. Transition rules are attached
to activities via the [Link] or the [Link] table. These rules
determine when the status of an activity changes and the status further determines if and when a
subsequent activity can appear on the [Link] list for a user and hence be executed.
When each multi-value is added from fields [Link] – CRITERIA, this acts as an ‘AND’
between the criteria – so if we have two multi-values, both conditions need to be met for the
[Link] test to be passed.
The Selection Operand determines whether the above fields AND the below routine, or the above
fields OR the below routine, need to be satisfied in order for the [Link] test to be passed.
[Link] record.
Note: When both ROUTINE and [Link] are given, the execution of the routine
specified in ROUTINE takes precedence over [Link] rules.
When there is a value specified in the [Link] field the ROUTINE field is mandatory.
When [Link] and ROUTINE are given without [Link] then
[Link] is defaulted to ‘OR’.
[Link] record.
[Link].
There should be content specified for [Link], ROUTINE or both. When ROUTINE is
given with [Link] with no value in [Link], the [Link]
is defaulted to NULL.
When neither of the [Link] or the ROUTINE field is populated the [Link]
field becomes mandatory. But if ROUTINE is given [Link] is not mandatory.
[Link]
[Link].
These records are used to map data from one activity record to another. The Mapping ID is attached
to the [Link] record where the data is to be mapped to. EG. If in a process a CUSTOMER
record is created, then an ACCOUNT record for that customer and you wish to map certain data from
the customer record to the account record, the [Link] record will be attached to the
[Link] for the account activity.
Please refer to the Data Mapping Worked Example for further information.
PW does not support mapping to the 2nd application/contract in a 2-phase application such as
mapping data from the main LD contract to [Link] fields.
PW currently does not support 2 phase commit applications with the exception of LD and
[Link].
[Link]
[Link].
This table can be used to define common field links to map data to be attached to the [Link]
table. This table allows data links to be re-used.
Please refer to the Data Mapping Worked Example for further information.
[Link]
[Link].
These records determine the status, transition rules, duration, data mapping and so on of an activity.
The TARGET field defines which T24 application will be launched when the activity is executed; it
details how the application will be run i.e. how the application is usually executed from the command
line. PW currently does not support 2 phase commit applications with the exception of LD and
[Link].
Please refer to the Data Mapping Worked Example for further information.
The field [Link] can be used to accept a hook routine only with a valid entry [Link] record.
On keying in any other value not already predefined in [Link], an error message,” RECORD NOT
FOUND” will be shown.
This field enables distribution of an activity to a user in PW based on certain selection criteria (i.e., by
competence level or region). And, a user could be assigned to handle continuous activities (i.e., the
same user from the previous activity will be assigned to handle the next activity).
[Link].
[Link]
[Link] record.
ENQ [Link]
This enquiry record should display the service name, the activities associated with it and the target for
the activity (to be picked up from [Link]) in every row. This should accept a [Link]
as selection criteria.
Enquiry [Link].
Enquiry results.
[Link]
[Link].
The first step in setting up and starting a process is by creating a [Link] record. This
contains the [Link] record that defines and determines the flow of activities
to be executed.
Once the [Link] record has been committed in Authorise mode, for each activity set up on
the [Link] record that has no [Link] attached to it, a
[Link] record will be automatically generated, thus only allowing activities to be
executed once previous tasks or activities have been performed. These [Link] record
IDs along with some detail are written to the [Link] record.
[Link]
[Link].
This table allows the linking of activities together in a logical business flow. It defines when an activity
is enabled depending on pre-required Activities and their Statuses or Transition Rules. So
[Link] helps not only in defining the activities to be a part of the process, but
the sequence and the stage at which they have to appear in the process.
Defining multiple status for process definition results allows activities to be completed based on
different sets of rules/conditions being met
[Link].
Enquiries
Launching of activities takes place through a drilldown ENQUIRY of the [Link] file,
allowing a user to automatically launch the activities from the enquiry.
The basic [Link] and [Link] ENQUIRY records come as part of the T24 PW module.
Specified key words in these enquiries allow Process Workflow to function and care must be taken to
not delete or change vital fields in these basic ENQUIRY records.
See the below example of the important fields involved.
A [Link] field on the ENQUIRY record, as in the above example, must contain the data ‘PW’,
along with the [Link] being set to ‘PWACTIVITY’.
And an [Link] field on the ENQUIRY must contain the launch functions as in the above
example.
If the ENQUIRY is not set up correctly intermittent problems will occur, with activity status’s and
[Link] records not being updated, and mapping not working.
Now that the process has been created, running the ENQUIRY, [Link] displays all
activities and their statuses that can be or have been executed. Drilldown on the enquiry will allow the
chosen activity to be executed automatically.
The standard ENQUIRY record [Link] allows activities to be listed per user, which allows a specific
user to concentrate on their allocated tasks.
With two stage applications LD and [Link] it is advisable to complete the activity before
launching applications via the explorer menu or command line.
Deal/Transaction processing
[Link]
[Link] Id’s are automatically generated by the system (as long as the
[Link] record has been set up, see ‘Setting Up of the System’ document for PW), these
records cannot be created manually, the copy function is also not allowed.
[Link].
This file contains the records of all activities that can be or have been executed. Once an activity has
been executed the [Link] field contains the ID of the record of the T24 or
[Link] application that was executed.
Upon completion of an activity, the system scans through the [Link] record
and creates [Link] records for all activities that could be started if their
[Link] has been met.
The field [Link] contains the date on which the activity was created through [Link].
The field [Link] is calculated as the [Link] + the number of working days, where the
number of working days is specified in the [Link] field of the respective [Link]
record.
For audit purpose the fields [Link] and [Link] record information of the
originating process ID and parent processing ID.
MAPPING
A Working Example
Taking into account that the [Link], [Link], [Link], [Link] and
[Link] records have been created.
Two [Link] records are created; one to launch an Account application; the other to launch a
Funds Transfer application.
[Link] Record.
[Link] Record.
A [Link] record is created; this will detail where the data is to be extracted from and where it
is going to.
[Link] details what type of T24 application this record is going to be attached to, in this case it is
an FT application.
[Link] any description can be chosen so long as it matches it’s corresponding field
[Link].
[Link] : This field dictates what data is being mapped and where it is coming from. In this
case the field CURRENCY in the [Link] record [Link].
[Link] is the data is being mapped to, this field must exist in the application detailed in the
[Link] field, in this case [Link].
[Link] Record.
The [Link] record is attached to the appropriate [Link] record in the [Link]
field.
[Link] field.
[Link] Definition.
[Link] Definition.
We can see that the Account Activity is first in the launch list.
The [Link] launches an ACCOUNT record that is populated and committed, note the
currency is CHF.
Account Record.
Once the Account record is committed and the Enquiry refreshed, the [Link] activity has
the committed record’s ID displayed.
[Link] activity.
@ID Mapping
Process Workflow can also map record ID’s to other application’s fields, in the example below the @ID
from the account activity is mapped to the [Link] field in the application
[Link]
[Link].
An [Link] record needs to be created, the field [Link] should be GLOBUS and the
field [Link] should be OFS. In the record below a Log has been created to track the OFS
scripts that TSA uses for mapping, see the OFS USER GUIDE for more details on [Link].
[Link] record.
Two [Link] are going to be used for the first test both are based on the ACCOUNT
application, the first is set up as usual with field [Link] set at MANUAL, a [Link]
set, the TARGET is a zero authoriser version.
[Link].
The second [Link] record is where we will be mapping the data from the first activity too.
To signal this record to use TSA for the mapping function the [Link] is set to AUTO and
the [Link] is populated with the [Link] record created earlier.
A [Link] record is also attached this will determined what is data is to be mapped, otherwise
the record is identical to that of the first activity.
[Link].
The [Link] record is designed to for the second activity has used the [Link] record
ACCT.ACCOUNT1 as the source to map over the fields CUSTOMER, CATEGORY, [Link].1,
CURRENCY, [Link].
[Link].
[Link].
Now the TSA functionality will be activated, more on the TSA functions can be found in the COB
USER GUIDE.
Firstly an existing [Link] record has the [Link] field set to START the record
is committed.
[Link] agent.
[Link] record.
The record BNK/[Link] has the [Link] field set to AUTO and committed.
[Link] record.
[Link].
The ENQUIRY [Link] is launched and again displayed the first activity, this is executed manually.
Enquiry.
The ENQUIRY [Link] is launched to track the progress of the PW workflow, this shows
that the first activity has reached the status of complete and that a transaction reference has been
assigned to it, in this case it is an ACCOUNT ID
Note we have not activated the TSA functionality yet so the record will not be created yet)
Next two CLASSIC sessions are opened, drop down to jshell and initiate the Service Manager by
typing
In the other CLASSIC session type tSA 2 this will launch the TSA agent
When the first activity reached completed status an OFS SCRIPT was created, the TSA functionality
finds this script, and maps the relevant fields detailed in the [Link] record over in an
[Link] creating and committing a new record.
The Script produced when launching the tSA 2 agents shows that this has occurred.
Viewing the [Link] record detailed in the [Link] that is attached to the [Link]
record shows in the first line the OFS script created when the first activity was completed, then the PW
mapping by the TSA functionality that creates the full OFS script at the bottom of the LOG.
Once that has been run, the ENQUIRY [Link] is launched again we can see the
difference the TSA service has made, the second activity (which is the automatic creation of the
record) has been completed and been assigned a transaction reference. Because the second activity
has reached a status of complete the third activity can be displayed.
On viewing the ACCOUNT record created by the automatic activity we can see that the fields
CUSTOMER, CATEGORY, [Link].1, CURRENCY, and [Link] HAVE been
successfully mapped over.
Enquiry.
The USER or [Link] detailed in the [Link] record must be the same as
the USER profile executing the workflow, so in the below example in order to use the new
functionality the USER profile of RICHARD01 will need to be used.
[Link].
The [Link] record must be included in the Owner field in the [Link] record
being used.
Below the [Link] record has the [Link] record of [Link] to allow the
Auto Screen Presentation functionality to operate. All other [Link] records that are to be
subject to the auto launch functionality are similarly edited.
[Link].
The [Link] record contains all the [Link] records that are to be
included in the workflow, to allow the new auto launch functionality the new field [Link] is
flagged to YES.
Note: In order to control the order in which the flagged [Link] records are launched the
[Link] fields need to be used in order to allow this functionality to operate.
[Link].
A [Link] record is then created, note the same [Link] record is used to
populate the OWNER field
[Link].
As soon as the [Link] record is committed and authorised the new functionality
automatically launches the first Activity flagged for auto launch in the [Link]
record with out having to launch a PW ENQUIRY e.g. [Link].
Customer.
Once the first activity has been committed and meets the required status to allow the second activity
to launch automatically
Note: that the [Link] field has been populated showing that data mapping is operating
with in the new functionality.
Account.
Allows a [Link] to be automatically created in the background with no interaction from the
User except for a command line entry.
To do this, the following format will be input into the command line of T24 Browser.
Automatic screen presentation can be used in conjunction with Auto Process Creation to create and
display activities with out interacting with the PW ENQUIRY.
Using an auto presentation set up the command line is populated with the PW pre fix, the ID of the
[Link] follows and then the [Link] ID is populated.
Process Creation.
As soon as the command line is committed the [Link] is created and following the
[Link] workflow the first activity is automatically presented to the user.
Customer creation.
In an example when auto presentation is disabled, the PW pre fix is entered the ID of the
[Link] follows and then the [Link] ID is populated in the
command line and committed.
Process Creation.
[Link].
On launching the ENQUIRY [Link] we can resume a normally manual launch of the workflow.
Data Mapping
To allow greater flexibility and to provide more options in Process Workflow mapping the application
[Link] has been linked to the PW module via [Link].
Data Mapping will be replacing [Link] and no new [Link] records will be allowed.
This will allow mapping options such as universal ID mapping, the ability to manipulate data through
concatenation of fields, using routines, universal local reference mapping and the mathematical
operator’s addition, subtraction, multiplication, division.
The new Data mapping options can work side by side with the current mapping functionality provide
for in [Link]. In the event that the Data mapping and PW mapping methods should clash
preference will be given to the current PW mapping method.
To use Data Mapping the following will need to be set-up, the [Link] record will need to
reference to a [Link] record which will communicate between the current Process
Workflow functionality and the mapping options available in [Link].
Like using [Link] the mapping instructions are attached to the target [Link].
The field [Link] in the application [Link] record will direct the workflow to use the
mapping instructions and options available in [Link].
[Link].
The [Link] record provides a description field for the record and also details the
target application in the field [Link].
There are two sets of multi values, the first set is used when mapping record ID’s the second when
mapping field data.
[Link]/[Link] is used to identify what type of source the data is coming from, a
Routine another PW activity or other source. ID Mapping into the first activity record in a workflow can
not be done but you can carry out mapping into fields of the first activity.
[Link]/[Link] further defines the details of the data source, usually the name of the
routine or the PW activity.
[Link] is name of the [Link] record and will give instructions of the type
of mapping that is to take place.
[Link] This defines logging options on the event of an error in the mapping workflow, the LOG
option will allow the workflow to continue but raise an entry in [Link], the BLOCK
option will raise the same entry and halt the workflow with an error message. The NULL option will do
none of the above.
[Link].
The [Link] record provides details of what the mapping is to, do the fields
[Link], [Link] and DESCRIPTION are all reporting fields and can contain any
information
The EXTRACTION field defines what information is mapped, the first command is what is done to the
information, the second part is which application it is coming from and the third is the field.
The PLACEMENT field defines where the information is going to, the first command is what is done to
the information, the second part is which application it is going to and the third is the field.
For further information on the field option in [Link] please see the applications help
text.
The below example shows a field to field mapping instruction, the EXTRACTION field extracts the data
from the application CUSTOMER field [Link]. The PLACEMENT field replaces any data
in the application ACCOUNT field [Link] with the data from the PLACEMENT field.
[Link].
In addition to the [Link] commands new ones have been added for Data Mapping
For example.
This [Link] record will take the application nominated by [Link]
and map its Company ID to the field nominated in the PLACEMENT.
[Link].
ID mapping,
With Data Mapping PW can map from record ID’s and into Record Id’s
The following example will map the data from the CUSTOMER field in ACCOUNT application and
populate the @ID in the second activity which is a CUSTOMER application.
Firstly note that the ID multi value set is being used not the Field multi value set.
The [Link] record identifies the application it is mapping to in [Link], the
[Link] is a [Link], the source of the data is detailed in [Link] and the
mapping rules as laid down in the [Link] record [Link] as per the
[Link] field.
[Link].
The mapping instructions in [Link] has the EXTRACTION field copy the data in the
field CUSTOMER from the ACCOUNT application.
The PLACEMENT field uses the A command to append data to the first field in the target application
which will be the record ID.
[Link].
The [Link] shows that the target application is ACCOUNT, and the data source
is a [Link] called [Link] and the [Link] record used for mapping
is [Link].
[Link].
The mapping instructions in [Link] has the EXTRACTION field pick up and store the
&&[Link]&& which is the command for the target application’s ID field.
The PLACEMENT field copies the mapping data in to the target field CUSTOMER in the ACCOUNT
application.
[Link].
ID to ID mapping
Below is a [Link] that will copy a @ID to another @ID field.
Both EXTRACTION and PLACEMENT field commands have been used in the past two examples.
[Link].
To map local references just use their field name in place of the normal field name, below the local
reference field TEST in the application ACCOUNT is being mapped to the local reference field
SYMBOL in CUSTOMER application.
[Link].
Concatenation of fields
The next example will show how to select two source fields to map and concatenate the selected data
in to one target field.
An [Link] record is created as normal, note that the Field multi-value set is being
used.
[Link].
The multi-value set in [Link] is expanded and the first EXTRACTION and PLACEMENT
fields are populated as if carrying out a normal field to field mapping instruction.
In the second multi-value set the second field is selected in the EXTRACTION field and the placement
field uses the NA command when appending the second value to the first value.
[Link].
Mathematical operators
(Addition, subtraction, multiplication, division)
Data mapping can carry out basic mathematical calculation in its mapping functions by a simple
command in the PLACEMENT field in the [Link] application.
Below the example record shows that the multi-value set has been expanded and the first value is
mapped from the FRISTVALUE field in the CUSTOMER application and the placed in the local
reference field ADDITIONRESULT in the ACCOUNT application.
Then a second value is mapped from the local reference field [Link] in the ACCOUNT
application and placed in the local reference field ADDITIONRESULT in the ACCOUNT application.
Note the placement field in the second multi-value has the command NP this will instruct Data
mapping to add the two values together.
[Link].
The [Link] record setup differs from other napping operations, here we have
nominated ROUTINE as [Link] and the [Link] is populated with the name of the
routine prefixed by the @ symbol.
[Link].
[Link].
Literals
Data that is to be mapped can also be defined in the [Link] application; it can also be
mapped to the first [Link] record in the [Link].
In the below example the [Link] record has a literal defined in the EXTRACTION field,
it will copy the data after the comma i.e. 1000.
The PLACEMENT field will place this literal data in to the SECTOR field in CUSTOMER.
[Link].
To use this mapping in the first [Link] the associated [Link] will need
to be attached to the first [Link] record in the [Link].
Reports
Duration Analytics
To enhance reporting, additional duration data has been added to the [Link] table.
The time the [Link] was created, each time the [Link] under goes a status
change and finally completes will be recorded so that the time each activity took, how long it spent in
different statuses can easily be calculate.
The below record displays a [Link] and [Link] for the [Link], these are set
in [Link].
The three sets of Times and Dates are displayed:
The first set gives the start time it of the [Link] record.
The second set gives the time and date the [Link] record was created.
The Third and final set gives the time and date the [Link] goes to a completed status.
[Link].