Database – Rules Applied, Loan Setup (rule_applied_loans_setup_entity)
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 |