Home

Derived Field: coll_efficiency_score

Back to List Edit Test
Field Details

Field Name:

coll_efficiency_score

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

INTEGER

Version:

v1

Used In:

Summaries

Display Name:

Collection Efficiency Score

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
Field Type Actions
coll_days_overdue Derived View
coll_recovery_rate Derived View
Joins

No joins defined

Registry Information

No registry entry found

Version History

No version history available

Field Usage

Referenced by:

Loading...