Database – Loan Settings Entity (loan_settings_entity)
Holds search, categorization and metadata settings for a loan.
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 | ||
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 |