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
© SimSol Technologies and Services Private Limited