Field Details: coll_settlement_percentage

Back to Fields
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