Field Details - coll_risk

Field Details: coll_risk_score

Basic Information

Field Name:	`coll_risk_score`
Source Table:	evolved_records
Version:	1
Expression Type:	jinja
Output Type:	INTEGER
Status:	Active
Created:	2025-10-16 04:31:29
Updated:	2025-10-16 04:31:29

Metadata

Display Name:	Risk Score
Categories:	COLLECTIONS
Group:	Risk Assessment

Usage

Used in Summary:	Yes
Used in Template:	No

Description

No description available

Expression


            {% set base_score = 50 %}
            
            {% if coll_days_overdue is defined %}
                {% if coll_days_overdue > 90 %}
                    {% set base_score = base_score + 40 %}
                {% elif coll_days_overdue > 60 %}
                    {% set base_score = base_score + 30 %}
                {% elif coll_days_overdue > 30 %}
                    {% set base_score = base_score + 20 %}
                {% elif coll_days_overdue > 0 %}
                    {% set base_score = base_score + 10 %}
                {% endif %}
            {% endif %}
            
            {% if raw_data.payment_status == "DEFAULTED" %}
                {% set base_score = base_score + 30 %}
            {% elif raw_data.payment_status == "OVERDUE" %}
                {% set base_score = base_score + 20 %}
            {% elif raw_data.payment_status == "PARTIAL" %}
                {% set base_score = base_score + 10 %}
            {% endif %}
            
            {% if raw_data.area_type == "RURAL" %}
                {% set base_score = base_score + 5 %}
            {% endif %}
            
            {% if coll_total_due is defined and coll_total_due > 10000 %}
                {% set base_score = base_score + 10 %}
            {% endif %}
            
            {{ min(base_score, 100) }}

Dependencies

coll_days_overdue
coll_total_due