Telah Dianugerahkan

SQL Procedure for Triggers using Primary Keys


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 lagi: primary key using triggers sql, check primary key sql triggers, sql procedure, what is a pending transaction, 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, data data sql, amendment, sql management, time table management system scope, current system time table management, primary key, 001

Tentang Majikan:
( 0 ulasan ) Ikeja, Nigeria

ID Projek: #1554510

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.

$200 USD dalam 30 hari
(0 Ulasan)

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

$210 USD dalam 15 hari
(0 Ulasan)

please check private message

$30 USD dalam 3 hari
(0 Ulasan)

Please Check private Message Box. Thanks.

$250 USD dalam 3 hari
(0 Ulasan)

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

$250 USD dalam 6 hari
(0 Ulasan)

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)

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)