Database – Rules Applied Settings (rule_applied_loan_settings_entity)
Updated 1 year ago
This table holds information for loan settings rules applied. These rules applied affect loan settings on loans.
Column | Data Type | Column Info | Value Notes |
id | int(11) | The id of the record; in this case, an individual rule. | |
name | varchar(100) | The name of the rule | |
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 | |
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 e-billing 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 repossession 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 to evaluate in real-time | 1 - yes 0 - no |
exec_pre_activation | tinyint(1) | Whether to execute pre activation | 1 - yes 0 - no |
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. |