Database – Loan Interest Rate Change (loan_interest_rate_change_entity)
Updated 3 days ago
Description
This table holds information for interest rate changes on loans.
Table Fields
|
Field |
Data Type |
Column Info |
Value Notes |
|
id |
int(11) |
This is the ID of the interest rate change. |
|
|
loan_id |
int(11) |
This is the ID of the loan in which the interest rate was changed. |
|
|
mod_id |
int(11) |
This is the ID of the loan modification. |
|
|
import_id |
varchar(15) |
This is the ID of the import, if applicable. |
|
|
apply_date |
date |
This is the day in which the interest rate change was applied to the loan. |
Defaults to: 0000-00-00 |
|
type |
char(50) |
This is the name of the type of the interest rate change. |
|
|
rate |
decimal(11,4) |
This is the new interest rate on the loan. |
Defaults to: 0.00 |
|
description |
varchar(255) |
This is a text field that describes the interest rate change. |
|
|
lastUpdated |
timestamp |
This is the timestamp in which the interest rate change was last updated. |
Defaults to: CURRENT_TIMESTAMP |
|
deleted |
tinyint(1) |
This determines whether the interest rate change has been deleted. |
Defaults to: 0 |