Database – Defaults Escrow Calculator (defaults_escrow_calculator)
Description
This holds tenant-wide default options for new escrow calculators.
|
Column |
Data Type |
Column Info |
Value Notes |
Other |
|
id |
int(11) |
The id of the entity |
||
|
parent_type |
char(30) |
Type of parent |
Entity.DefaultsSystemLoan |
|
|
loan_default_id |
int(11) |
Loan default ID info |
||
|
subset |
int(11) |
Holds late fee bucket subset info |
||
|
term |
int(11) |
Calculator term |
||
|
total |
decimal(11,2) |
Calculator total |
||
|
percent |
decimal(11,2) |
Percentage used to calculate total |
||
|
first_period |
decimal(11,2) |
Calculator first period |
||
|
regular_period |
decimal(11,2) |
Calculator regular period |
||
|
percent_base |
char(40) |
Calculator percent base |
loan.escrowPercentBase.* |
|
|
prorate_first |
char(40) |
Calculator Prorate first calc |
loan.escrowProrateFirst.* |
|
|
extend_final |
tinyint(1) |
Whether or not to extend final |
1 - yes, 0 - no |
|
|
deleted |
tinyint(1) |
Whether or not the entity was deleted |
1 - yes, 0 - no |
|
|
lastUpdated |
timestamp |
Timestamp of when the entity was last updated |