Basic Information
| Field Name: |
coll_settlement_percentage |
| Source Table: |
evolved_records |
| Version: |
1 |
| Expression Type: |
jinja |
| Output Type: |
FLOAT |
| Status: |
Active
|
| Created: |
2025-10-16 04:31:29 |
| Updated: |
2025-10-16 04:31:29 |
Metadata
| Display Name: |
Settlement Percentage |
| Categories: |
COLLECTIONS
|
| Group: |
Settlement Metrics |
Usage
| Used in Summary: |
Yes
|
| Used in Template: |
No
|
Description
No description available
Expression
{% if raw_data.settlement_percentage is defined %}
{{ raw_data.settlement_percentage }}
{% elif coll_installment_type == "STAGGERED" %}
{% if coll_days_overdue <= 30 %}
100
{% elif coll_days_overdue <= 60 %}
75
{% elif coll_days_overdue <= 90 %}
50
{% else %}
25
{% endif %}
{% else %}
100
{% endif %}
Dependencies
coll_installment_type
coll_days_overdue
© SimSol Technologies and Services Private Limited