Telah Dianugerahkan

SQL Procedure for Triggers using Primary Keys

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.

Kemahiran: SQL

Lihat lebih lanjut: sql procedure, sql business, sql based, sql 2012, primary, hms, event management business, scope event management system, sql different, end event management, primary business, change history, event method, event track management, record checks, amendment, sql management, primary key, 001, sql transaction, contract management sql, check sql, triggers sql, transaction sql, history transaction

Tentang Majikan:
( 0 ulasan ) Ikeja, Nigeria

ID Projek: #1554510

7 pekerja bebas membida secara purata $154 untuk pekerjaan ini

sakil1979

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.

$200 USD dalam 30 hari
(0 Ulasan)
0.0
suwishd

Quantity is the measurement of speed but accuracy can not be neglected.

$210 USD dalam 15 hari
(0 Ulasan)
0.0
srisskto

please check private message

$30 USD dalam 3 hari
(0 Ulasan)
0.0
worocker

Please Check private Message Box. Thanks.

$250 USD dalam 3 hari
(0 Ulasan)
0.0
alvicreatives

Hi, Alvicreatives has been long into web application development & designing and development business. The last 5 years, we are working on web based ASP.net / C#, Sqlserver 2005/2008, Ajax, CSS, Flash,PHP,MySql,Wor Lagi

$250 USD dalam 6 hari
(0 Ulasan)
0.0
kumar241915

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.

$40 USD dalam 5 hari
(0 Ulasan)
0.0
milindshah1986

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.

$100 USD dalam 6 hari
(0 Ulasan)
0.0