Table: Escrow Subset Options

Table: Escrow Subset Options

Options for calculation and triggers in regards to an escrow subset. This includes inclusion in APR calculations, payoff options, cushionning, deficiency actions, shortage actions, surplus actions, etc.

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
subsetint(11)Holds late fee bucket subset info
payoff_optionchar(50)Payoff optionloan.escrowpayoff.*
payment_applicationchar(30)Payment applicationloan.escrowpmtapp.*
apr_includetinyint(1)Whether or not to include in APR1 - yes, 0 - no
schedule_includetinyint(1)Whether or not to include in Amort Schedule1 - yes, 0 - no
disclosure_lnamt_addtinyint(1)Whether or not this entity will affect the disclosed loan amount1 - yes, 0 - no
interest_bearingtinyint(1)Whether or not is interest bearing1 - yes, 0 - no
escrow_analysis_enabledtinyint(1)Whether or not is enabled for escrow analysis1 - yes, 0 - no
cushiontinyint(1)Whether or not cushion is enabled1 - yes, 0 - no
cushion_fixed_amountdecimal(11,2)Cushion fixed amount
cushion_percentagedecimal(5,3)Cushion fixed percentage
escrow_computation_year_start_datedateEscrow computaiton year start date
next_escrow_analysis_datedatenext escrow analysis date
deficiency_delimiting_dpdtinyint(2)Deficiency - Delimiting Days Past Due
deficiency_days_to_paytinyint(2)Deficiency - Days to Pay
deficiency_delimiting_amounttinyint(1)Deficiency - Delimiting amount1 - yes, 0 - no
deficiency_delimiting_dollardecimal(11,2)Deficiency - Delimiting Dollar
deficiency_delimiting_percentagedecimal(5,3)Deficiency - Delimiting Percentage
deficiency_catchup_payment_numbertinyint(3)Deficiency - Catchup Payment Number
deficiency_action_atinyint(1)Deficiency - Action 1 Enabled1 - yes, 0 - no
deficiency_action_btinyint(1)Deficiency - Action 2 Enabled1 - yes, 0 - no
deficiency_action_ctinyint(1)Deficiency - Action 3 Enabled1 - yes, 0 - no
shortage_days_to_paytinyint(2)Shortage - Days to Pay
shortage_catchup_payment_numbertinyint(2)Shortage - Catchup payment number
shortage_delimiting_amounttinyint(2)Shortage - Delimiting amount
shortage_delimiting_dollardecimal(11,2)Shortage - Delimiting dollar
shortage_delimiting_percentagedecimal(5,3)Shortage - Delimiting Percentage
shortage_action_atinyint(1)Shortage - Action 1 Enabled1 - yes, 0 - no
shortage_action_btinyint(1)Shortage - Action 2 Enabled1 - yes, 0 - no
surplus_allowed_surplusdecimal(11,2)Whether or not to surplus is allowed
surplus_days_to_refundtinyint(2)Surplus - Days to Refund
surplus_delimiting_dpdtinyint(2)Setting on escrow analysis for number of days past due to determine the action
surplus_action_atinyint(1)Surplus - Aciton 1 Enabled1 - yes, 0 - no
surplus_action_btinyint(1)Surplus - Action 2 Enabled1 - 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