BUSINESS EVENT DETECTION
Business event detection occurs when there is a new contract or amendment of an existing one. Since the primary key of the loan transaction table (“loan”) is the deal_id, for any time data is loaded, checks will be done based on the primary key on each of the fields in that table. Where the primary key never existed, the record is a new contract. Where the primary key already exists, check should be made to see if the current version of data loaded has any differing fields. If so, it is a contract change.
History Management System (HMS): This is the method by which track can be kept of different versions of the same data.
As seen above, assuming there is a loan with deal_id “001” which is the PK, interest rate of 21% and principal of 20,000, although the loan was valid from January 18 2012, HMS requires that it has an infinitesimal end date. However, if the interest rate was reviewed upwards to 25% on January 19, then this is what happens:
The previous version becomes a history record and the current version becomes the valid one.
*Please note that start and end validity dates are different from deal date and maturity dates.
The HMS should be applied to ALL tables within the scope.
7 pekerja bebas membida secara purata $154 untuk pekerjaan ini
Good Morning, I have expertise in SQL, PL/SQL, Triggers, Cursors, Nested Queries, Database Design and have been working in an MNC as Database Developer for the last 3 years.
Hi, I have worked on so many similar projects will try to help asap. Please call me @7322083947 in pst timings, if you are interested to get it done from my end.
Hi, I am an Microsoft® Certified Technology Specialist MCTS. Microsoft Certification ID: 8547963 I can finish this work in very minimum time. Please consider my bid.