Database – Rules Applied, Loan Settings Backup (rule_applied_loan_settings_entity_backup)
Holds information for loan settings rules applied backup. These rules applied affect loan settings on loans.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
name | varchar(100) | Entity name | ||
rule | text | Associated Clojure Rule used in entity evaluation | ||
card_fee_amount | decimal(11,2) | servicing fee amount | ||
card_fee_type | char(30) | servicing fee type | ||
card_fee_percent | decimal(11,2) | servicing fee percent | ||
agent | int(11) | agent user id | ||
loan_status_id | int(11) | loan status id | ||
loan_sub_status_id | int(11) | loan sub status id | ||
source_company | int(11) | source company id | ||
ebilling | tinyint(1) | Whether or not ebilling is enabled | 1 - yes, 0 - no | |
ecoa_code | char(30) | Borrower ECOA Code | ||
co_ecoa_code | char(30) | Co-Borrower ECOA Code | ||
credit_status | char(30) | credit status | ||
credit_bureau | char(30) | credit bureau | ||
reporting_type | char(30) | Reporting Type | loan.reportingtype.* | |
secured | tinyint(1) | Determine 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 | |
merchant_processor_group_id | int(11) | Merchant processor group Id | ||
repo_date | int(11) | What to set the repo date to | ||
repo_date_setting | char(100) | Setting for repo date | ||
closed_date | int(11) | Closed date | ||
closed_date_setting | char(100) | Setting for closed date | ||
liquidation_date | int(11) | Liquidation date | ||
liquidation_date_setting | char(100) | Setting for liquidation date | ||
followup_date | int(11) | Followup date | ||
followup_date_setting | char(100) | Setting for followup date | ||
is_stoplight_manually_set | tinyint(1) | Is stoplight manually set | 1 - yes, 0 - no | |
delete_portfolios | tinyint(1) | Whether or not to delete existing portfolios | 1 - yes, 0 - no | |
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_in_daily_maint | tinyint(1) | Whether or not to evaluate this entity during daily maintenance | 1 - yes, 0 - no | |
eval_real_time | tinyint(1) | Whether or not to Evaluate in real-time | 1 - yes, 0 - no | 123456 |
exec_pre_activation | tinyint(1) | Whether to execute preactivation | ||
forcing | tinyint(1) | Whether or not to force | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
global_order | int(11) | Global execution order | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |