Database – Defaults Escrow Calculator (defaults_escrow_calculator)
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 |