Database – Escrow Subset Entity (escrow_subset_entity)
Description
Holds Escrow Subset options and information. This includes subset names as well as default calculation options for the subset.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(255) | The name/title of the entity instance | ||
entity_type | varchar(100) | Type of the associated entity | ||
payoff_option | char(50) | Payoff option | loan.escrowpayoff.* | |
payment_application | char(30) | Payment application | loan.escrowpmtapp.* | |
lease_sales_tax | tinyint(1) | Whether or not is this lease sales tax | 1 - yes, 0 - no | |
apr_include | tinyint(1) | Whether or not to include in APR | 1 - yes, 0 - no | |
schedule_include | tinyint(1) | Whether or not to include in Amort Schedule | 1 - yes, 0 - no | |
disclosure_lnamt_add | tinyint(1) | Whether or not this entity will affect the disclosed loan amount | 1 - yes, 0 - no | |
availability | char(40) | Escrow availability collection | loan.escrowAvailability.* | |
interest_bearing | tinyint(1) | Whether or not is interest bearing | 1 - yes, 0 - no | |
escrow_analysis_enabled | tinyint(1) | Whether or not is enabled for escrow analysis | 1 - yes, 0 - no | |
cushion | tinyint(1) | Whether or not cushion is enabled | 1 - yes, 0 - no | |
cushion_fixed_amount | decimal(11,2) | Cushion fixed amount | ||
cushion_percentage | decimal(5,3) | Cushion fixed percentage | ||
escrow_computation_year_start_date | date | Escrow computaiton year start date | ||
next_escrow_analysis_date | date | next escrow analysis date | ||
deficiency_delimiting_dpd | tinyint(2) | Deficiency - Delimiting Days Past Due | ||
deficiency_days_to_pay | tinyint(2) | Deficiency - Days to Pay | ||
deficiency_delimiting_amount | tinyint(1) | Deficiency - Delimiting amount | 1 - yes, 0 - no | |
deficiency_delimiting_dollar | decimal(11,2) | Deficiency - Delimiting Dollar | ||
deficiency_delimiting_percentage | decimal(5,3) | Deficiency - Delimiting Percentage | ||
deficiency_catchup_payment_number | tinyint(3) | Deficiency - Catchup Payment Number | ||
deficiency_action_a | tinyint(1) | Deficiency - Action 1 Enabled | 1 - yes, 0 - no | |
deficiency_action_b | tinyint(1) | Deficiency - Action 2 Enabled | 1 - yes, 0 - no | |
deficiency_action_c | tinyint(1) | Deficiency - Action 3 Enabled | 1 - yes, 0 - no | |
shortage_days_to_pay | tinyint(2) | Shortage - Days to Pay | ||
shortage_catchup_payment_number | tinyint(2) | Shortage - Catchup payment number | ||
shortage_delimiting_amount | tinyint(2) | Shortage - Delimiting amount | ||
shortage_delimiting_dollar | decimal(11,2) | Shortage - Delimiting dollar | ||
shortage_delimiting_percentage | decimal(5,3) | Shortage - Delimiting Percentage | ||
shortage_action_a | tinyint(1) | Shortage - Action 1 Enabled | 1 - yes, 0 - no | |
shortage_action_b | tinyint(1) | Shortage - Action 2 Enabled | 1 - yes, 0 - no | |
surplus_allowed_surplus | decimal(11,2) | Whether or not to surplus is allowed | ||
surplus_days_to_refund | tinyint(2) | Surplus - Days to Refund | ||
surplus_delimiting_dpd | tinyint(2) | Setting on escrow analysis for number of days past due to determine the action | ||
surplus_action_a | tinyint(1) | Surplus - Aciton 1 Enabled | 1 - yes, 0 - no | |
surplus_action_b | tinyint(1) | Surplus - Action 2 Enabled | 1 - yes, 0 - no | |
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |