Database – Loan Interest Rate Change (loan_interest_rate_change_entity)

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


How did we do?


Powered by HelpDocs (opens in a new tab)