Database – Rules Applied, Autopay (rule_applied_autopay_entity)
Shows information regarding Autopay Rules Applied.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID of the entity | ||
name | varchar(100) | The name of the entity | ||
rule | text | Associated Clojure Rule used in entity evaluation | ||
autopay_name | varchar(255) | Name of the autopay | ||
type | char(100) | The autopay type | ||
base_date | char(45) | Base date | ||
apply_days | int(11) | Days the autopay will apply | ||
process_days | int(11) | Days the autopay will process | ||
process_time | char(5) | What time the autopay will process | ||
amount_type | char(100) | The autopay amount type | ||
amount | decimal(10,2) | The specific amount | ||
payment_type_id | int(11) | Payment type ID | ||
process_current | tinyint(4) | Process even if the loan is current or not | ||
charge_service_fee | tinyint(4) | Whether or not to charge a service fee | ||
retry_days | tinyint(4) | How many days to retry if failed | ||
retry_count | int(11) | Retry count | ||
post_payment_update_apply_date | tinyint(4) | Change apply date after successful process | ||
recurring_frequency | char(100) | Frequency of recurring payments | ||
recurring_periods | int(11) | Amount of recurring periods | ||
recurring_date_option | char(64) | Recurring date option | ||
scheduling_type | char(64) | Autopay scheduling type | ||
last_dom_enabled | tinyint(4) | Last day of the month enabled or not | ||
days_in_period | char(100) | Number of days in the period | ||
payment_extra_towards | char(100) | Pay extra towards option | ||
payment_fee | decimal(6,2) | Payment fee | ||
payment_profile | char(40) | Payment profile | ||
payment_method_auth_type | char(100) | Payment menthod autorization type | ||
payoff_adjustment | tinyint(1) | Whether or not should adjust for payoff amount | ||
process_zero_or_negative_balance | tinyint(1) | Whether or not to process if balance is less than or equal to zero | ||
charge_off_recovery | tinyint(1) | Flag as recovery payment | ||
processor_id | int(11) | Processor ID | ||
cancel_autopays | tinyint(1) | Cancel autopay or not | ||
enroll_new_loans | tinyint(1) | Whether or not to enroll new loans | ||
enroll_existing_loans | tinyint(1) | Whether or not to enroll existing loans | ||
enabled | tinyint(1) | Whether or not rule applied is enabled | ||
eval_real_time | tinyint(1) | Whether or not to Evaluate in real-time | ||
eval_in_daily_maint | tinyint(1) | Whether or not to evaluate this entity during daily maintenance | ||
exec_pre_activation | tinyint(1) | Whether or not to execute pre activation | ||
forcing | tinyint(1) | Whether or not to force the rule applied | ||
global_order | int(11) | Global order of the rule applied | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
deleted | tinyint(1) | Whether or not the entity was deleted |