rule_applied_loans_setup_entity - Rules Applied, Loan Setup

Shows information regarding Loan Setup Rules Applied.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

Id of the entity

name

varchar(100)

Name of the rule applied

rule

text

Clojure rule

loan_amount

decimal(11,2)

Loan amount

discount

decimal(11,2)

Discount amount

underwriting

decimal(11,2)

Underwriting fee

loan_rate

decimal(11,4)

The interest rate

loan_rate_type

char(30)

The interest rate

loan.rateType.annually, loan.rateType.biweekly, loan.rateType.monthly, loan.rateType.semiannually, loan.rateType.semimonthly, loan.rateType.weekly

loan_term

decimal(11,4)

The amount of loan terms

money_factor

char(20)

Money factor is used to calculate the rental or lease fee

residual

decimal(11,2)

Residual amount that leased property will be worth at the end of the lease term

contract_date

int(11)

Contract date of the loan

first_payment_date

int(11)

First payment date

amount_down

decimal(11,2)

Down payment amount

reserve

decimal(11,2)

Reserve amount

sales_price

decimal(11,2)

Sales price

gap

decimal(11,2)

GAP insurance

warranty

decimal(11,2)

Warranty amount

dealer_profit

decimal(11,2)

Dealer profit amount

taxes

decimal(11,2)

Taxes

credit_limit

decimal(11,2)

Credit limit

reporting_credit_limit

decimal(11,2)

Credit limit amount being reported

loan_class

char(30)

Specific loan class

loan.class.carLoan, loan.class.mortgage, loan.class.consumer, loan.class.other

loan_type

char(30)

Specific loan type

loan.type.installment, loan.type.creditLimit, loan.type.flooring, loan.type.lease

discount_split

tinyint(1)

Specifies whether the discount portion will be shown as a separate line item for each payment

payment_frequency

char(30)

Payment frequency

loan.frequency.annually, loan.frequency.biWeekly, loan.frequency.custom, loan.frequency.monthly, loan.frequency.quarterly, loan.frequency.semiannually, loan.frequency.semiMonthly, loan.frequency.single, loan.frequency.weekly

calc_type

char(30)

Calculation type for loan

loan.calcType.interestOnly, loan.calcType.rule78, loan.calcType.simpleInterest, loan.calcType.simpleIntLocked

days_in_year

char(30)

Amount of days in year

loan.daysInYear.actual, loan.daysInYear.frequency

interest_application

char(50)

Setting for interest application

loan.interestApplication.betweenPeriods, loan.interestApplication.betweenTransactions

beg_end

char(20)

Determines if payments come due at the beginning of a payment period or the end of a period

loan.begend.beg, loan.begend.end

first_period_days

char(40)

Determines how interest in the first payment period will be calculated

loan.firstPeriodDays.actual, loan.firstPeriodDays.forceRegular, loan.fristPeriodDays.frequency

first_day_interest

tinyint(1)

Determines whether interest will accrue on the loan contract date

discount_calc

char(40)

Determines how discount portion will be calculated

loan.discountCalc.full, loan.discountCalc.percentage, loan.discountCalc.percentFixed, loan.discountCalc.rebalancing, loan.discountCalc.straightLine

diy_alt

tinyint(1)

This field is no longer supported

due_date_on_last_dom

tinyint(1)

Tracks whether payments will come due on the last day of the month

due_dates_on_business_days

varchar()

Specifies whether payments can come due on non-business days

loan.businessduedates.disabled, loan.businessduedates.addDays, loan.buisnessduedates.subtractDays

days_in_period

char(30)

Amount of days in a period

loan.daysinperiod.1, loan.daysinperiod.1B, loan.daysinperiod.2, loan.daysinperiod.3, loan.daysinperiod.4, loan.daysinperiod.5, loan.daysinperiod.6, loan.daysinperiod.8, loan.daysinperiod.9, loan.daysinperiod.10, loan.daysinperiod.12, loan.daysinperiod.13, loan.daysinperiod.15, loan.daysinperiod.18, loan.daysinperiod.20, loan.daysinperiod.24, loan.daysinperiod.26, loan.daysinperiod.28, loan.daysinperiod.30, loan.daysinperiod.36, loan.daysinperiod.40, loan.daysinperiod.45, loan.daysinperiod.52, loan.daysinperiod.60, loan.daysinperiod.72, loan.daysinperiod.73, loan.daysinperiod.90, loan.daysinperiod.91, loan.daysinperiod.120, loan.daysinperiod.180, loan.daysinperiod.182, loan.daysinperiod.360, loan.daysinperiod.364, loan.daysinperiod.365

round_decimals

int(11)

Determines the number of decimal places that will be held for loan numbers, during calculations

1 - 7

last_as_final

tinyint(1)

Specifies whether the final payment on the loan will grow to accommodate extra interest accrued because of late or missed payments, or if the payment schedule should have extra payments added to it instead

1 - yes, 0 - no

ndd_calc

char(30)

Specifies whether the amount past due should be calculated based on all loan components, or on interest only

loan.nddCalc.interestOnly, loan.nddCalc.standard

end_interest

char(30)

Specifies whether interest accrual should cease after the originally-calculated, final payment date on the loan

loan.endInterest.loanExp, loan.endInterest.no

schedule_template

int(11)

ID of the schedule roll template

curtailment_template

int(11)

ID of the curtailment template

fees_paid_by

char(30)

Fees paid by setting

loan.feesPaidBy.date, loan.feesPaidBy.period

use_interest_tiers

tinyint(1)

Whether to use interest tiers or not

grace_days

int(11)

Grace days

late_fee_type

char(30)

Late fee type setting

loan.lateFee.1, loan.lateFee.2, loan.lateFee.3, loan.lateFee.4

late_fee_amount

decimal(11,2)

Late fee amount

late_fee_percent

decimal(11,2)

Late fee percentage

late_fee_calc

char(30)

Late fee calculation type

loan.lateFeeCalc.current, loan.lateFeeCalc.standard, loan.lateFeeCalc.standardFee

latefee_percent_base

char(40)

Late fee percent base

loan.latefeepercentbase.escrow, loan.latefeepercentbase.regular

roll_last_payment

int(11)

Roll last payment or not

payment_date_app

char(30)

Payment date application

loan.pmtdateapp.acutal, loan.pmtdateapp.last

enroll_new_loans

tinyint(1)

Whether or not to enroll new loans

1 - yes, 0 - no

enroll_existing_loans

tinyint(1)

Whether or not to enroll existing loans

1 - yes, 0 - no

enabled

tinyint(1)

Whether or not is enabled

1 - yes, 0 - no

eval_real_time

tinyint(1)

Whether or not to Evaluate in real-time

1 - yes, 0 - no

eval_in_daily_maint

tinyint(1)

Whether or not to evaluate this entity during daily maintenance

1 - yes, 0 - no

exec_pre_activation

tinyint(1)

Whether or not to execute pre activation

1 - yes, 0 - no

forcing

tinyint(1)

Whether or not to force

1 - yes, 0 - no

global_order

int(11)

Global execution order

lastUpdated

timestamp

Timestamp of when the entity was last updated

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)