Database – Recurring Charge Entity (recurring_charge_entity)
Updated 1 year ago
Description
Holds recurring charge information.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
charge_application_type | char(25) | charge application type | loan.pastdue.standard, loan.latefeeapp.payoff | |
is_enabled | tinyint(1) | whether or not is enabled | 1 - yes, 0 - no | |
apply_in_new_loan | tinyint(1) | Whether or not applies to new loans | 1 - yes, 0 - no | |
title | varchar(100) | The name/title of the entity instance | ||
info | varchar(100) | Extra information about an entity instance | ||
calculation | char(41) | Encoded calculation information | ||
fixed_amount | decimal(11,2) | fixed amount | ||
percentage | decimal(5,2) | percentage | ||
percentage_base | char(36) | percentage base | charge.recurring.percentagebase.apd, charge.recurring.percentagebase.cpb, charge.recurring.percentagebase.npa, charge.recurring.percentagebase.ola | |
contingency_bracket_id | char(33) | associated contingency bracket | ||
trigger_type | char(35) | recurring charge trigger type | charge.recurring.triggertype.* | |
loan_type | char(30) | Loan type code for associated loans | loan.type.* | |
trigger_event | char(42) | Encoded trigger event information | ||
trigger_sub_event | char(52) | trigger sub event | ||
trigger_event_value | char(25) | trigger event value | ||
trigger_event_value_updated | text | |||
trigger_rule | text | trigger rule | Clojure | |
restriction_rule | text | restriction rule | Clojure | |
restriction_ui | text | restriction (UI) | ||
interest_bearing | tinyint(1) | Whether or not is interest bearing | 1 - yes, 0 - no | |
past_due_setting | varchar(100) | |||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |