Database – Escrow calculator (escrow_calculator_entity)
Description
Holds information about how to calculate escrow for loans.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
entity_id | int(11) | ID of the associated entity | ||
entity_type | varchar(100) | Type of the associated entity | ||
mod_id | int(11) | The id of the associated loan modification | ||
subset | int(11) | escrow subset id | ||
term | int(11) | Calculator term | ||
total | decimal(11,2) | Calculator total | ||
percent | decimal(11,2) | Calculator percent | ||
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 |