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 |