Database – Loan Settings Entity (loan_settings_entity)

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

loan_id

int(11)

The id of the associated loan account

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 user for the loan

loan_status_id

int(11)

Associated loan status id

loan_sub_status_id

int(11)

Associeated loan sub status id

source_company

int(11)

Associated source company id

payment_type_default

int(11)

The default payment type, as determined by either your company-wide settings or Rules Applied on a specific loan.

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.*

credit_status

char(30)

Credit Status

loan.creditstatus.*

credit_bureau

char(30)

Credit Bureau

loan.creditburearu.*

reporting_type

char(30)

Reporting Type

loan.reportingtype.*

secured

tinyint(1)

Whether or not the loan is secured

1 - yes, 0 - no

autopay_enabled

tinyint(1)

Whether or not autopay is enabled

1 - yes, 0 - no

repo_date

date

loan reposessed date

closed_date

date

closed date

liquidation_date

date

liquidation date

followup_date

date

is_stoplight_manually_set

tinyint(1)

is stoplight manually set

1 - yes, 0 - no

merchant_processor_group_id

tinyint(1)

The ID of the merchant processor group assigned to the loan. Merchant processor groups can be found in the merchant_processor group_entity table.

1 - yes, 0 - no

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

lastUpdated

timestamp

Timestamp of when the entity was last updated