|
FinTP Database
|
|
|
FinTP Database
|
|
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| QUEUEID | Integer | YES | FK | Assigned queue identifier | |
| ALERTID | Varchar2(37) | NO | PK | Alert identifier | |
| TYPE | Integer | YES | Alert type | ||
| EMAILADDRESS | Varchar2(4000) | NO | Configured receipt email addresses (; separeted) | ||
| FREQUENCY | Integer | NO | Checking frequency [minutes] | ||
| STATE | Integer | NO | Alert activation state | ||
| DESCRIPTION | Varchar2(500) | NO | Alert desciption | ||
| ALERTNAME | Varchar2(35) | NO | PK | Alert name | |
| WEEKDAYS | Varchar2(2) | NO | Weekdays activation interval | ||
| STARTTIME | Varchar2(5) | NO | Alert active hour interval - lower interval limit [h24:mi format] | ||
| ENDTIME | Varchar2(5) | NO | Alert active hour interval - upper interval limit [h24:mi format] |
| Name | Column name |
|---|---|
| PK_ALERTS_AID | ALERTID; |
| UK_ALERTS_ANAME | ALERTNAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores all the defined queue alerts. These alerts can be defined on investigation queues and will warn the user about any incoming messages.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| BIC | Varchar2(35) | YES | PK | BIC code | |
| DESCRIPTION | Varchar2(300) | NO | Bank name / description |
| Name | Column name |
|---|---|
| PK_BICLIST_BIC | BIC; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> 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.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| CURRENCY | Varchar2(3) | YES | PK | Currency code | |
| EXCHRATE | Number(12,2) | NO | Currency exchange rate | ||
| DESCRIPTION | Varchar2(50) | NO | Description |
| Name | Column name |
|---|---|
| PK_CURR_CODE | CURRENCY; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> 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.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| GUID | Integer | YES | PK | Record identifier | |
| CODE | Varchar2(5) | YES | PK | Feedback code | |
| DESCRIPTION | Varchar2(200) | YES | Feedback code description | ||
| CATEGORY | Varchar2(10) | YES | Code category | ||
| SOURCE | Varchar2(10) | YES | PK | Entity generating the response code. | |
| USERACTION | Varchar2(200) | NO | Needed user action, if any. |
| Name | Column name |
|---|---|
| PK_ERRCODES_GUID | GUID; |
| UK_ERRCODES_CODE | CODE; SOURCE; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> 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.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| MTID | Integer | YES | PK | Message type identifier | |
| MESSAGETYPE | Varchar2(50) | NO | Message type | ||
| FRIENDLYNAME | Varchar2(50) | NO | Displayed in UI | ||
| DISPLAYORDER | Integer | NO | Display order in UI | ||
| STORAGE | Varchar2(35) | NO | Storage table name | ||
| BUSINESSAREA | Varchar2(100) | NO | Corresponding business area |
| Name | Column name |
|---|---|
| PK_MTL_MTID | MTID; |
| Name | Column name |
|---|---|
| MSGTYPELIST_PK | MTID; |
| Name | Timing point | Event |
|---|
>> It stores all message types and their characteristics available in the application.
>> Used by: UI, DB<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| FREEDATE | Date | YES | PK | Non business day |
| Name | Column name |
|---|---|
| NTBDAYS_PK | FREEDATE; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores the user-defined days to be non business.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| NAME | Varchar2(35) | YES | PK | Parameter name | |
| VALUE | Varchar2(300) | YES | Set value for parameter | ||
| DESCRIPTION | Varchar2(50) | NO | Description | ||
| CATEGORY | Varchar2(35) | YES | Parameters group |
| Name | Column name |
|---|---|
| PK_PARAMS_NAME | NAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores the application parameters available and the values set.
| 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 |
| Name | Column name |
|---|---|
| PK_QMP_MAPID | MAPID; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> 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.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| MAPID | Integer | YES | PK | Record identifier | |
| QTYPEID | Integer | NO | FK | Queue type identifier | |
| QACTIONID | Integer | YES | FK | Queue action identifier |
| Name | Column name |
|---|---|
| PK_QTA_MAPID | MAPID; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores the mapping of queue types in relation with the available actions. Actions can be configured as to meet the corresponding business criteria.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| ACTIONID | Integer | YES | PK | Action identifier | |
| ACTION | Varchar2(100) | YES | PK | Action name | |
| DESCRIPTION | Varchar2(300) | NO | Action description | ||
| SINGLEMSG | Integer | NO | Single message level action | ||
| GROUPMSG | Integer | NO | Group message level action | ||
| OPTIONVALUES | Varchar2(50) | NO | Storage of available values in the drop down lists |
| Name | Column name |
|---|---|
| PK_QAL_ACTID | ACTIONID; |
| UK_QA_ACTION | ACTION; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores all the defined possible actions that user can perform on the queues in the application.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| GUID | Integer | YES | PK | Queue identifier | |
| NAME | Varchar2(50) | YES | PK | Queue name | |
| HOLDSTATUS | Integer | YES | Holding message in queue activation | ||
| CONNECTOR | Number(10,0) | NO | FK | Service identifier as ExitPoint | |
| TYPEID | Integer | YES | FK | Queue type identifier | |
| BATCHNO | Integer | NO | Maximum number of messages in batch | ||
| DESCRIPTION | Varchar2(100) | NO | Queue description | ||
| PRIORITY | Integer | NO | Message processing priority |
| Name | Column name |
|---|---|
| PK_QUEUES_ID | GUID; |
| UK_QUEUES_NAME | NAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|---|---|
| TRGBIQUEUES | BEFORE | INSERT |
>> It stores information about every queue defined in the application.
>> Used by: UI, RE, DB<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| TYPEID | Integer | NO | PK | Queue type identifier | |
| TYPENAME | Varchar2(50) | YES | PK | Queue type name | |
| LEV1KWORD1 | Varchar2(35) | NO | Level 1 - Keyword 1 | ||
| LEV1KWORD2 | Varchar2(35) | NO | Level 1 - Keyword 2 | ||
| LEV1KWORD3 | Varchar2(35) | NO | Level 1 - Keyword 3 | ||
| LEV1KWORD4 | Varchar2(35) | NO | Level 1 - Keyword 4 | ||
| LEV1KWORD5 | Varchar2(35) | NO | Level 1 - Keyword 5 | ||
| LEV2KWORD1 | Varchar2(35) | NO | Level 2 - Keyword 1 | ||
| LEV2KWORD2 | Varchar2(35) | NO | Level 2 - Keyword 2 | ||
| LEV2KWORD3 | Varchar2(35) | NO | Level 2 - Keyword 3 | ||
| LEV2KWORD4 | Varchar2(35) | NO | Level 2 - Keyword 4 | ||
| LEV2KWORD5 | Varchar2(35) | NO | Level 2 - Keyword 5 |
| Name | Column name |
|---|---|
| PK_QTL_TYPEID | TYPEID; |
| UK_QT_TYPENAME | TYPENAME; |
| Name | Column name |
|---|---|
| QUEUETYPELIST_PK | TYPEID; |
| Name | Timing point | Event |
|---|
>> 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>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| KEYWORDID | Number(10,0) | YES | FK | Routing keyword identifier | |
| TAG | Varchar2(200) | YES | Message keyword xpath | ||
| MT | Varchar2(35) | YES | Message type | ||
| SELECTOR | Varchar2(11) | YES | Selector type | ||
| MAPID | Integer | YES | PK | Record identifier |
| Name | Column name |
|---|---|
| PK_RKM_MAPID | MAPID; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>>Defines the mapping between routing keywords and their path in message payload.
>>Used by: RE<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| GUID | Number(10,0) | YES | PK | Keyword identifier | |
| KEYWORD | Varchar2(50) | YES | PK | Keyword | |
| COMPARER | Varchar2(200) | YES | Data type | ||
| SELECTOR | Varchar2(200) | NO | Regular expression | ||
| DESCRIPTION | Number(10,0) | NO | Keyword description | ||
| SELECTORISO | Varchar2(200) | NO | Regular expression (ISO version) |
| Name | Column name |
|---|---|
| PK_RK_ID | GUID; |
| UK_RK_KEYWORD | KEYWORD; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>>Describes the regular expression for every keyword available, applied when extracting keyword values.
>>Used by: RE<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| GUID | Integer | YES | PK | Rule identifier | |
| QUEUEID | Integer | YES | FK | Assigned queue identifier | |
| SCHEMAGUID | Number(10,0) | YES | FK | Belonging routing schema identifier | |
| SEQUENCE | Integer | NO | Rule executing order | ||
| RULETYPE | Integer | NO | Rule type | ||
| DESCRIPTION | Varchar2(70) | NO | Rule description | ||
| MSGCOND | Varchar2(500) | NO | Message type condition | ||
| FUNCCOND | Varchar2(500) | NO | Function result condition | ||
| METACOND | Varchar2(500) | NO | Metadata condition | ||
| ACTION | Varchar2(500) | YES | Rule action |
| Name | Column name |
|---|---|
| PK_RR_GUID | GUID; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores definitions for all the routing rules in the application.
>> Used by: UI, RE<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| NAME | Varchar2(10) | YES | PK | Routing schema name | |
| DESCRIPTION | Varchar2(250) | NO | Routing schema description | ||
| ACTIVE | Number(5,0) | YES | Routing schema activation | ||
| GUID | Number(10,0) | YES | PK | Routing schema identifier | |
| STARTLIMIT | Number(10,0) | YES | FK | Active schema interval - upper limit | |
| STOPLIMIT | Number(10,0) | YES | FK | Active schema interval - lower limit | |
| SESSIONCODE | Varchar2(10) | NO | Payment seesion code | ||
| ISVISIBLE | Varchar2(1) | NO | Routing schema visibility |
| Name | Column name |
|---|---|
| PK_RS_GUID | GUID; |
| UK_RS_NAME | NAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores information about all routing schemas. A routing schema is a collection of routing rules.
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| FRIENDLYNAME | Varchar2(50) | YES | PK | Service display name | |
| SERVICEID | Number(10,0) | YES | PK | Service identifier | |
| STATUS | Number(10,0) | YES | Service state | ||
| LASTSESSIONID | Number(10,0) | NO | [not used] | ||
| HEARTBEATINTERVAL | Number(10,0) | YES | [not used] | ||
| LASTHEARTBEAT | Timestamp(6) | NO | [not used] | ||
| VERSION | Varchar2(255) | NO | [not used] | ||
| PARTNER | Varchar2(255) | NO | Application name | ||
| SERVICETYPE | Number(10,0) | NO | [not used] | ||
| IOIDENTIFIER | Number(5,0) | NO | i/o service type | ||
| EXITPOINT | Varchar2(300) | NO | Exit point definition | ||
| SESSIONID | Varchar2(26) | NO | |||
| DUPLICATECHECK | Number | NO | Duplicate detection activation | ||
| DUPLICATEQ | Varchar2(50) | NO | Name of the queue where duplicates will be sent for investigation | ||
| DUPLICATEMAP | Varchar2(50) | NO | Name of the duplicate map for this service ( xslt) | ||
| DUPLICATENOTIFQ | Varchar2(50) | NO | Name of the queue storing duplicate notifications | ||
| DELAYEDNOTIFQ | Varchar2(50) | NO | Name of the queue storing delayed notifications |
| Name | Column name |
|---|---|
| PK_SM_SERVID | SERVICEID; |
| UK_SM_NAME | FRIENDLYNAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores application service definitions.
>> Used by: RE, Conn, UI, DB<br>
| Column Name | Data Type | Not null | Default | Key | Description |
|---|---|---|---|---|---|
| GUID | Number(10,0) | YES | PK | Time limit identifier | |
| LIMITNAME | Varchar2(100) | YES | PK | Time limit assigned name | |
| LIMITTIME | Timestamp(6) | NO | Time limit timestamp |
| Name | Column name |
|---|---|
| PK_TL_GUID | GUID; |
| UK_TL_NAME | LIMITNAME; |
| Name | Column name |
|---|
| Name | Timing point | Event |
|---|
>> It stores the defined time limits used for automated activation of routing schemas.
>> Used by: UI, RE<br>