FinTP Database
 All Files Pages
Tables

batchjobs


Table structure

Column Name Data Type Not null Default Key Description
batchid Character varying(16) YES
userid Character varying(5) YES
batchcount Integer YES
batchamount Character varying(20) YES
combatchid Character varying(35) YES PK
defjobcount Integer YES
batchstatus Integer YES
insertdate Timestamp YES
routingpoint Character varying(50) YES
reason Character varying(500) NO
combatchamt Numeric(20,2) NO
batchtype Character varying(50) NO
batchuid Character varying(32) NO


Constraints

Name Column name
bj_combatchid_pk combatchid;


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Stores outgoing message batch details. Messages grouped into batches and authorized by users.
>>Used by: UI, RE, DB



batchjobsinc


Table structure

Column Name Data Type Not null Default Key Description
sender Character varying(12) NO
combatchid Character varying(35) NO
batchtype Character varying(50) NO
insertdate Timestamp NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Stores incoming batch details. Messages grouped into batches received by the application.
>>Used by: UI, RE, DB



entryqueue


Table structure

Column Name Data Type Not null Default Key Description
guid Character varying(30) YES PK
payload Text YES
batchid Character varying(35) NO
correlationid Character varying(30) YES PK
requestorservice Character varying(30) YES
responderservice Character varying(30) NO
requesttype Character varying(30) YES
priority Integer NO 5
holdstatus Integer YES 0
sequence Integer YES 0
feedback Character varying(40) NO
sessionid Character varying(30) NO
status Integer NO 1
queuename Character varying(35) NO


Constraints

Name Column name
PK_EQ_GUID guid;
UK_EQ_CORRELID correlationid;


Indexes

Name Column name


Triggers

Name Timing point Event
trgaientryqueue AFTER INSERT


Notes

>>Generic queue table storing messages to be routed and inserted by Connectors. The name of the queue currently holding one message is stored into ROUTEDMESSAGES table. Messages are virtualy routed through queues by changing that value.
>>Used by: RE, Conn, UI, DB



feedbackagg


Table structure

Column Name Data Type Not null Default Key Description
requestor Character varying(50) NO
wmqid Character varying(32) NO
correlid Character varying(30) NO FK
interfacecode Character varying(10) NO
networkcode Character varying(10) NO
correspcode Character varying(10) NO
appcode Character varying(10) NO
payload Text NO
swiftmir Character varying(30) NO
insertdate Timestamp NO now()
batchid Character varying(35) NO
batchseq Character varying(10) NO
trn Character varying(35) NO
osession Character varying(10) NO
isession Character varying(10) NO
issuer Character varying(12) NO
obatchid Character varying(35) NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>> Stores feedbacks and additional details for every incoming or outgoing transaction / message.
>> Used by: UI, RE, DB<br>


history


Table structure

Column Name Data Type Not null Default Key Description
guid Character varying(30) YES PK
payload Text YES
batchid Character varying(35) NO
correlationid Character varying(30) YES
sessionid Character varying(30) NO
requestorservice Character varying(30) YES
responderservice Character varying(30) NO
requesttype Character varying(30) YES
priority Numeric(10,0) YES 5
holdstatus Numeric(5,0) YES 1
sequence Numeric(10,0) NO 0
insertdate Timestamp NO
feedback Character varying(40) NO


Constraints

Name Column name
hist_guid_pk guid;


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Internally used queue table; stores a copy of all routed messages.
>>Used by: RE, Conn, UI, DB



mt103tab


Table structure

Column Name Data Type Not null Default Key Description
correlid Character varying(30) NO FK
msgtype Character varying(50) NO
dbaccount Character varying(50) NO
cdaccount Character varying(50) NO
amount Character varying(50) NO
currency Character varying(3) NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Sample table; dynamically created according to keywords defined for each message type and storing specific details.



mt202tab


Table structure

Column Name Data Type Not null Default Key Description
correlid Character varying(30) NO FK
msgtype Character varying(50) NO
amount Character varying(50) NO
stlmdate Character varying(6) NO
currency Character varying(3) NO
ttc Numeric(3,0) NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Sample table; dynamically created according to keywords defined for each message type and storing specific details.



routedmessages


Table structure

Column Name Data Type Not null Default Key Description
guid Character varying(30) YES PK
correlationid Character varying(30) NO PK; FK
insertdate Timestamp NO now()
ack Integer NO 0
msgtype Character varying(50) NO
currentqueue Integer NO
sender Character varying(35) NO
receiver Character varying(35) NO
trn Character varying(35) NO
senderapp Character varying(35) NO
receiverapp Character varying(35) NO
userid Integer NO


Constraints

Name Column name
PK_RM_GUID guid;
UK_RM_CORRELID correlationid;


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Stores routed messages basic information.
>>USed by: RE, UI, DB



routingjobs


Table structure

Column Name Data Type Not null Default Key Description
guid Character varying(30) YES PK
status Integer YES 0
backout Integer YES 0
priority Integer YES 10
routingpoint Character varying(50) NO
function Character varying(200) YES
userid Character varying(5) NO


Constraints

Name Column name
rj_guid_pk guid;


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Stores the jobs assigned to RE at a given moment. After job completion, the assigned record is deleted; in case of failure, record is updated with an error state.
>>Used by: UI, RE, DB



serviceperformance


Table structure

Column Name Data Type Not null Default Key Description
serviceid Integer YES
insertdate Timestamp YES
mintransactiontime Integer YES
maxtransactiontime Integer YES
meantransactiontime Integer YES
sequenceno Numeric(10,0) YES
ioidentifier Integer YES
sessionid Integer YES
commitedtrns Integer NO
abortedtrns Integer NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes

>>Stores the defined service parameters status.
>>Used by: RE, DB



status


Table structure

Column Name Data Type Not null Default Key Description
guid Character varying(30) YES PK
service Integer YES
correlationid Character varying(30) YES
type Character varying(20) YES
machine Character varying(30) YES
eventdate Timestamp YES
insertdate Timestamp YES
message Character varying(256) YES
class Character varying(20) NO
innerexception Character varying(4000) NO
additionalinfo Character varying(4000) NO
sessionid Character varying(30) NO


Constraints

Name Column name
UK_test guid;


Indexes

Name Column name
idx_status correlationid;


Triggers

Name Timing point Event


Notes

>>Stores application events - errors, warnings and infos.
>>Used by: RE, UI, DB



tempbatchjobs


Table structure

Column Name Data Type Not null Default Key Description
jobid Character varying(30) YES
sequence Numeric YES
combatchid Character varying(35) YES
xformitem Character varying(4000) YES
correlationid Character varying(30) NO
feedback Character varying(40) NO


Constraints

Name Column name


Indexes

Name Column name


Triggers

Name Timing point Event


Notes