defaults_system_loan - System Loan Defaults

This holds tenant-wide default options for new loans.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

loan_class

char(30)

The classification for the loan

loan.class.*

loan_type

char(30)

Loan type code for associated loans

loan.type.*

is_primary

tinyint(1)

Whether or not it is the primary loan type for the specefied loan class.

1 - yes, 0 - no

grace_days

int(11)

Number of days a payment can be late before charging a late fee

late_fee_type

char(30)

late fee type

loan.lateFee.*

late_fee_amount

decimal(11,2)

Dolar amount for a late fee

late_fee_percent

decimal(11,2)

Percentage for late fee

late_fee_calc

char(30)

Calculation type for the late fee

loan.lateFeeCalc.*

card_fee_amount

decimal(11,2)

servicing fee amount

card_fee_type

char(30)

card fee type

loan.cardfee.types.*

card_fee_percent

decimal(11,2)

Card fee percentage

agent

int(11)

agent id of who made it

source_company

int(11)

Associated source company id

loan_status

int(11)

associated loan status id

loan_sub_status

int(11)

loan sub status id

ebilling

tinyint(1)

Whether or not is signed up for ebilling

1 - yes, 0 - no

ecoa_code

char(30)

Borrower ECOA code

loan.ecoacodes.*

co_ecoa_code

char(30)

Co-Borrower ECOA code

loan.ecoacodes.*

portfolio

text

loan portfolio

credit_status

char(30)

Credit Status

loan.creditstatus.*

credit_bureau

char(30)

Credit Bureau

loan.creditburearu.*

reporting_type

char(30)

Reporting Type

loan.reportingtype.*

discount_split

tinyint(1)

Whether or not to split the discount

1 - yes, 0 - no

payment_frequency

char(30)

The frequency at which payments occur

loan.frequency.*

calc_type

char(30)

Calculation type to use for the loan

loan.calcType.*

days_in_year

char(30)

Days in the year used during calculations

loan.daysInYear.*

interest_application

char(50)

How interest is applied to the loan

loan.interestApplication.*

beg_end

char(20)

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

loan.begend.*

first_period_days

char(40)

How to handle odd days in the first period

loan.firstPeriodDays.*

first_day_interest

tinyint(1)

Whether or not to charge interest on the first day

1 - yes, 0 - no

discount_calc

char(40)

How to calculate discount

loan.class.*

diy_alt

tinyint(1)

Days in Year (Alternate) for calculation

1 - yes, 0 - no

payment_date_app

char(30)

Method to apply payment date

loan.pmtdateapp.*

days_in_period

char(30)

Days in period info

smooth_payments

tinyint(1)

Whether or not to smooth payments

1 - yes, 0 - no

round_decimals

int(11)

Number of decimals to round to during calculation

last_as_final

tinyint(1)

Whether or not the last scheduled period is the final period

1 - yes, 0 - no

ndd_calc

char(30)

How to calculate the next due date

loan.nddCalc.*

end_interest

char(30)

Whether or not to charge interest after the original end date

loan.endinterest.*

fixed_term_pmt

tinyint(1)

Whether or not is fixed term payment

1 - yes, 0 - no

latefee_percent_base

char(40)

Late fee percentage base

loan.latefeepercentbase.*

schedule_template

int(11)

The ID of the schedule template to use

curtailment_template

int(11)

The ID of the curtailment template to use

fees_paid_by

char(30)

Fees paid by calculation

loan.feesPaidBy.*

use_interest_tiers

tinyint(1)

Whether or not to use tiered interest

1 - yes, 0 - no

loan_rate_type

char(30)

The interest rate calculation type

loan.rateType.annually

apr_force_single_freq

tinyint(1)

Whether or not the APR is forced to Single Frequency

1 - yes, 0 - no

due_date_on_last_dom

tinyint(1)

Due date on last day of month

1 - yes, 0 - no

due_dates_on_business_days

varchar(40)

How to restrict due dates to business days only

loan.businessduedates.*

autopay_enabled

tinyint(1)

Whether or not autopay is enabled

1 - yes, 0 - no

merchant_processor_group_id

int(11)

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

lastUpdated

timestamp

Timestamp of when the entity was last updated


How did we do?


Powered by HelpDocs (opens in a new tab)