Field Details: coll_efficiency_score

Back to Fields
Basic Information
Field Name: coll_efficiency_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: Collection Efficiency Score
Categories: COLLECTIONS
Group: Performance Metrics
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

Expression

            {% set base_score = 50 %}
            {% set recovery_rate = coll_recovery_rate|default(0) %}
            {% set days_overdue = coll_days_overdue|default(0) %}
            
            {% if recovery_rate >= 80 %}
                {% set base_score = base_score + 30 %}
            {% elif recovery_rate >= 60 %}
                {% set base_score = base_score + 20 %}
            {% elif recovery_rate >= 40 %}
                {% set base_score = base_score + 10 %}
            {% endif %}
            
            {% if days_overdue == 0 %}
                {% set base_score = base_score + 20 %}
            {% elif days_overdue <= 30 %}
                {% set base_score = base_score + 10 %}
            {% elif days_overdue > 90 %}
                {% set base_score = base_score - 20 %}
            {% endif %}
            
            {% if raw_data.collection_method == "DIGITAL" %}
                {% set base_score = base_score + 5 %}
            {% endif %}
            
            {{ min(max(base_score, 0), 100) %}
            
            {% if coll_days_overdue is defined %}
                {% if coll_days_overdue == 0 %}
                    {% set base_score = base_score + 30 %}
                {% elif coll_days_overdue <= 15 %}
                    {% set base_score = base_score + 20 %}
                {% elif coll_days_overdue <= 30 %}
                    {% set base_score = base_score + 10 %}
                {% endif %}
            {% endif %}
            
            {% if coll_recovery_rate is defined %}
                {% if coll_recovery_rate >= 80 %}
                    {% set base_score = base_score + 30 %}
                {% elif coll_recovery_rate >= 50 %}
                    {% set base_score = base_score + 20 %}
                {% elif coll_recovery_rate >= 20 %}
                    {% set base_score = base_score + 10 %}
                {% endif %}
            {% endif %}
            
            {{ min(base_score, 100) }}
            
Dependencies
  • coll_days_overdue
  • coll_recovery_rate