alerts

Table structure

Column Name	Data Type	Not null	Default	Key	Description
queueid	Integer	YES		FK	Assigned queue identifier
alertid	Character varying(37)	YES		PK	Alert identifier
type	Integer	NO			1 – new message 2 – check for messages
emailaddress	Character varying(4000)	NO			Configured receipt email addresses (; separeted)
frequency	Integer	NO			Checking frequency [minutes]
state	Integer	NO			1-Active 2-Inactive
description	Character varying(500)	NO			Alert desciption
alertname	Character varying(35)	YES		PK	Alert name
weekdays	Character varying(2)	NO			MF – Monday to Friday MS – Monday to Saturday
starttime	Character varying(5)	NO			Alert active hour interval - lower interval limit [h24:mi format]
endtime	Character varying(5)	NO			Alert active hour interval - upper interval limit [h24:mi format]

Constraints

Name	Column name
PK_ALERTS_AID	alertid;
UK_ALERTS_ANAME	alertname;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores all the defined queue alerts. These alerts can be defined on investigation queues and will warn the user about any incoming messages.

---

biccodes

Table structure

Column Name	Data Type	Not null	Default	Key	Description
bic	Character varying(35)	YES		PK	BIC code
description	Character varying(300)	NO			Bank name / description

Constraints

Name	Column name
PK_BICCODES_BIC	bic;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores all the BIC codes either manually defined or synchronized with the available data in application. The BICs reffer to the banks involved in the message transfer process.

---

currencies

Table structure

Column Name	Data Type	Not null	Default	Key	Description
currency	Character varying(3)	YES		PK	Currency code
exchrate	Numeric	YES			Currency exchange rate
description	Character varying(50)	NO			Description

Constraints

Name	Column name
PK_CURR_CODE	currency;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the defined currencies along with the exchange rates for local currency. These information can be used for reports when filtering or converting amounts.

---

feedbackcodes

Table structure

Column Name	Data Type	Not null	Default	Key	Description
guid	Integer	YES		PK	Record identifier
code	Character varying(5)	YES		PK	Feedback code
description	Character varying(200)	YES			Feedback code description
category	Character varying(10)	YES			Code category
source	Character varying(10)	YES			Entity generating the response code
useraction	Character varying(200)	NO			Needed user action, if any

Constraints

Name	Column name
PK_ERRCODES_GUID	guid;
UK_ERRCODES_CODE	code;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores all the feedback codes imported/defined in the application regarding processing the transactions. These feedbacks may be received from any entity involved in this process.

---

msgtypes

Table structure

Column Name	Data Type	Not null	Default	Key	Description
mtid	Integer	YES		PK	Message type identifier
messagetype	Character varying(50)	NO			Message type
friendlyname	Character varying(50)	NO			Displayed in UI
displayorder	Integer	NO			Display order in UI
storage	Character varying(35)	NO			Storage table name
businessarea	Character varying(100)	NO			Corresponding business area

Constraints

Name	Column name
PK_MTL_MTID	mtid;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores all message types and their characteristics available in the application.
>> Used by: UI, DB<br>

---

ntbdays

Table structure

Column Name	Data Type	Not null	Default	Key	Description
freedate	Date	YES		PK	Non business day

Constraints

Name	Column name
PKNTBDAYS_FDATE	freedate;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the user-defined days to be non business.

---

params

Table structure

Column Name	Data Type	Not null	Default	Key	Description
name	Character varying(35)	YES		PK	Parameter name
value	Character varying(300)	NO			Set value for parameter
description	Character varying(50)	NO			Description
category	Character varying(35)	NO			Parameters group

Constraints

Name	Column name
PK_PARAMS_NAME	name;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the application parameters available and the values set.

---

qmoveprivmaps

Table structure

Column Name	Data Type	Not null	Default	Key	Description
mapid	Integer	YES		PK	Record identifier
sourcequeueid	Integer	NO		FK	Source queue identifier
destqueueid	Integer	NO		FK	Destination queue identifier

Constraints

Name	Column name
PK_QPM_MAPID	mapid;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the mapping of queues in relation with the source queue, that is, the available destination queues. Messages held by the source queue can only be moved in certain queues according to business criteria.

---

qtypeactionmaps

Table structure

Column Name	Data Type	Not null	Default	Key	Description
mapid	Integer	YES		PK	Record identifier
qtypeid	Integer	NO		FK	Queue action identifier
qactionid	Integer	NO		FK	Queue type identifier

Constraints

Name	Column name
PK_QAM_MAPID	mapid;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the mapping of queue types in relation with the available actions. Actions can be configured as to meet the corresponding business criteria.

---

Entity1

Table structure

Column Name	Data Type	Not null	Default	Key	Description
actionid	Integer	YES		PK	Action identifier
action	Integer	YES		PK	Action name
description	Integer	NO			Description
singlemsg	Integer	NO			Single message level action
groupmsg	Integer	NO			Group message level action
optionvalues	Character varying(50)	NO			Storage of available values in the drop down lists

Constraints

Name	Column name
PK_QA_ACTID	actionid;
UK_QA_ACTION	action;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores all the defined possible actions that user can perform on the queues in the application.

---

queues

Table structure

Column Name	Data Type	Not null	Default	Key	Description
guid	Integer	YES		PK	Queue identifier
name	Character varying(50)	YES		PK	Queue name
holdstatus	Integer	YES			0 - inactive; 1- active
connector	Integer	NO	nextval('servicemap_serviceid_seq'::regclass)	FK	Service identifier as ExitPoint
typeid	Integer	NO		FK	Queue type identifier
batchno	Integer	NO			Max number of messages in batch
description	Character varying(100)	NO			Queue description
priority	Integer	NO			Message processing priority

Constraints

Name	Column name
PK_QUEUES_GUID	guid;
UK_QUEUES_NAME	name;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores information about every queue defined in the application.
>> Used by: UI, RE, DB<br>

---

queuetypes

Table structure

Column Name	Data Type	Not null	Default	Key	Description
typeid	Integer	YES		PK	Queue type identifier
typename	Character varying(50)	YES		PK	Queue type name
lev1kword1	Character varying(50)	NO			Level 1 - keyword 1
lev1kword2	Character varying(50)	NO			Level 1 - keyword 2
lev1kword3	Character varying(50)	NO			Level 1 - keyword 3
lev1kword4	Character varying(50)	NO			Level 1 - keyword 4
lev1kword5	Character varying(50)	NO			Level 1 - keyword 5
lev2kword1	Character varying(50)	NO			Level 2 - keyword 1
lev2kword2	Character varying(50)	NO			Level 2 - keyword 2
lev2kword3	Character varying(50)	NO			Level 2 - keyword 3
lev2kword4	Character varying(50)	NO			Level 2 - keyword 4
lev2kword5	Character varying(50)	NO			Level 2 - keyword 5

Constraints

Name	Column name
PK_QUEUETL_GUID	typeid;
UK_QT_TYPENAME	typename;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores a summary of all the available queue types that are to be used in the application. The messages in each queue type can be grouped according to certain criteria. There are available two hierarchical grouping levels and each contains a maximum of five custom keywords.
>> Used by: UI<br>

---

routingkeywordmaps

Table structure

Column Name	Data Type	Not null	Default	Key	Description
keywordid	Integer	NO		FK	Routing keyword identifier
tag	Character varying(200)	YES			Message keyword xpath
mt	Character varying(35)	YES			Message type
selector	Character varying(11)	YES			selector/selectoriso
mapid	Integer	YES		PK	Record identifier

Constraints

Name	Column name
PK_RKM_MAPID	mapid;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>>Defines the mapping between routing keywords and their path in message payload.
>>Used by: RE<br>

---

routingkeywords

Table structure

Column Name	Data Type	Not null	Default	Key	Description
guid	Integer	YES		PK	Keyword identifier
keyword	Character varying(50)	YES		PK	Keyword name
comparer	Character varying(200)	YES			Data type
selector	Character varying(200)	NO			Regular expression
description	Character varying(200)	NO			Keyword description
selectoriso	Character varying(200)	NO			Regular expression (ISO version)

Constraints

Name	Column name
PK_RK_GUID	guid;
UK_RK_KEYWORD	keyword;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>>Describes the regular expression for every keyword available, applied when extracting keyword values.
>>Used by: RE<br>

---

routingrules

Table structure

Column Name	Data Type	Not null	Default	Key	Description
guid	Integer	YES		PK	Rule identifier
queueid	Integer	YES		FK	Assigned queue identifier
schemaguid	Integer	YES		FK	Belonging routing schema identifier
sequence	Integer	NO			Rule executing order
ruletype	Integer	NO			0 - normal; 1 - ran only after schema activation; 2 - ran only after schema deactivation
description	Character varying(70)	NO			Rule description
msgcond	Character varying(500)	NO			Message type condition
funccond	Character varying(500)	NO			Function result condition
metacond	Character varying(500)	NO			Metadata condition
action	Character varying(500)	YES			Rule action

Constraints

Name	Column name
PK_RR_GUID	guid;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores definitions for all the routing rules in the application.
>> Used by: UI, RE<br>

---

routingschemas

Table structure

Column Name	Data Type	Not null	Default	Key	Description
name	Character varying(10)	YES		PK	Routing schema name
description	Character varying(250)	NO			Routing schema description
active	Integer	YES			1-active; 0-inactive
guid	Integer	YES		PK	Routing schema identifier
startlimit	Integer	YES		FK	Active schema interval - upper limit
stoplimit	Integer	YES		FK	Active schema interval - lower limit
sessioncode	Character varying(10)	NO			Payment seesion code
isvisible	Character varying(1)	NO			1- visible; 0 - not visible

Constraints

Name	Column name
PK_RS_SCHEMAGUID	guid;
UK_RS_NAME	name;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores information about all routing schemas. A routing schema is a collection of routing rules.

---

servicemaps

Table structure

Column Name	Data Type	Not null	Default	Key	Description
friendlyname	Character varying(50)	YES		PK	Service displaying name
serviceid	Integer	YES	nextval('servicemap_serviceid_seq'::regclass)	PK	Service identifier
status	Integer	YES			0 - not found; 1 - stopped; 3 - running
lastsessionid	Integer	NO			[not used]
heartbeatinterval	Integer	YES			[not used]
lastheartbeat	Timestamp(6)	NO			[not used]
version	Character varying(200)	NO			[not used]
partner	Character varying(200)	NO			Application name
servicetype	Integer	NO			[not used]
ioidentifier	Integer	NO			0 – output connector 1 – input connector
exitpoint	Character varying(300)	NO			Exit point definition
sessionid	Character varying(26)	NO
duplicatecheck	Integer	NO			0 – duplicate detection inactive 1 - duplicate detection active for RE&CONN, 2 - duplicate detection active for CONN
duplicateq	Character varying(50)	NO			Name of the queue where duplicates will be sent for investigation
duplicatemap	Character varying(50)	NO			Name of the duplicate map for this service ( xslt)
duplicatenotifq	Character varying(50)	NO			Name of the queue storing duplicate notifications
delayednotifq	Character varying(50)	NO			Name of the queue storing delayed notifications

Constraints

Name	Column name
PK_SM_SERVID	serviceid;
UK_SM_NAME	friendlyname;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores application service definitions.
>> Used by: RE, Conn, UI, DB<br>

---

timelimits

Table structure

Column Name	Data Type	Not null	Default	Key	Description
guid	Integer	YES		PK	Time limit identifier
limitname	Character varying(100)	YES		PK	Time limit assigned name
limittime	Timestamp	NO			Time limit time

Constraints

Name	Column name
PK_TL_GUID	guid;
UK_TL_NAME	limitname;

Indexes

Name	Column name

Triggers

Name	Timing point	Event

Notes

>> It stores the defined time limits used for automated activation of routing schemas.
>> Used by: UI, RE<br>

---