Find Jobs
Hire Freelancers

Business Event Detection(repost)

$100-180 USD

Cancelled
Posted about 12 years ago

$100-180 USD

Paid on delivery
**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. The procedure should be able to detect when there are such contract changes and return the respective business event types on the loan_business_event table. The PREPAYMENT event will be triggered by the source_event_type "PREPAYMENT" from the loan_source_event table (this is because there is no way to know if this happens unless there is a trigger that informs you). The prepayment amount and date should also be indicated in the source_event. After the contract changes, the "END OF DAY" events will continue each time a COB is run until the maturity of the deal. *Note that a PREPAYMENT will mean that the customer will finish repaying earlier than was agreed in the initial contract terms.
Project ID: 2716992

About the project

2 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $91 USD for this job
User Avatar
See private message.
$80.75 USD in 3 days
5.0 (1 review)
2.1
2.1
User Avatar
See private message.
$100.30 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Ikeja, Nigeria
0.0
0
Member since Apr 9, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.