escrow_subset_entity - Escrow Subset Entity

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


How did we do?


Powered by HelpDocs (opens in a new tab)