Table: Escrow calculator

Table: Escrow calculator

Holds information about how to calculate escrow for loans.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
entity_idint(11)ID of the associated entity
entity_typevarchar(100)Type of the associated entity
mod_idint(11)The id of the associated loan modification
subsetint(11)escrow subset id
termint(11)Calculator term
totaldecimal(11,2)Calculator total
percentdecimal(11,2)Calculator percent
first_perioddecimal(11,2)Calculator first period
regular_perioddecimal(11,2)Calculator regular period
percent_basechar(40)Calculator percent baseloan.escrowPercentBase.*
prorate_firstchar(40)Calculator Prorate first calcloan.escrowProrateFirst.*
extend_finaltinyint(1)Whether or not to extend final1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List