Derived Field: coll_efficiency_score
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) }}
Joins
No joins defined
Registry Information
No registry entry found
Version History
No version history available
Field Usage
Referenced by: